Home /Forums /KataK forum /General discussion /DB Error No. 1292

DB Error No. 1292

5 posts / 0 new
Accedi o registrati per inserire commenti.
Ultimo contenuto
Mer, 20/07/2016 - 22:28
#1
maara
Offline
Last seen: 7 anni 9 mesi fa
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!

In cima
Mer, 20/07/2016 - 23:29
neisep
Offline
Last seen: 7 anni 9 mesi fa
Joined: 27/08/2015 - 20:11

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

In cima
Dom, 24/07/2016 - 21:17
maara
Offline
Last seen: 7 anni 9 mesi fa
Joined: 20/07/2016 - 22:25

Hi,

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

thx

In cima
Gio, 11/05/2017 - 15:10
(Reply to #3)
Florin
Offline
Last seen: 6 anni 11 mesi fa
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

In cima
Ven, 12/05/2017 - 10:30
Tomark
Offline
Last seen: 12 mesi 4 giorni fa
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'.

In cima