Trying to convert from MyBB 1.6 to SMF 2.0 rc4. But when i go to start the conversion i get the following error message:
Converting members...Wrong value type sent to the database. Date expected. (birthdate)
Anyone know how i can get round this?
Thanks
Jon
Found out the problem, in the mybb16x_to_smf.sql file replace:
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
With:
timeonline AS total_time_logged_in
This worked for me!
Sorry for the delay on this, and thank you for coming back on it!
It seems the converter still has a problem with invalid birthdates. I will take a look to see what we can do.