wrong value...

[pjn]

Converting...
Converting members...Wrong value type sent to the database. Date expected. (birthdate)

what it mean?

[Norv]

Can you please tell, what version of IPB are you converting from, and what version of SMF are you converting to?

[pjn]

ipb2.0 to smf2rc3

[pjn]

any?...

[Norv]

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.

[pjn]

but i have ibp2.0?!....

[Norv]

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.

[Sheepy]

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:

Code Select Expand

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,