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)
committerJoy Nelson <joy@bywatersolutions.com>
Thu, 5 Mar 2020 01:47:32 +0000 (01:47 +0000)
commit9bf4f492d82196f10bb017dd761ff6fa022a9bb9
treef3acdb3de3d36b344366c584c728bc9c61a38b05
parent91c16e9e7a8e9eccf37024b0efde14819b7093b9
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>
installer/data/mysql/atomicupdate/bug_24640.perl [new file with mode: 0644]
installer/data/mysql/kohastructure.sql