Error with poll logs - IPB 1.3 *SOLVED*

[dame0n]

First of all, here's what the poll choices part looks like in the sql file:

Code Select Expand

/******************************************************************************/
--- Converting poll options...
/******************************************************************************/

---* {$to_prefix}poll_choices
---{
$no_add = true;
$keys = array('ID_POLL', 'ID_CHOICE', 'label', 'votes');

$choices = @unserialize(stripslashes($row['choices']));

if (is_array($choices))
foreach ($choices as $choice)
{
$choice = addslashes_recursive($choice);
$rows[] = "$row[ID_POLL], SUBSTRING('" . implode("', 1, 255), '", $choice) . "'";
}
---}
SELECT pid AS ID_POLL, choices
FROM {$from_prefix}polls;
---*

Now, here's the error im getting:

Code Select Expand

Converting poll options... Unsuccessful!
This query:
INSERT INTO `jazdan_ipb`.smf_poll_choices
(ID_POLL, ID_CHOICE, label, votes)
VALUES (1, SUBSTRING('0', 1, 255), 'Below 13 (like thats gonna happen)', 1, 255), '0'),
(1, SUBSTRING('1', 1, 255), '13-17', 1, 255), '8'),
(1, SUBSTRING('2', 1, 255), '17-20', 1, 255), '7'),
(1, SUBSTRING('3', 1, 255), '20+', 1, 255), '3'),
(2, SUBSTRING('0', 1, 255), 'Middle School (pssht)', 1, 255), '0'),
(2, SUBSTRING('1', 1, 255), 'High School', 1, 255), '8'),
(2, SUBSTRING('2', 1, 255), 'College (undergrad)', 1, 255), '2'),
(2, SUBSTRING('3', 1, 255), 'College (Grad)', 1, 255), '0'),
(2, SUBSTRING('4', 1, 255), 'Have a job! (an occupation in this case)', 1, 255), '3'),
(2, SUBSTRING('5', 1, 255), 'Psssht! I love staying at home.. Unemployed', 1, 255), '2'),
(3, SUBSTRING('0', 1, 255), 'Middle School (pssht)', 1, 255), '0'),
(3, SUBSTRING('1', 1, 255), 'High School', 1, 255), '0'),
(3, SUBSTRING('2', 1, 255), 'College (undergrad)', 1, 255), '0'),
(3, SUBSTRING('3', 1, 255), 'College (Grad)', 1, 255), '0'),
(3, SUBSTRING('4', 1, 255), 'Have a job! (an occupation in this case)', 1, 255), '0'),
(3, SUBSTRING('5', 1, 255), 'Psssht! I love staying at home.. Unemployed', 1, 255), '0'),
(4, SUBSTRING('0', 1, 255), 'Middle School (pssht)', 1, 255), '0'),
(4, SUBSTRING('1', 1, 255), 'High School', 1, 255), '0'),
(4, SUBSTRING('2', 1, 255), 'College (undergrad)', 1, 255), '0'),
(4, SUBSTRING('3', 1, 255), 'College (Grad)', 1, 255), '0'),
(4, SUBSTRING('4', 1, 255), 'Have a job! (an occupation in this case)', 1, 255), '0'),
(4, SUBSTRING('5', 1, 255), 'Psssht! I love staying at home.. Unemployed', 1, 255), '0'),
(5, SUBSTRING('0', 1, 255), 'Pure Str (PvE machine)', 1, 255), '2'),
(5, SUBSTRING('1', 1, 255), 'Pure Heal (Tanker)', 1, 255), '1'),
(5, SUBSTRING('2', 1, 255), 'Heal+Str (Hybrid)', 1, 255), '5'),
(5, SUBSTRING('3', 1, 255), 'Pure Dex (Crazy Crits??)', 1, 255), '3'),
(22, SUBSTRING('0', 1, 255), 'yep', 1, 255), '7'),
(22, SUBSTRING('1', 1, 255), 'no', 1, 255), '1'),
(22, SUBSTRING('2', 1, 255), 'plan to download XD', 1, 255), '0'),
(7, SUBSTRING('0', 1, 255), 'Grani', 1, 255), '0'),
(7, SUBSTRING('1', 1, 255), 'Sylphid', 1, 255), '6'),
(7, SUBSTRING('2', 1, 255), 'Ventus ', 1, 255), '3'),
(7, SUBSTRING('3', 1, 255), 'Screw them! Im cheap, I aint paying for a ride!', 1, 255), '0'),
(8, SUBSTRING('0', 1, 255), 'Yes!! Then pl do give rep ^^', 1, 255), '4'),
(8, SUBSTRING('1', 1, 255), 'Nope. Useless -.-', 1, 255), '3'),
(45, SUBSTRING('0', 1, 255), 'Azure Knight', 1, 255), '5'),
(45, SUBSTRING('1', 1, 255), 'Bagi', 1, 255), '4'),
(45, SUBSTRING('2', 1, 255), 'Hunter', 1, 255), '0'),
(45, SUBSTRING('3', 1, 255), 'Mage', 1, 255), '5'),
(45, SUBSTRING('4', 1, 255), 'Segnale', 1, 255), '3'),
(45, SUBSTRING('5', 1, 255), 'Summoner', 1, 255), '4'),
(21, SUBSTRING('0', 1, 255), 'yes', 1, 255), '1'),
(21, SUBSTRING('1', 1, 255), 'hell yes', 1, 255), '15'),
(21, SUBSTRING('2', 1, 255), 'no', 1, 255), '0'),
(14, SUBSTRING('0', 1, 255), 'less than 1 week', 1, 255), '4'),
(14, SUBSTRING('1', 1, 255), '1-2 weeks', 1, 255), '4'),
(14, SUBSTRING('2', 1, 255), '2-3 weeks', 1, 255), '3'),
(14, SUBSTRING('3', 1, 255), '3-4 weeks', 1, 255), '3'),
(14, SUBSTRING('4', 1, 255), '4-5 weeks', 1, 255), '0'),
(14, SUBSTRING('5', 1, 255), '5-6 weeks', 1, 255), '1'),
(14, SUBSTRING('6', 1, 255), '6-7 weeks', 1, 255), '0'),
(14, SUBSTRING('7', 1, 255), '7-8 weeks', 1, 255), '0'),
(14, SUBSTRING('8', 1, 255), '8-9 weeks', 1, 255), '0'),
(14, SUBSTRING('9', 1, 255), '9-10 weeks', 1, 255), '0'),
(14, SUBSTRING('10', 1, 255), '10+ weeks', 1, 255), '2'),
(12, SUBSTRING('0', 1, 255), 'yes', 1, 255), '2'),
(12, SUBSTRING('1', 1, 255), 'no', 1, 255), '1'),
(13, SUBSTRING('0', 1, 255), 'Yes, there should be stealing coin item', 1, 255), '0'),
(13, SUBSTRING('1', 1, 255), 'No, there shouldn't be stealing coin item', 1, 255), '0'),
(15, SUBSTRING('0', 1, 255), 'Pure Offense(Issue for PvP)', 1, 255), '3'),
(15, SUBSTRING('1', 1, 255), 'Mid-fielder', 1, 255), '7'),
(15, SUBSTRING('2', 1, 255), 'Crit Holders(Doesnt apply to archers)(Issue for pvp)', 1, 255), '1'),
(15, SUBSTRING('3', 1, 255), 'Pure Defense', 1, 255), '2'),
(15, SUBSTRING('4', 1, 255), 'Dep's suggestion - Dex, str and heal', 1, 255), '2'),
(16, SUBSTRING('0', 1, 255), 'Power', 1, 255), '0'),
(16, SUBSTRING('1', 1, 255), 'Popularity', 1, 255), '0'),
(16, SUBSTRING('2', 1, 255), 'Status', 1, 255), '0'),
(16, SUBSTRING('3', 1, 255), 'Trust', 1, 255), '0'),
(16, SUBSTRING('4', 1, 255), 'Power, Popularity, Status, + Trust', 1, 255), '0'),
(16, SUBSTRING('5', 1, 255), 'Power+Popularity', 1, 255), '1'),
(16, SUBSTRING('6', 1, 255), 'Power+Status', 1, 255), '0'),
(16, SUBSTRING('7', 1, 255), 'Power+Trust', 1, 255), '1'),
(16, SUBSTRING('8', 1, 255), 'Popularity+Status', 1, 255), '0'),
(16, SUBSTRING('9', 1, 255), 'Popularity+Trust', 1, 255), '0'),
(16, SUBSTRING('10', 1, 255), 'Status+Trust', 1, 255), '1'),
(16, SUBSTRING('11', 1, 255), 'Power+Popularity+Status', 1, 255), '0'),
(16, SUBSTRING('12', 1, 255), 'Power+Status+Trust', 1, 255), '2'),
(16, SUBSTRING('13', 1, 255), 'Popularity+Status+Trust', 1, 255), '1'),
(16, SUBSTRING('14', 1, 255), 'Status+Trust+Popularity', 1, 255), '0'),
(16, SUBSTRING('15', 1, 255), 'Trust+Power+Popularity', 1, 255), '2'),
(16, SUBSTRING('16', 1, 255), 'No Opinion', 1, 255), '0'),
(16, SUBSTRING('17', 1, 255), 'Other[Please Specify In Post]', 1, 255), '0'),
(17, SUBSTRING('0', 1, 255), 'Yes', 1, 255), '2'),
(17, SUBSTRING('1', 1, 255), 'No', 1, 255), '1'),
(17, SUBSTRING('2', 1, 255), 'Not sure', 1, 255), '4'),
(18, SUBSTRING('0', 1, 255), 'yes', 1, 255), '16'),
(18, SUBSTRING('1', 1, 255), 'no', 1, 255), '0'),
(18, SUBSTRING('2', 1, 255), 'not sure', 1, 255), '2'),
(19, SUBSTRING('0', 1, 255), 'no', 1, 255), '0'),
(19, SUBSTRING('1', 1, 255), 'huh', 1, 255), '1'),
(19, SUBSTRING('2', 1, 255), 'and yes', 1, 255), '2'),
(19, SUBSTRING('3', 1, 255), 'PURGE THE TRASH CAN', 1, 255), '3'),
(20, SUBSTRING('0', 1, 255), '"In V we trust"', 1, 255), '4'),
(20, SUBSTRING('1', 1, 255), 'You're already dead. I killed you 10 minutes ago.', 1, 255), '0'),
(20, SUBSTRING('2', 1, 255), '"Nothing is more costly, nothing is more sterile, than vengeance"', 1, 255), '0'),
(20, SUBSTRING('3', 1, 255), '"When the blameless and the righteous die, the very gods for vengeance cry"', 1, 255), '5'),
(20, SUBSTRING('4', 1, 255), '"Vengeance has no foresight" ', 1, 255), '0'),
(20, SUBSTRING('5', 1, 255), '"Vi Veri Vniversum Vivus Vici" (="By the power of Truth, I, while living, have conquered the universe")', 1, 255), '3'),
(20, SUBSTRING('6', 1, 255), '"On The Path To Greatness, Nothing Will Stand In Our Way Nor Stray Us From Our Goal"', 1, 255), '1'),
(20, SUBSTRING('7', 1, 255), '" The only verdict is vengeance, a vendetta, held as a votive not in vain."', 1, 255), '4'),
(20, SUBSTRING('8', 1, 255), '"Let them hate as long as they fear."', 1, 255), '0'),
(20, SUBSTRING('9', 1, 255), 'Let the Bloodbath Begin in the name of Vengeance and Vanity --Omega', 1, 255), '2'),
(53, SUBSTRING('0', 1, 255), 'Yes', 1, 255), '2'),
(53, SUBSTRING('1', 1, 255), 'Nope', 1, 255), '2'),
(24, SUBSTRING('0', 1, 255), 'Yes', 1, 255), '2'),
(24, SUBSTRING('1', 1, 255), 'No', 1, 255), '0'),
(24, SUBSTRING('2', 1, 255), 'Too lazy, but would.', 1, 255), '2'),
(25, SUBSTRING('0', 1, 255), 'Braiken', 1, 255), '6'),
(25, SUBSTRING('1', 1, 255), 'Loa', 1, 255), '13'),
(52, SUBSTRING('0', 1, 255), 'Love it!', 1, 255), '11'),
(52, SUBSTRING('1', 1, 255), 'Rather not!', 1, 255), '2'),
(48, SUBSTRING('0', 1, 255), 'I don't care that much...', 1, 255), '1'),
(48, SUBSTRING('1', 1, 255), '1', 1, 255), '0'),
(48, SUBSTRING('2', 1, 255), '2', 1, 255), '0'),
(48, SUBSTRING('3', 1, 255), '3', 1, 255), '1'),
(48, SUBSTRING('4', 1, 255), '4', 1, 255), '0'),
(48, SUBSTRING('5', 1, 255), '5', 1, 255), '0'),
(48, SUBSTRING('6', 1, 255), '6', 1, 255), '1'),
(48, SUBSTRING('7', 1, 255), '7', 1, 255), '0'),
(48, SUBSTRING('8', 1, 255), '8', 1, 255), '2'),
(48, SUBSTRING('9', 1, 255), '9', 1, 255), '0'),
(48, SUBSTRING('10', 1, 255), '10', 1, 255), '1'),
(48, SUBSTRING('11', 1, 255), 'It's off the scale', 1, 255), '4'),
(28, SUBSTRING('0', 1, 255), 'USA', 1, 255), '7'),
(28, SUBSTRING('1', 1, 255), 'North America (Excludes USA)', 1, 255), '0'),
(28, SUBSTRING('2', 1, 255), 'South America', 1, 255), '0'),
(28, SUBSTRING('3', 1, 255), 'Australia', 1, 255), '0'),
(28, SUBSTRING('4', 1, 255), 'Europe (please specify)', 1, 255), '4'),
(28, SUBSTRING('5', 1, 255), 'Asia', 1, 255), '1'),
(28, SUBSTRING('6', 1, 255), 'Africa?', 1, 255), '2'),
(44, SUBSTRING('0', 1, 255), 'Yes', 1, 255), '2'),
(44, SUBSTRING('1', 1, 255), 'No', 1, 255), '5'),
(44, SUBSTRING('2', 1, 255), 'Maybe', 1, 255), '0'),
(44, SUBSTRING('3', 1, 255), 'I don't care', 1, 255), '0'),
(29, SUBSTRING('0', 1, 255), 'R/B', 1, 255), '0'),
(29, SUBSTRING('1', 1, 255), 'Rock', 1, 255), '4'),
(29, SUBSTRING('2', 1, 255), 'Country', 1, 255), '0'),
(29, SUBSTRING('3', 1, 255), 'Hip Hop ( Rap ) ', 1, 255), '2'),
(29, SUBSTRING('4', 1, 255), 'Gansta ****** ', 1, 255), '1'),
(29, SUBSTRING('5', 1, 255), 'Techno', 1, 255), '1'),
(29, SUBSTRING('6', 1, 255), 'Blues', 1, 255), '0'),
(29, SUBSTRING('7', 1, 255), 'Classical ', 1, 255), '0'),
(29, SUBSTRING('8', 1, 255), 'Jazz', 1, 255), '0'),
(29, SUBSTRING('9', 1, 255), 'Dance', 1, 255), '0'),
(29, SUBSTRING('10', 1, 255), 'Folk ', 1, 255), '1'),
(29, SUBSTRING('11', 1, 255), 'Metal ', 1, 255), '4'),
(30, SUBSTRING('0', 1, 255), 'Youuu', 1, 255), '0'),
(30, SUBSTRING('1', 1, 255), 'Taber', 1, 255), '0'),
(30, SUBSTRING('2', 1, 255), 'Chowmein', 1, 255), '1'),
(30, SUBSTRING('3', 1, 255), 'Skiski', 1, 255), '8'),
(30, SUBSTRING('4', 1, 255), 'Ultima', 1, 255), '1'),
(30, SUBSTRING('5', 1, 255), 'Kuchiki', 1, 255), '2'),
(30, SUBSTRING('6', 1, 255), 'Dameon', 1, 255), '0'),
(30, SUBSTRING('7', 1, 255), 'Omega', 1, 255), '0'),
(30, SUBSTRING('8', 1, 255), 'Legolaslor', 1, 255), '1'),
(30, SUBSTRING('9', 1, 255), 'Deputatu1', 1, 255), '0'),
(30, SUBSTRING('10', 1, 255), 'RaguajBlack', 1, 255), '0'),
(30, SUBSTRING('11', 1, 255), 'Cryspler', 1, 255), '1'),
(30, SUBSTRING('12', 1, 255), 'NeuroL', 1, 255), '2'),
(30, SUBSTRING('13', 1, 255), 'Other[Please Specify]', 1, 255), '0'),
(49, SUBSTRING('0', 1, 255), 'SKISKI OF COURSE !!!!', 1, 255), '3'),
(49, SUBSTRING('1', 1, 255), 'Cryspler...so lame dude !!!', 1, 255), '1'),
(32, SUBSTRING('0', 1, 255), 'give the item to him for free', 1, 255), '3'),
(32, SUBSTRING('1', 1, 255), 'lend it to him', 1, 255), '1'),
(32, SUBSTRING('2', 1, 255), 'sell it to him with a discount', 1, 255), '7'),
(32, SUBSTRING('3', 1, 255), 'refuse and sell it in the market(open a store)', 1, 255), '2'),
(32, SUBSTRING('4', 1, 255), 'trade it to your friend for another item', 1, 255), '2'),
(32, SUBSTRING('5', 1, 255), 'other(specify)', 1, 255), '0'),
(33, SUBSTRING('0', 1, 255), 'Yes', 1, 255), '4'),
(33, SUBSTRING('1', 1, 255), 'No', 1, 255), '1'),
(51, SUBSTRING('0', 1, 255), 'Skiski!', 1, 255), '6'),
(51, SUBSTRING('1', 1, 255), 'Dameon!', 1, 255), '2'),
(51, SUBSTRING('2', 1, 255), 'Kuchiki_Byakuya&#33; <---ME ^^', 1, 255), '6'),
(51, SUBSTRING('3', 1, 255), '', 1, 255), '4'),
(35, SUBSTRING('0', 1, 255), 'Yes &#33;', 1, 255), '9'),
(35, SUBSTRING('1', 1, 255), 'I Will Buy A Microphone And I Agree &#33;', 1, 255), '3'),
(35, SUBSTRING('2', 1, 255), 'No &#33;', 1, 255), '6'),
(35, SUBSTRING('3', 1, 255), 'I can&#39;t Afford To Buy A Microphone :( &#33;', 1, 255), '1'),
(35, SUBSTRING('4', 1, 255), 'I Don&#39;t Have A Microphone &#33;', 1, 255), '0'),
(38, SUBSTRING('0', 1, 255), 'Yes &#33;', 1, 255), '3'),
(38, SUBSTRING('1', 1, 255), 'No&#33;', 1, 255), '0'),
(38, SUBSTRING('2', 1, 255), 'No Way Man You Suck &#33;', 1, 255), '0'),
(37, SUBSTRING('0', 1, 255), '1[It SUCKS&#33;]', 1, 255), '0'),
(37, SUBSTRING('1', 1, 255), '2', 1, 255), '0'),
(37, SUBSTRING('2', 1, 255), '3', 1, 255), '0'),
(37, SUBSTRING('3', 1, 255), '4', 1, 255), '1'),
(37, SUBSTRING('4', 1, 255), '5', 1, 255), '0'),
(37, SUBSTRING('5', 1, 255), '6', 1, 255), '0'),
(37, SUBSTRING('6', 1, 255), '7', 1, 255), '1'),
(37, SUBSTRING('7', 1, 255), '8', 1, 255), '2'),
(37, SUBSTRING('8', 1, 255), '9', 1, 255), '0'),
(37, SUBSTRING('9', 1, 255), '10[It OWNS&#33;&#33;&#33;&#33;]', 1, 255), '0'),
(42, SUBSTRING('0', 1, 255), '1', 1, 255), '2'),
(42, SUBSTRING('1', 1, 255), '2', 1, 255), '0'),
(42, SUBSTRING('2', 1, 255), '3', 1, 255), '0'),
(42, SUBSTRING('3', 1, 255), '4', 1, 255), '1'),
(42, SUBSTRING('4', 1, 255), '5', 1, 255), '2'),
(42, SUBSTRING('5', 1, 255), '6', 1, 255), '9'),
(42, SUBSTRING('6', 1, 255), 'Other[Please specify in a post]', 1, 255), '0'),
(41, SUBSTRING('0', 1, 255), 'Yes.', 1, 255), '4'),
(41, SUBSTRING('1', 1, 255), 'No.', 1, 255), '0'),
(54, SUBSTRING('0', 1, 255), '14 hours or below', 1, 255), '1'),
(54, SUBSTRING('1', 1, 255), '15-21 hours ', 1, 255), '1'),
(54, SUBSTRING('2', 1, 255), '22-28 hours', 1, 255), '0'),
(54, SUBSTRING('3', 1, 255), '29-36 hours', 1, 255), '2'),
(54, SUBSTRING('4', 1, 255), '37-50 hours ', 1, 255), '2'),
(54, SUBSTRING('5', 1, 255), '51+ Hours&#33;', 1, 255), '7'),
(55, SUBSTRING('0', 1, 255), 'Yes', 1, 255), '2'),
(55, SUBSTRING('1', 1, 255), 'No', 1, 255), '2'),
(55, SUBSTRING('2', 1, 255), 'Ill fix that -- Dameon', 1, 255), '0'),
(55, SUBSTRING('3', 1, 255), 'I dont care', 1, 255), '1'),
(56, SUBSTRING('0', 1, 255), 'Now', 1, 255), '1'),
(56, SUBSTRING('1', 1, 255), 'ASAP', 1, 255), '0'),
(56, SUBSTRING('2', 1, 255), 'In summer break', 1, 255), '1'),
(56, SUBSTRING('3', 1, 255), 'Dont care anymore', 1, 255), '0');
Caused the error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''0'),
(1, SUBSTRING('1', 1, 255), '13-17', 1, 255), '8')


