l.com
Subject: RE: Cannot convert value '0000-00-00 00:00:00' from column 4 to
TIMESTAMP
This is because with version 4.1 and higher the format of timestamp changes
to -00-00 00:00:00. We had this problem, so we had to add a few lines in
the scripts that take this field and work with it
-
This is because with version 4.1 and higher the format of timestamp
changes to -00-00 00:00:00. We had this problem, so we had to add a
few lines in the scripts that take this field and work with it
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
I'm simply executing a SELECT query that used to work before, same
database, everything the same except a higher version of the MySQL
server.
In that case you are probably facing some uncompatible issue between the
versions you used.
Maybe someone else is able to help you more that I :(
Sorr
t: Re: Cannot convert value '0000-00-00 00:00:00' from column 4 to
TIMESTAMP
> The second major problem I am running into after the upgrade is the
> following error, which did not occur on Development.
>
> Error Executing Database Query. Cannot convert value '-00-00
The second major problem I am running into after the upgrade is the
following error, which did not occur on Development.
Error Executing Database Query. Cannot convert value '-00-00
00:00:00'
from column 4 to TIMESTAMP.
The error occurred on line 8.
MySQL version is: 5.0.27
Thanks in advance