Converting pnphpbb to SMF

[Inforcer]

SMF Version: SMF 1.1 RC2
Hello,

I have used the convert.php with the phpbb2smf.sql but I always get

"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?

[Oldiesmann]

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.

[Inforcer]

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

[Inforcer]

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 ... 

[Inforcer]

I ot further but now I am definitely stuck!

Converting...
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

[Inforcer]

and after RETRY I always get

Converting...
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