🌍
English
Hello/Hi/Greetings,
Piwigo refuses to put in date_creation for any image, any ideas ? All images have date modified set as the exif date.
I have tried the following,
Removed, reinstalled, ffmpeg, exiftool, mediainfo
Tried tools/metadata.php (all fields are outputted perfectly)
Tried syncing metadata from web, didnt work
Tried removing and adding pictures again, didnt work
Tried to metadata sync one by one on images by photo editor, didnt work
The MYSQL field date_created in piwigo_images is NULL for all images.
I have too many images to enter date_created for each.
Piwigo version: 2.9.5
PHP version: 7.2.19-0ubuntu0.18.04.1 (Show info) [2019-08-12 15:39:23]
MySQL version: 5.7.27-0ubuntu0.18.04.1 [2019-08-12 15:39:23]
Piwigo URL: http://
Offline
Also
Warning: [mysql error 1067] Invalid default value for 'date'
ALTER TABLE piwigo_comments ORDER BY id; in /album/include/dblayer/functions_mysqli.inc.php on line 845
on doing repair and optimize database.
Any logs where I can get more detail ?
I suspect something wrong when I did upgrade.
mysql> select * from piwigo_comments ;
Empty set (0.00 sec)
mysql> desc piwigo_comments ;
+-----------------+-----------------------+------+-----+---------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+-----------------------+------+-----+---------------------+----------------+
| id | int(11) unsigned | NO | PRI | NULL | auto_increment |
| image_id | mediumint(8) unsigned | NO | MUL | 0 | |
| date | datetime | NO | | 0000-00-00 00:00:00 | |
| author | varchar(255) | YES | | NULL | |
| email | varchar(255) | YES | | NULL | |
| author_id | mediumint(8) unsigned | YES | | NULL | |
| anonymous_id | varchar(45) | NO | | NULL | |
| website_url | varchar(255) | YES | | NULL | |
| content | longtext | YES | | NULL | |
| validated | enum('true','false') | NO | | false | |
| validation_date | datetime | YES | MUL | NULL | |
+-----------------+-----------------------+------+-----+---------------------+----------------+
11 rows in set (0.00 sec)
mysql>Last edited by huz_akh (2019-08-12 14:59:22)
Offline