Advertisement:

Author Topic: Yabb 2.1 conversion error  (Read 5597 times)

Offline kelltech

  • Semi-Newbie
  • *
  • Posts: 10
Yabb 2.1 conversion error
« on: March 05, 2007, 11:24:11 PM »
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):
Quote
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

Offline Pete Windu

  • Newbie
  • *
  • Posts: 9
Re: Yabb 2.1 conversion error - Poll Conversion Unsucessful
« Reply #1 on: August 01, 2007, 01:14:21 PM »
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


Quote
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
« Last Edit: August 01, 2007, 01:25:50 PM by Pete Windu »

Offline SleePy

  • Let there be light!
  • Site Team Lead
  • SMF Master
  • *
  • Posts: 30,712
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: Yabb 2.1 conversion error
« Reply #2 on: August 01, 2007, 05:33:35 PM »
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.
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub

Offline Pete Windu

  • Newbie
  • *
  • Posts: 9
Re: Yabb 2.1 conversion error
« Reply #3 on: August 01, 2007, 07:28:23 PM »
Hi thank you...can you tel me where I would find that file or rather, it seems, how to empty it?

Offline SleePy

  • Let there be light!
  • Site Team Lead
  • SMF Master
  • *
  • Posts: 30,712
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: Yabb 2.1 conversion error
« Reply #4 on: August 02, 2007, 01:27:05 PM »
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.
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub

Offline Pete Windu

  • Newbie
  • *
  • Posts: 9
Re: Yabb 2.1 conversion error
« Reply #5 on: August 02, 2007, 11:06:46 PM »
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...