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

DB Error No. 1292

5 posts / 0 new
Zum Verfassen von Kommentaren bitte Anmelden oder Registrieren.
Letzter Beitrag
Mi, 20/07/2016 - 22:28
#1
maara
Offline
Last seen: vor 7 Jahre 8 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!

Oben
Mi, 20/07/2016 - 23:29
neisep
Offline
Last seen: vor 7 Jahre 8 Monate
Joined: 27/08/2015 - 20:11

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

Oben
So, 24/07/2016 - 21:17
maara
Offline
Last seen: vor 7 Jahre 8 Monate
Joined: 20/07/2016 - 22:25

Hi,

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

thx

Oben
Do, 11/05/2017 - 15:10
(Reply to #3)
Florin
Offline
Last seen: vor 6 Jahre 11 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

Oben
Fr, 12/05/2017 - 10:30
Tomark
Offline
Last seen: vor 12 Monate 1 Tag
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'.

Oben