News:

Bored?  Looking to kill some time?  Want to chat with other SMF users?  Join us in IRC chat or Discord

Main Menu

Prob converting members

Started by tizdaz, February 17, 2012, 06:20:39 AM

Previous topic - Next topic

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)

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?
Michael Eshom
Christian Metal Fans

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?
Slava
Ukraini!
"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum. Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas

How you can help SMF

Advertisement: