🌍
English
Announcement
- [2024-04-17] Piwigo 14.4.0
- [2024-04-01] Piwigo in Hobbit runes
- [2024-03-01] Piwigo 14.3.0
- [2024-01-30] Piwigo 14.2.0
- [2023-12-29] Piwigo 14.1.0
#1 2024-04-18 22:56:59
- Grymper21
- Member
- 2024-04-18
- 3
Photo uploads result in truncation of long tags
I researched the forum but cannot find a listing related to this issue.
Using Digikam 8.3.0 to upload tagged photos. Absolutely no problem except for tags exceeding 64 characters. Those tags are truncated to 64 characters. Windows 11 environment for Digikam. Piwigo hosted on Godaddy.
Environment:
Piwigo 14.4.0 Check for upgrade
Installed on 9 January 2024, 3 months 1 week 2 days ago
Operating system: Linux
PHP: 8.1.27 [2024-04-18 19:31:24]
MySQL: 10.6.17-MariaDB-cll-lve [2024-04-18 12:31:24]
Graphics Library: ImageMagick 7.1.1-19
Cache size 219.72 MB
Activated plugins:
Additional Pages
Extended Description
GThumb+
LocalFiles Editor
PWG Stuffs
SmartAlbums
Tag Groups
Take A Tour of Your Piwigo
XMP Tags
Offline
#2 2024-04-21 17:50:04
- Grymper21
- Member
- 2024-04-18
- 3
Re: Photo uploads result in truncation of long tags
Using phpMyAdmin, the tag table structure for "name" and "url_name" is varchar(255).
Filtering for name length>60, all the entries have three dots at the end.
Hovering over the "..." shows "Original length 64" (Obviously not true).
If I try to manually edit one of these entries, to restore it to its original length, the change is not retained, so truncation is not limited to imports.
I really need to find out how to correct this!
Offline
#3 2024-04-22 11:21:41
- erAck
- Only trying to help
- 2015-09-06
- 2043
Re: Photo uploads result in truncation of long tags
If it happens also when editing field values in phpMyAdmin then it's obviously a database setting. Unless your name values consist of all 4-byte UTF-8 encoded characters..
I don't know though what could cause this behaviour.
Running Piwigo at https://erack.net/gallery/
Offline
#4 2024-04-22 18:15:29
- Grymper21
- Member
- 2024-04-18
- 3
Re: Photo uploads result in truncation of long tags
Thank you for the insights! After adjusting and re-adjusting the database structure, I discovered I CAN change the tag in the database successfully. The problem isn't the database structure.
Then I looked at the EXIF Metadata pane and discovered that the tags are being imported as iptc_keywords which (I suspect) automatically truncates.
Is there a way to prevent this from occurring on import? It happens if I export from digiKam and/or if I drag and drop from Windows.
Again thanks!
Offline