IPB v2.0.0 -> SMF 1.1 RC2 conversion problem with polls

[SkidCooly]

SMF Version: SMF 1.1 RC2
In trying to do a test conversion of my IPB v2.0.0 database to SMF 1.1 RC2, the conversion progress came to a screeching halt with this error message as it was trying to convert the poll options (I apologize for the length of the error message, I didn't want to leave out anything that might be of importance):

Code Select Expand


Converting posts (this may take some time)... Successful.
Converting polls... Successful.
Converting poll options... Unsuccessful!
This query:
INSERT INTO `smf2`.smf_poll_choices
(ID_POLL, ID_CHOICE, label, votes)
VALUES (1, '0', 'YEAH!', '3'),
(1, '1', 'I guess so', '0'),
(1, '2', 'Eh', '1'),
(1, '3', 'I've seen better', '0'),
(1, '4', 'It sucks in so many dimensions...', '0'),
(1, '', '', ''),
(2, '0', 'Tuesday the 23rd', '0'),
(2, '1', 'Wednesday the 24th', '0'),
(2, '2', 'Thursday the 25th', '1'),
(2, '3', 'Friday the 26th', '4'),
(2, '4', 'Saturday the 27th', '0'),
(2, '5', 'Sunday the 28th', '0'),
(2, '', '', ''),
(3, '0', 'Whos down', '0'),
(3, '1', 'whos up', '4'),
(3, '', '', ''),
(4, '0', 'HELL ya!', '4'),
(4, '1', 'Sure SEEMS like it', '1'),
(4, '2', 'Elementary My Dear Watson', '0'),
(4, '3', 'WELL DUH!', '1'),
(4, '', '', ''),
(5, '0', 'YES', '7'),
(5, '1', 'NO', '0'),
(5, '2', 'what is irc?', '0'),
(5, '', '', ''),
(6, '0', 'I'd like to see news ONLY for gaming!', '0'),
(6, '1', 'I'd like to see news ONLY for hardware!', '0'),
(6, '2', 'I'd like to see news ONLY for software!', '0'),
(6, '3', 'I'd like to see news ONLY regarding new technology!', '0'),
(6, '4', 'I'd like to see news for gaming, hardware, and software!', '1'),
(6, '5', 'I'd like to see news for any combination of the above!', '0'),
(6, '6', 'Screw the news.  You heard me, SCREW IT!!!', '1'),
(6, '7', 'I'd like a variety of news on just about anything.', '5'),
(6, '', '', ''),
(7, '0', 'Rocky Balboa', '6'),
(7, '1', 'Mike Tyson', '2'),
(8, '0', 'Chocolate got in the Peanut Butter!', '3'),
(8, '1', 'Peanut Butter got in the Chocolate!', '3'),
(9, '0', 'Just...WRONG!!!', '6'),
(9, '1', 'It's FUN! ', '1'),
(9, '2', 'It's Fun...But in a wrong sort of way. But Fun. Sort of.', '2'),
(10, '0', 'You bet!', '2'),
(10, '1', 'He sure is!!', '1'),
(10, '2', 'Oh the HUMANITY!!', '2'),
(10, '3', 'Gasp! Marciis....MOCKED?...NO...NO!!!..', '3'),
(11, '0', 'Nissan Z - now thats what im talking about!!', '1'),
(11, '1', 'Mazda RX-8 - Hits on all cylinders, even though it ain't got any!', '2'),
(12, '0', 'Lieberman', '0'),
(12, '1', 'Edwards', '2'),
(12, '2', 'Kerry', '0'),
(12, '3', 'Clark', '0'),
(12, '4', 'Dean', '0'),
(12, '5', 'Sharpton', '2'),
(12, '6', 'other', '2'),
(13, '0', 'Yes I am!', '5'),
(13, '1', 'No I'm not!', '2'),
(14, '0', 'Definitely redundant.Oh yeah...It's redundant in it's redundancy.', '4'),
(15, '0', 'MAniiC did!', '2'),
(15, '1', 'I did!', '1'),
(15, '2', 'My brothers friends aunts sister did!', '2'),
(16, '0', 'Just Neverwinter Nights- No expansion packs', '0'),
(16, '1', 'Just Shadows of Undrentide', '1'),
(16, '2', 'Just Hordes of the Underdark', '0'),
(16, '3', 'Got'em all. Nyeh.', '2'),
(20, '0', 'INTEL', '2'),
(20, '1', 'AMD', '5'),
(20, '2', 'Whichever one is cheaper', '1'),
(20, '3', 'I don't care so long as I can play Joint Ops', '0'),
(19, '0', 'Yes', '2'),
(19, '1', 'No', '7'),
(18, '0', 'Call of duty', '0'),
(18, '1', 'Far Cry', '0'),
(18, '2', 'Insane', '2'),
(18, '3', 'Nascar 2003', '0'),
(18, '4', 'GTA3-Multi Theft auto', '1'),
(18, '5', 'IL-2 Sturmovik', '0'),
(18, '6', 'Battlefield 1942', '1'),
(18, '7', 'Command and Conquer Generals', '1'),
(18, '8', 'Total Annihilation', '0'),
(18, '9', 'Joint Operations', '2'),
(21, '0', 'Lora Croft-President, Samus Aaron-Vice Pres. (the girl power ticket)', '2'),
(21, '1', 'Sarge (Quake 3)-President, Duke Nukem-Vice Pres. (the kicking arse and taking names ticket)', '2'),
(21, '2', 'Pac Man-President and Pitfall Guy- Vice Pres. (the old school ticket)', '1'),
(21, '3', 'Ken-President and Guile-Vice Pres. (the Street Fighter 2 ticket)', '0'),
(22, '0', 'close it', '5'),
(22, '1', 'keep it open', '1'),
(22, '2', 'keep it open, nix the politics', '2'),
(24, '0', '1. Hell yeah, great idea!', '9'),
(24, '1', '2. Hell no, bad idea!', '0'),
(24, '2', '3. Hell yeah but charge less- $1.00 is too much', '0'),
(25, '0', 'January', '0'),
(25, '1', 'February', '1'),
(25, '2', 'March', '5'),
(25, '3', 'April', '1'),
(26, '0', 'First', '1'),
(26, '1', 'Second', '0'),
(26, '2', 'Third', '1'),
(26, '3', 'Fourth', '1'),
(26, '4', 'Any weekend in March works for me', '4');
Caused the error:

Duplicate entry '1-0' for key 1


A search of these forums came up with one other post that was having a somewhat similar issue, but not quite (plus it didn't seem to have a resolution).  Can one of the gurus here at SMF give me a hand with this?  Thanks in advance for any help.

Nice looking software, btw.

[SkidCooly]

Help?

[SkidCooly]

OK, well I guess I will respond to my own problem here to help others who might also run into this.

After thinking this over a bit and looking at the error message, it appeared to me that perhaps there could be a problem in regards to the null values that I saw sprinkled here and there.  So I went to my original forum and did an edit on the polls that were showing a null value, removed the null value option and then re-ran the conversion file.  This time it got past the polls with no problems.  I suspect these null values were put in place by the previous conversion program when I went from Ikonboard to IPB years ago.  So the moral of the story is, sometimes you need to go in and clean things up a bit to get the conversion to run smoothly.  However, after getting through most of the conversion process I got another error message regarding stats....but I guess that will be the subject of another topic...

[Oldiesmann]

The stats issue is a known problem. Just go into SMF and click on "Recount all totals and statistics" from the "Forum Maintenance" section of the admin center and you should be fine.

[SkidCooly]

Thank you, I will.

[SkidCooly]

As a follow-up on my last comment about the stats error at the end of the conversion.  I tried the new convert.php file posted in this thread http://www.simplemachines.org/community/index.php?topic=65677.0 along with the standard invision2_to_smf.sql file.  That combo appeared to work great.  It got rid of the error message and completed the conversion process.  My stats appeared to be in place and correct when I logged into the forums and everything else seemed to be correct at a quick glance.