Any help? Thanks!

[dame0n]

This is now fixed. Now there is a problem with converting poll logs. Error:

Code Select Expand

Converting poll logs... Unsuccessful!
This query:
INSERT INTO `jazdan_ipb`.smf_log_polls
(ID_POLL, ID_MEMBER)
VALUES ('1', '3'),
('1', '1'),
('1', '11'),
('2', '3'),
('3', '3'),
('4', '3'),
('2', '6'),
('3', '6'),
('4', '6'),
('2', '1'),
('3', '1'),
('4', '1'),
('2', '2'),
('3', '2'),
('4', '2'),
('1', '2'),
('2', '11'),
('3', '11'),
('4', '11'),
('5', '3'),
('2', '5'),
('3', '5'),
('4', '5'),
('5', '7'),
('5', '2'),
('5', '11'),
('5', '16'),
('', '16'),
('', '3'),
('', '5'),
('', '2'),
('7', '3'),
('7', '16'),
('7', '5'),
('7', '2'),
('51', '81'),
('51', '1'),
('51', '16'),
('7', '7'),
('29', '4'),
('7', '10'),
('', '11'),
('8', '16'),
('', '13'),
('7', '1'),
('32', '4'),
('48', '69'),
('', '16'),
('', '3'),
('12', '16'),
('13', '16'),
('12', '3'),
('13', '3'),
('8', '3'),
('1', '16'),
('2', '16'),
('3', '16'),
('4', '16'),
('', '1'),
('14', '1'),
('14', '16'),
('14', '3'),
('14', '2'),
('12', '2'),
('13', '2'),
('14', '5'),
('48', '5'),
('48', '91'),
('7', '13'),
('14', '13'),
('48', '2'),
('14', '10'),
('1', '10'),
('2', '10'),
('3', '10'),
('4', '10'),
('14', '17'),
('2', '13'),
('3', '13'),
('4', '13'),
('1', '5'),
('14', '11'),
('5', '17'),
('5', '13'),
('2', '17'),
('3', '17'),
('4', '17'),
('48', '30'),
('48', '16'),
('8', '2'),
('8', '5'),
('8', '21'),
('5', '1'),
('48', '3'),
('2', '19'),
('3', '19'),
('4', '19'),
('8', '1'),
('15', '3'),
('15', '2'),
('15', '13'),
('15', '10'),
('15', '17'),
('15', '11'),
('14', '7'),
('14', '20'),
('15', '7'),
('8', '7'),
('48', '4'),
('15', '1'),
('1', '17'),
('15', '16'),
('15', '21'),
('14', '6'),
('14', '25'),
('14', '21'),
('48', '57'),
('1', '91'),
('16', '3'),
('16', '1'),
('16', '2'),
('16', '5'),
('16', '16'),
('16', '20'),
('16', '10'),
('14', '30'),
('16', '30'),
('1', '13'),
('1', '30'),
('16', '11'),
('17', '16'),
('17', '2'),
('17', '5'),
('17', '17'),
('17', '3'),
('17', '1'),
('18', '2'),
('18', '16'),
('18', '21'),
('18', '1'),
('18', '5'),
('18', '3'),
('18', '18'),
('14', '55'),
('25', '81'),
('20', '30'),
('18', '30'),
('45', '1'),
('18', '39'),
('1', '33'),
('18', '37'),
('20', '91'),
('18', '13'),
('18', '10'),
('1', '47'),
('17', '10'),
('20', '5'),
('20', '3'),
('20', '2'),
('20', '10'),
('20', '21'),
('20', '18'),
('20', '12'),
('20', '11'),
('45', '81'),
('19', '1'),
('45', '91'),
('14', '52'),
('18', '55'),
('7', '52'),
('21', '3'),
('21', '16'),
('20', '16'),
('21', '2'),
('', '3'),
('', '16'),
('', '1'),
('22', '3'),
('21', '18'),
('22', '2'),
('22', '1'),
('21', '1'),
('20', '1'),
('', '4'),
('20', '4'),
('22', '30'),
('21', '30'),
('', '30'),
('21', '21'),
('21', '5'),
('20', '6'),
('22', '6'),
('21', '6'),
('', '5'),
('21', '10'),
('', '10'),
('22', '10'),
('20', '17'),
('21', '17'),
('', '17'),
('2', '21'),
('3', '21'),
('4', '21'),
('2', '30'),
('3', '30'),
('4', '30'),
('', '57'),
('20', '59'),
('21', '20'),
('44', '10'),
('45', '10'),
('22', '11'),
('', '11'),
('22', '57'),
('21', '57'),
('21', '12'),
('1', '57'),
('2', '57'),
('3', '57'),
('4', '57'),
('21', '11'),
('24', '3'),
('24', '17'),
('24', '2'),
('21', '33'),
('2', '62'),
('3', '62'),
('4', '62'),
('24', '10'),
('25', '5'),
('25', '2'),
('25', '30'),
('25', '10'),
('25', '4'),
('25', '3'),
('25', '1'),
('25', '11'),
('25', '18'),
('25', '13'),
('25', '16'),
('45', '11'),
('18', '71'),
('', '30'),
('', '16'),
('', '11'),
('', '4'),
('', '3'),
('', '30'),
('', '3'),
('', '4'),
('', '16'),
('', '2'),
('', '5'),
('1', '69'),
('28', '3'),
('28', '10'),
('28', '80'),
('28', '5'),
('28', '16'),
('45', '21'),
('28', '1'),
('5', '79'),
('25', '57'),
('28', '18'),
('28', '30'),
('25', '48'),
('45', '88'),
('25', '17'),
('28', '17'),
('29', '3'),
('29', '17'),
('29', '5'),
('29', '11'),
('28', '11'),
('29', '10'),
('25', '33'),
('29', '1'),
('51', '20'),
('28', '69'),
('25', '6'),
('45', '26'),
('29', '30'),
('18', '26'),
('35', '33'),
('25', '74'),
('25', '69'),
('30', '1'),
('30', '57'),
('30', '4'),
('30', '69'),
('45', '69'),
('30', '2'),
('30', '5'),
('30', '30'),
('30', '88'),
('28', '57'),
('29', '57'),
('5', '69'),
('30', '17'),
('18', '57'),
('20', '57'),
('28', '25'),
('30', '3'),
('30', '10'),
('28', '89'),
('45', '30'),
('30', '16'),
('51', '7'),
('51', '3'),
('51', '25'),
('51', '57'),
('42', '21'),
('29', '33'),
('1', '88'),
('48', '10'),
('49', '10'),
('32', '69'),
('32', '10'),
('49', '30'),
('32', '16'),
('49', '4'),
('32', '17'),
('32', '3'),
('32', '5'),
('29', '81'),
('30', '18'),
('29', '16'),
('30', '81'),
('33', '3'),
('33', '16'),
('33', '30'),
('33', '57'),
('33', '2'),
('42', '17'),
('1', '81'),
('42', '26'),
('32', '81'),
('42', '2'),
('42', '91'),
('32', '11'),
('35', '30'),
('35', '13'),
('35', '3'),
('35', '6'),
('35', '16'),
('35', '1'),
('42', '81'),
('42', '18'),
('35', '4'),
('35', '69'),
('35', '81'),
('35', '57'),
('35', '17'),
('32', '91'),
('37', '16'),
('37', '3'),
('5', '81'),
('42', '10'),
('32', '88'),
('42', '88'),
('35', '88'),
('42', '30'),
('32', '1'),
('32', '2'),
('37', '4'),
('35', '25'),
('15', '69'),
('35', '10'),
('35', '18'),
('30', '91'),
('37', '30'),
('15', '30'),
('42', '16'),
('42', '69'),
('35', '21'),
('38', '1'),
('45', '3'),
('', '1'),
('42', '1'),
('38', '30'),
('30', '36'),
('38', '2'),
('38', '16'),
('41', '3'),
('41', '16'),
('41', '2'),
('41', '1'),
('35', '11'),
('35', '5'),
('29', '69'),
('44', '17'),
('44', '3'),
('20', '69'),
('44', '16'),
('44', '30'),
('18', '69'),
('44', '1'),
('44', '91'),
('18', '91'),
('51', '30'),
('51', '2'),
('51', '69'),
('51', '10'),
('52', '3'),
('52', '113'),
('52', '16'),
('52', '69'),
('52', '1'),
('53', '3'),
('53', '16'),
('53', '1'),
('52', '91'),
('52', '57'),
('52', '17'),
('52', '2'),
('1', '25'),
('45', '16'),
('45', '25'),
('49', '91'),
('32', '30'),
('53', '30'),
('52', '10'),
('52', '30'),
('45', '57'),
('52', '26'),
('51', '17'),
('51', '91'),
('51', '5'),
('45', '20'),
('45', '2'),
('51', '27'),
('45', '5'),
('45', '17'),
('20', '81'),
('52', '5'),
('51', '103'),
('54', '3'),
('54', '10'),
('54', '30'),
('54', '25'),
('54', '57'),
('54', '1'),
('54', '2'),
('55', '2'),
('55', '1'),
('55', '16'),
('54', '16'),
('54', '18'),
('56', '3'),
('54', '4'),
('54', '5'),
('45', '33'),
('54', '91'),
('55', '3'),
('45', '18'),
('54', '69'),
('15', '121'),
('15', '33'),
('55', '30'),
('15', '81'),
('45', '6'),
('42', '6'),
('51', '6'),
('32', '6'),
('56', '10');
Caused the error:

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


