Cannot convert value '1111-11-11 11:11:11' from column X to TIMESTAMP.

I got this error a few months ago:

Cannot convert value '1111-11-11 11:11:11' from column X to TIMESTAMP. 

Only, all those 1's were replaced with an actual timestamp from my application, and the X was actually a real integer corresponding to a column in my database.

This answer helped me, but I seem to remember it only worked on my development machine, not my server, something like that:

https://community.jboss.org/thread/192804?start=0&tstart=0&_sscc=t

I think my database was on a Windows server, and I had to do a mysqldump, change the datatypes, then import to the mysql on my RedHat server. 

No comments:

Post a Comment

Translate