Hi;

I have a large library of over 100,000 photos that are mostly keyworded according to the albums that I ultimately want them in. Some photos exist in multiple albums, so I can't import by album, or I'll have duplicates. My plan was to import the entire collection into an All Photos album and then move them to the album i want them in using the Batch Manager and based upon the keywords. If this logic is bad, someone please let me know, because it is not working well for me.

I am not a PHP programmer, but I do understand databases very well.

I have FTP'd small album groups of photos into Piwigo and then Synchronized. With the help of @erACK, I have been able to get the photos keywords written into piwigo_tags. Since the photos keywords show in the detail photo view AND they made it to this table, I assume the keyword structure in my photos is acceptable. But, I still can not search by keyword, off the menu or the Batch Manager.

I did a test, by taking an album with keywords, and adding the same keyword to all the photos in the album. This added that keyword to piwigo_image_tag. Now that search works both from the menu and Batch Manager.

Since the photos image id is known when the keyword is pulled and then added to piwigo_tags, why isn't the id of the keyword then pulled and both ids could be added to piwigo_image_tag? I assume, I am doing something wrong, but can't figure it out.

Please advise, I really like Piwigo and have built up my own Linux server just for this purpose.

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['upload_form_all_types'] = true;
$conf['sync_chars_regex'] = '/^[a-zA-Z0-9-_. ]+$/';

$conf['show_exif'] = true;
$conf['show_exif_fields'] = array(
  'Make',
  'Model',
  'ExifVersion',
  'Software',
  'DateTimeOriginal',
  'FNumber',
  'ExposureBiasValue',
  'FILE;FileSize',
  'ExposureTime',
  'Flash',
  'ISOSpeedRatings',
  'FocalLength',
  'FocalLengthIn35mmFilm',
  'WhiteBalance',
  'ExposureMode',
  'MeteringMode',
  'ExposureProgram',
  'LightSource',
  'Contrast',
  'Saturation',
  'Sharpness',
  'bitrate',
  'channel',
  'date_creation',
  'display_aspect_ratio',
  'duration',
  'filesize',
  'format',
  'formatprofile',
  'codecid',
  'frame_rate',
  'latitude',
  'longitude',
  'make',
  'model',
  'playtime_seconds',
  'sampling_rate',
  'type',
  'resolution',
  'rotation',
  );

$conf['show_iptc'] = true;
$conf['use_iptc'] = true;

$conf['show_iptc_mapping'] = array(
  'Author'          => '2#080',
  'Title'           => '2#005',
  'Description'     => '2#120',
  'Keywords'        => '2#025',
  'Headline'        => '2#105',
  );

$conf['use_iptc_mapping'] = array(
  'keywords'        => '2#025',
  'author'          => '2#080',
  'name'            => '2#005',
  'comment'         => '2#120',
  );
?>


Environment

    Piwigo 14.1.0 Check for upgrade
    Installed on 1 January 2024, 1 day ago
    Operating system: Linux
    PHP: 8.1.2-1ubuntu2.14 (Show info) [2024-01-03 09:10:55]
    MySQL: 8.0.35-0ubuntu0.22.04.1 [2024-01-03 13:10:55]
    Graphics Library: ImageMagick 6.9.11-60
    Cache size 27.93 Mo   calculated 23 hours ago Refresh

Activated plugin list 26

    Additional Pages
    Batch Downloader
    Contact 1 menu
    Contact Form
    Custom Download Link
    Download Counter
    Exif View
    Exiftool GPS
    Exiftool Keywords
    Extended Description
    Force HTTPS
    gdThumb
    Grum Plugins Classes.3
    GuestBook
    LocalFiles Editor
    Most Commented
    Most Downloaded
    No Stats For Robots
    Perso Footer
    Personal Favicon
    Read Metadata
    RV Thumb Scroller
    Smilies Support
    Tag To Keyword
    VideoJS
    Write Metadata


Piwigo URL: https://marcsphotos.mywire.org/