Hello,

After inserting more than 84000 images in 64 albums with 74000 keywords (working fine) I decide to insert tags/keywords on jpg files that was tag's empty with the adobe bridge.

At the end of the insertion keywords task I just click from admin panel to :
tools --> Syncronise -->
+synchronise database photos with file metadata Synchronise metadata (filesize, width, height, date_creation, latitude, longitude, author, name, comment, keywords)
+including already synchronised photos

and clicking the button Syncronise gets the following error:

Warning:  [mysql error 1048] Column 'name' cannot be null

INSERT  INTO `epcms_tags`
  (`name`,`url_name`)
  VALUES(NULL,NULL) in E:\xampp\htdocs\cms\include\dblayer\functions_mysqli.inc.php on line 847


Warning:  [mysql error 1062] Duplicate entry '7339-65535' for key 'PRIMARY'

INSERT  INTO `epcms_image_tag`
  (`image_id`,`tag_id`)
  VALUES('7312','5')
  , ('7312','1042')
  , ('7312','1893')
  , ('7312','25695')
  , ('7312','2122')
  , ('7312','226')
  , ('7312','101')
  , ('7312','19287')
  , ('7312','1063')
  , ('7312','1298')
  , ('7312','2143')
  , ('7312','134')
  , ('7312','747')
  , ('7312','144')
  , ('7312','8')
  , ('7312','781')
  , ('7312','140')
  , ('7312','3601')
  , ('7312','454')
  , ('7312','1369')
  , ('7312','11012')
  , ('7312','32')
  , ('7312','490')
  , ('7312','191')
  , ('7312','1049')
  , ('7312','1086')
  , ('7314','26033')
  , ('7314','7949')
  , ('7314','1374')
  , ('7314','17849')
  , ('7314','26034')
  , ('7314','390')
  , ('7314','26035')
  , ('7314','20484')
  , ('7314','16162')
  , ('7314','226')
  , ('7314','2127')
  , ('7314','189')
  , ('7314','2926')
  , ('7314','140')
  , ('7314','217')
  , ('7314','408')
  , ('7315','26036')
  , ('7315','4842')
  , ('7315','437')
  , ('7315',' in E:\xampp\htdocs\cms\include\dblayer\functions_mysqli.inc.php on line 847

The weird think is that I have a prompt that :
775 photo information synchronised with file metadata
775 candidate photos for metadata synchronisation

But using the search no keywords added. Also searching with the file name The image details panel has no Keywords.


Also my local/config/config.inc.php
<?php

/* The file does not exist until some information is entered
below. Once information is entered and saved, the file will be created. */

$conf['sync_chars_regex'] = '/^[a-zA-Z0-9-_. \sÀÁÂÃÄÅçğıİöşüÇĞÖŞÜàáâãäåÒÓÔÕÖØòóôõöøÈÉ@:ÊËèéêëÇçÌÍÎÏìíîïÙÚÛÜùúûüÿÑñ!\(\)\&\/\°\'\,\-]+$/';
$conf['use_iptc'] = true;
$conf['use_iptc_mapping'] = array(
  'author'          => '2#080',
  'name'            => '2#005',
  'comment'         => '2#120',
  'keywords'        => '2#025',
  );
$conf['guest_access'] = false;

?>


Environment
Piwigo 13.5.0 Check for upgrade
Installed on 13 November 2022, 2 months 4 weeks ago
Operating system: WINNT
PHP: 7.3.33 (Show info) [2023-02-12 11:33:55]
MySQL: 5.5.5-10.4.22-MariaDB [2023-02-12 12:33:55]
Graphics Library: External ImageMagick 6.2.6

Activated plugin list
Block search
LocalFiles Editor
PWG Stuffs

Piwigo URL: is localhost on win Server with xampp v.3.3.0

Best Regards
Panos