Any help?

[dame0n]

Now it's showing this error...

Code Select Expand

Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Successful.
Converting posts (this may take some time)... Successful.
Converting polls... Successful.
Converting poll options...
Parse error: parse error, unexpected $ in /home/www/vendetta2.freehostia.com/forums/convert.php(827) : eval()'d code on line 10

Parse error: parse error, unexpected $ in /home/www/vendetta2.freehostia.com/forums/convert.php(827) : eval()'d code on line 10

Parse error: parse error, unexpected $ in /home/www/vendetta2.freehostia.com/forums/convert.php(827) : eval()'d code on line 10

Parse error: parse error, unexpected $ in /home/www/vendetta2.freehostia.com/forums/convert.php(827) : eval()'d code on line 10

Parse error: parse error, unexpected $ in /home/www/vendetta2.freehostia.com/forums/convert.php(827) : eval()'d code on line 10

Parse error: parse error, unexpected $ in /home/www/vendetta2.freehostia.com/forums/convert.php(827) : eval()'d code on line 10

Parse error: parse error, unexpected $ in /home/www/vendetta2.freehostia.com/forums/convert.php(827) : eval()'d code on line 10

Parse error: parse error, unexpected $ in /home/www/vendetta2.freehostia.com/forums/convert.php(827) : eval()'d code on line 10

