phpbb2 to smf

[rbaobao]

I have installed the SMF, and i tried to use the 1.1 converter to convert my phpbb2 forum to smf.
When it was converting, it said

Converting topics... Unsuccessful!
This query:
INSERT INTO `fccinfo2_smf`.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 ('553', '0', '1936', '1936', '12', '12', '10', '', '0', '0', '161'),
('554', '0', '1937', '1937', '12', '12', '10', '', '0', '0', '156'),
('555', '0', '1938', '1938', '12', '12', '12', '', '0', '0', '150'),
('556', '0', '1950', '2069', '53', '79', '9', '', '0', '2', '182'),
('557', '0', '1953', '2925', '53', '15', '14', '', '0', '1', '275'),
('558', '0', '1959', '2889', '20', '102', '2', '', '0', '17', '876'),
('559', '0', '1965', '2004', '20', '9', '16', '', '0', '1', '45'),
('560', '0', '1968', '2130', '24', '20', '36', '', '0', '2', '45'),
('561', '0', '1978', '2052', '20', '18', '36', '', '0', '2', '27'),
('562', '0', '1980', '2046', '20', '6', '34', '', '0', '3', '27'),
('563', '0', '1988', '2008', '6', '5', '25', '', '0', '2', '9'),
('564', '0', '2016', '2028', '5', '90', '10', '', '0', '2', '256'),
('565', '0', '2017', '2113', '5', '13', '12', '', '0', '2', '189'),
('566', '0', '2018', '2018', '5', '5', '12', '', '0', '0', '114'),
('567', '0', '2019', '2019', '5', '5', '12', '', '0', '0', '92'),
('568', '0', '2021', '2044', '9', '24', '36', '', '0', '1', '27'),
('569', '0', '2023', '4091', '18', '147', '8', '', '0', '9', '526'),
('570', '0', '2026', '2117', '91', '20', '3', '', '0', '1', '194'),
('571', '0', '2050', '2162', '32', '32', '16', '', '0', '9', '102'),
('572', '0', '2051', '2122', '20', '18', '38', '', '0', '3', '34'),
('573', '0', '2058', '2058', '38', '38', '16', '', '0', '0', '48'),
('574', '0', '2070', '2110', '29', '20', '38', '', '0', '4', '48'),
('575', '0', '2074', '2221', '38', '21', '16', '', '0', '7', '135'),
('576', '0', '2087', '2105', '20', '20', '16', '', '0', '2', '50'),
('577', '0', '2094', '2866', '39', '79', '11', '', '0', '1', '299'),
('578', '0', '2095', '2120', '39', '79', '9', '', '0', '2', '178'),
('579', '0', '2096', '2096', '39', '39', '9', '', '0', '0', '120'),
('580', '0', '2111', '2111', '44', '44', '39', '', '0', '0', '26'),
('582', '0', '2116', '2251', '12', '53', '13', '', '0', '2', '240'),
('583', '0', '2118', '2140', '12', '75', '10', '', '0', '1', '154'),
('584', '0', '2119', '2119', '12', '12', '12', '', '0', '0', '87'),
('585', '0', '2129', '2129', '24', '24', '13', '', '0', '0', '36'),
('586', '0', '2131', '2141', '24', '11', '13', '', '0', '1', '96'),
('587', '0', '2133', '2133', '24', '24', '13', '', '0', '0', '38'),
('588', '0', '2135', '3608', '18', '138', '8', '', '0', '13', '480'),
('589', '0', '2143', '2143', '45', '45', '14', '', '0', '0', '142'),
('590', '0', '2145', '2232', '45', '3', '34', '', '0', '1', '17'),
......
.....
Caused the error:

Duplicate entry '553' for key 1


How to solve this problem?
thanks.

[rbaobao]

the first error i got is:
'1052', '0', '4456', '4510', '39', '65', '12', '', '0', '1', '161'),
('1053', '0', '4458', '5027', '6', '6', '25', '', '0', '8', '58'),
('1054', '0', '4473', '4497', '102', '19', '37', '', '0', '2', '30'),
('1056', '0', '4487', '4544', '101', '35', '39', '', '0', '1', '49'),
('1057', '0', '4490', '4535', '24', '75', '13', '', '0', '2', '135'),
('1058', '0', '4492', '4511', '24', '14', '13', '', '0', '1', '181'),
('1059', '0', '4501', '4820', '18', '11', '8', '', '0', '12', '380'),
('1060', '0', '4503', '4809', '18', '154', '8', '', '0', '9', '350'),
('1061', '0', '4505', '4810', '18', '154', '8', '', '0', '10', '371'),
('1062', '0', '4519', '4528', '100', '45', '37', '', '0', '3', '43'),
('1063', '0', '4522', '4685', '20', '45', '16', '', '0', '4', '94'),
('1065', '0', '4562', '4563', '39', '144', '12', '', '0', '1', '148'),
('1066', '0', '4567', '4769', '144', '144', '33', '', '0', '10', '106'),
('1067', '0', '4568', '4571', '21', '3', '34', '', '0', '1', '21'),
('1068', '0', '4579', '4579', '24', '24', '13', '', '0', '0', '43'),
('1069', '0', '4580', '4580', '24', '24', '13', '', '0', '0', '68'),
('1070', '0', '4581', '4581', '24', '24', '13', '', '0', '0', '74'),
('1071', '0', '4582', '4582', '24', '24', '13', '', '0', '0', '71'),
('1072', '0', '4584', '4584', '136', '136', '12', '', '0', '0', '96'),
('1073', '0', '4585', '4592', '136', '145', '10', '', '0', '1', '156'),
('1074', '0', '4586', '4586', '136', '136', '10', '', '0', '0', '155'),
('1075', '0', '4587', '4774', '136', '44', '8', '', '0', '14', '547'),
('1076', '0', '4591', '25367', '145', '456', '5', '', '0', '88', '2704'),
('1077', '0', '4595', '4749', '100', '27', '16', '', '0', '10', '109'),
('1078', '0', '4596', '4761', '19', '19', '16', '', '0', '3', '79'),
('1079', '0', '4597', '4620', '14', '66', '10', '', '0', '1', '159'),
('1080', '0', '4601', '4601', '39', '39', '9', '', '0', '0', '75'),
('1081', '0', '4602', '5007', '14', '142', '2', '', '0', '1', '386'),
('1082', '0', '4603', '5257', '39', '66', '9', '', '0', '13', '336'),
('1083', '0', '4604', '4907', '18', '47', '38', '', '0', '36', '296');
Caused the error:

Duplicate entry '3038-16' for key 3

and after i clicked the 'Try again', i got the above one

[Fizzy]

Hi,

Can you try emptying only the "smf_topics" table using phpmyadmin and run the convertor again and see if you get the same error messages

[rbaobao]

I got the same error.

[rbaobao]

anyone can help me?!?!

[Fizzy]

If the receiving table was truncated (emptied) then you might have a duplicate entry in your phpbb2 table.
Can you verify that?

If so, you could renumber the duplicate in phpbb2 to a high figure and then run Admin Panel Forum Maintenance to correct the error for you.