#1 2025-03-04 18:50:10

dougienisbet
Member
2025-01-02
16

synchronise sometimes fails - perhaps bad chars in exif tag keywords

Hello/Hi/Greetings,

I occasionally get errors when synchronizing my photos. My workflow is currently experimenting with using piwigo as an alternative viewer for my own photos so there are large amounts of photos being synced.

The error I occasionally get is :

Fatal error: Uncaught mysqli_sql_exception: Column 'name' cannot be null in /denweb/photos/include/dblayer/functions_mysqli.inc.php:132 Stack trace: #0 /denweb/photos/include/dblayer/functions_mysqli.inc.php(132): mysqli->query() #1 /denweb/photos/include/dblayer/functions_mysqli.inc.php(550): pwg_query() #2 /denweb/photos/admin/include/functions.php(1750): mass_inserts() #3 /denweb/photos/admin/site_update.php(881): tag_id_from_tag_name() #4 /denweb/photos/admin.php(406): include('...') #5 {main} thrown in /denweb/photos/include/dblayer/functions_mysqli.inc.php on line 132

Often I find it's bad characters in filename, but I've come across an interesting case where it seems to be characters in the exif data.

Here is the exif data for the keywords tag before and after (I changed the period to an underscore)

Code:

exiftool -keywords viola.jpg 
Keywords                        : Viola spp. , Stanhope, United Kingdom, North East England, County Durham, Harthope Road, East Blackdene, England

Keywords                        : Viola spp_ , Stanhope, United Kingdom, North East England, County Durham, Harthope Road, East Blackdene, England

No sync error with the second example. I concluded, falsely I think, that it was the period that was causing the problem, but I have other files that have periods in the keywords field without issue. e.g.

Code:

St. John's Chapel, United Kingdom, County Durham, England, North East England, Stanhope

So perhaps it's the combination of the period space comma, or some edge case.


Environment

    Piwigo 15.4.0 Check for upgrade
    Installed on 8 January 2025, 1 month 3 weeks 5 days ago
    Operating system: Linux
    PHP: 8.2.26 (Show info) [2025-03-04 17:49:14]
    MySQL: 10.11.6-MariaDB-0+deb12u1 [2025-03-04 17:49:14]
    Graphics Library: ImageMagick ImageMagick 6.9.11-60
    Cache size 94.36 Mo   calculated 3 days ago Refresh

Activated plugin list 5

    LocalFiles Editor
    OpenStreetMap
    Piwigo Failed Login logger
    Tag Groups
    Take A Tour of Your Piwigo

Last edited by dougienisbet (2025-03-04 18:51:09)

Offline

 

Board footer

Powered by FluxBB