Announcement

#1 2019-08-12 14:40:28

huz_akh
Member
2014-06-01
4

date_created NULL despite of all efforts.

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

 

#2 2019-08-12 14:57:33

huz_akh
Member
2014-06-01
4

Re: date_created NULL despite of all efforts.

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.


Code:

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

 

Board footer

Powered by FluxBB

github twitter facebook google+ newsletter Donate Piwigo.org © 2002-2019 · Contact