News:

Wondering if this will always be free?  See why free is better.

Main Menu

[SMF Converter] IPB 2.2.x

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

Previous topic - Next topic

Flameykins

Quote from: placebo333 on August 31, 2007, 07:58:32 AM
Hello,
I just did a test conversion from IPB 2.3 to SMF. The converter finnished fine and nearly everything is working fine besides the above mentioned problems with attachments/signatures and that my pm box is empty but showing 1 new post.

1.Fixing PMs not beeing displayed
update `smf_pm_recipients` set labels = -1
Hi, I was wondering what file I can find this in.   I've converted everything but have the same problem with PMs.  They're in the database but don't show up so I'd like to get rid of the labels that are showing new posts.
Kind regards

JayBachatero

Need to run that query in phpMyAdmin.
Follow me on Twitter

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

Flameykins

Thank you!

I ran the query and now have all the PM's from IPB showing.

creativemind.mll

Converting poll options...
Notice: Array to string conversion in /home/musiclif/public_html/musiclifelong/converter/convert.php(827) : eval()'d code on line 8

Notice: Array to string conversion in /home/musiclif/public_html/musiclifelong/converter/convert.php(827) : eval()'d code on line 8

Notice: Array to string conversion in /home/musiclif/public_html/musiclifelong/converter/convert.php(827) : eval()'d code on line 8

Notice: Array to string conversion in /home/musiclif/public_html/musiclifelong/converter/convert.php(827) : eval()'d code on line 8
Unsuccessful!
This query:
INSERT INTO `musiclif_musiclifelong`.smf_poll_choices
(ID_POLL, ID_CHOICE, label, votes)
VALUES (1, SUBSTRING('Do you like Musiclifelong?', 1, 255), 'Array', 1, 255), 'Array'),
(1, SUBSTRING('How You feel Here', 1, 255), 'Array', 1, 255), 'Array');
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 ''Array'),
(1, SUBSTRING('How You feel Here', 1, 255), 'Array', 1, 255), ' at line 3



What i have 2 do now

creativemind.mll

Hello sir Before i got poll chice error so i deleted the polls and i tried now i got this errors and finaly it says successfull but there is no forum Correctly converted 2smf..

Converting...

Notice: Undefined index: convert_script in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 580

Warning: Invalid argument supplied for foreach() in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 583

Notice: Undefined index: convert_script in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 588
Successful.
Recalculating forum statistics...
Notice: Undefined variable: result in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1827

Notice: Undefined variable: result in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1828

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 935

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 945

Notice: Undefined variable: result in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1827

Notice: Undefined variable: result in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1828

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 953

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 963

Notice: Undefined variable: result in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1827

Notice: Undefined variable: result in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1828

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 976

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 989

Notice: Undefined variable: result in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1827

Notice: Undefined variable: result in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1828

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1035

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1037

Notice: Undefined variable: result in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1827

Notice: Undefined variable: result in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1828

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1043

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1049

Notice: Undefined variable: result in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1827

Notice: Undefined variable: result in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1828

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1060

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1061

Notice: Undefined variable: result in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1827

Notice: Undefined variable: result in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1828

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1069

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1071

Notice: Undefined variable: result in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1827

Notice: Undefined variable: result in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1828

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1077

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1078

Notice: Undefined variable: result in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1827

Notice: Undefined variable: result in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1828

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1084

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1085

Notice: Undefined variable: result in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1827

Notice: Undefined variable: result in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1828

Notice: Undefined variable: result in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1827

Notice: Undefined variable: result in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1828

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1109

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1111

Notice: Undefined variable: result in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1827

Notice: Undefined variable: result in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1828

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1117

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1129

Notice: Undefined variable: result in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1827

Notice: Undefined variable: result in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1828

Notice: Undefined variable: result in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1827

Notice: Undefined variable: result in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1828

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1154

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1156

Notice: Undefined variable: result in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1827

Notice: Undefined variable: result in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1828

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1192

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1193

Notice: Undefined variable: result in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1827

Notice: Undefined variable: result in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1828

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1231

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1236

Notice: Undefined variable: result in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1827

Notice: Undefined variable: result in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1828

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1297

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1299

Notice: Undefined variable: result in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1827

Notice: Undefined variable: result in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1828

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1335

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1354

Notice: Undefined variable: result in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1827

Notice: Undefined variable: result in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1828

Notice: Undefined variable: result in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1827

Notice: Undefined variable: result in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1828

Notice: Undefined variable: result in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1827

Notice: Undefined variable: result in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1828

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1377

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/musiclif/public_html/musiclifelong/converter/convert.php on line 1378
Successful.


Help me plz...

JayBachatero

Are you using the convert files in this topic?
Follow me on Twitter

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

creativemind.mll

yes....

Can i convert once again.????

JayBachatero

Yes just try running the converter again.
Follow me on Twitter

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

creativemind.mll

Which software are you using?
The converter did not find any conversion data files. Please check to see if the one you want is available for download at www.simplemachines.org. If it isn't, we may be able to write one for you - just ask us!
After you download it, simply upload it into the same folder as this convert.php file. If you're having any other problems with this converter, don't hesitate to look for help on our forum.








I am getting ..bro can u do for me.....
Plz

creativemind.mll

Sir ..once plz chk ur inbox to..and help me to solve

placebo333

#70
Hi, i just did another test conversion, this time IPB 2.33 to SMF 1.14.

I spend some time looking at signatures as they are all broken after conversion. Following queries will remove unwanted tags and fix most of your signatures, executed in phpmyadmin.

Please do so at your own risk of course  :D


UPDATE smf_members SET `signature` = replace(signature,"[size=]","");
UPDATE smf_members SET `signature` = replace(signature,"[/size]","");
UPDATE smf_members SET `signature` = replace(signature,"class=\\\"linked-image\\\" /]","[/img]");
UPDATE smf_members SET `signature` = replace(signature,"class=\"linked-sig-image\" /]","[/img]");
UPDATE smf_members SET `signature` = replace(signature,"border=\\\"0\\\" class=\\\"linked-sig-image\\\" /]","[/img]");
UPDATE smf_members SET `signature` = replace(signature,".jpg\\",".jpg");
UPDATE smf_members SET `signature` = replace(signature,".gif\\",".gif");
UPDATE smf_members SET `signature` = replace(signature,".png\\",".png");
UPDATE smf_members SET `signature` = replace(signature,"[div align=\\\"center\\\"]","");
UPDATE smf_members SET `signature` = replace(signature,"[div align=\\\"right\\\"]","");
UPDATE smf_members SET `signature` = replace(signature,"[div align=\\\"left\\\"]","");
UPDATE smf_members SET `signature` = replace(signature,"[/div]","");
UPDATE smf_members SET `signature` = replace(signature,"\\\"/]","[/img]");
UPDATE smf_members SET `signature` = replace(signature,"/]","[/img]");
UPDATE smf_members SET `signature` = replace(signature,"[/blockquote]","");
UPDATE smf_members SET `signature` = replace(signature,"[blockquote]","");
UPDATE smf_members SET `signature` = replace(signature,"\\\"","\"");
UPDATE smf_members SET `signature` = replace(signature,"\\'","'");

creativemind.mll

when i reconvert ...i got following errors ...

Converting yearly events... Unsuccessful!
This query:
SELECT
SUBSTRING(title, 1, 30) AS title,
CONCAT(year, '-', month, '-', mday) AS eventDate
FROM `musiclif_musiclifelong`.ibf_calendar_events
WHERE event_repeat = 1
AND repeat_unit = 'y'
LIMIT 0, 500;
Caused the error:
Table 'musiclif_musiclifelong.ibf_calendar_events' doesn't exis

JayBachatero

What version of IPB are you using?
Follow me on Twitter

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


JayBachatero

Can I get a database dump of 2.3.x?  Seems like there were a few database changes.
Follow me on Twitter

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


samuelpage

Hi Jay,

I'm trying to convert my IPB 2.3 using the files from the converter download section. Hoever, I hit a brick wall at the poll options section:

Converting poll options...
Notice: Array to string conversion in /home/udqxrza/public_html/forum/convert.php(827) : eval()'d code on line 8


That code repeats many times and then outputs this:

