Page 1 of 1

Error of migration from Joomla 1.5 to 2.5 Jupgrade

Posted: Mon Dec 12, 2016 10:28 pm
by sylwekb
When you attempt to migrate Joomla version 2.5 1,5.26 to appear the following errors and the migration is impossible. How to solve this problem?

Migrating undefined
jUpgrade Wersja 2.5.2

Developed by Matware © Copyleft 2006-2012
Licensed as GNU General Public License v2

Project Site / Project Community / FAQ


==========
[install_config]

1

==========
[install_db]



==========
[undefined] [undefined]


Fatal error: Uncaught exception 'JDatabaseException' with message 'Table 'valencia_riders2.jupgrade_steps' doesn't exist SQL=SELECT * FROM jupgrade_steps AS s WHERE s.status != 1 AND s.extension = 0 ORDER BY s.id ASC LIMIT 1' in .../jupgrade/libraries/joomla/database/database/mysqli.php:403 Stack trace: #0 .../jupgrade/libraries/joomla/database/database.php(1062): JDatabaseMySQLi->execute() #1 .../administrator/components/com_jupgrade/includes/controller.php(27): JDatabase->loadObject() #2 {main} thrown in .../jupgrade/libraries/joomla/database/database/mysqli.php on line 403


==========
[undefined] [undefined]


Fatal error: Uncaught exception 'JDatabaseException' with message 'Table 'valencia_riders2.jupgrade_steps' doesn't exist SQL=SELECT * FROM jupgrade_steps AS s WHERE s.status != 1 AND s.extension = 0 ORDER BY s.id ASC LIMIT 1' in .../jupgrade/libraries/joomla/database/database/mysqli.php:403 Stack trace: #0 .../jupgrade/libraries/joomla/database/database.php(1062): JDatabaseMySQLi->execute() #1 .../administrator/components/com_jupgrade/includes/controller.php(27): JDatabase->loadObject() #2 {main} thrown in .../jupgrade/libraries/joomla/database/database/mysqli.php on line 403


==========
[undefined] [undefined]


Fatal error: Uncaught exception 'JDatabaseException' with message 'Table 'valencia_riders2.jupgrade_steps' doesn't exist SQL=SELECT * FROM jupgrade_steps AS s WHERE s.status != 1 AND s.extension = 0 ORDER BY s.id ASC LIMIT 1' in .../jupgrade/libraries/joomla/database/database/mysqli.php:403 Stack trace: #0 .../jupgrade/libraries/joomla/database/database.php(1062): JDatabaseMySQLi->execute() #1 .../administrator/components/com_jupgrade/includes/controller.php(27): JDatabase->loadObject() #2 {main} thrown in .../jupgrade/libraries/joomla/database/database/mysqli.php on line 403


==========
[undefined] [undefined]


Fatal error: Uncaught exception 'JDatabaseException' with message 'Table 'valencia_riders2.jupgrade_steps' doesn't exist SQL=SELECT * FROM jupgrade_steps AS s WHERE s.status != 1 AND s.extension = 0 ORDER BY s.id ASC LIMIT 1' in .../jupgrade/libraries/joomla/database/database/mysqli.php:403 Stack trace: #0 .../jupgrade/libraries/joomla/database/database.php(1062): JDatabaseMySQLi->execute() #1 .../administrator/components/com_jupgrade/includes/controller.php(27): JDatabase->loadObject() #2 {main} thrown in .../jupgrade/libraries/joomla/database/database/mysqli.php on line 403


==========
[undefined] [undefined]


Fatal error: Uncaught exception 'JDatabaseException' with message 'Table 'valencia_riders2.jupgrade_steps' doesn't exist SQL=SELECT * FROM jupgrade_steps AS s WHERE s.status != 1 AND s.extension = 0 ORDER BY s.id ASC LIMIT 1' in .../jupgrade/libraries/joomla/database/database/mysqli.php:403 Stack trace: #0 .../jupgrade/libraries/joomla/database/database.php(1062): JDatabaseMySQLi->execute() #1 .../administrator/components/com_jupgrade/includes/controller.php(27): JDatabase->loadObject() #2 {main} thrown in .../jupgrade/libraries/joomla/database/database/mysqli.php on line 403

