Hello/Hi/Greetings,
I need to use several IPTC fields in the metadata. Where can I find a list of all the (in example below) piwigo_images column names that correspond to the '2#nnn' values where 'nnn' is a 3 digit numeric?
I will be using several more of these values for the mapping like this one.
$conf['use_iptc_mapping'] = array(
'keywords' => '2#025',
'date_creation' => '2#055',
'author' => '2#122',
'name' => '2#005',
'comment' => '2#120'
);
I can't get the metadata synchronisation to work. It fails because of invalid column names during the MySQL statements.
Piwigo version: 2.9.4
PHP version: 7.0.0 (and 5.6.10)
MySQL version: 5.5.42
Piwigo URL: http://. -- not on publicly accessible server.
Thanks,
Terry Banks
Offline
Hi Terry
I had exactly the same question as you.
In my case, I saw the word Example in the code and concluded there must be more, perhaps many more fields in piwigo_images that could store IPTC data. Is that what you thought?
I've suggested a change to the documentation https://piwigo.org/forum/viewtopic.php?id=28872.
Would such a change have helped you?
Anyway, to answer your question - I've attached a jpeg showing all the columns in the piwigo_images table.
As you'll see, the only ones which will accept text are:
'file'
'name'
'comment'
'author'
'keywords' will accept text but the data is actually stored in the piwigo_tags table.
I imagine someone who knows their way round SQL could add more columns in piwigo_images but I'm a newbie at this and don't know if that would adversely affect the software. Anyone?
Hope this helps
Reg
Last edited by RegSputnik (2018-09-14 19:50:31)
Offline