Parse error: parse error, unexpected $ in /home/www/vendetta2.freehostia.com/forums/convert.php(827) : eval()'d code on line 10

Parse error: parse error, unexpected $ in /home/www/vendetta2.freehostia.com/forums/convert.php(827) : eval()'d code on line 10

Parse error: parse error, unexpected $ in /home/www/vendetta2.freehostia.com/forums/convert.php(827) : eval()'d code on line 10

Parse error: parse error, unexpected $ in /home/www/vendetta2.freehostia.com/forums/convert.php(827) : eval()'d code on line 10

Parse error: parse error, unexpected $ in /home/www/vendetta2.freehostia.com/forums/convert.php(827) : eval()'d code on line 10

Parse error: parse error, unexpected $ in /home/www/vendetta2.freehostia.com/forums/convert.php(827) : eval()'d code on line 10

Parse error: parse error, unexpected $ in /home/www/vendetta2.freehostia.com/forums/convert.php(827) : eval()'d code on line 10

Parse error: parse error, unexpected $ in /home/www/vendetta2.freehostia.com/forums/convert.php(827) : eval()'d code on line 10

Parse error: parse error, unexpected $ in /home/www/vendetta2.freehostia.com/forums/convert.php(827) : eval()'d code on line 10

Parse error: parse error, unexpected $ in /home/www/vendetta2.freehostia.com/forums/convert.php(827) : eval()'d code on line 10

