Bug 487524

Summary: Cannot update from 7.1.0 to 7.2 or 8.3
Product: [Applications] digikam Reporter: buyer <buyer>
Component: Database-MysqlAssignee: Digikam Developers <digikam-bugs-null>
Status: REPORTED ---    
Severity: normal CC: metzpinguin
Priority: NOR    
Version First Reported In: 7.10.0   
Target Milestone: ---   
Platform: Microsoft Windows   
OS: Microsoft Windows   
Latest Commit: Version Fixed/Implemented In:
Sentry Crash Report:
Attachments: Debug Log

Description buyer@softbyte.com.au 2024-05-25 09:52:35 UTC
Created attachment 169811 [details]
Debug Log

SUMMARY
Cannot update MariaDB database from v10 to v11. Connection tests reports OK, digikam V7.1 runs OK but not later versions.

STEPS TO REPRODUCE
1. Update digikam to V7.2 or above
2. Digikam reports "Fails to update schema from version 10 to version 11
3. Test connection reports ALL OK

OBSERVED RESULT
Cannot update the MariaDB database

EXPECTED RESULT
Able to update the MariaDB database and run later versions of digikam


SOFTWARE/OS VERSIONS
Windows: 10 pro, 10.0.19045 Build 19045
KDE Plasma Version: 
KDE Frameworks Version: 
Qt Version: 

ADDITIONAL INFORMATION
Comment 1 Maik Qualmann 2024-05-25 10:26:01 UTC
The error message in the log indicates that you do not have the necessary rights to the database to create and delete triggers. Triggers require special privileges, activate these for your digiKam database user. We cannot do this in digiKam.

Maik
Comment 2 Maik Qualmann 2024-05-25 10:47:24 UTC
Which MySQL Server version is used exactly? Note that we only support MariaDB. A current Oracle MySQL server can still be used for an external database.

Maik
Comment 3 caulier.gilles 2025-04-11 18:14:01 UTC
Hi,

The 8.7.0 pre-release Windows installer from today have been rebuilt from
scratch with Qt 6.8.3, KDE 6.12, OpenCV 4.11 + CUDA support, Exiv2 0.28.5, ExifTool 13.27, ffmpeg 7, all image codecs updated to last version (jxl, avif, heif, aom, etc.).

Please try with this version to see if your problem still reproducible...

https://files.kde.org/digikam/

Thanks in advance
Best regards

Gilles Caulier