Announcement

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

matthys
Member
2014-04-02
81

date/datetime format due php upgrades

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

 

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

Zentalquabula
Member
2014-05-10
188

Re: date/datetime format due php upgrades

Enter this in MySQL:

SET sql_mode = '';

Or install MariaDB instead.

Offline

 

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

erAck
Only trying to help
2015-09-06
1029

Offline

 

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

matthys
Member
2014-04-02
81

Re: date/datetime format due php upgrades

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

 

Board footer

Powered by FluxBB

github twitter newsletter Donate Piwigo.org © 2002-2021 · Contact