Parse error: parse error, unexpected $ in /home/www/vendetta2.freehostia.com/forums/convert.php(827) : eval()'d code on line 10

Parse error: parse error, unexpected $ in /home/www/vendetta2.freehostia.com/forums/convert.php(827) : eval()'d code on line 10

Parse error: parse error, unexpected $ in /home/www/vendetta2.freehostia.com/forums/convert.php(827) : eval()'d code on line 10

Parse error: parse error, unexpected $ in /home/www/vendetta2.freehostia.com/forums/convert.php(827) : eval()'d code on line 10

Parse error: parse error, unexpected $ in /home/www/vendetta2.freehostia.com/forums/convert.php(827) : eval()'d code on line 10

Parse error: parse error, unexpected $ in /home/www/vendetta2.freehostia.com/forums/convert.php(827) : eval()'d code on line 10

Parse error: parse error, unexpected $ in /home/www/vendetta2.freehostia.com/forums/convert.php(827) : eval()'d code on line 10

Parse error: parse error, unexpected $ in /home/www/vendetta2.freehostia.com/forums/convert.php(827) : eval()'d code on line 10

Parse error: parse error, unexpected $ in /home/www/vendetta2.freehostia.com/forums/convert.php(827) : eval()'d code on line 10

Parse error: parse error, unexpected $ in /home/www/vendetta2.freehostia.com/forums/convert.php(827) : eval()'d code on line 10

Parse error: parse error, unexpected $ in /home/www/vendetta2.freehostia.com/forums/convert.php(827) : eval()'d code on line 10

Parse error: parse error, unexpected $ in /home/www/vendetta2.freehostia.com/forums/convert.php(827) : eval()'d code on line 10

Parse error: parse error, unexpected $ in /home/www/vendetta2.freehostia.com/forums/convert.php(827) : eval()'d code on line 10

Parse error: parse error, unexpected $ in /home/www/vendetta2.freehostia.com/forums/convert.php(827) : eval()'d code on line 10

Parse error: parse error, unexpected $ in /home/www/vendetta2.freehostia.com/forums/convert.php(827) : eval()'d code on line 10

Parse error: parse error, unexpected $ in /home/www/vendetta2.freehostia.com/forums/convert.php(827) : eval()'d code on line 10

Parse error: parse error, unexpected $ in /home/www/vendetta2.freehostia.com/forums/convert.php(827) : eval()'d code on line 10

Parse error: parse error, unexpected $ in /home/www/vendetta2.freehostia.com/forums/convert.php(827) : eval()'d code on line 10

Parse error: parse error, unexpected $ in /home/www/vendetta2.freehostia.com/forums/convert.php(827) : eval()'d code on line 10

Parse error: parse error, unexpected $ in /home/www/vendetta2.freehostia.com/forums/convert.php(827) : eval()'d code on line 10

Parse error: parse error, unexpected $ in /home/www/vendetta2.freehostia.com/forums/convert.php(827) : eval()'d code on line 10

Parse error: parse error, unexpected $ in /home/www/vendetta2.freehostia.com/forums/convert.php(827) : eval()'d code on line 10
Unsuccessful!
This query:
INSERT INTO `jazdan_ipb`.smf_poll_choices
(ID_POLL, choices)
VALUES ('1', 'a:4:{i:0;a:3:{i:0;i:0;i:1;s:34:\"Below 13 (like thats gonna happen)\";i:2;i:0;}i:1;a:3:{i:0;i:1;i:1;s:5:\"13-17\";i:2;i:8;}i:2;a:3:{i:0;i:2;i:1;s:5:\"17-20\";i:2;i:7;}i:3;a:3:{i:0;i:3;i:1;s:3:\"20+\";i:2;i:3;}}'),
('2', 'a:6:{i:0;a:3:{i:0;i:0;i:1;s:21:\"Middle School (pssht)\";i:2;i:0;}i:1;a:3:{i:0;i:1;i:1;s:11:\"High School\";i:2;i:8;}i:2;a:3:{i:0;i:2;i:1;s:19:\"College (undergrad)\";i:2;i:2;}i:3;a:3:{i:0;i:3;i:1;s:14:\"College (Grad)\";i:2;i:0;}i:4;a:3:{i:0;i:4;i:1;s:44:\"Have a job! (an occupation in this case)\";i:2;i:3;}i:5;a:3:{i:0;i:5;i:1;s:47:\"Psssht! I love staying at home.. Unemployed\";i:2;i:2;}}'),
('3', 'a:6:{i:0;a:3:{i:0;i:0;i:1;s:21:\"Middle School (pssht)\";i:2;i:0;}i:1;a:3:{i:0;i:1;i:1;s:11:\"High School\";i:2;i:0;}i:2;a:3:{i:0;i:2;i:1;s:19:\"College (undergrad)\";i:2;i:0;}i:3;a:3:{i:0;i:3;i:1;s:14:\"College (Grad)\";i:2;i:0;}i:4;a:3:{i:0;i:4;i:1;s:44:\"Have a job! (an occupation in this case)\";i:2;i:0;}i:5;a:3:{i:0;i:5;i:1;s:47:\"Psssht! I love staying at home.. Unemployed\";i:2;i:0;}}'),
('4', 'a:6:{i:0;a:3:{i:0;i:0;i:1;s:21:\"Middle School (pssht)\";i:2;i:0;}i:1;a:3:{i:0;i:1;i:1;s:11:\"High School\";i:2;i:0;}i:2;a:3:{i:0;i:2;i:1;s:19:\"College (undergrad)\";i:2;i:0;}i:3;a:3:{i:0;i:3;i:1;s:14:\"College (Grad)\";i:2;i:0;}i:4;a:3:{i:0;i:4;i:1;s:44:\"Have a job! (an occupation in this case)\";i:2;i:0;}i:5;a:3:{i:0;i:5;i:1;s:47:\"Psssht! I love staying at home.. Unemployed\";i:2;i:0;}}'),
('5', 'a:4:{i:0;a:3:{i:0;i:0;i:1;s:22:\"Pure Str (PvE machine)\";i:2;i:2;}i:1;a:3:{i:0;i:1;i:1;s:18:\"Pure Heal (Tanker)\";i:2;i:1;}i:2;a:3:{i:0;i:2;i:1;s:17:\"Heal+Str (Hybrid)\";i:2;i:5;}i:3;a:3:{i:0;i:3;i:1;s:24:\"Pure Dex (Crazy Crits??)\";i:2;i:3;}}'),
('22', 'a:3:{i:0;a:3:{i:0;i:0;i:1;s:3:\"yep\";i:2;i:7;}i:1;a:3:{i:0;i:1;i:1;s:2:\"no\";i:2;i:1;}i:2;a:3:{i:0;i:2;i:1;s:19:\"plan to download XD\";i:2;i:0;}}'),
('7', 'a:4:{i:0;a:3:{i:0;i:0;i:1;s:5:\"Grani\";i:2;i:0;}i:1;a:3:{i:0;i:1;i:1;s:7:\"Sylphid\";i:2;i:6;}i:2;a:3:{i:0;i:2;i:1;s:7:\"Ventus \";i:2;i:3;}i:3;a:3:{i:0;i:3;i:1;s:55:\"Screw them! Im cheap, I aint paying for a ride!\";i:2;i:0;}}'),
('8', 'a:2:{i:0;a:3:{i:0;i:0;i:1;s:36:\"Yes!! Then pl do give rep ^^\";i:2;i:4;}i:1;a:3:{i:0;i:1;i:1;s:17:\"Nope. Useless -.-\";i:2;i:3;}}'),
('45', 'a:6:{i:0;a:3:{i:0;i:0;i:1;s:12:\"Azure Knight\";i:2;i:5;}i:1;a:3:{i:0;i:1;i:1;s:4:\"Bagi\";i:2;i:4;}i:2;a:3:{i:0;i:2;i:1;s:6:\"Hunter\";i:2;i:0;}i:3;a:3:{i:0;i:3;i:1;s:4:\"Mage\";i:2;i:5;}i:4;a:3:{i:0;i:4;i:1;s:7:\"Segnale\";i:2;i:3;}i:5;a:3:{i:0;i:5;i:1;s:8:\"Summoner\";i:2;i:4;}}'),
('21', 'a:3:{i:0;a:3:{i:0;i:0;i:1;s:3:\"yes\";i:2;i:1;}i:1;a:3:{i:0;i:1;i:1;s:8:\"hell yes\";i:2;i:15;}i:2;a:3:{i:0;i:2;i:1;s:2:\"no\";i:2;i:0;}}'),
('14', 'a:11:{i:0;a:3:{i:0;i:0;i:1;s:16:\"less than 1 week\";i:2;i:4;}i:1;a:3:{i:0;i:1;i:1;s:9:\"1-2 weeks\";i:2;i:4;}i:2;a:3:{i:0;i:2;i:1;s:9:\"2-3 weeks\";i:2;i:3;}i:3;a:3:{i:0;i:3;i:1;s:9:\"3-4 weeks\";i:2;i:3;}i:4;a:3:{i:0;i:4;i:1;s:9:\"4-5 weeks\";i:2;i:0;}i:5;a:3:{i:0;i:5;i:1;s:9:\"5-6 weeks\";i:2;i:1;}i:6;a:3:{i:0;i:6;i:1;s:9:\"6-7 weeks\";i:2;i:0;}i:7;a:3:{i:0;i:7;i:1;s:9:\"7-8 weeks\";i:2;i:0;}i:8;a:3:{i:0;i:8;i:1;s:9:\"8-9 weeks\";i:2;i:0;}i:9;a:3:{i:0;i:9;i:1;s:10:\"9-10 weeks\";i:2;i:0;}i:10;a:3:{i:0;i:10;i:1;s:9:\"10+ weeks\";i:2;i:2;}}'),
('12', 'a:2:{i:0;a:3:{i:0;i:0;i:1;s:3:\"yes\";i:2;i:2;}i:1;a:3:{i:0;i:1;i:1;s:2:\"no\";i:2;i:1;}}'),
('13', 'a:2:{i:0;a:3:{i:0;i:0;i:1;s:39:\"Yes, there should be stealing coin item\";i:2;i:0;}i:1;a:3:{i:0;i:1;i:1;s:45:\"No, there shouldn't be stealing coin item\";i:2;i:0;}}'),
('15', 'a:5:{i:0;a:3:{i:0;i:0;i:1;s:27:\"Pure Offense(Issue for PvP)\";i:2;i:3;}i:1;a:3:{i:0;i:1;i:1;s:11:\"Mid-fielder\";i:2;i:7;}i:2;a:3:{i:0;i:2;i:1;s:52:\"Crit Holders(Doesnt apply to archers)(Issue for pvp)\";i:2;i:1;}i:3;a:3:{i:0;i:3;i:1;s:12:\"Pure Defense\";i:2;i:2;}i:4;a:3:{i:0;s:1:\"4\";i:1;s:40:\"Dep's suggestion - Dex, str and heal\";i:2;i:2;}}'),
('16', 'a:18:{i:0;a:3:{i:0;i:0;i:1;s:5:\"Power\";i:2;i:0;}i:1;a:3:{i:0;i:1;i:1;s:10:\"Popularity\";i:2;i:0;}i:2;a:3:{i:0;i:2;i:1;s:6:\"Status\";i:2;i:0;}i:3;a:3:{i:0;i:3;i:1;s:5:\"Trust\";i:2;i:0;}i:4;a:3:{i:0;s:1:\"4\";i:1;s:34:\"Power, Popularity, Status, + Trust\";i:2;i:0;}i:5;a:3:{i:0;s:1:\"5\";i:1;s:16:\"Power+Popularity\";i:2;i:1;}i:6;a:3:{i:0;s:1:\"6\";i:1;s:12:\"Power+Status\";i:2;i:0;}i:7;a:3:{i:0;s:1:\"7\";i:1;s:11:\"Power+Trust\";i:2;i:1;}i:8;a:3:{i:0;s:1:\"8\";i:1;s:17:\"Popularity+Status\";i:2;i:0;}i:9;a:3:{i:0;s:1:\"9\";i:1;s:16:\"Popularity+Trust\";i:2;i:0;}i:10;a:3:{i:0;s:2:\"10\";i:1;s:12:\"Status+Trust\";i:2;i:1;}i:11;a:3:{i:0;s:2:\"11\";i:1;s:23:\"Power+Popularity+Status\";i:2;i:0;}i:12;a:3:{i:0;s:2:\"12\";i:1;s:18:\"Power+Status+Trust\";i:2;i:2;}i:13;a:3:{i:0;s:2:\"13\";i:1;s:23:\"Popularity+Status+Trust\";i:2;i:1;}i:14;a:3:{i:0;s:2:\"14\";i:1;s:23:\"Status+Trust+Popularity\";i:2;i:0;}i:15;a:3:{i:0;s:2:\"15\";i:1;s:22:\"Trust+Power+Popularity\";i:2;i:2;}i:16;a:3:{i:0;s:2:\"16\";i:1;s:10:\"No Opinion\";i:2;i:0;}i:17;a:3:{i:0;s:2:\"17\";i:1;s:29:\"Other[Please Specify In Post]\";i:2;i:0;}}'),
('17', 'a:3:{i:0;a:3:{i:0;i:0;i:1;s:3:\"Yes\";i:2;i:2;}i:1;a:3:{i:0;i:1;i:1;s:2:\"No\";i:2;i:1;}i:2;a:3:{i:0;i:2;i:1;s:8:\"Not sure\";i:2;i:4;}}'),
('18', 'a:3:{i:0;a:3:{i:0;i:0;i:1;s:3:\"yes\";i:2;i:16;}i:1;a:3:{i:0;i:1;i:1;s:2:\"no\";i:2;i:0;}i:2;a:3:{i:0;s:1:\"2\";i:1;s:8:\"not sure\";i:2;i:2;}}'),
('19', 'a:4:{i:0;a:3:{i:0;i:0;i:1;s:2:\"no\";i:2;i:0;}i:1;a:3:{i:0;i:1;i:1;s:3:\"huh\";i:2;i:1;}i:2;a:3:{i:0;i:2;i:1;s:7:\"and yes\";i:2;i:2;}i:3;a:3:{i:0;i:3;i:1;s:19:\"PURGE THE TRASH CAN\";i:2;i:3;}}'),
('20', 'a:10:{i:0;a:3:{i:0;i:0;i:1;s:25:\""In V we trust"\";i:2;i:4;}i:1;a:3:{i:0;i:1;i:1;s:53:\"You're already dead. I killed you 10 minutes ago.\";i:2;i:0;}i:2;a:3:{i:0;i:2;i:1;s:65:\""Nothing is more costly, nothing is more sterile, than vengeance"\";i:2;i:0;}i:3;a:3:{i:0;i:3;i:1;s:80:\""When the blameless and the righteous die, the very gods for vengeance cry"\";i:2;i:5;}i:4;a:3:{i:0;i:4;i:1;s:29:\""Vengeance has no foresight" \";i:2;i:0;}i:5;a:3:{i:0;i:5;i:1;s:123:\""Vi Veri Vniversum Vivus Vici" (="By the power of Truth, I, while living, have conquered the universe")\";i:2;i:3;}i:6;a:3:{i:0;i:6;i:1;s:94:\""On The Path To Greatness, Nothing Will Stand In Our Way Nor Stray Us From Our Goal"\";i:2;i:1;}i:7;a:3:{i:0;i:7;i:1;s:85:\"" The only verdict is vengeance, a vendetta, held as a votive not in vain."\";i:2;i:4;}i:8;a:3:{i:0;i:8;i:1;s:47:\""Let them hate as long as they fear."\";i:2;i:0;}i:9;a:3:{i:0;s:1:\"9\";i:1;s:67:\"Let the Bloodbath Begin in the name of Vengeance and Vanity --Omega\";i:2;i:2;}}'),
('53', 'a:2:{i:0;a:3:{i:0;i:0;i:1;s:3:\"Yes\";i:2;i:2;}i:1;a:3:{i:0;i:1;i:1;s:4:\"Nope\";i:2;i:2;}}'),
('24', 'a:3:{i:0;a:3:{i:0;i:0;i:1;s:3:\"Yes\";i:2;i:2;}i:1;a:3:{i:0;i:1;i:1;s:2:\"No\";i:2;i:0;}i:2;a:3:{i:0;i:2;i:1;s:20:\"Too lazy, but would.\";i:2;i:2;}}'),
('25', 'a:2:{i:0;a:3:{i:0;i:0;i:1;s:7:\"Braiken\";i:2;i:6;}i:1;a:3:{i:0;i:1;i:1;s:3:\"Loa\";i:2;i:13;}}'),
('52', 'a:2:{i:0;a:3:{i:0;i:0;i:1;s:12:\"Love it!\";i:2;i:11;}i:1;a:3:{i:0;i:1;i:1;s:15:\"Rather not!\";i:2;i:2;}}'),
('48', 'a:12:{i:0;a:3:{i:0;i:0;i:1;s:29:\"I don't care that much...\";i:2;i:1;}i:1;a:3:{i:0;i:1;i:1;s:1:\"1\";i:2;i:0;}i:2;a:3:{i:0;i:2;i:1;s:1:\"2\";i:2;i:0;}i:3;a:3:{i:0;i:3;i:1;s:1:\"3\";i:2;i:1;}i:4;a:3:{i:0;i:4;i:1;s:1:\"4\";i:2;i:0;}i:5;a:3:{i:0;i:5;i:1;s:1:\"5\";i:2;i:0;}i:6;a:3:{i:0;i:6;i:1;s:1:\"6\";i:2;i:1;}i:7;a:3:{i:0;i:7;i:1;s:1:\"7\";i:2;i:0;}i:8;a:3:{i:0;i:8;i:1;s:1:\"8\";i:2;i:2;}i:9;a:3:{i:0;i:9;i:1;s:1:\"9\";i:2;i:0;}i:10;a:3:{i:0;i:10;i:1;s:2:\"10\";i:2;i:1;}i:11;a:3:{i:0;i:11;i:1;s:22:\"It's off the scale\";i:2;i:4;}}'),
('28', 'a:7:{i:0;a:3:{i:0;i:0;i:1;s:3:\"USA\";i:2;i:7;}i:1;a:3:{i:0;i:1;i:1;s:28:\"North America (Excludes USA)\";i:2;i:0;}i:2;a:3:{i:0;i:2;i:1;s:13:\"South America\";i:2;i:0;}i:3;a:3:{i:0;i:3;i:1;s:9:\"Australia\";i:2;i:0;}i:4;a:3:{i:0;i:4;i:1;s:23:\"Europe (please specify)\";i:2;i:4;}i:5;a:3:{i:0;i:5;i:1;s:4:\"Asia\";i:2;i:1;}i:6;a:3:{i:0;i:6;i:1;s:7:\"Africa?\";i:2;i:2;}}'),
('44', 'a:4:{i:0;a:3:{i:0;i:0;i:1;s:3:\"Yes\";i:2;i:2;}i:1;a:3:{i:0;i:1;i:1;s:2:\"No\";i:2;i:5;}i:2;a:3:{i:0;i:2;i:1;s:5:\"Maybe\";i:2;i:0;}i:3;a:3:{i:0;i:3;i:1;s:16:\"I don't care\";i:2;i:0;}}'),
('29', 'a:12:{i:0;a:3:{i:0;i:0;i:1;s:3:\"R/B\";i:2;i:0;}i:1;a:3:{i:0;i:1;i:1;s:4:\"Rock\";i:2;i:4;}i:2;a:3:{i:0;i:2;i:1;s:7:\"Country\";i:2;i:0;}i:3;a:3:{i:0;i:3;i:1;s:16:\"Hip Hop ( Rap ) \";i:2;i:2;}i:4;a:3:{i:0;i:4;i:1;s:12:\"Gansta ****** \";i:2;i:1;}i:5;a:3:{i:0;i:5;i:1;s:6:\"Techno\";i:2;i:1;}i:6;a:3:{i:0;i:6;i:1;s:5:\"Blues\";i:2;i:0;}i:7;a:3:{i:0;i:7;i:1;s:10:\"Classical \";i:2;i:0;}i:8;a:3:{i:0;i:8;i:1;s:4:\"Jazz\";i:2;i:0;}i:9;a:3:{i:0;i:9;i:1;s:5:\"Dance\";i:2;i:0;}i:10;a:3:{i:0;i:10;i:1;s:5:\"Folk \";i:2;i:1;}i:11;a:3:{i:0;i:11;i:1;s:6:\"Metal \";i:2;i:4;}}'),
('30', 'a:14:{i:0;a:3:{i:0;i:0;i:1;s:5:\"Youuu\";i:2;i:0;}i:1;a:3:{i:0;i:1;i:1;s:5:\"Taber\";i:2;i:0;}i:2;a:3:{i:0;i:2;i:1;s:8:\"Chowmein\";i:2;i:1;}i:3;a:3:{i:0;i:3;i:1;s:6:\"Skiski\";i:2;i:8;}i:4;a:3:{i:0;i:4;i:1;s:6:\"Ultima\";i:2;i:1;}i:5;a:3:{i:0;i:5;i:1;s:7:\"Kuchiki\";i:2;i:2;}i:6;a:3:{i:0;i:6;i:1;s:6:\"Dameon\";i:2;i:0;}i:7;a:3:{i:0;i:7;i:1;s:5:\"Omega\";i:2;i:0;}i:8;a:3:{i:0;i:8;i:1;s:10:\"Legolaslor\";i:2;i:1;}i:9;a:3:{i:0;i:9;i:1;s:9:\"Deputatu1\";i:2;i:0;}i:10;a:3:{i:0;i:10;i:1;s:11:\"RaguajBlack\";i:2;i:0;}i:11;a:3:{i:0;i:11;i:1;s:8:\"Cryspler\";i:2;i:1;}i:12;a:3:{i:0;i:12;i:1;s:6:\"NeuroL\";i:2;i:2;}i:13;a:3:{i:0;i:13;i:1;s:21:\"Other[Please Specify]\";i:2;i:0;}}'),
('49', 'a:2:{i:0;a:3:{i:0;i:0;i:1;s:37:\"SKISKI OF COURSE !!!!\";i:2;i:3;}i:1;a:3:{i:0;i:1;i:1;s:39:\"Cryspler...so lame dude !!!\";i:2;i:1;}}'),
('32', 'a:6:{i:0;a:3:{i:0;i:0;i:1;s:29:\"give the item to him for free\";i:2;i:3;}i:1;a:3:{i:0;i:1;i:1;s:14:\"lend it to him\";i:2;i:1;}i:2;a:3:{i:0;i:2;i:1;s:30:\"sell it to him with a discount\";i:2;i:7;}i:3;a:3:{i:0;i:3;i:1;s:46:\"refuse and sell it in the market(open a store)\";i:2;i:2;}i:4;a:3:{i:0;i:4;i:1;s:40:\"trade it to your friend for another item\";i:2;i:2;}i:5;a:3:{i:0;s:1:\"5\";i:1;s:14:\"other(specify)\";i:2;i:0;}}'),
('33', 'a:2:{i:0;a:3:{i:0;i:0;i:1;s:3:\"Yes\";i:2;i:4;}i:1;a:3:{i:0;i:1;i:1;s:2:\"No\";i:2;i:1;}}'),
('51', 'a:4:{i:0;a:3:{i:0;i:0;i:1;s:11:\"Skiski!\";i:2;i:6;}i:1;a:3:{i:0;i:1;i:1;s:11:\"Dameon!\";i:2;i:2;}i:2;a:3:{i:0;i:2;i:1;s:33:\"Kuchiki_Byakuya! <---ME ^^\";i:2;i:6;}i:3;a:3:{i:0;s:1:\"3\";i:1;s:0:\"\";i:2;i:4;}}'),
('35', 'a:5:{i:0;a:3:{i:0;i:0;i:1;s:9:\"Yes !\";i:2;i:9;}i:1;a:3:{i:0;i:1;i:1;s:41:\"I Will Buy A Microphone And I Agree !\";i:2;i:3;}i:2;a:3:{i:0;i:2;i:1;s:8:\"No !\";i:2;i:6;}i:3;a:3:{i:0;i:3;i:1;s:47:\"I can't Afford To Buy A Microphone :( !\";i:2;i:1;}i:4;a:3:{i:0;s:1:\"4\";i:1;s:35:\"I Don't Have A Microphone !\";i:2;i:0;}}'),
('38', 'a:3:{i:0;a:3:{i:0;i:0;i:1;s:9:\"Yes !\";i:2;i:3;}i:1;a:3:{i:0;s:1:\"1\";i:1;s:7:\"No!\";i:2;i:0;}i:2;a:3:{i:0;s:1:\"2\";i:1;s:25:\"No Way Man You Suck !\";i:2;i:0;}}'),
('37', 'a:10:{i:0;a:3:{i:0;i:0;i:1;s:16:\"1[It SUCKS!]\";i:2;i:0;}i:1;a:3:{i:0;i:1;i:1;s:1:\"2\";i:2;i:0;}i:2;a:3:{i:0;i:2;i:1;s:1:\"3\";i:2;i:0;}i:3;a:3:{i:0;i:3;i:1;s:1:\"4\";i:2;i:1;}i:4;a:3:{i:0;i:4;i:1;s:1:\"5\";i:2;i:0;}i:5;a:3:{i:0;i:5;i:1;s:1:\"6\";i:2;i:0;}i:6;a:3:{i:0;i:6;i:1;s:1:\"7\";i:2;i:1;}i:7;a:3:{i:0;i:7;i:1;s:1:\"8\";i:2;i:2;}i:8;a:3:{i:0;i:8;i:1;s:1:\"9\";i:2;i:0;}i:9;a:3:{i:0;i:9;i:1;s:31:\"10[It OWNS!!!!]\";i:2;i:0;}}'),
('42', 'a:7:{i:0;a:3:{i:0;i:0;i:1;s:1:\"1\";i:2;i:2;}i:1;a:3:{i:0;i:1;i:1;s:1:\"2\";i:2;i:0;}i:2;a:3:{i:0;i:2;i:1;s:1:\"3\";i:2;i:0;}i:3;a:3:{i:0;i:3;i:1;s:1:\"4\";i:2;i:1;}i:4;a:3:{i:0;i:4;i:1;s:1:\"5\";i:2;i:2;}i:5;a:3:{i:0;i:5;i:1;s:1:\"6\";i:2;i:9;}i:6;a:3:{i:0;i:6;i:1;s:31:\"Other[Please specify in a post]\";i:2;i:0;}}'),
('41', 'a:2:{i:0;a:3:{i:0;i:0;i:1;s:4:\"Yes.\";i:2;i:4;}i:1;a:3:{i:0;i:1;i:1;s:3:\"No.\";i:2;i:0;}}'),
('54', 'a:6:{i:0;a:3:{i:0;i:0;i:1;s:17:\"14 hours or below\";i:2;i:1;}i:1;a:3:{i:0;i:1;i:1;s:12:\"15-21 hours \";i:2;i:1;}i:2;a:3:{i:0;i:2;i:1;s:11:\"22-28 hours\";i:2;i:0;}i:3;a:3:{i:0;i:3;i:1;s:11:\"29-36 hours\";i:2;i:2;}i:4;a:3:{i:0;i:4;i:1;s:12:\"37-50 hours \";i:2;i:2;}i:5;a:3:{i:0;i:5;i:1;s:14:\"51+ Hours!\";i:2;i:7;}}'),
('55', 'a:4:{i:0;a:3:{i:0;i:0;i:1;s:3:\"Yes\";i:2;i:2;}i:1;a:3:{i:0;i:1;i:1;s:2:\"No\";i:2;i:2;}i:2;a:3:{i:0;i:2;i:1;s:22:\"Ill fix that -- Dameon\";i:2;i:0;}i:3;a:3:{i:0;s:1:\"3\";i:1;s:11:\"I dont care\";i:2;i:1;}}'),
('56', 'a:4:{i:0;a:3:{i:0;i:0;i:1;s:3:\"Now\";i:2;i:1;}i:1;a:3:{i:0;i:1;i:1;s:4:\"ASAP\";i:2;i:0;}i:2;a:3:{i:0;i:2;i:1;s:15:\"In summer break\";i:2;i:1;}i:3;a:3:{i:0;i:3;i:1;s:17:\"Dont care anymore\";i:2;i:0;}}');
Caused the error:

Unknown column 'choices' in 'field list'
Ugh...
*FIXED, CONVERSION IS SUCCESSFUL*

[izi]

I have the same errors, how did you solve it?

[xmariox]

Same errors here. Please also tell us _how_ you solved these errors. I guess it will also help other in the future

[JayBachatero]

[SMF Converter] IPB 1.3.x