Error of migration from Joomla 1.5 to 2.5 Jupgrade

Joomla versions 2.5, 1.7 and 1.6 are all end-of-life since December 31st 2014 and are no longer supported. Please use Joomla 3.x instead.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Locked
sylwekb
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 205
Joined: Mon Mar 14, 2011 5:08 pm

Error of migration from Joomla 1.5 to 2.5 Jupgrade

Post by sylwekb » Mon Dec 12, 2016 10:28 pm

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
Last edited by imanickam on Mon Dec 12, 2016 11:46 pm, edited 1 time in total.
Reason: Moved the topic from the forum Migrating and Upgrading to Joomla! 1.5 to the forum Migrating and Upgrading to Joomla! 2.5

sylwekb
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 205
Joined: Mon Mar 14, 2011 5:08 pm

Re: Error of migration from Joomla 1.5 to 2.5 Jupgrade

Post by sylwekb » Wed Dec 14, 2016 9:09 am

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;


Locked

Return to “Migrating and Upgrading to Joomla! 2.5”