[SMF Converter] IPB 2.2.x

Started by JayBachatero, January 24, 2007, 07:30:01 PM

Previous topic - Next topic

Powerbob

No Difference, here is the line from IPB db

QuoteINSERT INTO `ibf_posts` VALUES(71175, 0, NULL, 1, 'Powerbob', 1, 1, '125.27.31.10', 1199873939, 0, 'Glad u enjoy the pics.<br /><br />Here some more.<br /><br /><!--sizeo:5--><span style="font-size:18pt;line-height:100%"><!--/sizeo-->Kang<br /><br /><!--sizec--></span><!--/sizec--><div align="center"><img src="http://xxx.com/cpg1410/albums/userpics/10001/normal_kang1.JPG" border="0" class="linked-image" /><br /><br /><br /><img src="http://xxx.com/cpg1410/albums/userpics/10001/normal_kang2.JPG" border="0" class="linked-image" /><br /></div>', 0, 9934, NULL, 0, NULL, '3a3860c3a150890e211cfd4e89c5f835', 0, 0, '');



My SMF 2.1 Beta test site; http://www.pplb.net/smf21/index.php

JayBachatero

Heh it would help if I pass over the changes to the right file :P.  Here you go.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Powerbob

Thanks Jay that worked, photos posted are now showing, I will check through and see what else still is not working. During conversion user avatars were not converted nor were polls, but that is no biggy ;D

Thanks

Bob



My SMF 2.1 Beta test site; http://www.pplb.net/smf21/index.php

JayBachatero

Polls should be converted.  What version of IPB are you running?
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Powerbob

IPB 2.3.3 but I only had 2/3 polls so no problem for me.



My SMF 2.1 Beta test site; http://www.pplb.net/smf21/index.php

JayBachatero

Oh ok.  This converter needs its own topic then.  I'll create it later.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

el canadiano

Converting posts (this may take some time)... Successful.
Converting polls... Successful.
Converting poll options...
Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11

