Bug 27253: (follow-up) Fix UNIXTIME(0) in db_revs/211200037.pl
authorMarcel de Rooy <m.de.rooy@rijksmuseum.nl>
Mon, 25 Apr 2022 10:29:05 +0000 (10:29 +0000)
committerKyle Hall <kyle@bywatersolutions.com>
Fri, 29 Apr 2022 17:35:04 +0000 (13:35 -0400)
commit4c263cb9cf89c16c6521da8d4f42cfa865dee99e
tree31b6f3f52dce92a2606bf488161bf326054dbffc
parentfaa35972b038b9df0459a582ced73e98adb897cc
Bug 27253: (follow-up) Fix UNIXTIME(0) in db_revs/211200037.pl

MariaDB [koha_myclone]> update borrowers set updated_on=COALESCE( NULL, FROM_UNIXTIME(0) ) where borrowernumber=51;
ERROR 1292 (22007): Incorrect datetime value: '1970-01-01 00:00:00' for column `koha_myclone`.`borrowers`.`updated_on` at row 1

MariaDB [koha_myclone]> update borrowers set updated_on=COALESCE( NULL, FROM_UNIXTIME(1) ) where borrowernumber=51;
Query OK, 1 row affected (0.008 sec)
Rows matched: 1  Changed: 1  Warnings: 0

Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
Tested by switching updated_on to datetime. Remove NOT NULL, etc.
Copied dbrev to atomicupdate folder.
Resulted in:
    Updated all NULL values of borrowers.updated_on to GREATEST(date_renewed, dateenrolled, lastseen): 51 rows updated

Signed-off-by: Fridolin Somers <fridolin.somers@biblibre.com>
Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com>
installer/data/mysql/db_revs/211105001.pl