Error converting phpbb2 to SMF

[Hponce]

Hi Guys, when i Run the convert.php i'm getting this error.

=====


phpBB2 to SMF Converter

Code Select Expand


Converting...

Converting ranks... Successful.


Converting groups... Successful.
Converting members... Successful.
Converting additional member groups... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Unsuccessful!
This query:

    INSERT INTO `volksgdl_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 ('2548', '0', '7727', '8291', '772', '772', '13', '', '0', '2', '155'),
    ('2549', '0', '7732', '7778', '844', '178', '2', '', '0', '2', '131'),
    ('2550', '0', '7757', '7850', '71', '45', '2', '', '0', '10', '157'),
    ('2551', '0', '7759', '7894', '123', '26', '2', '', '0', '9', '228'),
    ('2552', '0', '7772', '8161', '1057', '1057', '1', '', '0', '16', '321'),
    ('2553', '0', '7803', '14764', '45', '1580', '2', '', '0', '27', '602'),
    ('2554', '0', '7806', '7806', '1490', '1490', '9', '', '0', '0', '76'),
    ('2555', '0', '7812', '15646', '1531', '1692', '15', '', '0', '38', '1162'),
    ('2556', '0', '7815', '15962', '1541', '71', '1', '', '0', '35', '1181'),
    ('2557', '1', '7834', '13993', '542', '1802', '1', '', '0', '19', '577'),
    ('2558', '0', '7840', '7968', '1247', '45', '2', '', '0', '11', '297'),
    ('2559', '0', '7861', '11825', '182', '182', '11', '', '0', '10', '428'),
    ('2560', '0', '7871', '7977', '1559', '1559', '2', '', '0', '5', '166'),
    ('2561', '0', '7876', '7990', '1065', '45', '2', '', '0', '8', '221'),
    ('2562', '0', '7876', '7880', '1065', '1065', '1', '', '0', '3', '9'),
    ('2563', '0', '7896', '8473', '178', '45', '9', '', '0', '12', '266'),
    ('2564', '0', '7904', '11737', '1490', '36', '1', '', '0', '11', '400'),
    ('2565', '0', '7905', '7940', '1490', '106', '1', '', '0', '1', '110'),
    ('2567', '0', '7916', '7916', '161', '161', '8', '', '0', '0', '273'),
    ('2568', '0', '7920', '7920', '1544', '1544', '8', '', '0', '0', '256'),
    ('2570', '0', '7934', '7987', '45', '542', '1', '', '0', '9', '257'),
    ('2571', '0', '7936', '7939', '106', '106', '12', '', '0', '2', '169'),
    ('2572', '0', '7944', '7992', '5', '106', '1', '', '0', '6', '235'),
    ('2573', '0', '7946', '12558', '739', '5', '15', '', '0', '9', '423'),
    ('2574', '0', '7952', '8064', '1559', '161', '2', '', '0', '5', '158'),
    ('2575', '0', '7961', '11044', '1262', '1001', '4', '', '0', '3', '151'),
    ('2577', '0', '7970', '8090', '886', '1001', '15', '', '0', '4', '304'),
    ('2578', '0', '7979', '8063', '45', '45', '2', '', '0', '5', '202'),
    ('2579', '0', '7986', '8061', '123', '45', '2', '', '0', '9', '207'),
    ('2581', '0', '7998', '17127', '1559', '2064', '2', '', '0', '14', '431'),
    ('2582', '0', '7999', '8073', '1559', '1559', '2', '', '0', '5', '156'),
    ('2583', '0', '8007', '14349', '45', '45', '15', '', '0', '97', '2025'),
    ('2584', '0', '8011', '8020', '1539', '1531', '2', '', '0', '2', '110'),
    ('2585', '0', '8023', '8149', '178', '178', '2', '', '0', '3', '146'),
    ('2586', '0', '8026', '8082', '1065', '1001', '1', '', '0', '8', '241'),
    ('2587', '0', '8066', '8077', '370', '542', '2', '', '0', '3', '160'),
    ('2588', '0', '8086', '8416', '161', '45', '6', '', '0', '8', '418'),
    ('2589', '0', '8089', '9461', '1001', '1622', '11', '', '0', '9', '397'),
    ('2590', '0', '8104', '12096', '161', '356', '1', '', '0', '7', '199'),
    ('2591', '0', '8108', '8109', '83', '1531', '2', '', '0', '1', '88'),
    ('2592', '0', '8111', '8111', '1531', '1531', '2', '', '0', '0', '83'),
    ('2593', '0', '8123', '15810', '1065', '1931', '3', '', '0', '16', '492'),
    ('2594', '0', '8125', '8214', '192', '17', '2', '', '0', '4', '207'),
    ('2595', '0', '8128', '8133', '1539', '1531', '2', '', '0', '1', '82'),
    ('2596', '1', '8134', '8747', '1531', '26', '12', '', '1', '2', '135'),
    ('2597', '0', '8139', '8423', '1531', '1531', '1', '', '0', '5', '148'),
    ('2598', '0', '8157', '8237', '1559', '1559', '2', '', '0', '7', '265'),
    ('2599', '0', '8158', '8241', '329', '329', '1', '', '0', '2', '129'),
    ('2600', '0', '8167', '8177', '232', '45', '6', '', '0', '3', '195'),
    ('2601', '0', '8183', '9334', '4', '1623', '2', '', '0', '3', '291'),
    ('2602', '0', '8188', '8252', '45', '1531', '1', '', '0', '6', '138'),
    ('2603', '0', '8229', '8266', '258', '26', '8', '', '0', '6', '341'),
    ('2604', '0', '8242', '8499', '71', '71', '1', '', '0', '20', '342'),
    ('2605', '0', '8261', '12799', '45', '45', '1', '', '0', '51', '815'),
    ('2606', '0', '8269', '8271', '153', '1057', '2', '', '0', '1', '132'),
    ('2607', '0', '8282', '11413', '1247', '1587', '3', '', '0', '10', '351'),
    ('2608', '0', '8292', '8292', '772', '772', '13', '', '0', '0', '134'),
    ('2609', '0', '8295', '8295', '71', '71', '5', '', '0', '0', '253'),
    ('2610', '0', '8295', '8296', '71', '', '1', '', '0', '1', '9'),
    ('2611', '0', '8298', '8735', '1562', '1531', '2', '', '0', '4', '201'),
    ('2612', '0', '8308', '10390', '1057', '1661', '2', '', '0', '19', '402'),
    ('2613', '0', '8310', '8334', '1001', '161', '1', '', '0', '8', '160'),
    ('2614', '0', '8330', '9517', '161', '106', '1', '', '0', '13', '323'),
    ('2615', '0', '8345', '16695', '772', '1690', '15', '', '0', '51', '1351'),
    ('2616', '0', '8354', '8374', '45', '45', '2', '', '0', '11', '284'),
    ('2617', '0', '8366', '8378', '370', '26', '2', '', '0', '3', '114'),
    ('2618', '0', '8370', '8414', '161', '45', '1', '', '0', '6', '139'),
    ('2619', '0', '8379', '9115', '1057', '1541', '8', '', '0', '10', '493'),
    ('2620', '0', '8385', '12455', '106', '1709', '6', '', '0', '24', '951'),
    ('2621', '0', '8394', '8973', '192', '1531', '2', '', '0', '12', '212'),
    ('2622', '0', '8419', '9878', '1490', '168', '1', '', '0', '22', '611'),
    ('2624', '0', '8435', '8444', '1539', '1539', '2', '', '0', '2', '112'),
    ('2625', '0', '8436', '8561', '1569', '1531', '2', '', '0', '7', '239'),
    ('2626', '0', '8440', '8455', '1570', '5', '1', '', '0', '5', '70'),
    ('2632', '0', '8469', '16304', '1490', '1882', '8', '', '0', '18', '604'),
    ('2639', '0', '8488', '8691', '1577', '1531', '1', '', '0', '8', '158'),
    ('2641', '0', '8496', '9074', '1580', '1579', '2', '', '0', '17', '395'),
    ('2642', '0', '8505', '8773', '1539', '71', '2', '', '0', '12', '250'),
    ('2644', '0', '8508', '8535', '1580', '26', '1', '', '0', '2', '91'),
    ('2649', '0', '8520', '8552', '4', '4', '2', '', '0', '2', '112'),
    ('2650', '0', '8526', '8531', '1577', '178', '2', '', '0', '1', '80'),
    ('2651', '0', '8533', '8774', '1543', '1112', '2', '', '0', '7', '172'),
    ('2652', '0', '8508', '8521', '1580', '5', '2', '', '0', '1', '14'),
    ('2653', '0', '8541', '10635', '106', '1559', '1', '', '0', '29', '392'),
    ('2654', '0', '8555', '8584', '161', '26', '1', '', '0', '1', '57'),
    ('2655', '0', '8558', '8923', '1583', '1583', '2', '', '0', '4', '149'),
    ('2656', '0', '8558', '8558', '1583', '1583', '1', '', '0', '0', '8'),
    ('2657', '0', '8563', '9039', '772', '1064', '1', '', '0', '22', '378'),
    ('2669', '0', '8600', '8601', '1579', '1580', '2', '', '0', '1', '118'),
    ('2670', '0', '8602', '8689', '1585', '26', '1', '', '0', '21', '151'),
    ('2671', '0', '8603', '8603', '1585', '1585', '7', '', '0', '0', '88'),
    ('2672', '0', '8604', '8604', '1585', '1585', '7', '', '0', '0', '56'),
    ('2673', '0', '8607', '10084', '1586', '34', '1', '', '0', '13', '342'),
    ('2674', '0', '8627', '8915', '1131', '178', '2', '', '0', '4', '192'),
    ('2675', '0', '8632', '8632', '1001', '1001', '1', '', '0', '0', '76'),
    ('2678', '0', '8641', '8693', '886', '1531', '3', '', '0', '1', '84'),
    ('2679', '0', '8643', '9875', '5', '34', '10', '', '0', '5', '199'),
    ('2680', '0', '8647', '8662', '161', '26', '1', '', '0', '1', '36'),
    ('2681', '0', '8649', '12307', '1588', '1709', '1', '', '0', '7', '391'),
    ('2682', '0', '8649', '8650', '1588', '26', '15', '', '0', '1', '3'),
    ('2687', '0', '8670', '8674', '1585', '5', '1', '', '0', '2', '92'),
    ('2694', '0', '8696', '8696', '1591', '1591', '3', '', '0', '0', '102'),
    ('2695', '0', '8699', '8717', '1591', '26', '1', '', '0', '2', '93'),
    ('2703', '0', '8716', '8985', '1580', '1580', '2', '', '0', '8', '212'),
    ('2711', '0', '8753', '12573', '106', '1001', '1', '', '0', '12', '180'),
    ('2712', '0', '8754', '16883', '1583', '1882', '6', '', '0', '8', '409'),
    ('2715', '0', '8767', '8835', '4', '4', '2', '', '0', '8', '203'),
    ('2716', '0', '8775', '8775', '1531', '1531', '12', '', '0', '0', '69'),
        ('3336', '0', '12240', '12890', '71', '178', '2', '', '0', '8', '167'),
    ('3338', '0', '12268', '12275', '45', '45', '1', '', '0', '2', '80'),
    ('3339', '0', '12283', '12320', '1745', '45', '1', '', '0', '8', '100'),
    ('3340', '0', '12291', '12364', '1665', '542', '1', '', '0', '8', '161'),
    ('3341', '0', '12297', '12413', '33', '106', '1', '', '0', '11', '128'),
    ('3342', '0', '12311', '15598', '1746', '258', '2', '', '0', '28', '588'),
    ('3343', '0', '12314', '12365', '1580', '1580', '9', '', '0', '4', '112'),
    ('3346', '0', '12321', '12764', '1490', '1586', '1', '25', '0', '23', '337'),
    ('3347', '0', '12354', '16514', '5', '1882', '13', '', '0', '13', '273'),
    ('3348', '0', '12366', '12772', '1490', '83', '1', '', '0', '5', '152'),
    ('3349', '0', '12381', '15197', '40', '40', '15', '', '0', '12', '256'),
    ('3350', '0', '12386', '16942', '1700', '1700', '15', '', '0', '86', '1744'),
    ('3351', '0', '12387', '12431', '1541', '26', '1', '', '0', '3', '65'),
    ('3352', '0', '12388', '12434', '1580', '1001', '9', '', '0', '1', '81'),
    ('3353', '0', '12389', '12396', '1580', '1531', '3', '', '0', '1', '111'),
    ('3355', '0', '12398', '12412', '1755', '106', '1', '', '0', '2', '57'),
    ('3356', '0', '12409', '12547', '4', '542', '2', '', '0', '1', '67'),
    ('3357', '0', '12423', '12600', '1755', '1490', '3', '', '0', '1', '146'),
    ('3358', '0', '12427', '12590', '1559', '71', '1', '', '0', '7', '135'),
    ('3359', '0', '12435', '12470', '1578', '4', '2', '', '0', '3', '107'),
    ('3360', '0', '12437', '12541', '1745', '1490', '1', '', '0', '9', '115'),
    ('3361', '0', '12438', '12592', '5', '45', '1', '', '0', '9', '168');

Caused the error:

    Duplicate entry '2548' for key 1

[Hponce]

  Any Idea???

[jackulator]

I'm having the exact same problem - could it have something to do with my having installed a topic prioritizing mod called 'topic cement' for my old phpbb forum??

here's a link to that mod:

http://www.phpbb.com/community/viewtopic.php?f=15&t=219682&start=0 [nofollow]

other than that, the forums and member lists are all converted, so I've very sad 

[SleePy]

The error is from it finding a duplicate topic ID.

Check your phpbb database. Is there a duplicate topic in there with the same ID?

[jackulator]

I looked at the database using phpMyAdmin and could not find any duplicate topicID

I did however change the ID in the database, and then hit 'TryAgain' on the converter, only to have it come up with another duplicate in the same line - which I then changed, and was told of yet another duplicate in the same line, and after changing that one and hit 'TryAgain', the error was identical to the very first one - ie duplicate topicID, but this time it was for the next line down - so I imagine unless I can figure out what's going on, in order to get it to work I'd have to go through each line and alter the database

it's almost like the converter thinks it's being asked to duplicate every entry in the database rather than copy the existing entries into new lines with the _smf prefix or whatever it is

so, on the main page of my smf forum, the post counts and replies are all accurately shown in the columns corresponding to the various forums, but there aren't any 'last reply' listings in the far right column - it's just blank down all the forums - and when you click into a forum, there aren't any posts/replies in any of them

other than that, the members are all there, along with their avatars

just very disappointed I can't figure this out - and I did everything by the book, so I would think that there'd be more people with this problem

I also uninstalled the 'topicCement' mod I mentioned in my last reply just to see if that would help - makes no difference whatsoever

[jackulator]

here's a recap/update of my situation from the beginning:

1. I had a phpbb 2 forum and wanted more features, so I uploaded smf 1-1-3 to a new folder on my site and it installed fine

2. I then wanted to bring over all of my posts/members etc from the phpbb forum, so I ran the converter tool

3. the converter tool was telling me that the user name for the new smf database did not have access to the database for the phpbb forum

4. I deleted the smf install and redid it in a new folder, but this time having smf 1-1-3 install it's data into the same database as the phpbb forum, which is what was recommended on this site

5. the conversion successfully got as far as converting topics, at which point it failed saying there was a duplicate topicID

6. I used phpMyAdmin and could not find any duplicate topicID, and after doing some manipulation of the data that the converter was telling me was causing the error, I came to the conclusion that I had better start again

7. I noticed that the converter tool I had used was 'smf_1-1-2_phpbb2_converter.zip', but the install of smf I had was 'smf_1-1-3_install.zip', so I decided to do another fresh smf install of smf 1-1-2 and perhaps the converter tool might work

8. I went to my host's database manager and created a blank database

9. I uploaded 1-1-2 to a new folder on my site, and told the smf install to create data in the new database from step 8, and the install went perfectly as usual

10. I ran the converter tool again, and once again was told that the user name for the smf database did not have access to the phpbb forum, so I went to my host's control panel and found that they have it set up so that one cannot simply add a preexisting user to multiple databases, but rather one could click 'create user' and it would generate a random username/password for a new user - so bottom line, there was no way I was going to be able to have the user for the new smf database be able to access the database for the old phpbb forum

11. so I talked with my host company, and at the moment they are, and I believe the terminology is correct (I know nothing of any of this stuff), going to INSERT the entire phpbb database into my new swf database

Once this is done I'm hoping that:

1. when I launch the converter tool I can enter the same database for smf and phpbb and the converter tool won't object

2. when the converter tool runs I won't end up with the same problem as before - the phantom duplicate topicIDs or whatever the problem was that I replied to in someone's earlier reply in this topic

3. be able to upgrade to smf 1-1-3 after the conversion is successfully completed

[JayBachatero]

Use the converter from the [SMF Converter] phpBB - 2.0.19+ topic.

[jackulator]

oddly enough, when I click the converter in the first post in the link you gave me, it leads me not to a topic where the converter you want me to use is, nor to the converter itself, but to the main page of the smf forums

[JayBachatero]

That's weird.  I'll reupload the file tonight when I get home then.  Are you logged in when trying to download the file?