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 .. ;-(
Offline
Enter this in MySQL:
SET sql_mode = '';
Or install MariaDB instead.
Offline
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
Offline
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)
Offline