Hello,

Problem with EXIF Metadata

I installed a fresh and compleet new testserver for working with Piwigo.
But i have problems with reading the EXIF Metadata.
==> Remark i know that IPTC data can be used but that's not the point :-)

For some reason Piwigo shows most of the EXIF data as ????????????? while Metadata2Go.com, Microsoft and exiftools shows the correct data.
Can someone help me pls.

==> REMARK, everytime i test a new version or installation of Piwigo i deleted al the tables in the mysql server database and deleted and replaced al the files from Piwigo folder to prevent crossover errors.
only the conf of NGINX rest the same.

Environment details
//-----------------------------------------------------------------------------------------------------------------------
- Debian GNU/Linux 12 (bookworm)
- php/8.2 PHP Modules installed bcmath calendar curl date exif imagick json mbstring memcached xml xmlreader xmlrpc xmlwriter (REMARK List NOT complete for easier reading)
- NGINX
- mysql Ver 15.1 Distrib 10.11.6-MariaDB

Piwigo 14.2.0 Upgradecontrole
Geïnstalleerd op 15 februari 2024, 5 dagen geleden
Besturingssysteem: Linux
PHP: 8.2.7 (Toon info) [2024-02-20 19:28:45]
MySQL: 10.11.6-MariaDB-0+deb12u1 [2024-02-20 19:28:45]
Afbeeldingen-bibliotheek: ImageMagick 6.9.11-60
Cache grootte Niet beschikbaar nooit berekend Ververs

Geactiveerde plug-in lijst
AlwaysShowMetadata
Exif View
Grum Plugins Classes.3
LocalFiles Editor
Read Metadata
Tag To Keyword

//=======================================================================================================================

==>I tried different configs to see the different outputs
example with 'Keywords' or with 'XPKeywords' and so on ... (whatever i found on goolge about Piwigo and metadata)

==> content of my current local/config/config.inc.php
//-----------------------------------------------------------------------------------------------------------------------
<?php

$conf['sync_chars_regex'] = '/^[a-zA-Z0-9-+_.,; ‘!@#$%^()\[\]ÀÁÂÃÄÅąāàáâãäåæßẞÇçćÈÉÊËèéêëĞğÌÍÎÏİıìíîïŁÑñńöÖÒÓÔÕÖØòóôõöøŞŠşÙÚÛÜùúûüÿ]+$/u';

// for some file types, Piwigo will try to generate a pwg_representative TIFF, videos, PDF)
$conf['upload_form_all_types'] = true;
// $conf['enable_i_log'] = true;

// $conf['menubar_tag_cloud_content'] = 'current_only';

$conf['use_exif'] = true;
$conf['use_exif_mapping'] = array(
  'tags'             => 'Keywords',
  //  'tags'             => 'XPKeywords',
  'date_creation'    => 'DateTimeOriginal',
  'comments'         => 'XPComment',
  'title'            => 'XPSubject',
  'subject'          => 'XPSubject',
  'author'           => 'Artist'
  );

$conf['show_exif'] = true;
$conf['show_exif_fields'] = array(
  //  'XPKeywords',
  'Keywords',
  'DateTimeOriginal',
  'Artist',
  'Copyright',
  'Comment'
  );
?>
//-----------------------------------------------------------------------------------------------------------------------

==> Test Piwigo
==> After pressing syncronisation button with Simulatie

[Simulatie] Zoek naar nieuwe foto's in de mappen
3 Albums toegevoegd aan de database
7 Foto's toegevoegd aan de database
0 Albums uit de database verwijderd
0 Foto's verwijderd uit de database
0 Foto's bijgewerkt in de database
0 Fouten tijdens de synchronisatie

[Simulatie] Metadata synchronisatie-resultaten
0 Foto-informatie gesynchroniseerd met bestandsmetadata
0 Foto's waarvan de metadata gesynchroniseerd zou kunnen worden
Gebruikte metadata : filesize, width, height, tags, keywords, date_creation, comment, latitude, longitude

==>  After pressing syncronisation button without Simulatie

Metadata synchronisatie-resultaten
9 Foto-informatie gesynchroniseerd met bestandsmetadata
9 Foto's waarvan de metadata gesynchroniseerd zou kunnen worden
Gebruikte metadata : filesize, width, height, tags, date_creation, comments, title, subject, author, latitude, longitude

//=====================================================================================================================
RESULTS INTO DATABASE

'Keywords'    ===> ???  imported into database
'XPKeywords'  ===> NO IMPORT into database

Data imported into sql database (piwigo_tags)

|_. id |_. name |_. url_name |_. lastmodified |
| 3 | ?????????????????? | ?????????????????? | 2024-02-20 14:31:54 |
| 2 | ??????????????????????????????????????????? | ??????????????????????????????????????????? | 2024-02-20 14:31:54 |
| 4 | ????????????????????????????????????????????? | ????????????????????????????????????????????? | 2024-02-20 14:31:54 |

===> REMARK FROM MYSELF No sign found of importing comments, title, subject, author into database
//-----------------------------------------------------------------------------------------------------------------------

==> Getting a sample of metadata “sample.jpg” into to <rootfolder>/tools/sample.jpg with metadata.php (shorted for realibility)

Informations are read from sample.jpg

IPTC Fields in sample.jpg

2#005 = IPTC ObjectName 2024-01-01 (FileName)
2#025 = XPkeyword1,keyword2,keyword3,mam,being mother
2#055 = 20220814
2#060 = 100102+0200
2#062 = 20220814
2#063 = 100102+0200
2#080 = IPTC By-Line Artist
2#116 = IPTC CopyRightNotice
2#120 = IPTC Caption-abstract 2024-01-01 (FileName)

EXIF Fields in sample.jpg
Array
(
    [FileName] => sample.jpg
    [FileDateTime] => 1708440201
    [FileSize] => 135428
    [FileType] => 2
    [MimeType] => image/jpeg
    [SectionsFound] => ANY_TAG, IFD0, EXIF, WINXP
    [COMPUTED] => Array
        (
            [html] => width="880" height="513"
            [Height] => 513
            [Width] => 880
            [IsColor] => 1
            [ByteOrderMotorola] => 1
            [Copyright] => XP Copyright (sample.jpg)
        )

    [ImageDescription] => XP Title 2024-01-01  (FileName)
    [Software] => Software Exiftool 12.70
(sample.jpg)
    [Artist] => XP Artist (sample.jpg)
    [Copyright] => XP Copyright (sample.jpg)
    [Exif_IFD_Pointer] => 534
    [Title] => ???????????????????????????????
    [Comments] => ??????????????????????
    [Author] => ??????????????????????
    [Keywords] => ?????????????????????????????????????????????
    [Subject] => ??????????????????????????
    [UndefinedTag:0xEA1C] =>
    [DateTimeOriginal] => 2022:08:14 10:01:02
    [DateTimeDigitized] => 2022:08:14 10:01:02
    [SubSecTimeOriginal] => 01
    [SubSecTimeDigitized] => 01
)
XMP data in 'sample.jpg'

(Requires Imagemagick PHP extension)
No data
[end of XMP]

===> REMARK BY MYSELF
Output metadata.php show

(Requires Imagemagick PHP extension)
No data
[end of XMP]

===> But php/8.2 PHP Modules imagick is installed and XMP Metada does exist

//-------------------------

==> Output by exiftool.exe(-a -u -g1 -w txt)

Image Description               : ImageDescription (Trunc FileName)
Software                        : Software Exiftool 12.70. (sample.jpg)
Artist                          : Artist (sample.jpg)
Copyright                       : Copyright (sample.jpg)
XP Title                        : XPTiltle 2024-01-01 (FileName)
XP Comment                      : XPComment (sample.jpg)
XP Author                       : XP Author (sample.jpg)
XP Keywords                     : XPkeyword1;keyword2;keyword3;mam;being mother
XP Subject                      : XPSubject (Trunc Filename)
Padding                         : (Binary data 268 bytes, use -b option to extract)
---- ExifIFD ----
Date/Time Original              : 2022:08:14 10:01:02
Create Date                     : 2022:08:14 10:01:02
Sub Sec Time Original           : 01
Sub Sec Time Digitized          : 01
Padding                         : (Binary data 268 bytes, use -b option to extract)
---- IPTC ----
Keywords                        : IPTC being mother, IPTCkeyword1, keyword2, keyword3, mam
Application Record Version      : 4
By-line                         : IPTC By-Line Artist
Object Name                     : IPTC ObjectName 2024-01-01 (FileName)
Date Created                    : 2022:08:14
Time Created                    : 10:01:02+02:00
Digital Creation Date           : 2022:08:14
Digital Creation Time           : 10:01:02+02:00
Copyright Notice                : IPTC CopyRightNotice
Caption-Abstract                : IPTC Caption-Abstract (Trunc FileName)

//=====================================================================================================================