Bug 487524 - Cannot update from 7.1.0 to 7.2 or 8.3
Summary: Cannot update from 7.1.0 to 7.2 or 8.3
Status: REPORTED
Alias: None
Product: digikam
Classification: Applications
Component: Database-Mysql (show other bugs)
Version: 7.10.0
Platform: Microsoft Windows Microsoft Windows
: NOR normal
Target Milestone: ---
Assignee: Digikam Developers
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-05-25 09:52 UTC by buyer@softbyte.com.au
Modified: 2024-05-25 10:47 UTC (History)
1 user (show)

See Also:
Latest Commit:
Version Fixed In:
Sentry Crash Report:

Attachments
Debug Log (4.14 KB, text/plain)
2024-05-25 09:52 UTC, buyer@softbyte.com.au 		Details
View All Add an attachment

Note You need to log in before you can comment on or make changes to this bug.
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