News:

Wondering if this will always be free?  See why free is better.

Main Menu

Conversion Error...

Started by The 12th Doctor, November 24, 2010, 05:50:51 PM

Previous topic - Next topic

The 12th Doctor

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
The Doctors Companion - http://www.doctorscompanion.net

The 12th Doctor

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!
The Doctors Companion - http://www.doctorscompanion.net

Norv

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.
To-do lists are for deferral. The more things you write down the later they're done... until you have 100s of lists of things you don't do.

File a security report | Developers' Blog | Bug Tracker


Also known as Norv on D* | Norv N. on G+ | Norv on Github

Advertisement: