DB Error No. 1292

5 posts / 0 new
Letzter Beitrag
maara
Offline
Last seen: vor 5 Jahre 2 Monate
Joined: 20/07/2016 - 22:25
DB Error No. 1292

Hello,

While creating a ticket, I am getting:
Incorrect datetime value: '0000-00-00 00:00:00' for column 'updated' at row 1

I am using Mysql 5.7 and "SET SQL_MODE='ALLOW_INVALID_DATES';" haven't fixed the error for me.

Any way to get around this?

Thanks!

neisep
Offline
Last seen: vor 5 Jahre 2 Monate
Joined: 27/08/2015 - 20:11

is it possible to set a now() on the column as default ?

maara
Offline
Last seen: vor 5 Jahre 2 Monate
Joined: 20/07/2016 - 22:25

Hi,

Yes, I had to change the format of the two columns and it got ok.

thx

Florin
Offline
Last seen: vor 4 Jahre 4 Monate
Joined: 11/05/2017 - 15:06

Hi maara can u pls give more details on how to sort this out ? I'm a beginner on MySQL and I just install KATAK today and I cannot create a ticket
what tables and what rows u have modify? thank you

Tomark
Offline
Last seen: vor 3 Wochen 2 Tage
Joined: 14/01/2013 - 16:00

As mentioned in the announcements of this forum, there are some known issues using Katak with MySQL version 5.7. The fix will be included in the next release. Meanwhile,if you plan to use Katak-support with MySQL 5.7 you can download the development version directly from Github: https://github.com/Katak-support/Katak-support/archive/master.zip, where the problems are already solved.

A temporary solution is to edit the database: In the table xxx_ticket you have to set the default value of all the 'datetime' fileds to 'NULL'.