Piwigo.org

matthys · 2019-12-25 13:08:51

I wonder if there can be a check in Piwigo about date/datetime format?

Seems due upgrades of php datetime format (0000-00-00 00:00:00) is no longer valid but gives lot of error messages under Maintenance (Repair and optimize database), like:
[mysql error 1292] Incorrect datetime value: '0000-00-00 00:00:00' for column 'lastmodified' at row 1
ALTER TABLE piwigo_images ORDER BY id; in ../include/dblayer/functions_mysqli.inc.php on line 856

The same for date format .. ;-(

Zentalquabula · 2019-12-25 16:51:01

Enter this in MySQL:

SET sql_mode = '';

Or install MariaDB instead.

erAck · 2019-12-25 17:59:00

See also https://dev.mysql.com/doc/refman/8.0/en … de-setting and https://dev.mysql.com/doc/refman/8.0/en … ode-strict

matthys · 2019-12-27 08:16:03

I didn't want to change the default settings of mysql, so I modified the tables myself (set to a 1970 date). There is of course a reason that mysql changed to NO_ZERO_IN_DATE, NO_ZERO_DATE

A pity as the tool is called "Repair and optimize database" but is not able to check or what to do with these kind of error's...

Last edited by matthys (2019-12-27 08:16:44)

Piwigo.org

Announcement

#1 2019-12-25 13:08:51

date/datetime format due php upgrades

#2 2019-12-25 16:51:01

Re: date/datetime format due php upgrades

#3 2019-12-25 17:59:00

Re: date/datetime format due php upgrades

#4 2019-12-27 08:16:03

Re: date/datetime format due php upgrades

Board footer