Topic: Prob converting members

[tizdaz]

hi guys im trying to convert mybb 1.4 to smf, heres my 2nd prob (1st 1 i mamaged to do with a bit of searching! but cant find nowt on this error)

Code: [Select]

Converting members...
Notice: Undefined variable: row in url/convert.php(1091) : eval()'d code on line 1
Unsuccessful!
This query:

    uid AS id_member, SUBSTRING(username, 1, 255) AS member_name,
    SUBSTRING(username, 1, 255) AS real_name, email AS email_address,
    SUBSTRING(password, 1, 64) AS passwd, SUBSTRING(salt, 1, 8) AS password_salt,
    postnum AS posts, SUBSTRING(usertitle, 1, 255) AS usertitle,
    lastvisit AS last_login, IF(usergroup = 4, 1, 0) AS id_group,
    regdate AS date_registered, SUBSTRING(website, 1, 255) AS website_url,
    SUBSTRING(website, 1, 255) AS website_title,
    SUBSTRING(icq, 1, 255) AS icq, SUBSTRING(aim, 1, 16) AS aim,
    SUBSTRING(yahoo, 1, 32) AS yim, SUBSTRING(msn, 1, 255) AS msn,
    SUBSTRING(signature, 1, 65534) AS signature, hideemail AS hide_email,
    SUBSTRING(buddylist, 1, 255) AS buddy_list,
    SUBSTRING(regip, 1, 255) AS member_ip, SUBSTRING(regip, 1, 255) AS member_ip2,
    SUBSTRING(ignorelist, 1, 255) AS pm_ignore_list,
    timeonline AS total_time_logged_in,
    CASE
    WHEN birthday = '' THEN '0001-01-01'
    ELSE CONCAT_WS('-', RIGHT(birthday, 4), SUBSTRING(birthday, LOCATE('-', birthday) + 1, LOCATE('-', birthday, LOCATE('-', birthday) + 1) - LOCATE('-', birthday) - 1), LEFT(birthday, LOCATE('-', birthday) - 1))
    END AS birthdate
    FROM `carpinma_nwforum`.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 'uid AS id_member, SUBSTRING(username, 1, 255) AS member_name,
    SUBSTRING(usernam' at line 1

[Oldiesmann]

It looks like you're missing a SELECT statement in there. Have you modified the convert.php or SQL file at all?

[micah sin]

I ran into this error quite a bit when i tried converting mybb straight to SMF.

In fact, it was near impossible for me to do it and I couldn't really find the answer here.

If you don't get the answer you are looking for to fix it
I suggest converting to phpbb3 first then SMF.

It sounds like a lot but it only took me 45 mins to actually get set up and converted to SMF
and all the problems I had such as the one you had above, I no longer had.

[Aleksi "Lex" Kilpinen]

Hi tizdaz, do you still need help with this?