According to the release notes Piwigo 14.1.0 is only compatible with PHP up to 8.2.

https://piwigo.org/release-14.0.0

Last edited by homdax (2024-01-22 12:49:31)

Unfortunately PHP 8.2 is still throwing up the same error relating to Incorrect datetime value.

Last edited by John R (2024-01-22 13:30:13)

I've tried with a few from whatsapp and from my own photos I've taken with my phone, same error each time.

Take the "Incorrect datetime value" literally, the string (unhexed)
2023-04-30 2:38:36â ¯pm
(and with 0x80 padding character instead of the space in "â ¯") certainly is a bad DateTime value. If that happens on all photos taken with your phone then likely your phone's camera app writes bad values to the EXIF field and you need to preprocess them to clean before uploading to Piwigo. (and Piwigo maybe could check validity). You'll also have to sanitize data in the piwigo_images table's date_creation column.

Hi John,

First time I hear about an issue like this.

The creation date is encoded in UTF-8 on the iOS app when uploading photos.
Which MySQL and HTTP encodings do you use on your server?

Cheers,
Eddy

cryopad wrote:

The creation date is encoded in UTF-8 on the iOS app when uploading photos.
Which MySQL and HTTP encodings do you use on your server?

That may indeed hint into the right direction, 0xE280AF is the UTF-8 sequence for U+202F NARROW NO-BREAK SPACE, NNBSP; which for the example would had been the original string
2023-04-30 2:38:36 pm

Stored in and retrieved from an 8-bit (instead of UTF-8) text encoding database it could lead to the crippled value encountered.

John R wrote:

LANG=en_GB.UTF-8
...

Those are your shell environment locale settings, not the database (nor HTTP) text encoding. Use for example phpMyAdmin to inspect the database's Structure, the Collation property of all and specifically the piwigo_images table should be utf8mb3_general_ci. If it is something else then likely that's the culprit.  (utf8mb4_... would also be ok but shouldn't be the case here).

Setting lc_time_names in my.cnf has moved me on somewhat, now I get

[Tue Jan 23 01:57:31.778751 2024] [php:warn] [pid 8513] [client 10.0.0.35:49743] PHP Warning:  Undefined array key 118 in /usr/local/www/piwigo/include/ws_functions/pwg.categories.php on line 188
[Tue Jan 23 01:57:31.779014 2024] [php:warn] [pid 8513] [client 10.0.0.35:49743] PHP Warning:  Undefined array key 118 in /usr/local/www/piwigo/include/ws_functions/pwg.categories.php on line 192

The image doesn't load into the album I made but I can manually move it there, but it doesn't have a thumbnail. I'm losing more hair follicles than I can afford with this, lol