MyBB 1.1.8 to SMF 1.1 RC3

[devnet]

SMF Version: SMF 1.1 RC3
Getting the following error right off the bat during conversion:

Code Select Expand

Converting...
Converting members... Unsuccessful!
This query:

    SELECT
    uid AS ID_MEMBER, SUBSTRING(username, 1, 255) AS memberName,
    SUBSTRING(username, 1, 255) AS realName,
    SUBSTRING(password, 1, 64) AS passwd, email AS emailAddress,
    postnum AS posts, SUBSTRING(usertitle, 1, 255) AS usertitle,
    lastvisit AS lastLogin, IF(usergroup = 4, 1, 0) AS ID_GROUP,
    regdate AS dateRegistered, SUBSTRING(website, 1, 255) AS websiteUrl,
    SUBSTRING(website, 1, 255) AS websiteTitle,
    SUBSTRING(icq, 1, 255) AS ICQ, SUBSTRING(aim, 1, 16) AS AIM,
    SUBSTRING(yahoo, 1, 32) AS YIM, SUBSTRING(msn AS MSN, 1, 255) AS MSN,
    SUBSTRING(signature, 1, 65534) AS signature, hideemail AS hideEmail,
    SUBSTRING(buddylist, 1, 255) AS buddy_list,
    SUBSTRING(regip, 1, 255) AS memberIP, SUBSTRING(regip, 1, 255) AS memberIP2,
    SUBSTRING(ignorelist, 1, 255) AS pm_ignore_list,
    timeonline AS totalTimeLoggedIn,
    IF(birthday = '', '0001-01-01', CONCAT_WS('-', RIGHT(birthday, 4), SUBSTRING(birthday, LOCATE('-', birthday) + 1, LOCATE('-', birthday, LOCATE('-', birthday) + 1) - LOCATE('-', birthday) - 1), LEFT(birthday, LOCATE('-', birthday) - 1))) AS birthdate
    FROM `pclos_mybb`.mybb_users
    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 'AS MSN, 1, 255) AS MSN,
    SUBSTRING(signature, 1, 65534) AS signature, hideemail ' at line 10
It's important to note that MyBB SQL table structure has been the same through ALL 1.1.X versions.  Also important to note that this is a step backwards from the RC2 conversion I tested previously in this thread which went a bit more smoothly:

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

What I think I might have to do is use RC2 and convert, then upgrade to RC3...that is unless someone can point me in the right direction based on the error I posted above.

Forgot to include MySQL and PHP version:

Code Select Expand


PHP version  PHP/4.4.4 (more info)
MySQL version 4.1.21-standard-log


[devnet]

So..the process for RC3 will not work.  Each time I try it I get the previous error.  In order to get myself migrated, I had to use the RC2 conversion scripts and install RC2, then upgrade to RC3 afterwards (see link in previous post).

Now one problem that I'd like to solve is that notifications could not convert over to the SMF install.  Therefore, I'd like to construct a MySQL query to change notifications to 'ON' for everyone posting inside of individual forums.

For example, if the person is registered and if the person has posted inside the forum, it would set notifications to 'on' for that thread.  However, I have no skills with MySQL at all and would appreciate help if anyone could give it to me.