Error in MyBulletinBoard 1.0 to SMF Converter

[bandiit]

Code Select Expand

Converting members... Unsuccessful!
This query:
SELECT
uid AS ID_MEMBER, username AS memberName, username AS realName,
password AS passwd, email AS emailAddress, postnum AS posts, usertitle,
lastvisit AS lastLogin, IF(usergroup = 4, 1, 0) AS ID_GROUP,
regdate AS dateRegistered, website AS websiteUrl, website AS websiteTitle,
icq AS ICQ, aim AS AIM, yahoo AS YIM, msn AS MSN, signature,
hideemail AS hideEmail, buddylist AS buddy_list, regip AS memberIP,
ignorelist AS pm_ignore_list, timeonline AS totalTimeLoggedIn,
IF(birthday = '', '0000-00-00', CONCAT_WS('-', RIGHT(birthday, 4), SUBSTR(birthday, LOCATE('-', birthday) + 1, LOCATE('-', birthday, LOCATE('-', birthday) + 1) - LOCATE('-', birthday) - 1), LEFT(birthday, LOCATE('-', birthday) - 1))) AS birthdate
FROM `mybb_rc4`.mybb_users
LIMIT 0, 500;
Caused the error:

You have an error in your SQL syntax near '(birthday, LOCATE('-', birthday) + 1, LOCATE('-', birthday, LOCATE('-', birthday' at line 9
They use same DB and DBuser

[[Unknown]]

What version of MySQL is this?

Change SUBSTR to SUBSTRING in the .sql file.

-[Unknown]

[bandiit]

MySQL 3.23.58

So, the line

Code Select Expand


CONCAT_WS('-', RIGHT(birthday, 4)
stays as it is?

EDIT: I answer myself: it stays.
and hurray, previous post helped