Bug 24640: Allow quotes.timestamp to be NULL
authorJonathan Druart <jonathan.druart@bugs.koha-community.org>
Wed, 12 Feb 2020 11:26:25 +0000 (12:26 +0100)
committerLucas Gass <lucas@bywatersolutions.com>
Tue, 10 Mar 2020 22:36:57 +0000 (22:36 +0000)
commit12ac783d98c470513e039269b0f986b1b0988d08
tree9fb665edb7576022c454d739f92845655bfedf26
parent49080b42a1b1c584ec974f4abb310044b4f3906e
Bug 24640: Allow quotes.timestamp to be NULL

It is broken with strict mode enable, timestamp is created without
default value.

Note that the .sql installer file init the value with NOW(), which is
wrong.

DBD::mysql::st execute failed: Field 'timestamp' doesn't have a default
value [for Statement "INSERT INTO quotes (source, text) VALUES (?, ?);"
with ParamValues: 0="poeut", 1="pouet"] at
/kohadevbox/koha/tools/quotes/quotes_ajax.pl line 49.

Test plan:
Create a new quote of the day
=> Without this patch you will get an error

Signed-off-by: David Nind <david@davidnind.com>
Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de>
Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
Signed-off-by: Joy Nelson <joy@bywatersolutions.com>
(cherry picked from commit 9bf4f492d82196f10bb017dd761ff6fa022a9bb9)

Signed-off-by: Lucas Gass <lucas@bywatersolutions.com>
installer/data/mysql/atomicupdate/bug_24640.perl [new file with mode: 0644]
installer/data/mysql/kohastructure.sql