Notice: Undefined index: question in /home/stone/public_html/smf/convert.php(826) : eval()'d code on line 11
Unsuccessful!
This query:

    INSERT INTO `stone_smf`.smf_poll_choices
    (ID_POLL, ID_CHOICE, label, votes)
    VALUES (1, 1, "", ),
    (2, 1, "", ),
    (3, 1, "", ),
    (4, 1, "PS2", 0),
    (4, 2, "PS3", 2),
    (4, 3, "X-Box 360", 1),
    (4, 4, "Nintendo Wii", 1),
    (5, 1, "", ),
    (6, 1, "", ),
    (7, 1, "", ),
    (8, 1, "", ),
    (9, 1, "", ),
    (10, 1, "", ),
    (11, 1, "Yay", 3),
    (11, 2, "Nay", 0),
    (12, 1, "IE", 2),
    (12, 2, "Firefox (or the old Netscape)", 2),
    (12, 3, "Opera", 0),
    (12, 4, "Safari", 0),
    (12, 5, "Other", 0),
    (13, 1, "", ),
    (14, 1, "", ),
    (15, 1, "", ),
    (16, 1, "", ),
    (17, 1, "", ),
    (18, 1, "", ),
    (19, 1, "", ),
    (20, 1, "", ),
    (21, 1, "", ),
    (22, 1, "", ),
    (23, 1, "", ),
    (24, 1, "", ),
    (25, 1, "", ),
    (26, 1, "", ),
    (27, 1, "", ),
    (28, 1, "", ),
    (29, 1, "", ),
    (30, 1, "", ),
    (31, 1, "", ),
    (32, 1, "", ),
    (33, 1, "", ),
    (34, 1, "", ),
    (35, 1, "", ),
    (36, 1, "", ),
    (37, 1, "", ),
    (38, 1, "", ),
    (39, 1, "", ),
    (40, 1, "", ),
    (41, 1, "", ),
    (42, 1, "", ),
    (43, 1, "", ),
    (44, 1, "", ),
    (45, 1, "", ),
    (46, 1, "", ),
    (47, 1, "", ),
    (48, 1, "", ),
    (49, 1, "Texas Stadium (Dallas)", 2),
    (49, 2, "Rogers Centre (Toronto)", 1),
    (49, 3, "Allianz Arena (Munich)", 0),
    (49, 4, "Emirates Stadium (London)", 3),
    (49, 5, "Old Trafford (Manchester)", 4),
    (49, 6, "Other (Please specify)", 0),
    (50, 1, "1", 0),
    (50, 2, "2", 1),
    (50, 3, "3", 0),
    (50, 4, "4", 4),
    (50, 5, "5", 1),
    (50, 6, "6", 2),
    (50, 7, "7", 2),
    (50, 8, "8", 0),
    (50, 9, "9", 0),
    (50, 10, "10", 1),
    (50, 11, "11", 1),
    (50, 12, "12", 0),
    (50, 13, "13", 0),
    (50, 14, "14", 0),
    (50, 15, "15", 0),
    (50, 16, "16", 0),
    (50, 17, "17", 0),
    (50, 18, "18", 0),
    (50, 19, "19", 0),
    (51, 1, "Downloads Mod", 2),
    (51, 2, "Downloads Forum", 1),
    (52, 1, "Internet Explorer", 3),
    (52, 2, "Firefox", 13),
    (52, 3, "Safari (Macintosh)", 0),
    (52, 4, "Safari (Windows)", 1),
    (53, 1, "0/5", 0),
    (53, 2, "1/5", 0),
    (53, 3, "2/5", 0),
    (53, 4, "3/5", 1),
    (53, 5, "4/5", 0),
    (53, 6, "5/5", 0),
    (54, 1, "0/5", 0),
    (54, 2, "1/5", 0),
    (54, 3, "2/5", 0),
    (54, 4, "3/5", 1),
    (54, 5, "4/5", 1),
    (54, 6, "5/5", 0),
    (55, 1, "0/5", 0),
    (55, 2, "1/5", 0),
    (55, 3, "2/5", 3),
    (55, 4, "3/5", 0),
    (55, 5, "4/5", 0),
    (55, 6, "5/5", 0),
    (56, 1, "0/5", 0),
    (56, 2, "1/5", 0),
    (56, 3, "2/5", 0),
    (56, 4, "3/5", 1),
    (56, 5, "4/5", 0),
    (56, 6, "5/5", 1),
    (57, 1, "0/5", 0),
    (57, 2, "1/5", 0),
    (57, 3, "2/5", 0),
    (57, 4, "3/5", 0),
    (57, 5, "4/5", 0),
    (57, 6, "5/5", 1),
    (58, 1, "0/5", 0),
    (58, 2, "1/5", 0),
    (58, 3, "2/5", 0),
    (58, 4, "3/5", 0),
    (58, 5, "4/5", 2),
    (58, 6, "5/5", 0),
    (59, 1, "0/5", 0),
    (59, 2, "1/5", 0),
    (59, 3, "2/5", 0),
    (59, 4, "3/5", 1),
    (59, 5, "4/5", 1),
    (59, 6, "5/5", 0),
    (60, 1, "0/5", 0),
    (60, 2, "1/5", 0),
    (60, 3, "2/5", 1),
    (60, 4, "3/5", 0),
    (60, 5, "4/5", 1),
    (60, 6, "5/5", 0),
    (61, 1, "1/5", 0),
    (61, 2, "2/5", 0),
    (61, 3, "3/5", 0),
    (61, 4, "4/5", 0),
    (61, 5, "5/5", 2),
    (62, 1, "0/5", 0),
    (62, 2, "1/5", 0),
    (62, 3, "2/5", 0),
    (62, 4, "3/5", 1),
    (62, 5, "4/5", 0),
    (62, 6, "5/5", 0),
    (63, 1, "0/5", 0),
    (63, 2, "1/5", 1),
    (63, 3, "2/5", 1),
    (63, 4, "3/5", 0),
    (63, 5, "4/5", 0),
    (63, 6, "5/5", 1),
    (64, 1, "0/5", 0),
    (64, 2, "1/5", 0),
    (64, 3, "2/5", 0),
    (64, 4, "3/5", 1),
    (64, 5, "4/5", 1),
    (64, 6, "5/5", 0),
    (65, 1, "0/5", 0),
    (65, 2, "1/5", 0),
    (65, 3, "2/5", 0),
    (65, 4, "3/5", 1),
    (65, 5, "4/5", 0),
    (65, 6, "5/5", 1),
    (66, 1, "1/5", 0),
    (66, 2, "2/5", 0),
    (66, 3, "3/5", 0),
    (66, 4, "4/5", 1),
    (66, 5, "5/5", 1),
    (67, 1, "0/5", 0),
    (67, 2, "1/5", 0),
    (67, 3, "2/5", 0),
    (67, 4, "3/5", 0),
    (67, 5, "4/5", 2),
    (67, 6, "5/5", 1),
    (68, 1, "", ),
    (69, 1, "", ),
    (70, 1, "1/5", 0),
    (70, 2, "2/5", 1),
    (70, 3, "3/5", 2),
    (70, 4, "4/5", 0),
    (70, 5, "5/5", 2),
    (71, 1, "", ),
    (72, 1, "1/5", 1),
    (72, 2, "2/5", 0),
    (72, 3, "3/5", 1),
    (72, 4, "4/5", 0),
    (72, 5, "5/5", 0),
    (73, 1, "I/V", 0),
    (73, 2, "II/V", 1),
    (73, 3, "III/V", 0),
    (73, 4, "IV/V", 0),
    (73, 5, "V/V", 0),
    (74, 1, "1/5", 0),
    (74, 2, "2/5", 0),
    (74, 3, "3/5", 1),
    (74, 4, "4/5", 0),
    (74, 5, "5/5", 2),
    (75, 1, "1/5", 1),
    (75, 2, "2/5", 1),
    (75, 3, "3/5", 0),
    (75, 4, "4/5", 0),
    (75, 5, "5/5", 0),
    (76, 1, "1/5", 0),
    (76, 2, "2/5", 1),
    (76, 3, "3/5", 0),
    (76, 4, "4/5", 0),
    (76, 5, "5/5", 0),
    (77, 1, "1/5", 1),
    (77, 2, "2/5", 0),
    (77, 3, "3/5", 0),
    (77, 4, "4/5", 1),
    (77, 5, "5/5", 1),
    (78, 1, "", ),
    (79, 1, "5/5", 3),
    (79, 2, "4/5", 4),
    (79, 3, "3/5", 4),
    (79, 4, "2/5", 1),
    (79, 5, "1/5", 0),
    (80, 1, "yes", 2),
    (80, 2, "no", 2),
    (81, 1, "Homer", 0),
    (81, 2, "grampa", 0),
    (81, 3, "selma", 0),
    (81, 4, "patty", 0),
    (81, 5, "maggie", 1),
    (81, 6, "bart", 1),
    (81, 7, "lisa", 0),
    (81, 8, "marge", 0),
    (82, 1, "5/5", 6),
    (82, 2, "4/5", 2),
    (82, 3, "3/5", 0),
    (82, 4, "2/5", 0),
    (82, 5, "1/5", 0),
    (82, 6, "0/5", 0),
    (83, 1, "5/5", 2),
    (83, 2, "4/5", 4),
    (83, 3, "3/5", 3),
    (83, 4, "2/5", 0),
    (83, 5, "1/5", 0),
    (83, 6, "0/5", 0),
    (84, 1, "I'll fly to where ever its shown first and camp out for 3 days to be first in line!", 4),
    (84, 2, "I'll be first in line at my local cinema", 4),
    (84, 3, "I'll See it on the first day. Not gonna drop everything to see it though.", 7),
    (84, 4, "I'll see it with in a week.", 6),
    (84, 5, "I'll see it when I see it.", 9),
    (84, 6, "I'm gonna wait until it comes out on DVD", 1),
    (84, 7, "I'll illegally torrent it so I get it for free.", 1),
    (84, 8, "I'll watch it if it comes on TV", 0),
    (84, 9, "I wont see it.", 1),
    (85, 1, "5/5", 1),
    (85, 2, "4/5", 1),
    (85, 3, "3/5", 1),
    (85, 4, "2/5", 0),
    (85, 5, "1/5", 1),
    (85, 6, "0/5", 0),
    (86, 1, "G", 0),
    (86, 2, "PG", 8),
    (86, 3, "M", 3),
    (86, 4, "MA", 1),
    (86, 5, "R", 2),
    (87, 1, "5/5", 2),
    (87, 2, "4/5", 0),
    (87, 3, "3/5", 2),
    (87, 4, "2/5", 0),
    (87, 5, "1/5", 0),
    (87, 6, "0/5", 0),
    (88, 1, "5/5", 2),
    (88, 2, "4/5", 3),
    (88, 3, "3/5", 1),
    (88, 4, "2/5", 1),
    (88, 5, "1/5", 0),
    (88, 6, "0/5", 0),
    (89, 1, "New Wave Of British Heavy Metal (EG: Iron Maiden)", 2),
    (89, 2, "Death Metal (EG: Death, Napalm Death)", 1),
    (89, 3, "Glam Metal (EG: Motley Crue, Bon Jovi)", 3),
    (89, 4, "Thrash Metal (EG: Metallica, Slayer)", 4),
    (89, 5, "Metalcore (EG: Bleeding Through)", 2),
    (89, 6, "Nu Metal (EG: Korn)", 0),
    (89, 7, "Power Metal (EG: DragonForce)", 1),
    (89, 8, "Progressive Metal (EG: Dream Theater)", 1),
    (89, 9, "Hardcore (EG: Parkway Drive, Atreyu)", 2),
    (89, 10, "Hard Rock (EG: Alter Bridge, Audioslave", 2),
    (89, 11, "Other", 2),
    (90, 1, "PC", 15),
    (90, 2, "Mac", 4),
    (91, 1, "Nintendo Wii", 5),
    (91, 2, "Xbox 360", 1),
    (91, 3, "PS3", 3),
    (92, 1, "3G01 - The Springfield Files (January 12, 1997)", 4),
    (92, 2, "3G02 - Lisa's Sax (October 19, 1997)", 6),
    (92, 3, "3G03 - Simpsoncalifragilisticexplialadohcious (February 7, 1997)", 1),
    (92, 4, "3G04 - Simpson Tide (March 29, 1998)", 2),
    (93, 1, "Homer Simpson", 3),
    (93, 2, "Moe Szyslak", 0),
    (93, 3, "Mr. Burns", 2),
    (93, 4, "Ned Flanders", 1),
    (93, 5, "Abraham Simpson", 0),
    (93, 6, "Comic Book Guy", 1),
    (93, 7, "Krusty The Clown", 0),
    (93, 8, "Lionel Hutz", 1),
    (93, 9, "Ralph Wiggum", 5),
    (94, 1, "A", 2),
    (94, 2, "B", 0),
    (94, 3, "C", 1),
    (94, 4, "D", 0),
    (94, 5, "F (Why do they skip E's in grading rubrics?)", 0),
    (95, 1, "Fruits ", 14),
    (95, 2, "Vegetables", 2),
    (96, 1, "5/5", 3),
    (96, 2, "4/5", 0),
    (96, 3, "3/5", 1),
    (96, 4, "2/5", 0),
    (96, 5, "1/5", 0),
    (96, 6, "0/5", 0),
    (97, 1, "A", 4),
    (97, 2, "B", 2),
    (97, 3, "C", 0),
    (97, 4, "D", 0),
    (97, 5, "E (or F)", 0),
    (98, 1, "5/5", 2),
    (98, 2, "4/5", 0),
    (98, 3, "3/5", 1),
    (98, 4, "2/5", 0),
    (98, 5, "1/5 ", 0),
    (99, 1, "In parts - Rapidshare...", 2),
    (99, 2, "All at once - Megashare...", 14),
    (100, 1, "The Simpsons Movie", 11),
    (100, 2, "Spider-Man 3", 3),
    (101, 1, "5/5", 4),
    (101, 2, "4/5", 0),
    (101, 3, "3/5", 0),
    (101, 4, "2/5", 0),
    (101, 5, "1/5", 0),
    (102, 1, "5/5", 4),
    (102, 2, "4/5", 3),
    (102, 3, "3/5", 0),
    (102, 4, "2/5", 0),
    (102, 5, "1/5", 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 '),
    (2, 1, "", ),
    (3, 1, "", ),
    (4, 1, "PS2", 0),
    ' at line 3


What's wrong here?

JayBachatero

-AW- send me an IM.  I need to look into how IPB 2.3.x handles polls now.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

rodo37

Hello,

I've the following error

Converting posts (this may take some time)... Successful.
Converting polls... Successful.
Converting poll options... Successful.
Converting poll logs... Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting topic notifications... Successful.
Converting board notifications... Successful.
Converting moderators... Successful.
Converting yearly events... Successful.
Converting permissions...Duplicate entry '12' for key 1

JayBachatero

Weird.  Did you try running it again?
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

rodo37

Yes. I've also tried to reinstall SMF but same error.

JayBachatero

Edit the .sql file.

Code (find) Select

INSERT INTO {$to_prefix}membergroups

Code (replace) Select

INSERT IGNORE INTO {$to_prefix}membergroups
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Ali Imran

#112
Hello Jay,

I need to convert ipb 2.2.2 to SMF immediately because IPB is easting server CPU even being on dedicated server it is slowing down every other site hosted here.

My question:

Most important of all is my attachments in forum. Is there any document that demonstartes what should I do before and afte running convert.php ? I mean the database is translated to SMF but what about attachments folder, where and how do I move it to make if visible to SMF?

Secondly the basic thing, where do I place convert.php and .sql file to run, in ipb forum folder ?
At the end, do I need SMF already installed before running convert.php? if yes, then which verion of SMF I should install before or after conversion?

At end, I have very large forum with more than 100,000 usres and big number of posts and topics, would it be safe to run convert.php to do al conversion at the same time, isn't there any chance of database corruption with this much extensive use?


Waiting for kind quick response.


regards

JayBachatero

1. The converter transfer attachments as well.

2. Converting to SMF

3. The converter should handle 100k posts w/o a problem.  If you do run into a problem let me know and I'll point you to the CLI converter.  Covert via the command line.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Ali Imran

Your respone is highly apprecited.
Besides if ther anoher option that is more secure to use, le menow about it sir.

regards

JayBachatero

They are both secure.  I've converter plenty of forums bigger than yours w/o a problem.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Ali Imran

Thanks

Besides, it may not fit the topic, but, do you provide sode paid services for conversion sir ?

regards

JayBachatero

You can just become a Charter Member if you want me to do the conversion for you.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

daveb47

Tryingto convert ipb 2.2.2  to smf1 .1.4 bot getting following error

Converting members... Unsuccessful!
This query:

    SELECT
    id AS ID_MEMBER, SUBSTRING(name, 1, 80) AS memberName,
    joined AS dateRegistered, posts,
    IF(mgroup = 4, 1, IF(mgroup > 5, mgroup + 3, 0)) AS ID_GROUP,
    last_visit AS lastLogin, SUBSTRING(name, 1, 255) AS realName,
    msg_total AS instantMessages, SUBSTRING(password, 1, 64) AS passwd,
    SUBSTRING(email, 1, 255) AS emailAddress,
    SUBSTRING(website, 1, 255) AS websiteTitle,
    SUBSTRING(website, 1, 255) AS websiteUrl,
    SUBSTRING(location, 1, 255) AS location,
    SUBSTRING(icq_number, 1, 255) AS ICQ, signature,
    IF (bday_year = 0 AND bday_month != 0 AND bday_day != 0, CONCAT('0004-', bday_month, '-', bday_day), CONCAT_WS('-', IF(bday_year <= 4, 1, bday_year), IF(bday_month = 0, 1, bday_month), IF(bday_day = 0, 1, bday_day))) AS birthdate,
    SUBSTRING(aim_name, 1, 16) AS AIM, SUBSTRING(yahoo, 1, 32) AS YIM,
    SUBSTRING(msnname, 1, 255) AS MSN, hide_email AS hideEmail,
    SUBSTRING(IF(avatar = 'noavatar' OR INSTR(avatar, 'upload') > 0, '', avatar), 1, 255) AS avatar,
    email_pm AS pm_email_notify, '' AS lngfile, '' AS buddy_list,
    '' AS pm_ignore_list, '' AS messageLabels, '' AS personalText,
    '' AS timeFormat, '' AS usertitle, '' AS memberIP, '' AS secretQuestion,
    '' AS secretAnswer, '' AS validation_code, '' AS additionalGroups,
    '' AS smileySet, '' AS passwordSalt, '' AS memberIP
    FROM `arnoldvo_org`.ibf_members
    WHERE id != 0
    LIMIT 0, 500;

Caused the error:

    Unknown column 'password' in 'field list'
https://daveb47.co.uk

A Slinky is like Jeremy CorbynWinehouse,Weird looking,Not really of any use to anybody.
But its really funny when it falls down the stairs!!:D:D

Ali Imran

Hello again.

At some post within this topic, you suggest a member to drop index of posts table.
I have same error with users table 'Duplicate key...'

My question is:

1. Is it safe to drop index of topics table of the ipb 2.2.2?
2. HOW to drop index using mysql query?


regards

Advertisement: