MyBB 1.2.7 to SMF Conversion Error

[wvoncannon]

Hello.  I hope someone can help me as I am trying to convert a MyBB 1.2.7 forum to SMF 1.1.3.  I have searched through the "Converters and Importers" forum using the keyword "MyBB" but haven't been so lucky as to find the answer I am needing.  I do not believe this is a "user has no access" problem which I have found alot in my searches.  It seems to not have the common error message associated with that.  Below is what I am seeing when I try to convert.

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 'AS MSN, 1, 255) AS MSN,
SUBSTRING(signature, 1, 65534) AS signature, hideemail ' at line 10

Any help would be much apprieciated. 

Thanks.

[whatsit]

Hi there.

I just spent an hour or so wrestling with the converter too.

I found several problems and I can help you with the one you refer to - although there are others that I couldn't.

THere is an error in the sql file so you need to edit it. Just look under the section "converting members" remove the extra "AS MSN" that's been accidentally placed within the substring line.

The line should look like this

SUBSTRING(yahoo, 1, 32) AS YIM, SUBSTRING(msn, 1, 255) AS MSN,

later you will come across other errors most likely. Apparently if you go to the main mybb convertor thread you can download a newer version that fixes all the problems but I couldn't get the download attachment to work.

You can try it though - you'll find it here

http://www.simplemachines.org/community/index.php?topic=145191.0

I ended up removing the polls conversion sections altogether due to errors in the syntax and then also removed the section on converting topic view logs because every time I finally found and fixed the syntax problem or whatever another error popped up. There appear to be a bunch of field name errors in the conversion file.

Just so you know - I removed the entry "dateline AS logTime" from the topic view logs section and that worked before other problems - including a misplaced comma - forced me to abandon the whole log view conversion bit.

A shame to lose bits of the conversion but at least most of it is done.

Good luck.

[wvoncannon]

Thank you for the help and insight.   

Update:
I got this to work successfully thanks to the help of whatsit and the thread linked to in the post above.  I used the "convert.php" file that was on the converters download page, but deleted the "mybb_to_smf.sql" file that was in that zip file.  Instead, I used the "mybb12_to_smf.sql" file from the main mybb converter thread linked above.  I did rename the file from "mybb12_to_smf.sql" to "mybb_to_smf.sql" before uploading it.  After upload, I ran the convert.php file and, after a few minutes, everything was successful.

Thanks again for the help.