IPB 2.1.3

[Oldiesmann]

Can someone provide me with another copy of the IPB 2.1.3 table structure? I seem to have accidentally deleted the sql.rar file that was mentioned earlier in this post and it's not there anymore...

[Monteiro]

Of course! Here it is:
http://www.cs-news.com.br/temp/ipb.zip

This is an IPB fresh install sql. If you need some real data let me know. Also, if you have any problem downloading that, let me know too

[Oldiesmann]

Thanks!

[Oldiesmann]

Don't know why I didn't do anything with this sooner as there are only a couple of problems preventing the converter from working right (one of which I fixed). Can you give me a dump of your polls table? Once I have that I can work on fixing any issues with poll conversion.

[Monteiro]

You only need the pools table? Here it goes my "production" ipb_pools table:
http://www.cs-news.com.br/temp/pools.zip

Again, if you need anything else, lemme know!

[Oldiesmann]

Thanks again. Assuming I don't run into any weird problems, I should have something ready for you within a few days.

[Monteiro]

Sooo glad to hear that

[daveb47]

I take it that you ran into wierd problems Oldiesmann,Knowing IPB i kinda guessed you might

[daveb47]

Just teased Oldiesmann with a PM

Do you think it might be time for another one Montiero

[daveb47]

Now 2.1.5,Do you want another Database dump Oldiesmann.

[Monteiro]

I believe if you have intentions of converting from IPB to SMF, there's no need to keep IPB up to date
And I'll tease Oldiesmann a PM again lol

[H]

Maybe Grudge could make an offical one....

[Oldiesmann]

Thanks for all the data. That poll data you provided was extremely useful

[daveb47]

Thanx Oldiesman
Members/posts etc seem to be converting,But stops on this error so forums etc are not converting,

Code Select Expand

Converting polls... Unsuccessful!
This query:

    SELECT
    p.pid AS ID_POLL, p.starter_id AS ID_MEMBER, choices
    IFNULL(m.name, 'Guest') AS posterName
    FROM `davebiz_smf`.ibf_polls AS p
    LEFT JOIN `davebiz_smf`.ibf_members AS m ON (m.id = p.starter_id)
    LIMIT 0, 500;

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 'IFNULL(m.name, 'Guest') AS posterName
    FROM `davebiz_smf`.ibf_polls AS p
    LEFT ' at line 3 

[Oldiesmann]

Whoopsies!

Hang on a second and I'll fix it.

[Oldiesmann]

Ok. Fixed that issue and updated the above post with the fixed file.

[daveb47]

Unfortunately now getting this one

Code Select Expand

Converting posts (this may take some time)... Successful.
Converting polls... Successful.
Converting poll options...
Parse error: parse error, unexpected T_VARIABLE in /home/goldus/public_html/essexfm4/smf/convert.php(814) : eval()'d code on line 3

Parse error: parse error, unexpected T_VARIABLE in /home/goldus/public_html/essexfm4/smf/convert.php(814) : eval()'d code on line 3

Parse error: parse error, unexpected T_VARIABLE in /home/goldus/public_html/essexfm4/smf/convert.php(814) : eval()'d code on line 3

Parse error: parse error, unexpected T_VARIABLE in /home/goldus/public_html/essexfm4/smf/convert.php(814) : eval()'d code on line 3

Parse error: parse error, unexpected T_VARIABLE in /home/goldus/public_html/essexfm4/smf/convert.php(814) : eval()'d code on line 3

Parse error: parse error, unexpected T_VARIABLE in /home/goldus/public_html/essexfm4/smf/convert.php(814) : eval()'d code on line 3

Parse error: parse error, unexpected T_VARIABLE in /home/goldus/public_html/essexfm4/smf/convert.php(814) : eval()'d code on line 3

Parse error: parse error, unexpected T_VARIABLE in /home/goldus/public_html/essexfm4/smf/convert.php(814) : eval()'d code on line 3

Parse error: parse error, unexpected T_VARIABLE in /home/goldus/public_html/essexfm4/smf/convert.php(814) : eval()'d code on line 3

Parse error: parse error, unexpected T_VARIABLE in /home/goldus/public_html/essexfm4/smf/convert.php(814) : eval()'d code on line 3

Parse error: parse error, unexpected T_VARIABLE in /home/goldus/public_html/essexfm4/smf/convert.php(814) : eval()'d code on line 3

Parse error: parse error, unexpected T_VARIABLE in /home/goldus/public_html/essexfm4/smf/convert.php(814) : eval()'d code on line 3

Parse error: parse error, unexpected T_VARIABLE in /home/goldus/public_html/essexfm4/smf/convert.php(814) : eval()'d code on line 3

Parse error: parse error, unexpected T_VARIABLE in /home/goldus/public_html/essexfm4/smf/convert.php(814) : eval()'d code on line 3

Parse error: parse error, unexpected T_VARIABLE in /home/goldus/public_html/essexfm4/smf/convert.php(814) : eval()'d code on line 3

Parse error: parse error, unexpected T_VARIABLE in /home/goldus/public_html/essexfm4/smf/convert.php(814) : eval()'d code on line 3

Parse error: parse error, unexpected T_VARIABLE in /home/goldus/public_html/essexfm4/smf/convert.php(814) : eval()'d code on line 3

Parse error: parse error, unexpected T_VARIABLE in /home/goldus/public_html/essexfm4/smf/convert.php(814) : eval()'d code on line 3

Parse error: parse error, unexpected T_VARIABLE in /home/goldus/public_html/essexfm4/smf/convert.php(814) : eval()'d code on line 3

Parse error: parse error, unexpected T_VARIABLE in /home/goldus/public_html/essexfm4/smf/convert.php(814) : eval()'d code on line 3

Parse error: parse error, unexpected T_VARIABLE in /home/goldus/public_html/essexfm4/smf/convert.php(814) : eval()'d code on line 3

Parse error: parse error, unexpected T_VARIABLE in /home/goldus/public_html/essexfm4/smf/convert.php(814) : eval()'d code on line 3

Parse error: parse error, unexpected T_VARIABLE in /home/goldus/public_html/essexfm4/smf/convert.php(814) : eval()'d code on line 3

Parse error: parse error, unexpected T_VARIABLE in /home/goldus/public_html/essexfm4/smf/convert.php(814) : eval()'d code on line 3

Parse error: parse error, unexpected T_VARIABLE in /home/goldus/public_html/essexfm4/smf/convert.php(814) : eval()'d code on line 3

Parse error: parse error, unexpected T_VARIABLE in /home/goldus/public_html/essexfm4/smf/convert.php(814) : eval()'d code on line 3

Parse error: parse error, unexpected T_VARIABLE in /home/goldus/public_html/essexfm4/smf/convert.php(814) : eval()'d code on line 3

Parse error: parse error, unexpected T_VARIABLE in /home/goldus/public_html/essexfm4/smf/convert.php(814) : eval()'d code on line 3

Parse error: parse error, unexpected T_VARIABLE in /home/goldus/public_html/essexfm4/smf/convert.php(814) : eval()'d code on line 3

Parse error: parse error, unexpected T_VARIABLE in /home/goldus/public_html/essexfm4/smf/convert.php(814) : eval()'d code on line 3

Parse error: parse error, unexpected T_VARIABLE in /home/goldus/public_html/essexfm4/smf/convert.php(814) : eval()'d code on line 3

Parse error: parse error, unexpected T_VARIABLE in /home/goldus/public_html/essexfm4/smf/convert.php(814) : eval()'d code on line 3

Parse error: parse error, unexpected T_VARIABLE in /home/goldus/public_html/essexfm4/smf/convert.php(814) : eval()'d code on line 3

Parse error: parse error, unexpected T_VARIABLE in /home/goldus/public_html/essexfm4/smf/convert.php(814) : eval()'d code on line 3

Parse error: parse error, unexpected T_VARIABLE in /home/goldus/public_html/essexfm4/smf/convert.php(814) : eval()'d code on line 3

Parse error: parse error, unexpected T_VARIABLE in /home/goldus/public_html/essexfm4/smf/convert.php(814) : eval()'d code on line 3
Unsuccessful!
This query:

    INSERT INTO `davebiz_smf`.smf_poll_choices
    (ID_POLL, choices)
    VALUES ('1', 'a:1:{i:1;a:3:{s:8:\"question\";s:41:\"What should the resolution of Goldies be?\";s:6:\"choice\";a:3:{i:0;s:9:\"800 X 600\";i:1;s:10:\"1024 X 768\";i:2;s:10:\"1280 X 960\";}s:5:\"votes\";a:3:{i:0;i:1;i:1;i:2;i:2;i:1;}}}'),
    ('2', 'a:1:{i:1;a:3:{s:8:\"question\";s:37:\"What Operating System do you all use?\";s:6:\"choice\";a:10:{i:0;s:6:\"XP Pro\";i:1;s:7:\"XP Home\";i:2;s:12:\"Windows 2003\";i:3;s:23:\"Windows 2000 Pro/Server\";i:4;s:10:\"Windows ME\";i:5;s:9:\"Windows98\";i:6;s:9:\"Windows95\";i:7;s:11:\"Windows3.xx\";i:8;s:10:\"Linux/Unix\";i:9;s:3:\"MAC\";}s:5:\"votes\";a:10:{i:0;i:15;i:1;i:2;i:2;i:0;i:3;i:1;i:4;i:0;i:5;i:0;i:6;i:0;i:7;i:1;i:8;i:1;i:9;i:0;}}}'),
    ('3', 'a:1:{i:1;a:3:{s:8:\"question\";s:42:\"Who would you vote, or who are you voting?\";s:6:\"choice\";a:6:{i:0;s:26:\"I am voting George W. Bush\";i:1;s:25:\"I am voting John F. Kerry\";i:2;s:31:\"I would vote for George W. Bush\";i:3;s:30:\"I would vote for John F. Kerry\";i:4;s:5:\"Other\";i:5;s:6:\"Unsure\";}s:5:\"votes\";a:6:{i:0;i:1;i:1;i:0;i:2;i:2;i:3;i:1;i:4;i:0;i:5;i:0;}}}'),
    ('5', 'a:1:{i:1;a:3:{s:8:\"question\";s:223:\"Do you update just because there is a new version,new skin,new option.ect.ect.. or only when truely necessary? Im not talking antivirus, trojan hunters ect ect... I'm talking winamp,winzip,Im's services ect ect!\";s:6:\"choice\";a:4:{i:0;s:40:\"I like being a Guineapig* All the time*?\";i:1;s:87:\""Only when it's a Security Issue* Only after it's proven necessary*?"\";i:2;s:93:\""Not till the appz stops working* forced update as it's no longer supported*?"\";i:3;s:5:\"Never\";}s:5:\"votes\";a:4:{i:0;i:1;i:1;i:7;i:2;i:1;i:3;i:2;}}}'),
    ('7', 'a:1:{i:1;a:3:{s:8:\"question\";s:12:\"Decide here.\";s:6:\"choice\";a:12:{i:0;s:20:\"Sakura(female Vote) \";i:1;s:20:\"Sharky(female Vote) \";i:2;s:18:\"Dona(female Vote) \";i:3;s:17:\"Sari(female Vote)\";i:4;s:18:\"Raven(female Vote)\";i:5;s:19:\"Tanith(female Vote)\";i:6;s:17:\"Sakura(male Vote)\";i:7;s:18:\"Sharky(male Vote) \";i:8;s:16:\"Dona(male Vote) \";i:9;s:16:\"Sari(male Vote) \";i:10;s:18:\"Tanith(male Vote) \";i:11;s:16:\"Raven(male Vote)\";}s:5:\"votes\";a:12:{i:0;i:2;i:1;i:0;i:2;i:0;i:3;i:0;i:4;i:0;i:5;i:0;i:6;i:6;i:7;i:3;i:8;i:3;i:9;i:0;i:10;i:0;i:11;i:0;}}}'),
    ('8', 'a:1:{i:1;a:3:{s:8:\"question\";s:49:\"Is it just me, or does the new Band Aid song suck\";s:6:\"choice\";a:5:{i:0;s:24:\"Yeah it's utter crap\";i:1;s:25:\"Yeah it's pretty poor\";i:2;s:12:\"Not heard it\";i:3;s:14:\"No it's OK\";i:4;s:21:\"No it's fantastic\";}s:5:\"votes\";a:5:{i:0;i:12;i:1;i:1;i:2;i:3;i:3;i:2;i:4;i:0;}}}'),
    ('9', 'a:1:{i:1;a:3:{s:8:\"question\";s:57:\"What Games consoles do you have? Which is your favourite?\";s:6:\"choice\";a:13:{i:0;s:13:\"Playstation 2\";i:1;s:4:\"Xbox\";i:2;s:8:\"Gamecube\";i:3;s:9:\"Dreamcast\";i:4;s:13:\"Playstation 1\";i:5;s:11:\"Sega Saturn\";i:6;s:11:\"Amiga CD-32\";i:7;s:7:\"Neo-Geo\";i:8;s:3:\"3DO\";i:9;s:14:\"Super Nintendo\";i:10;s:18:\"Sega Master System\";i:11;s:3:\"NES\";i:12;s:10:\"Atari 2600\";}s:5:\"votes\";a:13:{i:0;i:6;i:1;i:2;i:2;i:2;i:3;i:0;i:4;i:1;i:5;i:0;i:6;i:0;i:7;i:0;i:8;i:0;i:9;i:2;i:10;i:0;i:11;i:0;i:12;i:0;}}}'),
    ('10', 'a:1:{i:1;a:3:{s:8:\"question\";s:44:\"Who believes he was looking for blond jokes?\";s:6:\"choice\";a:2:{i:0;s:30:\"No your a dirty pervy mod!\";i:1;s:33:\"Yes we believe you oh mighty one.\";}s:5:\"votes\";a:2:{i:0;i:5;i:1;i:9;}}}'),
    ('19', 'a:1:{i:1;a:3:{s:8:\"question\";s:75:\"is there a teen sex problem in the world and does it lead to more abortions\";s:6:\"choice\";a:2:{i:0;s:4:\"yes \";i:1;s:3:\"no \";}s:5:\"votes\";a:2:{i:0;i:12;i:1;i:1;}}}'),
    ('13', 'a:1:{i:1;a:3:{s:8:\"question\";s:39:\"Who's Got The Best Avatar/Signature\";s:6:\"choice\";a:17:{i:0;s:12:\"Bolt_Thrower\";i:1;s:9:\"s.i.f.e.r\";i:2;s:6:\"sharky\";i:3;s:6:\"sakura\";i:4;s:7:\"daveb47\";i:5;s:6:\"psiDOC\";i:6;s:9:\"DJ Weeble\";i:7;s:5:\"Gazza\";i:8;s:6:\"Spooky\";i:9;s:15:\"Wannahockaloogy\";i:10;s:4:\"Mike\";i:11;s:5:\"Bonor\";i:12;s:8:\"B. Daddy\";i:13;s:11:\"jedi.warior\";i:14;s:10:\"Onlymenotu\";i:15;s:8:\"screamer\";i:16;s:35:\"skipper_jimSomebody else (post who)\";}s:5:\"votes\";a:17:{i:0;i:3;i:1;i:1;i:2;i:4;i:3;i:1;i:4;i:0;i:5;i:2;i:6;i:1;i:7;i:0;i:8;i:1;i:9;i:0;i:10;i:0;i:11;i:0;i:12;i:0;i:13;i:1;i:14;i:0;i:15;i:0;i:16;i:2;}}}'),
    ('15', 'a:1:{i:1;a:3:{s:8:\"question\";s:39:\"Who's gonna win the 2005 F1 season?\";s:6:\"choice\";a:15:{i:0;s:18:\"Michael Schumacher\";i:1;s:18:\"Bubens Barrichello\";i:2;s:13:\"Jenson Button\";i:3;s:15:\"Fernando Alonso\";i:4;s:12:\"Juan Montoya\";i:5;s:12:\"Jarno Trulli\";i:6;s:14:\"Kimi Raikkonen\";i:7;s:11:\"Takuma Sato\";i:8;s:15:\"Ralf Schumacher\";i:9;s:15:\"David Coulthard\";i:10;s:20:\"Giancarlo Fisichella\";i:11;s:5:\"Massa\";i:12;s:6:\"Webber\";i:13;s:8:\"Heidfeld\";i:14;s:37:\"I dont watch F1, its too boring! \";}s:5:\"votes\";a:15:{i:0;i:2;i:1;i:0;i:2;i:1;i:3;i:0;i:4;i:0;i:5;i:0;i:6;i:1;i:7;i:0;i:8;i:0;i:9;i:0;i:10;i:1;i:11;i:0;i:12;i:0;i:13;i:0;i:14;i:0;}}}'),
    ('16', 'a:1:{i:1;a:3:{s:8:\"question\";s:19:\"Which do you prefer\";s:6:\"choice\";a:2:{i:0;s:16:\"e107 based board\";i:1;s:18:\"PHPBB2 based board\";}s:5:\"votes\";a:2:{i:0;i:0;i:1;i:1;}}}'),
    ('17', 'a:1:{i:1;a:3:{s:8:\"question\";s:29:\"Who are you going to vote for\";s:6:\"choice\";a:7:{i:0;s:6:\"Labour\";i:1;s:12:\"Conservative\";i:2;s:8:\"Lib/Dems\";i:3;s:5:\"Other\";i:4;s:21:\"Wouldnt waste my time\";i:5;s:18:\"Who,What Election.\";i:6;s:12:\"Ronald Biggs\";}s:5:\"votes\";a:7:{i:0;i:1;i:1;i:2;i:2;i:0;i:3;i:1;i:4;i:4;i:5;i:0;i:6;i:0;}}}'),
    ('18', 'a:1:{i:1;a:3:{s:8:\"question\";s:62:\"Do you agree with Trump's idea to rebuild the twin towers?\";s:6:\"choice\";a:2:{i:0;s:22:\"Yes I agree with Trump\";i:1;s:52:\"NO, they should go with the original plans after 911\";}s:5:\"votes\";a:2:{i:0;i:0;i:1;i:1;}}}'),
    ('20', 'a:1:{i:1;a:3:{s:8:\"question\";s:28:\"should prostitution be legal\";s:6:\"choice\";a:2:{i:0;s:4:\"yes \";i:1;s:3:\"no \";}s:5:\"votes\";a:2:{i:0;i:10;i:1;i:4;}}}'),
    ('21', 'a:1:{i:1;a:3:{s:8:\"question\";s:41:\"should the drinking age be set back to 18\";s:6:\"choice\";a:3:{i:0;s:4:\"yes \";i:1;s:3:\"no \";i:2;s:47:\"i can die for the country but cant have a beer \";}s:5:\"votes\";a:3:{i:0;i:8;i:1;i:3;i:2;i:3;}}}'),
    ('22', 'a:1:{i:1;a:3:{s:8:\"question\";s:28:\"Was Hitler A Military Genius\";s:6:\"choice\";a:2:{i:0;s:40:\"yes- The man was a brilliant strategiest\";i:1;s:33:\"no -he did nothing with the army \";}s:5:\"votes\";a:2:{i:0;i:6;i:1;i:2;}}}'),
    ('23', 'a:1:{i:1;a:3:{s:8:\"question\";s:20:\"is this real or what\";s:6:\"choice\";a:2:{i:0;s:3:\"yes\";i:1;s:2:\"no\";}s:5:\"votes\";a:2:{i:0;i:4;i:1;i:1;}}}'),
    ('24', 'a:1:{i:1;a:3:{s:8:\"question\";s:30:\"should pitbull dogs be banned?\";s:6:\"choice\";a:2:{i:0;s:3:\"Yes\";i:1;s:2:\"No\";}s:5:\"votes\";a:2:{i:0;i:5;i:1;i:7;}}}'),
    ('25', 'a:1:{i:1;a:3:{s:8:\"question\";s:35:\"Should"Experts"be trusted\";s:6:\"choice\";a:2:{i:0;s:3:\"Yes\";i:1;s:2:\"No\";}s:5:\"votes\";a:2:{i:0;i:1;i:1;i:6;}}}'),
    ('26', 'a:1:{i:1;a:3:{s:8:\"question\";s:30:\"Praying is it worth the effort\";s:6:\"choice\";a:3:{i:0;s:3:\"yes\";i:1;s:2:\"no\";i:2;s:57:\"it works only if you give enough $$$$\";}s:5:\"votes\";a:3:{i:0;i:6;i:1;i:6;i:2;i:1;}}}'),
    ('27', 'a:1:{i:1;a:3:{s:8:\"question\";s:30:\"Are Trade Unions worth joining\";s:6:\"choice\";a:4:{i:0;s:64:\"Yes, Trade unions are strong, especially during pay negotiations\";i:1;s:54:\"Yes but only for the accident,legal and sickness cover\";i:2;s:19:\"No, Waste of time, \";i:3;s:45:\"My workplace does not have a recognized union\";}s:5:\"votes\";a:4:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:0;}}}'),
    ('28', 'a:1:{i:1;a:3:{s:8:\"question\";s:55:\"has the womans lib movement destroyed and family values\";s:6:\"choice\";a:2:{i:0;s:4:\"yes \";i:1;s:3:\"no \";}s:5:\"votes\";a:2:{i:0;i:3;i:1;i:5;}}}'),
    ('29', 'a:1:{i:1;a:3:{s:8:\"question\";s:91:\"Has Britian's involvement in the middle East wars caused it to be a target of terrorism\";s:6:\"choice\";a:2:{i:0;s:3:\"Yes\";i:1;s:2:\"No\";}s:5:\"votes\";a:2:{i:0;i:6;i:1;i:0;}}}'),
    ('30', 'a:1:{i:1;a:3:{s:8:\"question\";s:42:\"should this form of sex be against the law\";s:6:\"choice\";a:2:{i:0;s:4:\"yes \";i:1;s:2:\"no\";}s:5:\"votes\";a:2:{i:0;i:2;i:1;i:5;}}}'),
    ('31', 'a:1:{i:1;a:3:{s:8:\"question\";s:93:\"Do you get turned on by the idea of seeing 2 members of the opposite Sex having sex together.\";s:6:\"choice\";a:5:{i:0;s:14:\"Yes Definately\";i:1;s:8:\"Urrgh No\";i:2;s:9:\"Not sure \";i:3;s:5:\"Maybe\";i:4;s:21:\"Wots the Opposite Sex\";}s:5:\"votes\";a:5:{i:0;i:4;i:1;i:2;i:2;i:0;i:3;i:1;i:4;i:0;}}}'),
    ('32', 'a:1:{i:1;a:3:{s:8:\"question\";s:34:\"Should God Thread have been closed\";s:6:\"choice\";a:3:{i:0;s:3:\"Yes\";i:1;s:2:\"No\";i:2;s:5:\"Maybe\";}s:5:\"votes\";a:3:{i:0;i:3;i:1;i:1;i:2;i:5;}}}'),
    ('33', 'a:1:{i:1;a:3:{s:8:\"question\";s:29:\"Over the top even for Goldies\";s:6:\"choice\";a:2:{i:0;s:14:\"Yes definately\";i:1;s:2:\"No\";}s:5:\"votes\";a:2:{i:0;i:6;i:1;i:0;}}}'),
    ('34', 'a:1:{i:1;a:3:{s:8:\"question\";s:46:\"Do you think that todays children are spolied?\";s:6:\"choice\";a:2:{i:0;s:3:\"yes\";i:1;s:2:\"No\";}s:5:\"votes\";a:2:{i:0;i:12;i:1;i:1;}}}'),
    ('35', 'a:1:{i:1;a:3:{s:8:\"question\";s:44:\"Should the ******e Box (shout box) stay or go?\";s:6:\"choice\";a:2:{i:0;s:34:\"STAY (as in keep the bloody thing)\";i:1;s:56:\"GO (as in get rid of the ******e and people may post more)\";}s:5:\"votes\";a:2:{i:0;i:1;i:1;i:6;}}}'),
    ('36', 'a:1:{i:1;a:3:{s:8:\"question\";s:61:\"Do you agree with Pat Robertson's statement, or disagree?\";s:6:\"choice\";a:2:{i:0;s:96:\"I agree with Pat Robertson's call for the assassination of Venezuelan President Hugo Chavez \";i:1;s:99:\"I disagree with Pat Robertson's call for the assassination of Venezuelan President Hugo Chavez \";}s:5:\"votes\";a:2:{i:0;i:0;i:1;i:2;}}}'),
    ('37', 'a:1:{i:1;a:3:{s:8:\"question\";s:109:\"If Niggers can call Niggers "Niggers", should Honky's be allwed to call Niggers "Niggers ?\";s:6:\"choice\";a:3:{i:0;s:3:\"Yes\";i:1;s:2:\"No\";i:2;s:14:\"Watch it Honky\";}s:5:\"votes\";a:3:{i:0;i:5;i:1;i:5;i:2;i:1;}}}'),
    ('39', 'a:1:{i:1;a:3:{s:8:\"question\";s:11:\"God made us\";s:6:\"choice\";a:7:{i:1;s:62:\"God made us for when he needed something to take things out on\";i:2;s:33:\"God made us as a toy for his kids\";i:3;s:9:\"Evolution\";i:4;s:10:\"Sheer luck\";i:5;s:18:\"Life is from space\";i:6;s:14:\"Sheer bad luck\";i:7;s:41:\"If we wasnt here who would drink the beer\";}s:5:\"votes\";a:7:{i:1;i:0;i:2;i:0;i:3;i:1;i:4;i:1;i:5;i:1;i:6;i:0;i:7;i:1;}}}'),
    ('41', 'a:1:{i:1;a:3:{s:8:\"question\";s:83:\"Is it now the time to pull the troops out and leave Iraq to there own devices ???? \";s:6:\"choice\";a:3:{i:1;s:14:\"Yes defiantly.\";i:2;s:20:\"No leave them there.\";i:3;s:9:\"Not Sure.\";}s:5:\"votes\";a:3:{i:1;i:2;i:2;i:0;i:3;i:2;}}}'),
    ('42', 'a:1:{i:1;a:3:{s:8:\"question\";s:39:\"Should we have a paypal donation button\";s:6:\"choice\";a:2:{i:1;s:3:\"yes\";i:2;s:2:\"no\";}s:5:\"votes\";a:2:{i:1;i:5;i:2;i:1;}}}'),
    ('46', 'a:1:{i:1;a:3:{s:8:\"question\";s:32:\"Which one do you have or prefer?\";s:6:\"choice\";a:3:{i:1;s:3:\"AMD\";i:2;s:7:\"Pentium\";i:3;s:14:\"Don't mind\";}s:5:\"votes\";a:3:{i:1;i:2;i:2;i:0;i:3;i:0;}}}');

Caused the error:

    Unknown column 'choices' in 'field list'

[Oldiesmann]

Another minor typo... Sorry about that. I fixed it and uploaded the new file to the above post again.

EDIT: Hang on. Didn't see the "Unknown column choices" error a second ago.

[Oldiesmann]

Ok. I think that "unknown column choices" error was due to the typo, so go ahead and try again.

[daveb47]

Third time lucky m8,

Now Getting this error

Code Select Expand

Converting attachments... Successful.
Recalculating forum statistics... Unsuccessful!
This query:

    UPDATE `biz_smf`.smf_boards
    SET ID_LAST_MSG = 32242, lastUpdated = 1141716287
    WHERE ID_BOARD = 4
    LIMIT 1;

Caused the error:

    Unknown column 'lastUpdated' in 'field list'

Getting there tho!!!!

Thanx
Dave