News:

SMF 2.1.4 has been released! Take it for a spin! Read more.

Main Menu

Convert problem :|

Started by LukaNS, November 23, 2007, 02:49:23 PM

Previous topic - Next topic

LukaNS

Hi, i wanted to convert YaBB 2.1 to SMF and i've got error:
Converting posts (part 3)... Successful.
Converting attachments (if the mod is installed)... Successful.
Cleaning up (part 1)... Successful.
Cleaning up (part 2)... Successful.
Converting polls and poll choices... Successful.
Converting polls and poll choices (part 2)... Successful.
Converting poll votes... Unsuccessful!
This query:

    INSERT INTO `autobusi_smf1`.smf_log_polls
    (ID_POLL, ID_MEMBER, ID_CHOICE)
    VALUES ('2', '0', '3'),
    ('2', '2', '2'),
    ('2', '0', '4'),
    ('2', '0', '4'),
    ('2', '108', '2'),
    ('2', '84', '0'),
    ('2', '0', '4'),
    ('2', '0', '4'),
    ('2', '0', '1'),
    ('2', '0', '4'),
    ('2', '0', '4'),
    ('2', '0', '4'),
    ('2', '23', '3'),
    ('2', '0', '5'),
    ('2', '0', '7'),
    ('2', '0', '3'),
    ('2', '0', '7'),
    ('2', '0', '5'),
    ('2', '0', '3'),
    ('2', '0', '0'),
    ('2', '0', '5'),
    ('2', '0', '0'),
    ('2', '0', '4'),
    ('2', '0', '4'),
    ('2', '0', '2'),
    ('2', '22', '1'),
    ('2', '0', '2'),
    ('2', '0', '0'),
    ('2', '109', '4'),
    ('2', '81', '7'),
    ('2', '95', '4'),
    ('2', '73', '4'),
    ('2', '49', '0'),
    ('3', '73', '7'),
    ('3', '22', '2'),
    ('3', '59', '3'),
    ('3', '62', '5'),
    ('3', '68', '3'),
    ('3', '83', '6'),
    ('3', '49', '0'),
    ('5', '53', '1'),
    ('5', '47', '3'),
    ('5', '29', '0'),
    ('5', '95', '0'),
    ('5', '78', '0'),
    ('5', '82', '1'),
    ('5', '49', '4'),
    ('13', '22', '2'),
    ('13', '62', '3'),
    ('13', '81', '4'),
    ('13', '73', '0'),
    ('13', '83', '2'),
    ('13', '49', '5');

Caused the error:

    Duplicate entry '2-0-4' for key 1



I've found somewhere that I need to empty something in phpMyadmin, but i couldn't find it there..

Can someone help me?

SleePy

well besides SMF not doing guest posting.. there is a bunch of guest posts.

The only way to get around this would be to remove the guest posts.
I know yabb runs flat file so I don't got any fancy queries to remove the guest posts sadly :(
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

LukaNS

I don't have any guest post. It was disabled, even guest viewing of forum..   :-\

SleePy

Sorry I meant guest polls, a typo on my part.

From the query above it tells me that there is polls that guests are posting in.
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

JayBachatero

Try the converter in the sticky on this board.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

akyeame

I'm having the same issue. Any ideas on how to resolve?

I appreciate the assistance and I look forward to running my SMF board!



Converting poll votes... Unsuccessful!
This query:

    INSERT INTO `abibitum_smf1`.smf_log_polls
    (ID_POLL, ID_MEMBER, ID_CHOICE)
    VALUES ('13', '71', '0,4'),
    ('13', '39', '0,4'),
    ('13', '42', '2'),
    ('13', '126', '2'),
    ('13', '128', '0,1'),
    ('9', '0', '0'),
    ('9', '0', '0'),
    ('9', '96', '0'),
    ('9', '0', '0'),
    ('9', '71', '0'),
    ('9', '256', '0'),
    ('9', '10', '0'),
    ('9', '91', '0'),
    ('9', '2', '0'),
    ('14', '324', '0'),
    ('14', '0', '0'),
    ('14', '42', '0'),
    ('14', '2', '0'),
    ('26', '136', '2'),
    ('26', '239', '2'),
    ('26', '2', '2'),
    ('26', '28', '2'),
    ('26', '42', '1'),
    ('26', '117', '2'),
    ('26', '10', '2'),
    ('26', '0', '2'),
    ('35', '7', '5,6'),
    ('35', '256', '0,1,4'),
    ('35', '2', '0,1,5'),
    ('35', '10', '0,5'),
    ('35', '71', '5'),
    ('35', '239', '1,2,5'),
    ('15', '6', '0'),
    ('15', '0', '0'),
    ('15', '0', '0'),
    ('15', '10', '0'),
    ('15', '2', '0'),
    ('4', '7', '2'),
    ('4', '200', '8'),
    ('4', '245', '7'),
    ('4', '10', '1'),
    ('4', '6', '2'),
    ('4', '57', '7'),
    ('4', '71', '1'),
    ('4', '239', '5,7'),
    ('17', '7', '0,1,3'),
    ('17', '254', '0'),
    ('17', '10', '0,2,4,7'),
    ('17', '256', '0,1,2,3,4,5,6'),
    ('17', '69', '0'),
    ('17', '0', '0'),
    ('17', '0', '0,2'),
    ('17', '200', '5'),
    ('17', '71', '0,3'),
    ('17', '2', '0,1,2,3,4,5,6,7'),
    ('17', '239', '0');

Caused the error:

    Duplicate entry '13-71-0' for key 1


JayBachatero

Which converter are you using?
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Advertisement: