QuoteConverting...
Converting members...Wrong value type sent to the database. Date expected. (birthdate)
what it mean?
Can you please tell, what version of IPB are you converting from, and what version of SMF are you converting to?
ipb2.0 to smf2rc3
any?...
Which converter package did you use?
Can you please consider to try using the package from IPB 2.3, to SMF 2.0 RC3 ? On this site's Downloads > Converters, you can find more versions as you can see. Please try using the one from IPB 2.3 if you didn't already, and let us know how it goes.
but i have ibp2.0?!....
For minor versions (only for minor versions, like from 2.0 to 2.3) it is possible that the newer converter works better.
In any case, it *doesn't* do anything wrong, so if you wish, please try it.
As always, however, please do make sure you make a backup of your ipb database before making any changes.
When I was converting from IPB 1.3 to SMF 2.0 rc3, I encountered the same error. It seems that the converter I used have problem with null and 0 birthdays. If the birthday fields haven't changed in 2.0, you may try this code:
IF ( (bday_year = 0 OR bday_year IS NULL) AND bday_month != 0 AND bday_day != 0,
CONCAT('0004-', bday_month, '-', bday_day),
CONCAT_WS('-',
IF(bday_year <= 4 OR bday_year IS NULL, '0001', bday_year),
IF(bday_month = 0 OR bday_month IS NULL, '01', bday_month),
IF(bday_day = 0 OR bday_day IS NULL, '01', bday_day)
)
) AS birthdate,