Bug 393855 - MySQL/MariaDB upgrade fails
Summary: MySQL/MariaDB upgrade fails
Status: RESOLVED FIXED
Alias: None
Product: digikam
Classification: Applications
Component: Database-Mysql (show other bugs)
Version: 5.9.0
Platform: Other Linux
: NOR normal
Target Milestone: ---
Assignee: Digikam Developers
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-05-04 17:11 UTC by Rettich
Modified: 2018-07-22 20:02 UTC (History)
1 user (show)

See Also:
Latest Commit: https://commits.kde.org/digikam/c5c23ea81b8e6ee58d02c9cd88bfa1f4c21c84e7
Version Fixed In: 6.0.0

Attachments
Patch for dbconfig.xml (2.65 KB, patch)
2018-05-04 17:11 UTC, Rettich 		Details
View All Add an attachment

Note You need to log in before you can comment on or make changes to this bug.
Description Rettich 2018-05-04 17:11:11 UTC 
Created attachment 112418 [details]
Patch for dbconfig.xml

Digikam failed to upgrade my (external) MariaDB due to a collation issue. Probably the same issue as described here: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=895937

I patched two procedures in the dbconfig.xml (see attachment) by using the idea from other procedures.

After the patch, the upgrade worked like a charm.
Comment 1 Maik Qualmann 2018-05-04 21:20:31 UTC 
Git commit c5c23ea81b8e6ee58d02c9cd88bfa1f4c21c84e7 by Maik Qualmann.
Committed on 04/05/2018 at 21:19.
Pushed by mqualmann into branch 'master'.

apply patch #112418 from Rettich to fix upgrade the database
FIXED-IN: 6.0.0

M  +2    -1    NEWS
M  +17   -6    core/data/database/dbconfig.xml.cmake.in

https://commits.kde.org/digikam/c5c23ea81b8e6ee58d02c9cd88bfa1f4c21c84e7
Comment 2 Maik Qualmann 2018-07-22 20:02:22 UTC 
*** Bug 396765 has been marked as a duplicate of this bug. ***