Duplicate Entry Error when converting I have tried everything here, please help!

[phaeth]

I have tried everything in these forums and on the net.  I cannot resolve this error when converting.

I have checked the database multiple times and the duplicate entry does not exist!  I have deleted it and then it goes to the next entry with the same error.  I tried remove every single duplicate entry it cries about one by one.  And then I get the error from the beginning of the insert all over again.

I'm losing my mind and am so frustrated at this point.  I see people have this problem in posts from over a year ago and nobody has posted a real resolution to this problem.  The only people able to get around it are those that did not need the converter in the first place.  I'm not savvy with working in mysql databases thus the need for the converter.

Please help!

Code Select Expand

Converting topics... Unsuccessful!
This query:

    INSERT INTO tagge3_forumSMF.3s3m3f_topics
    (ID_TOPIC, isSticky, ID_FIRST_MSG, ID_LAST_MSG, ID_MEMBER_STARTED, ID_MEMBER_UPDATED, ID_BOARD, ID_POLL, locked, numReplies, numViews)
    VALUES ('1082', '0', '4617', '14929', '408', '657', '8', '', '0', '5', '273'),
    ('1083', '0', '4629', '4630', '551', '2', '1', '', '0', '1', '179'),
    ('1084', '0', '4643', '4652', '609', '451', '8', '', '0', '2', '83'),
    ('1085', '0', '4644', '4645', '610', '16', '32', '', '0', '1', '90'),
    ('1086', '0', '4646', '4646', '331', '331', '10', '', '0', '0', '6'),
    ('1087', '0', '4647', '4656', '611', '3', '32', '', '0', '3', '100'),
    ('1088', '0', '4648', '4650', '240', '567', '1', '', '0', '1', '128'),
    ('1090', '0', '4657', '4712', '613', '613', '32', '', '0', '7', '237'),
    ('1091', '0', '4658', '4689', '590', '355', '8', '', '0', '7', '90'),
 
...blah blah blah... more of this here

     ('1610', '0', '7729', '7750', '421', '421', '8', '', '0', '7', '109'),
    ('1612', '0', '7758', '7798', '762', '762', '8', '', '1', '3', '107'),
    ('1613', '0', '7765', '8095', '567', '398', '1', '', '0', '17', '421'),
    ('1614', '0', '7774', '7889', '84', '567', '1', '', '0', '9', '250'),
    ('1616', '0', '7781', '7867', '93', '567', '1', '', '0', '2', '138'),
    ('1618', '0', '7799', '7824', '567', '567', '8', '', '0', '2', '28'),
    ('1620', '0', '7721', '7806', '356', '3', '8', '', '0', '15', '118'),
    ('1622', '0', '7819', '8096', '398', '398', '1', '', '0', '14', '238');

Caused the error:

    Duplicate entry '1082' for key 1


[phaeth]

gr rr

[SleePy]

Using phpmyadmin go look at your phpbb database.

Go to the topics table. And then search for in the id_topic or what ever phpbb calls it for '1082'

You should find two of them. One of them is causing the issue So one needs to either be changed or deleted (which may cause issues with the messages linked to the topic).
Should figure out which one has more posts in it than the other and delete the one with little or no posts.

[JayBachatero]

Have you tried the converter in the sticky topic?