We recently updated from mysql 5.0 to 5.6 (took a mysqldump and restored on a new server) we then received a timestamp error so we added the parameter zeroDateTimeBehavior=convertToNull' to our jdbc connection string, now it appears that dates get updated with 0000-00-00 instead of the correct date
Hi Matthew,
I believe that jumping from 5.0 to 5.6 is a huge step. I would recommend going to 5.5 and then 5.6 after testing each upgrade and confirming that everything is working fine. The mySQL documentation should help too.
https://dev.mysql.com/doc/refman/5.6/en/upgrading.html
Cheers,
Rodrigo
Hi Matthew,
Did you try a re-index after you add the jdbc paramenter?
Regards,
Renato Rudnicki
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.