Topic: Yabb 2.1 conversion error

[kelltech]

hello-

everything with installation is going well, but now the conversion process is acting up, I have the following error and I don't know what to do from here ("Try Again" repeats the same error):

Converting poll votes... Unsuccessful!
This query:

    INSERT INTO `american_smf1`.smf_log_polls
    (ID_POLL, ID_MEMBER, ID_CHOICE)
    VALUES ('15', '184', '2'),
    ('15', '36', '2'),
    ('15', '198', '0'),
    ('15', '197', '2'),
    ('15', '62', '2'),
    ('12', '199', '0'),
    ('12', '184', '2'),
    ('12', '0', '3'),
    ('12', '197', '2'),
    ('12', '198', '2'),
    ('9', '0', '3'),
    ('9', '0', '4'),
    ('9', '0', '0'),
    ('9', '0', '3'),
    ('9', '0', '7'),
    ('9', '0', '3'),
    ('9', '0', '3'),
    ('9', '0', '1'),
    ('9', '0', '3'),
    ('9', '60', '1'),
    ('9', '96', '6'),
    ('9', '0', '0'),
    ('9', '198', '7'),
    ('9', '62', '6'),
    ('9', '184', '4'),
    ('9', '197', '2'),
    ('6', '36', '1'),
    ('6', '80', '4'),
    ('6', '136', '4'),
    ('6', '197', '4'),
    ('6', '88', '1'),
    ('6', '0', '1'),
    ('6', '0', '1'),
    ('6', '0', '1'),
    ('6', '0', '1'),
    ('6', '0', '1'),
    ('6', '0', '1'),
    ('6', '0', '1'),
    ('6', '0', '4'),
    ('6', '198', '4'),
    ('6', '14', '0'),
    ('6', '0', '4'),
    ('6', '184', '4'),
    ('6', '112', '1'),
    ('25', '130', '3'),
    ('25', '124', '3'),
    ('25', '0', '1'),
    ('25', '0', '3'),
    ('25', '0', '3'),
    ('25', '0', '3'),
    ('25', '0', '3'),
    ('25', '0', '1'),
    ('25', '88', '3'),
    ('25', '0', '3'),
    ('25', '0', '2'),
    ('25', '24', '3'),
    ('25', '36', '0'),
    ('25', '152', '3'),
    ('25', '0', '0'),
    ('25', '0', '0'),
    ('25', '0', '3'),
    ('25', '0', '3'),
    ('25', '197', '1'),
    ('25', '0', '0'),
    ('25', '184', '3'),
    ('25', '0', '3'),
    ('25', '198', '0');

Caused the error:

    Duplicate entry '15-184-2' for key 1

[Pete Windu]

Hi.  I have this same problem (just as shown above, just with different values)...can someone please guide me through a solution.  Thanks!

btw...I don't care if it skips the poll conversion...I would just like to get through to the end of this so we can enjoy the forums again.

Thanks again

Converting poll votes... Unsuccessful!
This query:
INSERT INTO `jeditemp_smf`.smf_log_polls
(ID_POLL, ID_MEMBER, ID_CHOICE)
VALUES ('1', '0', '2'),
('1', '38', '3'),
('1', '17', '1'),
('1', '22', '0'),
('1', '5', '1'),
('1', '19', '1'),
('1', '13', '1'),
('1', '16', '1'),
('1', '12', '1'),
('1', '1', '0'),
('1', '4', '2'),
('1', '18', '1'),
('2', '3', '7'),
('2', '4', '7'),
('2', '1', '0'),
('3', '28', '0'),
('3', '15', '0'),
('3', '13', '0'),
('3', '19', '0'),
('3', '18', '0'),
('3', '5', '0'),
('3', '0', '0'),
('3', '3', '0'),
('3', '4', '0'),
('3', '1', '0'),
('4', '47', '0'),
('4', '41', '0'),
('4', '0', '3'),
('4', '39', '0'),
('4', '26', '1'),
('4', '0', '2'),
('4', '28', '1'),
('4', '11', '1'),
('4', '0', '1'),
('4', '27', '1'),
('4', '19', '1'),
('4', '23', '1'),
('4', '17', '2'),
('4', '3', '1'),
('4', '1', '0'),
('4', '5', '0'),
('4', '13', '0'),
('4', '18', '1'),
('4', '10', '0'),
('4', '4', '1'),
('4', '8', '1'),
('5', '15', '0'),
('5', '11', '1'),
('5', '4', '0'),
('5', '19', '0'),
('5', '13', '1'),
('5', '1', '0'),
('5', '3', '0');
Caused the error:

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

[SleePy]

empty the `jeditemp_smf`.smf_log_polls table and then try again.
It seems to have data already in it and is finding this duplicate ID.

[Pete Windu]

Hi thank you...can you tel me where I would find that file or rather, it seems, how to empty it?

[SleePy]

What is phpMyAdmin?
 
Use that and you can empty it
be careful what you do though, that tool is editing your database stuff so you got to be careful.

[Pete Windu]

That stuff is way over my head, but since you helped got a bunch of the really really important info imported into my new forums I am actually going to let the old poll information just fade away...