When you attempt to migrate Joomla version 2.5 1,5.26 to appear the following errors and the migration is impossible. How to solve this problem?


==========
[undefined] [undefined]


Fatal error: Uncaught exception 'JDatabaseException' with message 'Table 'valencia_riders2.jupgrade_steps' doesn't exist SQL=SELECT * FROM jupgrade_steps AS s WHERE s.status != 1 AND s.extension = 0 ORDER BY s.id ASC LIMIT 1' in .../jupgrade/libraries/joomla/database/database/mysqli.php:403 Stack trace: #0 .../jupgrade/libraries/joomla/database/database.php(1062): JDatabaseMySQLi->execute() #1 .../administrator/components/com_jupgrade/includes/controller.php(27): JDatabase->loadObject() #2 {main} thrown in .../jupgrade/libraries/joomla/database/database/mysqli.php on line 403


==========
[undefined] [undefined]


Fatal error: Uncaught exception 'JDatabaseException' with message 'Table 'valencia_riders2.jupgrade_steps' doesn't exist SQL=SELECT * FROM jupgrade_steps AS s WHERE s.status != 1 AND s.extension = 0 ORDER BY s.id ASC LIMIT 1' in .../jupgrade/libraries/joomla/database/database/mysqli.php:403 Stack trace: #0 .../jupgrade/libraries/joomla/database/database.php(1062): JDatabaseMySQLi->execute() #1 .../administrator/components/com_jupgrade/includes/controller.php(27): JDatabase->loadObject() #2 {main} thrown in .../jupgrade/libraries/joomla/database/database/mysqli.php on line 403

Re: Error of migration from Joomla 1.5 to 2.5 Jupgrade

Posted: Wed Dec 14, 2016 9:09 am
by sylwekb
Problem SOLVED missing tables
VIA PHPMYADMIN ADD SQL WINDOW

Code: Select all

CREATE TABLE `jupgrade_categories` (
  `old` int(11) NOT NULL,
  `new` int(11) NOT NULL,
  `section` varchar(255) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


INSERT INTO `jupgrade_categories` (`old`, `new`, `section`) VALUES
(0, 2, '0'),
(20, 389, 'com_section'),
(19, 390, 'com_section'),
(16, 391, 'com_section'),
(15, 392, 'com_section'),
(14, 393, 'com_section'),
(13, 394, 'com_section'),
(12, 395, 'com_section'),
(11, 396, 'com_section'),
(10, 397, 'com_section'),
(9, 398, 'com_section'),
(8, 399, 'com_section'),
(7, 400, 'com_section'),
(6, 401, 'com_section'),
(5, 402, 'com_section'),
(1, 403, 'com_section'),
(186, 186, '1'),
(83, 83, '1'),
(27, 27, '1'),
(266, 266, '10'),
(214, 214, '10'),
(209, 209, '10'),
(65, 65, '10'),
(63, 63, '10'),
(62, 62, '10'),
(388, 388, '11'),
(382, 382, '11'),
(379, 379, '11'),
(375, 375, '11'),
(365, 365, '11'),
(355, 355, '11'),
(351, 351, '11'),
(345, 345, '11'),
(340, 340, '11'),
(339, 339, '11'),
(329, 329, '11'),
(326, 326, '11'),
(318, 318, '11'),
(312, 312, '11'),
(307, 307, '11'),
(298, 298, '11'),
(296, 296, '11'),
(294, 294, '11'),
(289, 289, '11'),
(287, 287, '11'),
(284, 284, '11'),
(281, 281, '11'),
(277, 277, '11'),
(278, 278, '11'),
(273, 273, '11'),
(268, 268, '11'),
(264, 264, '11'),
(258, 258, '11'),
(257, 257, '11'),
(69, 69, '11'),
(68, 68, '11'),
(67, 67, '11'),
(66, 66, '11'),
(190, 190, '12'),
(82, 82, '12'),
(81, 81, '12'),
(80, 80, '12'),
(79, 79, '12'),
(78, 78, '12'),
(77, 77, '12'),
(76, 76, '12'),
(377, 377, '13'),
(376, 376, '13'),
(41, 41, '13'),
(40, 40, '13'),
(39, 39, '13'),
(38, 38, '13'),
(37, 37, '13'),
(334, 334, '14'),
(328, 328, '14'),
(253, 253, '14'),
(251, 251, '14'),
(250, 250, '14'),
(237, 237, '14'),
(211, 211, '14'),
(189, 189, '14'),
(170, 170, '14'),
(171, 171, '14'),
(370, 370, '15'),
(331, 331, '15'),
(304, 304, '15'),
(285, 285, '15'),
(260, 260, '15'),
(235, 235, '15'),
(228, 228, '15'),
(219, 219, '15'),
(114, 114, '15'),
(113, 113, '15'),
(112, 112, '15'),
(111, 111, '15'),
(110, 110, '15'),
(109, 109, '15'),
(108, 108, '15'),
(367, 367, '16'),
(337, 337, '16'),
(303, 303, '16'),
(286, 286, '16'),
(261, 261, '16'),
(236, 236, '16'),
(227, 227, '16'),
(218, 218, '16'),
(107, 107, '16'),
(106, 106, '16'),
(105, 105, '16'),
(104, 104, '16'),
(103, 103, '16'),
(102, 102, '16'),
(101, 101, '16'),
(265, 265, '19'),
(224, 224, '19'),
(384, 384, '20'),
(373, 373, '20'),
(352, 352, '20'),
(271, 271, '20'),
(270, 270, '20'),
(191, 191, '5'),
(42, 42, '5'),
(31, 31, '5'),
(30, 30, '5'),
(29, 29, '5'),
(28, 28, '5'),
(357, 357, '6'),
(353, 353, '6'),
(349, 349, '6'),
(341, 341, '6'),
(320, 320, '6'),
(310, 310, '6'),
(255, 255, '6'),
(231, 231, '6'),
(35, 35, '6'),
(34, 34, '6'),
(33, 33, '6'),
(32, 32, '6'),
(381, 381, '7'),
(348, 348, '7'),
(249, 249, '7'),
(163, 163, '7'),
(44, 44, '7'),
(43, 43, '7'),
(36, 36, '7'),
(323, 323, '8'),
(315, 315, '8'),
(293, 293, '8'),
(276, 276, '8'),
(267, 267, '8'),
(210, 210, '8'),
(192, 192, '8'),
(130, 130, '8'),
(50, 50, '8'),
(49, 49, '8'),
(48, 48, '8'),
(47, 47, '8'),
(46, 46, '8'),
(45, 45, '8'),
(386, 386, '9'),
(385, 385, '9'),
(371, 371, '9'),
(362, 362, '9'),
(360, 360, '9'),
(356, 356, '9'),
(295, 295, '9'),
(198, 198, '9'),
(61, 61, '9'),
(60, 60, '9'),
(59, 59, '9'),
(58, 58, '9'),
(53, 53, '9'),
(52, 52, '9'),
(51, 51, '9'),
(15, 15, 'com_contact');


CREATE TABLE `jupgrade_menus` (
  `old` int(11) NOT NULL,
  `new` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `jupgrade_menus` (`old`, `new`) VALUES
(0, 0),
(100001, 100001),
(275, 275),
(274, 274),
(273, 273),
(272, 272),
(271, 271),
(270, 270),
(269, 269),
(268, 268),
(267, 267),
(266, 266),
(265, 265),
(264, 264),
(263, 263),
(262, 262),
(261, 261),
(260, 260),
(259, 259),
(258, 258),
(257, 257),
(256, 256),
(255, 255),
(254, 254),
(253, 253),
(252, 252),
(251, 251),
(250, 250),
(249, 249),
(248, 248),
(247, 247),
(246, 246),
(245, 245),
(244, 244),
(243, 243),
(242, 242),
(241, 241),
(240, 240),
(239, 239),
(238, 238),
(237, 237),
(236, 236),
(235, 235),
(234, 234),
(233, 233),
(232, 232),
(231, 231),
(230, 230),
(229, 229),
(228, 228),
(227, 227),
(226, 226),
(225, 225),
(224, 224),
(223, 223),
(222, 222),
(221, 221),
(220, 220),
(219, 219),
(218, 218),
(217, 217),
(216, 216),
(215, 215),
(214, 214),
(213, 213),
(212, 212),
(211, 211),
(210, 210),
(209, 209),
(208, 208),
(207, 207),
(206, 206),
(205, 205),
(204, 204),
(203, 203),
(202, 202),
(201, 201),
(200, 200),
(199, 199),
(198, 198),
(197, 197),
(196, 196),
(195, 195),
(194, 194),
(193, 193),
(192, 192),
(191, 191),
(190, 190),
(189, 189),
(188, 188),
(187, 187),
(186, 186),
(185, 185),
(184, 184),
(183, 183),
(182, 182),
(181, 181),
(180, 180),
(179, 179),
(178, 178),
(177, 177),
(176, 176),
(175, 175),
(174, 174),
(173, 173),
(172, 172),
(171, 171),
(170, 170),
(169, 169),
(168, 168),
(167, 167),
(166, 166),
(165, 165),
(164, 164),
(163, 163),
(162, 162),
(161, 161),
(160, 160),
(159, 159),
(158, 158),
(157, 157),
(156, 156),
(155, 155),
(154, 154),
(153, 153),
(152, 152),
(151, 151),
(150, 150),
(149, 149),
(148, 148),
(147, 147),
(146, 146),
(145, 145),
(144, 144),
(143, 143),
(142, 142),
(141, 141),
(140, 140),
(139, 139),
(138, 138),
(137, 137),
(136, 136),
(135, 135),
(134, 134),
(125, 125),
(118, 118),
(117, 117),
(116, 116),
(115, 115),
(114, 114),
(111, 111),
(110, 110),
(109, 109),
(108, 108),
(107, 107),
(106, 106),
(105, 105),
(104, 104),
(103, 103),
(102, 102),
(101, 101),
(100, 100),
(99, 99),
(98, 98),
(97, 97),
(95, 95),
(94, 94),
(93, 93),
(92, 92),
(91, 91),
(89, 89),
(88, 88),
(87, 87),
(86, 86),
(84, 84),
(83, 83),
(76, 76),
(75, 75),
(74, 74),
(73, 73),
(71, 71),
(70, 70),
(69, 69),
(68, 68),
(61, 61),
(60, 60),
(59, 59),
(58, 58),
(57, 57),
(53, 53),
(52, 52),
(44, 44),
(43, 43),
(37, 37),
(35, 35),
(1, 100002);


CREATE TABLE `jupgrade_modules` (
  `old` int(11) NOT NULL,
  `new` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


INSERT INTO `jupgrade_modules` (`old`, `new`) VALUES
(2, 87),
(3, 88),
(30, 89),
(45, 90),
(10001, 91);


CREATE TABLE `jupgrade_steps` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `status` int(11) NOT NULL,
  `extension` int(1) NOT NULL DEFAULT '0',
  `state` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


INSERT INTO `jupgrade_steps` (`id`, `name`, `status`, `extension`, `state`) VALUES
(1, 'users', 1, 0, ''),
(2, 'categories', 1, 0, ''),
(3, 'content', 1, 0, ''),
(4, 'menus', 1, 0, ''),
(5, 'modules', 1, 0, ''),
(6, 'banners', 1, 0, ''),
(7, 'contacts', 1, 0, ''),
(8, 'newsfeeds', 1, 0, ''),
(9, 'weblinks', 1, 0, ''),
(10, 'extensions', 1, 1, '');

--
-- Indeksy dla zrzutów tabel
--

--
-- Indexes for table `jupgrade_steps`
--
ALTER TABLE `jupgrade_steps`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT dla tabeli `jupgrade_steps`
--
ALTER TABLE `jupgrade_steps`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;