Unsuccessful!
This query:

    INSERT INTO `udqxrza_smforum`.smf_poll_choices
    (ID_POLL, ID_CHOICE, label, votes)
    VALUES (1, SUBSTRING('How old where you, or was your child, when diagnosed with dyslexia?', 1, 255), 'Array', 1, 255), 'Array'),
    (2, SUBSTRING('Have you ever faced some prejudice or discrimination at work?', 1, 255), 'Array', 1, 255), 'Array'),
    (3, SUBSTRING('What level of assesement/support is your child at?', 1, 255), 'Array', 1, 255), 'Array'),
    (4, SUBSTRING('Do you disclose dyslexia in interviews and/or socially?', 1, 255), 'Array', 1, 255), 'Array'),
    (11, SUBSTRING('Why do you debate?', 1, 255), 'Array', 1, 255), 'Array'),
    (6, SUBSTRING('Do you think, that dislexic's use more/have a bigger brain capacity ?', 1, 255), 'Array', 1, 255), 'Array'),
    (10, SUBSTRING('Which Internet Browser do you Prefer?', 1, 255), 'Array', 1, 255), 'Array'),
    (12, SUBSTRING('Has participation in this forum helped anybody ?', 1, 255), 'Array', 1, 255), 'Array'),
    (13, SUBSTRING('Which scenario do you think is correct?', 1, 255), 'Array', 1, 255), 'Array'),
    (14, SUBSTRING('Public Or Private.', 1, 255), 'Array', 1, 255), 'Array'),
    (15, SUBSTRING('Are you diyslexic, and see 3D or not?', 1, 255), 'Array', 1, 255), 'Array'),
    (29, SUBSTRING('writing leters', 1, 255), 'Array', 1, 255), 'Array'),
    (29, SUBSTRING('Writing cheques', 1, 255), 'Array', 1, 255), 'Array'),
    (29, SUBSTRING('people names', 1, 255), 'Array', 1, 255), 'Array'),
    (19, SUBSTRING('who is the worst, depending uopn how histroy reports it, many people take the same path but get a diffent place in histoty', 1, 255), 'Array', 1, 255), 'Array'),
    (20, SUBSTRING('Which do you prefer?', 1, 255), 'Array', 1, 255), 'Array'),
    (21, SUBSTRING('Which do you prefer?', 1, 255), 'Array', 1, 255), 'Array'),
    (28, SUBSTRING('Does your dyslexia live in any of the following places?', 1, 255), 'Array', 1, 255), 'Array'),
    (23, SUBSTRING('Who can be trusted to do the right thing?', 1, 255), 'Array', 1, 255), 'Array'),
    (24, SUBSTRING('yes and I think it is due to my dyslexia', 1, 255), 'Array', 1, 255), 'Array'),
    (25, SUBSTRING(' crossword and word puzzles', 1, 255), 'Array', 1, 255), 'Array'),
    (26, SUBSTRING('Do you have or do you think you could have dyslexia and dyspraxia', 1, 255), 'Array', 1, 255), 'Array'),
    (27, SUBSTRING('Which one do you have (or you think is best)', 1, 255), 'Array', 1, 255), 'Array'),
    (30, SUBSTRING('what doe you think of the feed', 1, 255), 'Array', 1, 255), 'Array'),
    (31, SUBSTRING('My Dyslexia is a symptom of', 1, 255), 'Array', 1, 255), 'Array'),
    (31, SUBSTRING('As well as Reading, Writing, and spelling issues I have', 1, 255), 'Array', 1, 255), 'Array'),
    (31, SUBSTRING('Because of your Dyslexia have you developed', 1, 255), 'Array', 1, 255), 'Array'),
    (32, SUBSTRING('Which profession ARE you in?', 1, 255), 'Array', 1, 255), 'Array'),
    (32, SUBSTRING('Which profession DO YOU WISH you were in?', 1, 255), 'Array', 1, 255), 'Array'),
    (33, SUBSTRING('I read a theory all dyslexics have Dad's that fall into one of three corgeies. Which one's sounds most like your Dad?', 1, 255), 'Array', 1, 255), 'Array'),
    (34, SUBSTRING('Which UK party do you support at the moment?', 1, 255), 'Array', 1, 255), 'Array'),
    (35, SUBSTRING('send him to court or let him go free', 1, 255), 'Array', 1, 255), 'Array'),
    (36, SUBSTRING('How do you feel?', 1, 255), 'Array', 1, 255), 'Array'),
    (37, SUBSTRING('At what age did you discover your dyslexia or your childs dyslexia?', 1, 255), 'Array', 1, 255), 'Array'),
    (38, SUBSTRING('Does anyone have ADD', 1, 255), 'Array', 1, 255), 'Array'),
    (39, SUBSTRING('What would you do?', 1, 255), 'Array', 1, 255), 'Array'),
    (40, SUBSTRING('Cards', 1, 255), 'Array', 1, 255), 'Array'),
    (41, SUBSTRING('Please choose one of the following or leave a post, thank you', 1, 255), 'Array', 1, 255), 'Array'),
    (42, SUBSTRING('whta colouere lenses do yuo hvae ', 1, 255), 'Array', 1, 255), 'Array'),
    (42, SUBSTRING('do yuo waer thme?', 1, 255), 'Array', 1, 255), 'Array'),
    (43, SUBSTRING('Who'll win this year?', 1, 255), 'Array', 1, 255), 'Array'),
    (43, SUBSTRING('Will England manage a grand slam?', 1, 255), 'Array', 1, 255), 'Array'),
    (43, SUBSTRING('And the most important question .... what beer while watching rugby?', 1, 255), 'Array', 1, 255), 'Array'),
    (44, SUBSTRING('For our Dyslexic Members', 1, 255), 'Array', 1, 255), 'Array'),
    (44, SUBSTRING('For our Non-Dyslexic Members', 1, 255), 'Array', 1, 255), 'Array'),
    (45, SUBSTRING('Do your pets make you feel less stressed?', 1, 255), 'Array', 1, 255), 'Array'),
    (46, SUBSTRING('Have you emailed the BDA yet', 1, 255), 'Array', 1, 255), 'Array'),
    (47, SUBSTRING('How good is your uni / college / school for dyslexics during exam time?', 1, 255), 'Array', 1, 255), 'Array'),
    (48, SUBSTRING('George Bush has spoken of the high point of his presidency what was it ', 1, 255), 'Array', 1, 255), 'Array'),
    (49, SUBSTRING('my education level', 1, 255), 'Array', 1, 255), 'Array'),
    (49, SUBSTRING('My Dyslexia level', 1, 255), 'Array', 1, 255), 'Array'),
    (50, SUBSTRING('did/ do you get humiliated by your teacher?', 1, 255), 'Array', 1, 255), 'Array'),
    (50, SUBSTRING('If you could not use the dictionary how was help offered', 1, 255), 'Array', 1, 255), 'Array'),
    (51, SUBSTRING('From first visiting the Being Dyslexic forum how long did it take you before you made your first post?', 1, 255), 'Array', 1, 255), 'Array'),
    (52, SUBSTRING('How does smoking affect the environment?', 1, 255), 'Array', 1, 255), 'Array'),
    (52, SUBSTRING('Why is second hand smoking bad?', 1, 255), 'Array', 1, 255), 'Array'),
    (52, SUBSTRING('What are your feelings toward smoking?', 1, 255), 'Array', 1, 255), 'Array'),
    (53, SUBSTRING('would you tell a prosective firm you are dysleicx?', 1, 255), 'Array', 1, 255), 'Array'),
    (54, SUBSTRING('Would you be interested in Blogging in a Dyslexia friendly environment?', 1, 255), 'Array', 1, 255), 'Array'),
    (55, SUBSTRING('How fast do you work?', 1, 255), '1', 1, 255), 'Array', 1, 255), 'Array'),
    (55, SUBSTRING('How tidy and disorganised are you?', 1, 255), '1', 1, 255), 'Array', 1, 255), 'Array'),
    (55, SUBSTRING('Do you think it will affect your job prospects', 1, 255), '1', 1, 255), 'Array', 1, 255), 'Array'),
    (56, SUBSTRING('Do prefer to learn threw:', 1, 255), 'Array', 1, 255), 'Array');

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 ''Array'),
    (2, SUBSTRING('Have you ever faced some prejudice or discrimin' at line 3


Is there an easy fix for this, your help is very much appreciated.

SleePy

IPB 2.3 may not work with the 2.2.x converter.

Jay is working on updating converters, but he is a very busy person :(
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

creativemind.mll

Quote from: samuelpage on November 18, 2007, 02:55:21 PM
Hi Jay,

I'm trying to convert my IPB 2.3 using the files from the converter download section. Hoever, I hit a brick wall at the poll options section:

Converting poll options...
Notice: Array to string conversion in /home/udqxrza/public_html/forum/convert.php(827) : eval()'d code on line 8


That code repeats many times and then outputs this:

Unsuccessful!
This query:

    INSERT INTO `udqxrza_smforum`.smf_poll_choices
    (ID_POLL, ID_CHOICE, label, votes)
    VALUES (1, SUBSTRING('How old where you, or was your child, when diagnosed with dyslexia?', 1, 255), 'Array', 1, 255), 'Array'),
    (2, SUBSTRING('Have you ever faced some prejudice or discrimination at work?', 1, 255), 'Array', 1, 255), 'Array'),
    (3, SUBSTRING('What level of assesement/support is your child at?', 1, 255), 'Array', 1, 255), 'Array'),
    (4, SUBSTRING('Do you disclose dyslexia in interviews and/or socially?', 1, 255), 'Array', 1, 255), 'Array'),
    (11, SUBSTRING('Why do you debate?', 1, 255), 'Array', 1, 255), 'Array'),
    (6, SUBSTRING('Do you think, that dislexic's use more/have a bigger brain capacity ?', 1, 255), 'Array', 1, 255), 'Array'),
    (10, SUBSTRING('Which Internet Browser do you Prefer?', 1, 255), 'Array', 1, 255), 'Array'),
    (12, SUBSTRING('Has participation in this forum helped anybody ?', 1, 255), 'Array', 1, 255), 'Array'),
    (13, SUBSTRING('Which scenario do you think is correct?', 1, 255), 'Array', 1, 255), 'Array'),
    (14, SUBSTRING('Public Or Private.', 1, 255), 'Array', 1, 255), 'Array'),
    (15, SUBSTRING('Are you diyslexic, and see 3D or not?', 1, 255), 'Array', 1, 255), 'Array'),
    (29, SUBSTRING('writing leters', 1, 255), 'Array', 1, 255), 'Array'),
    (29, SUBSTRING('Writing cheques', 1, 255), 'Array', 1, 255), 'Array'),
    (29, SUBSTRING('people names', 1, 255), 'Array', 1, 255), 'Array'),
    (19, SUBSTRING('who is the worst, depending uopn how histroy reports it, many people take the same path but get a diffent place in histoty', 1, 255), 'Array', 1, 255), 'Array'),
    (20, SUBSTRING('Which do you prefer?', 1, 255), 'Array', 1, 255), 'Array'),
    (21, SUBSTRING('Which do you prefer?', 1, 255), 'Array', 1, 255), 'Array'),
    (28, SUBSTRING('Does your dyslexia live in any of the following places?', 1, 255), 'Array', 1, 255), 'Array'),
    (23, SUBSTRING('Who can be trusted to do the right thing?', 1, 255), 'Array', 1, 255), 'Array'),
    (24, SUBSTRING('yes and I think it is due to my dyslexia', 1, 255), 'Array', 1, 255), 'Array'),
    (25, SUBSTRING(' crossword and word puzzles', 1, 255), 'Array', 1, 255), 'Array'),
    (26, SUBSTRING('Do you have or do you think you could have dyslexia and dyspraxia', 1, 255), 'Array', 1, 255), 'Array'),
    (27, SUBSTRING('Which one do you have (or you think is best)', 1, 255), 'Array', 1, 255), 'Array'),
    (30, SUBSTRING('what doe you think of the feed', 1, 255), 'Array', 1, 255), 'Array'),
    (31, SUBSTRING('My Dyslexia is a symptom of', 1, 255), 'Array', 1, 255), 'Array'),
    (31, SUBSTRING('As well as Reading, Writing, and spelling issues I have', 1, 255), 'Array', 1, 255), 'Array'),
    (31, SUBSTRING('Because of your Dyslexia have you developed', 1, 255), 'Array', 1, 255), 'Array'),
    (32, SUBSTRING('Which profession ARE you in?', 1, 255), 'Array', 1, 255), 'Array'),
    (32, SUBSTRING('Which profession DO YOU WISH you were in?', 1, 255), 'Array', 1, 255), 'Array'),
    (33, SUBSTRING('I read a theory all dyslexics have Dad's that fall into one of three corgeies. Which one's sounds most like your Dad?', 1, 255), 'Array', 1, 255), 'Array'),
    (34, SUBSTRING('Which UK party do you support at the moment?', 1, 255), 'Array', 1, 255), 'Array'),
    (35, SUBSTRING('send him to court or let him go free', 1, 255), 'Array', 1, 255), 'Array'),
    (36, SUBSTRING('How do you feel?', 1, 255), 'Array', 1, 255), 'Array'),
    (37, SUBSTRING('At what age did you discover your dyslexia or your childs dyslexia?', 1, 255), 'Array', 1, 255), 'Array'),
    (38, SUBSTRING('Does anyone have ADD', 1, 255), 'Array', 1, 255), 'Array'),
    (39, SUBSTRING('What would you do?', 1, 255), 'Array', 1, 255), 'Array'),
    (40, SUBSTRING('Cards', 1, 255), 'Array', 1, 255), 'Array'),
    (41, SUBSTRING('Please choose one of the following or leave a post, thank you', 1, 255), 'Array', 1, 255), 'Array'),
    (42, SUBSTRING('whta colouere lenses do yuo hvae ', 1, 255), 'Array', 1, 255), 'Array'),
    (42, SUBSTRING('do yuo waer thme?', 1, 255), 'Array', 1, 255), 'Array'),
    (43, SUBSTRING('Who'll win this year?', 1, 255), 'Array', 1, 255), 'Array'),
    (43, SUBSTRING('Will England manage a grand slam?', 1, 255), 'Array', 1, 255), 'Array'),
    (43, SUBSTRING('And the most important question .... what beer while watching rugby?', 1, 255), 'Array', 1, 255), 'Array'),
    (44, SUBSTRING('For our Dyslexic Members', 1, 255), 'Array', 1, 255), 'Array'),
    (44, SUBSTRING('For our Non-Dyslexic Members', 1, 255), 'Array', 1, 255), 'Array'),
    (45, SUBSTRING('Do your pets make you feel less stressed?', 1, 255), 'Array', 1, 255), 'Array'),
    (46, SUBSTRING('Have you emailed the BDA yet', 1, 255), 'Array', 1, 255), 'Array'),
    (47, SUBSTRING('How good is your uni / college / school for dyslexics during exam time?', 1, 255), 'Array', 1, 255), 'Array'),
    (48, SUBSTRING('George Bush has spoken of the high point of his presidency what was it ', 1, 255), 'Array', 1, 255), 'Array'),
    (49, SUBSTRING('my education level', 1, 255), 'Array', 1, 255), 'Array'),
    (49, SUBSTRING('My Dyslexia level', 1, 255), 'Array', 1, 255), 'Array'),
    (50, SUBSTRING('did/ do you get humiliated by your teacher?', 1, 255), 'Array', 1, 255), 'Array'),
    (50, SUBSTRING('If you could not use the dictionary how was help offered', 1, 255), 'Array', 1, 255), 'Array'),
    (51, SUBSTRING('From first visiting the Being Dyslexic forum how long did it take you before you made your first post?', 1, 255), 'Array', 1, 255), 'Array'),
    (52, SUBSTRING('How does smoking affect the environment?', 1, 255), 'Array', 1, 255), 'Array'),
    (52, SUBSTRING('Why is second hand smoking bad?', 1, 255), 'Array', 1, 255), 'Array'),
    (52, SUBSTRING('What are your feelings toward smoking?', 1, 255), 'Array', 1, 255), 'Array'),
    (53, SUBSTRING('would you tell a prosective firm you are dysleicx?', 1, 255), 'Array', 1, 255), 'Array'),
    (54, SUBSTRING('Would you be interested in Blogging in a Dyslexia friendly environment?', 1, 255), 'Array', 1, 255), 'Array'),
    (55, SUBSTRING('How fast do you work?', 1, 255), '1', 1, 255), 'Array', 1, 255), 'Array'),
    (55, SUBSTRING('How tidy and disorganised are you?', 1, 255), '1', 1, 255), 'Array', 1, 255), 'Array'),
    (55, SUBSTRING('Do you think it will affect your job prospects', 1, 255), '1', 1, 255), 'Array', 1, 255), 'Array'),
    (56, SUBSTRING('Do prefer to learn threw:', 1, 255), 'Array', 1, 255), 'Array');

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 ''Array'),
    (2, SUBSTRING('Have you ever faced some prejudice or discrimin' at line 3


Is there an easy fix for this, your help is very much appreciated.


Delete the polls and reconvert it ...


Then u wont face any prob

JayBachatero

samuelpage use the files on this topic.
Follow me on Twitter

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

Advertisement: