Announcement

#1 2017-09-24 22:58:48

djnoah
Member
2016-12-30
15

synchronisation leads to albums not getting processed

Hello/Hi/Greetings,

Piwigo 2.9.1
Operating system: Linux
PHP: 7.0.22-0ubuntu0.16.04.1 (Show info) [2017-09-24 13:44:30]
MySQL: 5.7.19-0ubuntu0.16.04.1 [2017-09-24 13:44:30]
Graphics Library: GD 2.1.1
Piwigo URL: <private>

Synchronisation leads to the following error.  Any suggestions to correcting this warning?

Warning:  [mysql error 1292] Incorrect datetime value: '0000-00-00 00:00:00' for column 'date_creation' at row 15919

INSERT  INTO piwigo_images_1506286563611987
  (id,filesize,width,height,date_creation,latitude,longitude,date_metadata_update)
  VALUES('1','2803','2816','2112','2007-08-25 14:35:58',NULL,NULL,'2017-09-24 13:45:24')
  , ('2','2624','2816','2112','2007-08-25 14:36:03',NULL,NULL,'2017-09-24 13:45:24')
  , ('3','2523','2112','2816','2007-08-25 14:36:22',NULL,NULL,'2017-09-24 13:45:24')
  , ('4','2498','2112','2816','2007-08-25 14:36:23',NULL,NULL,'2017-09-24 13:45:24')
  , ('5','2409','2112','2816','2007-08-25 14:36:28',NULL,NULL,'2017-09-24 13:45:24')
  , ('6','2770','2816','2112','2007-08-25 14:36:35',NULL,NULL,'2017-09-24 13:45:24')
  , ('7','3081','2112','2816','2007-08-25 15:20:09',NULL,NULL,'2017-09-24 13:45:24')
  , ('8','3185','2112','2816','2007-08-25 15:20:21',NULL,NULL,'2017-09-24 13:45:24')
  , ('9','2639','2112','2816','2007-08-25 15:23:00',NULL,NULL,'2017-09-24 13:45:24')
  , ('10','2853','28 in /var/www/piwigo/include/dblayer/functions_mysqli.inc.php on line 845

Offline

 

Board footer

Powered by FluxBB

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