Simple Machines Community Forum

SMF Support => Converting to SMF => Topic started by: Inforcer on April 19, 2006, 06:07:31 PM

Title: Converting pnphpbb to SMF
Post by: Inforcer on April 19, 2006, 06:07:31 PM
SMF Version: SMF 1.1 RC2
Hello,

I have used the convert.php with the phpbb2smf.sql but I always get
Quote"Unable to find the settings for phpBB2. Please double check the path and try again."
when I give the path to the pnphpbb which is .../modules/pnphpbb

Has anyone done this successfully?
Title: Re: Converting pnphpbb to SMF
Post by: Oldiesmann on April 19, 2006, 06:14:29 PM
You need to enter the path to the directory where the config file is. Unless the module has a seperate config file, you want to enter the path to postNuke's config file.
Title: Re: Converting pnphpbb to SMF
Post by: Inforcer on April 19, 2006, 06:49:53 PM
Quote from: Oldiesmann on April 19, 2006, 06:14:29 PM
You need to enter the path to the directory where the config file is. Unless the module has a seperate config file, you want to enter the path to postNuke's config file.

Ok, found the config.php in the PostNuke root ... still same error :(
Title: Re: Converting pnphpbb to SMF
Post by: Inforcer on April 19, 2006, 07:57:18 PM
Ok I now installed a fresh phpbb2.0.20 and moved the corresponding tables from the pn/pnphpbb2 to the db serving the fresh phpbb. I still get the very same error ...  :'(

(http://www.cmd-live.com/smferror.jpg)
Title: Re: Converting pnphpbb to SMF
Post by: Inforcer on April 19, 2006, 10:17:25 PM
I ot further but now I am definitely stuck!

QuoteConverting...
Converting ranks... Successful.
Converting groups... Successful.
Converting members...
Warning: copy(/var/www/vhosts/c-md.info/httpdocs/phpbb/images/avatars/upload/141965070643510cf1ea725.png): failed to open stream: No such file or directory in /var/www/vhosts/c-md.info/httpdocs/convert.php(1627) : eval()'d code on line 35

Warning: copy(/var/www/vhosts/c-md.info/httpdocs/phpbb/images/avatars/upload/1712180801443f67c6a76c8.jpg): failed to open stream: No such file or directory in /var/www/vhosts/c-md.info/httpdocs/convert.php(1627) : eval()'d code on line 35

Warning: copy(/var/www/vhosts/c-md.info/httpdocs/phpbb/images/avatars/upload/11036419794379f728350f1.jpg): failed to open stream: No such file or directory in /var/www/vhosts/c-md.info/httpdocs/convert.php(1627) : eval()'d code on line 35

Warning: copy(/var/www/vhosts/c-md.info/httpdocs/phpbb/images/avatars/upload/1359800868435544aed120a.jpg): failed to open stream: No such file or directory in /var/www/vhosts/c-md.info/httpdocs/convert.php(1627) : eval()'d code on line 35

Warning: copy(/var/www/vhosts/c-md.info/httpdocs/phpbb/images/avatars/upload/11702264234353e523ea66d.gif): failed to open stream: No such file or directory in /var/www/vhosts/c-md.info/httpdocs/convert.php(1627) : eval()'d code on line 35

Warning: copy(/var/www/vhosts/c-md.info/httpdocs/phpbb/images/avatars/upload/14470214954357e6304f9d2.gif): failed to open stream: No such file or directory in /var/www/vhosts/c-md.info/httpdocs/convert.php(1627) : eval()'d code on line 35

Warning: copy(/var/www/vhosts/c-md.info/httpdocs/phpbb/images/avatars/upload/606167441443e565c965fe.gif): failed to open stream: No such file or directory in /var/www/vhosts/c-md.info/httpdocs/convert.php(1627) : eval()'d code on line 35

Warning: copy(/var/www/vhosts/c-md.info/httpdocs/phpbb/images/avatars/upload/11987580074351247e7c64f.gif): failed to open stream: No such file or directory in /var/www/vhosts/c-md.info/httpdocs/convert.php(1627) : eval()'d code on line 35

Warning: copy(/var/www/vhosts/c-md.info/httpdocs/phpbb/images/avatars/upload/199293706243569937ed334.gif): failed to open stream: No such file or directory in /var/www/vhosts/c-md.info/httpdocs/convert.php(1627) : eval()'d code on line 35

Warning: copy(/var/www/vhosts/c-md.info/httpdocs/phpbb/images/avatars/upload/17982596284445e1e14d1c0.jpg): failed to open stream: No such file or directory in /var/www/vhosts/c-md.info/httpdocs/convert.php(1627) : eval()'d code on line 35

Warning: copy(/var/www/vhosts/c-md.info/httpdocs/phpbb/images/avatars/upload/846870503435e3e02b0d2a.gif): failed to open stream: No such file or directory in /var/www/vhosts/c-md.info/httpdocs/convert.php(1627) : eval()'d code on line 35

Warning: copy(/var/www/vhosts/c-md.info/httpdocs/phpbb/images/avatars/upload/1244311094435ccae4e5d36.gif): failed to open stream: No such file or directory in /var/www/vhosts/c-md.info/httpdocs/convert.php(1627) : eval()'d code on line 35

Warning: copy(/var/www/vhosts/c-md.info/httpdocs/phpbb/images/avatars/upload/57345002943513856b291f.jpg): failed to open stream: No such file or directory in /var/www/vhosts/c-md.info/httpdocs/convert.php(1627) : eval()'d code on line 35

Warning: copy(/var/www/vhosts/c-md.info/httpdocs/phpbb/images/avatars/upload/1700309198435d04a7c0504.jpg): failed to open stream: No such file or directory in /var/www/vhosts/c-md.info/httpdocs/convert.php(1627) : eval()'d code on line 35

Warning: copy(/var/www/vhosts/c-md.info/httpdocs/phpbb/images/avatars/upload/106914581343694d25ef779.jpg): failed to open stream: No such file or directory in /var/www/vhosts/c-md.info/httpdocs/convert.php(1627) : eval()'d code on line 35

Warning: copy(/var/www/vhosts/c-md.info/httpdocs/phpbb/images/avatars/upload/12130053034356a66a35736.jpg): failed to open stream: No such file or directory in /var/www/vhosts/c-md.info/httpdocs/convert.php(1627) : eval()'d code on line 35
Successful.
Converting additional member groups... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Unsuccessful!
This query:
INSERT INTO `cmd`.smf_topics

(ID_TOPIC, isSticky, ID_FIRST_MSG, ID_LAST_MSG, ID_MEMBER_STARTED, ID_MEMBER_UPDATED, ID_BOARD, ID_POLL, locked, numReplies, numViews)

VALUES ('6', '0', '6', '247', '2', '40', '1', '', '0', '25', '264'),

('7', '0', '9', '10', '2', '2', '1', '', '1', '1', '32'),

('8', '0', '12', '243', '4', '2', '3', '', '1', '9', '134'),

('9', '0', '17', '127', '10', '10', '4', '', '0', '4', '79'),

('10', '0', '20', '39', '10', '23', '1', '', '0', '2', '37'),

('11', '0', '21', '242', '10', '2', '1', '', '1', '2', '30'),

('12', '0', '34', '36', '12', '4', '1', '', '1', '1', '25'),

('13', '0', '37', '362', '4', '30', '4', '', '0', '9', '106'),

('14', '0', '41', '241', '23', '2', '1', '', '1', '3', '28'),

('16', '0', '50', '233', '20', '2', '1', '', '1', '18', '136'),

('17', '0', '54', '231', '7', '2', '1', '', '1', '6', '81'),

('18', '0', '70', '238', '10', '2', '1', '', '1', '5', '50'),

('19', '0', '83', '234', '14', '2', '1', '', '1', '2', '35'),

('20', '0', '86', '299', '4', '4', '2', '', '0', '10', '113'),

('21', '0', '91', '236', '20', '2', '1', '', '1', '2', '46'),

('22', '0', '96', '239', '4', '2', '1', '', '1', '4', '41'),

('23', '0', '103', '237', '4', '2', '1', '', '1', '3', '45'),

('24', '0', '106', '113', '4', '4', '1', '', '0', '2', '65'),

('25', '0', '107', '240', '29', '2', '1', '', '1', '3', '62'),

('26', '0', '107', '108', '29', '4', '1', '', '0', '1', '4'),

('28', '0', '116', '128', '4', '10', '4', '', '0', '3', '48'),

('30', '0', '121', '244', '4', '2', '5', '', '1', '4', '62'),

('31', '0', '124', '232', '4', '2', '1', '', '1', '21', '158'),

('32', '0', '126', '462', '18', '18', '1', '', '0', '14', '240'),

('33', '0', '135', '176', '14', '14', '3', '', '0', '3', '43'),

('34', '0', '138', '171', '13', '3', '1', '', '1', '6', '73'),

('35', '0', '150', '152', '29', '4', '1', '', '1', '1', '23'),

('36', '0', '154', '273', '15', '35', '2', '', '0', '12', '130'),

('37', '0', '158', '169', '9', '4', '3', '', '0', '5', '39'),

('38', '0', '161', '387', '12', '40', '1', '', '1', '24', '262'),

('39', '0', '179', '261', '4', '22', '3', '', '0', '5', '99'),

('40', '0', '180', '303', '4', '44', '2', '', '0', '6', '70'),

('41', '0', '191', '250', '11', '4', '1', '', '0', '6', '84'),

('42', '0', '193', '309', '2', '2', '1', '', '1', '4', '57'),

('43', '0', '216', '549', '18', '3', '1', '', '0', '16', '172'),

('44', '0', '229', '330', '32', '2', '1', '', '1', '2', '36'),

('45', '0', '230', '296', '40', '7', '1', '', '0', '2', '46'),

('46', '0', '249', '465', '4', '43', '7', '', '0', '6', '87'),

('47', '0', '253', '272', '14', '3', '7', '', '0', '2', '63'),

('48', '0', '262', '269', '4', '16', '1', '', '0', '4', '56'),

('49', '0', '274', '552', '11', '2', '1', '', '0', '4', '68'),

('54', '0', '285', '476', '2', '10', '1', '', '0', '2', '64'),

('59', '0', '297', '311', '10', '10', '1', '', '0', '2', '55'),

('60', '0', '304', '307', '44', '44', '1', '', '0', '2', '31'),

('63', '0', '315', '380', '34', '28', '1', '', '0', '1', '47'),

('64', '0', '320', '338', '4', '29', '1', '', '0', '6', '103'),

('65', '0', '334', '528', '23', '7', '1', '1', '0', '15', '213'),

('66', '0', '335', '336', '23', '4', '4', '', '0', '1', '19'),

('67', '0', '339', '339', '4', '4', '5', '', '0', '0', '22'),

('69', '0', '347', '347', '15', '15', '1', '', '0', '0', '26'),

('70', '0', '348', '460', '29', '44', '1', '', '0', '7', '164'),

('71', '0', '357', '360', '4', '29', '1', '', '0', '2', '49'),

('72', '0', '359', '384', '23', '28', '1', '', '0', '1', '48'),

('73', '0', '361', '440', '43', '35', '1', '', '0', '4', '105'),

('74', '0', '363', '373', '47', '10', '1', '', '0', '2', '39'),

('76', '0', '383', '391', '28', '4', '4', '', '0', '4', '41'),

('78', '0', '395', '395', '4', '4', '9', '', '0', '0', '7'),

('79', '0', '396', '436', '11', '4', '1', '', '0', '5', '72'),

('80', '0', '399', '457', '11', '12', '1', '', '0', '6', '99'),

('81', '0', '404', '434', '4', '4', '2', '', '0', '3', '82'),

('82', '0', '405', '425', '43', '34', '1', '', '0', '4', '57'),

('84', '0', '410', '427', '2', '2', '7', '', '0', '6', '127'),

('86', '0', '419', '419', '2', '2', '1', '', '1', '0', '47'),

('87', '0', '420', '430', '51', '10', '5', '', '0', '1', '47'),

('90', '0', '423', '429', '51', '32', '5', '', '0', '2', '37'),

('91', '0', '431', '472', '51', '26', '5', '2', '0', '3', '115'),

('92', '0', '435', '705', '4', '2', '2', '', '0', '2', '67'),

('96', '0', '443', '443', '2', '2', '1', '', '0', '0', '15'),

('97', '0', '444', '444', '2', '2', '1', '', '0', '0', '33'),

('98', '0', '445', '445', '4', '4', '1', '', '0', '0', '8'),

('99', '0', '447', '533', '10', '4', '1', '', '0', '3', '91'),

('100', '0', '450', '450', '4', '4', '1', '', '0', '0', '36'),

('101', '0', '456', '456', '10', '10', '5', '', '0', '0', '22'),

('103', '0', '461', '461', '51', '51', '5', '', '0', '0', '18'),

('105', '0', '466', '507', '51', '51', '5', '', '0', '8', '177'),

('106', '0', '466', '467', '51', '10', '5', '', '0', '1', '21'),

('107', '0', '469', '469', '4', '4', '1', '', '0', '0', '35'),

('108', '0', '475', '498', '17', '23', '1', '', '0', '13', '164'),

('109', '0', '480', '480', '2', '2', '3', '', '0', '0', '22'),

('110', '0', '489', '493', '20', '4', '7', '', '0', '1', '34'),

('111', '0', '494', '494', '2', '2', '1', '', '0', '0', '38'),

('112', '0', '499', '511', '23', '51', '5', '', '0', '7', '76'),

('113', '0', '505', '530', '23', '23', '1', '', '0', '2', '68'),

('114', '0', '506', '506', '2', '2', '2', '', '0', '0', '16'),

('115', '0', '512', '598', '12', '16', '7', '', '0', '5', '101'),

('116', '0', '516', '516', '2', '2', '3', '', '0', '0', '22'),

('117', '0', '469', '517', '4', '', '7', '', '0', '1', '17'),

('119', '0', '532', '559', '4', '3', '1', '', '0', '8', '71'),

('120', '0', '535', '585', '7', '8', '1', '', '0', '10', '117'),

('121', '0', '543', '551', '4', '2', '1', '', '0', '4', '20'),

('122', '0', '557', '560', '2', '3', '1', '', '0', '1', '24'),

('123', '0', '561', '572', '58', '10', '3', '', '0', '1', '30'),

('124', '0', '562', '562', '2', '2', '2', '', '0', '0', '21'),

('125', '0', '563', '605', '2', '10', '9', '', '0', '6', '26'),

('126', '0', '564', '724', '8', '34', '7', '', '0', '15', '149'),

('127', '0', '567', '583', '4', '4', '4', '', '0', '2', '33'),

('128', '0', '525', '665', '10', '32', '1', '', '0', '15', '105'),

('129', '0', '579', '579', '2', '2', '1', '', '0', '0', '16'),

('130', '0', '581', '608', '12', '10', '7', '', '0', '5', '45'),

('131', '0', '607', '607', '4', '4', '9', '', '0', '0', '6'),

('132', '0', '613', '627', '4', '2', '2', '', '0', '4', '46'),

('133', '0', '616', '618', '4', '4', '1', '', '0', '2', '27'),

('134', '0', '619', '630', '10', '12', '1', '', '0', '5', '74'),

('135', '0', '624', '646', '22', '43', '1', '', '0', '7', '61'),

('136', '0', '634', '650', '3', '16', '1', '', '0', '13', '96'),

('137', '0', '635', '636', '6', '2', '1', '', '0', '1', '32'),

('138', '0', '635', '635', '6', '6', '3', '', '0', '0', '3'),

('139', '0', '634', '639', '3', '4', '5', '', '0', '3', '25'),

('140', '0', '651', '651', '30', '30', '2', '', '0', '0', '33'),

('141', '0', '652', '655', '51', '3', '5', '', '0', '3', '45'),

('142', '0', '656', '703', '32', '32', '1', '', '0', '6', '79'),

('143', '0', '657', '660', '32', '32', '2', '', '0', '2', '39'),

('144', '0', '659', '678', '43', '43', '1', '', '0', '4', '83'),

('145', '0', '662', '673', '51', '24', '5', '', '0', '2', '41'),

('146', '0', '668', '675', '16', '22', '1', '', '0', '3', '59'),

('147', '0', '671', '671', '43', '43', '1', '', '0', '0', '18'),

('148', '0', '677', '799', '4', '4', '7', '', '0', '2', '39'),

('149', '1', '680', '680', '2', '2', '1', '', '0', '0', '19'),

('150', '0', '681', '682', '58', '16', '3', '', '0', '1', '16'),

('151', '0', '683', '736', '3', '23', '1', '', '0', '3', '39'),

('152', '0', '684', '684', '2', '2', '4', '', '0', '0', '8'),

('153', '0', '685', '685', '2', '2', '2', '', '0', '0', '10'),

('154', '0', '686', '688', '21', '2', '1', '', '0', '2', '33'),

('155', '0', '693', '693', '2', '2', '1', '', '0', '0', '8'),

('156', '0', '695', '695', '4', '4', '1', '', '0', '0', '15'),

('157', '0', '696', '798', '15', '4', '7', '', '0', '2', '49'),

('158', '0', '706', '706', '2', '2', '2', '', '0', '0', '7'),

('159', '0', '707', '728', '2', '22', '7', '', '0', '7', '110'),

('160', '0', '709', '725', '3', '2', '2', '', '0', '1', '33'),

('161', '0', '713', '729', '3', '7', '7', '', '0', '5', '77'),

('162', '0', '719', '722', '32', '4', '1', '', '0', '3', '42'),

('163', '1', '723', '727', '4', '3', '1', '', '0', '1', '27'),

('164', '0', '730', '751', '3', '59', '1', '', '0', '5', '76'),

('165', '0', '733', '733', '23', '23', '1', '', '0', '0', '26'),

('166', '0', '735', '735', '23', '23', '1', '', '0', '0', '7'),

('167', '0', '737', '748', '7', '4', '1', '', '0', '4', '52'),

('168', '0', '739', '752', '7', '4', '1', '', '0', '1', '32'),

('169', '0', '741', '743', '34', '7', '1', '', '0', '1', '30'),

('170', '0', '744', '758', '23', '4', '7', '', '0', '1', '35'),

('171', '0', '745', '745', '23', '23', '2', '', '0', '0', '13'),

('172', '0', '749', '750', '18', '34', '1', '', '0', '1', '32'),

('173', '0', '753', '760', '7', '4', '1', '', '0', '6', '43'),

('174', '0', '761', '797', '7', '4', '7', '', '0', '6', '47'),

('175', '0', '767', '774', '35', '4', '1', '', '0', '3', '33'),

('176', '0', '770', '775', '7', '4', '1', '', '0', '4', '20'),

('177', '0', '776', '776', '2', '2', '10', '', '0', '0', '21'),

('178', '0', '777', '804', '21', '4', '1', '', '0', '5', '48'),

('179', '0', '778', '815', '7', '4', '7', '', '0', '16', '110'),

('180', '0', '789', '812', '7', '3', '7', '', '0', '8', '75'),

('181', '0', '789', '793', '7', '32', '1', '', '0', '4', '26'),

('182', '0', '778', '788', '7', '4', '1', '', '0', '10', '46'),

('183', '0', '761', '766', '7', '4', '1', '', '0', '5', '37'),

('184', '0', '696', '697', '15', '2', '1', '', '0', '1', '37'),

('185', '0', '677', '689', '4', '4', '1', '', '0', '1', '29'),

('186', '0', '802', '802', '4', '4', '9', '', '0', '0', '2'),

('187', '0', '808', '817', '22', '22', '10', '', '0', '4', '34'),

('188', '0', '818', '823', '7', '21', '7', '', '0', '3', '17'),

('189', '0', '819', '825', '7', '4', '9', '', '0', '3', '11');
Caused the error:

Duplicate entry '107-1' for key 3
Title: Re: Converting pnphpbb to SMF
Post by: Inforcer on April 19, 2006, 10:19:35 PM
and after RETRY I always get

QuoteConverting...
Converting topics... Unsuccessful!
This query:
INSERT INTO `cmd`.smf_topics

(ID_TOPIC, isSticky, ID_FIRST_MSG, ID_LAST_MSG, ID_MEMBER_STARTED, ID_MEMBER_UPDATED, ID_BOARD, ID_POLL, locked, numReplies, numViews)

VALUES ('6', '0', '6', '247', '2', '40', '1', '', '0', '25', '264'),

('7', '0', '9', '10', '2', '2', '1', '', '1', '1', '32'),

('8', '0', '12', '243', '4', '2', '3', '', '1', '9', '134'),

('9', '0', '17', '127', '10', '10', '4', '', '0', '4', '79'),

('10', '0', '20', '39', '10', '23', '1', '', '0', '2', '37'),

('11', '0', '21', '242', '10', '2', '1', '', '1', '2', '30'),

('12', '0', '34', '36', '12', '4', '1', '', '1', '1', '25'),

('13', '0', '37', '362', '4', '30', '4', '', '0', '9', '106'),

('14', '0', '41', '241', '23', '2', '1', '', '1', '3', '28'),

('16', '0', '50', '233', '20', '2', '1', '', '1', '18', '136'),

('17', '0', '54', '231', '7', '2', '1', '', '1', '6', '81'),

('18', '0', '70', '238', '10', '2', '1', '', '1', '5', '50'),

('19', '0', '83', '234', '14', '2', '1', '', '1', '2', '35'),

('20', '0', '86', '299', '4', '4', '2', '', '0', '10', '113'),

('21', '0', '91', '236', '20', '2', '1', '', '1', '2', '46'),

('22', '0', '96', '239', '4', '2', '1', '', '1', '4', '41'),

('23', '0', '103', '237', '4', '2', '1', '', '1', '3', '45'),

('24', '0', '106', '113', '4', '4', '1', '', '0', '2', '65'),

('25', '0', '107', '240', '29', '2', '1', '', '1', '3', '62'),

('26', '0', '107', '108', '29', '4', '1', '', '0', '1', '4'),

('28', '0', '116', '128', '4', '10', '4', '', '0', '3', '48'),

('30', '0', '121', '244', '4', '2', '5', '', '1', '4', '62'),

('31', '0', '124', '232', '4', '2', '1', '', '1', '21', '158'),

('32', '0', '126', '462', '18', '18', '1', '', '0', '14', '240'),

('33', '0', '135', '176', '14', '14', '3', '', '0', '3', '43'),

('34', '0', '138', '171', '13', '3', '1', '', '1', '6', '73'),

('35', '0', '150', '152', '29', '4', '1', '', '1', '1', '23'),

('36', '0', '154', '273', '15', '35', '2', '', '0', '12', '130'),

('37', '0', '158', '169', '9', '4', '3', '', '0', '5', '39'),

('38', '0', '161', '387', '12', '40', '1', '', '1', '24', '262'),

('39', '0', '179', '261', '4', '22', '3', '', '0', '5', '99'),

('40', '0', '180', '303', '4', '44', '2', '', '0', '6', '70'),

('41', '0', '191', '250', '11', '4', '1', '', '0', '6', '84'),

('42', '0', '193', '309', '2', '2', '1', '', '1', '4', '57'),

('43', '0', '216', '549', '18', '3', '1', '', '0', '16', '172'),

('44', '0', '229', '330', '32', '2', '1', '', '1', '2', '36'),

('45', '0', '230', '296', '40', '7', '1', '', '0', '2', '46'),

('46', '0', '249', '465', '4', '43', '7', '', '0', '6', '87'),

('47', '0', '253', '272', '14', '3', '7', '', '0', '2', '63'),

('48', '0', '262', '269', '4', '16', '1', '', '0', '4', '56'),

('49', '0', '274', '552', '11', '2', '1', '', '0', '4', '68'),

('54', '0', '285', '476', '2', '10', '1', '', '0', '2', '64'),

('59', '0', '297', '311', '10', '10', '1', '', '0', '2', '55'),

('60', '0', '304', '307', '44', '44', '1', '', '0', '2', '31'),

('63', '0', '315', '380', '34', '28', '1', '', '0', '1', '47'),

('64', '0', '320', '338', '4', '29', '1', '', '0', '6', '103'),

('65', '0', '334', '528', '23', '7', '1', '1', '0', '15', '213'),

('66', '0', '335', '336', '23', '4', '4', '', '0', '1', '19'),

('67', '0', '339', '339', '4', '4', '5', '', '0', '0', '22'),

('69', '0', '347', '347', '15', '15', '1', '', '0', '0', '26'),

('70', '0', '348', '460', '29', '44', '1', '', '0', '7', '164'),

('71', '0', '357', '360', '4', '29', '1', '', '0', '2', '49'),

('72', '0', '359', '384', '23', '28', '1', '', '0', '1', '48'),

('73', '0', '361', '440', '43', '35', '1', '', '0', '4', '105'),

('74', '0', '363', '373', '47', '10', '1', '', '0', '2', '39'),

('76', '0', '383', '391', '28', '4', '4', '', '0', '4', '41'),

('78', '0', '395', '395', '4', '4', '9', '', '0', '0', '7'),

('79', '0', '396', '436', '11', '4', '1', '', '0', '5', '72'),

('80', '0', '399', '457', '11', '12', '1', '', '0', '6', '99'),

('81', '0', '404', '434', '4', '4', '2', '', '0', '3', '82'),

('82', '0', '405', '425', '43', '34', '1', '', '0', '4', '57'),

('84', '0', '410', '427', '2', '2', '7', '', '0', '6', '127'),

('86', '0', '419', '419', '2', '2', '1', '', '1', '0', '47'),

('87', '0', '420', '430', '51', '10', '5', '', '0', '1', '47'),

('90', '0', '423', '429', '51', '32', '5', '', '0', '2', '37'),

('91', '0', '431', '472', '51', '26', '5', '2', '0', '3', '115'),

('92', '0', '435', '705', '4', '2', '2', '', '0', '2', '67'),

('96', '0', '443', '443', '2', '2', '1', '', '0', '0', '15'),

('97', '0', '444', '444', '2', '2', '1', '', '0', '0', '33'),

('98', '0', '445', '445', '4', '4', '1', '', '0', '0', '8'),

('99', '0', '447', '533', '10', '4', '1', '', '0', '3', '91'),

('100', '0', '450', '450', '4', '4', '1', '', '0', '0', '36'),

('101', '0', '456', '456', '10', '10', '5', '', '0', '0', '22'),

('103', '0', '461', '461', '51', '51', '5', '', '0', '0', '18'),

('105', '0', '466', '507', '51', '51', '5', '', '0', '8', '177'),

('106', '0', '466', '467', '51', '10', '5', '', '0', '1', '21'),

('107', '0', '469', '469', '4', '4', '1', '', '0', '0', '35'),

('108', '0', '475', '498', '17', '23', '1', '', '0', '13', '164'),

('109', '0', '480', '480', '2', '2', '3', '', '0', '0', '22'),

('110', '0', '489', '493', '20', '4', '7', '', '0', '1', '34'),

('111', '0', '494', '494', '2', '2', '1', '', '0', '0', '38'),

('112', '0', '499', '511', '23', '51', '5', '', '0', '7', '76'),

('113', '0', '505', '530', '23', '23', '1', '', '0', '2', '68'),

('114', '0', '506', '506', '2', '2', '2', '', '0', '0', '16'),

('115', '0', '512', '598', '12', '16', '7', '', '0', '5', '101'),

('116', '0', '516', '516', '2', '2', '3', '', '0', '0', '22'),

('117', '0', '469', '517', '4', '', '7', '', '0', '1', '17'),

('119', '0', '532', '559', '4', '3', '1', '', '0', '8', '71'),

('120', '0', '535', '585', '7', '8', '1', '', '0', '10', '117'),

('121', '0', '543', '551', '4', '2', '1', '', '0', '4', '20'),

('122', '0', '557', '560', '2', '3', '1', '', '0', '1', '24'),

('123', '0', '561', '572', '58', '10', '3', '', '0', '1', '30'),

('124', '0', '562', '562', '2', '2', '2', '', '0', '0', '21'),

('125', '0', '563', '605', '2', '10', '9', '', '0', '6', '26'),

('126', '0', '564', '724', '8', '34', '7', '', '0', '15', '149'),

('127', '0', '567', '583', '4', '4', '4', '', '0', '2', '33'),

('128', '0', '525', '665', '10', '32', '1', '', '0', '15', '105'),

('129', '0', '579', '579', '2', '2', '1', '', '0', '0', '16'),

('130', '0', '581', '608', '12', '10', '7', '', '0', '5', '45'),

('131', '0', '607', '607', '4', '4', '9', '', '0', '0', '6'),

('132', '0', '613', '627', '4', '2', '2', '', '0', '4', '46'),

('133', '0', '616', '618', '4', '4', '1', '', '0', '2', '27'),

('134', '0', '619', '630', '10', '12', '1', '', '0', '5', '74'),

('135', '0', '624', '646', '22', '43', '1', '', '0', '7', '61'),

('136', '0', '634', '650', '3', '16', '1', '', '0', '13', '96'),

('137', '0', '635', '636', '6', '2', '1', '', '0', '1', '32'),

('138', '0', '635', '635', '6', '6', '3', '', '0', '0', '3'),

('139', '0', '634', '639', '3', '4', '5', '', '0', '3', '25'),

('140', '0', '651', '651', '30', '30', '2', '', '0', '0', '33'),

('141', '0', '652', '655', '51', '3', '5', '', '0', '3', '45'),

('142', '0', '656', '703', '32', '32', '1', '', '0', '6', '79'),

('143', '0', '657', '660', '32', '32', '2', '', '0', '2', '39'),

('144', '0', '659', '678', '43', '43', '1', '', '0', '4', '83'),

('145', '0', '662', '673', '51', '24', '5', '', '0', '2', '41'),

('146', '0', '668', '675', '16', '22', '1', '', '0', '3', '59'),

('147', '0', '671', '671', '43', '43', '1', '', '0', '0', '18'),

('148', '0', '677', '799', '4', '4', '7', '', '0', '2', '39'),

('149', '1', '680', '680', '2', '2', '1', '', '0', '0', '19'),

('150', '0', '681', '682', '58', '16', '3', '', '0', '1', '16'),

('151', '0', '683', '736', '3', '23', '1', '', '0', '3', '39'),

('152', '0', '684', '684', '2', '2', '4', '', '0', '0', '8'),

('153', '0', '685', '685', '2', '2', '2', '', '0', '0', '10'),

('154', '0', '686', '688', '21', '2', '1', '', '0', '2', '33'),

('155', '0', '693', '693', '2', '2', '1', '', '0', '0', '8'),

('156', '0', '695', '695', '4', '4', '1', '', '0', '0', '15'),

('157', '0', '696', '798', '15', '4', '7', '', '0', '2', '49'),

('158', '0', '706', '706', '2', '2', '2', '', '0', '0', '7'),

('159', '0', '707', '728', '2', '22', '7', '', '0', '7', '110'),

('160', '0', '709', '725', '3', '2', '2', '', '0', '1', '33'),

('161', '0', '713', '729', '3', '7', '7', '', '0', '5', '77'),

('162', '0', '719', '722', '32', '4', '1', '', '0', '3', '42'),

('163', '1', '723', '727', '4', '3', '1', '', '0', '1', '27'),

('164', '0', '730', '751', '3', '59', '1', '', '0', '5', '76'),

('165', '0', '733', '733', '23', '23', '1', '', '0', '0', '26'),

('166', '0', '735', '735', '23', '23', '1', '', '0', '0', '7'),

('167', '0', '737', '748', '7', '4', '1', '', '0', '4', '52'),

('168', '0', '739', '752', '7', '4', '1', '', '0', '1', '32'),

('169', '0', '741', '743', '34', '7', '1', '', '0', '1', '30'),

('170', '0', '744', '758', '23', '4', '7', '', '0', '1', '35'),

('171', '0', '745', '745', '23', '23', '2', '', '0', '0', '13'),

('172', '0', '749', '750', '18', '34', '1', '', '0', '1', '32'),

('173', '0', '753', '760', '7', '4', '1', '', '0', '6', '43'),

('174', '0', '761', '797', '7', '4', '7', '', '0', '6', '47'),

('175', '0', '767', '774', '35', '4', '1', '', '0', '3', '33'),

('176', '0', '770', '775', '7', '4', '1', '', '0', '4', '20'),

('177', '0', '776', '776', '2', '2', '10', '', '0', '0', '21'),

('178', '0', '777', '804', '21', '4', '1', '', '0', '5', '48'),

('179', '0', '778', '815', '7', '4', '7', '', '0', '16', '110'),

('180', '0', '789', '812', '7', '3', '7', '', '0', '8', '75'),

('181', '0', '789', '793', '7', '32', '1', '', '0', '4', '26'),

('182', '0', '778', '788', '7', '4', '1', '', '0', '10', '46'),

('183', '0', '761', '766', '7', '4', '1', '', '0', '5', '37'),

('184', '0', '696', '697', '15', '2', '1', '', '0', '1', '37'),

('185', '0', '677', '689', '4', '4', '1', '', '0', '1', '29'),

('186', '0', '802', '802', '4', '4', '9', '', '0', '0', '2'),

('187', '0', '808', '817', '22', '22', '10', '', '0', '4', '34'),

('188', '0', '818', '823', '7', '21', '7', '', '0', '3', '17'),

('189', '0', '819', '825', '7', '4', '9', '', '0', '3', '11');
Caused the error:

Duplicate entry '6' for key 1