https://bugs.kde.org/show_bug.cgi?id=524196
Bug ID: 524196
Summary: Slved for me after performing the mention steps
Classification: Applications
Product: digikam
Version First 9.1.0
Reported In:
Platform: Ubuntu
OS: Other
Status: REPORTED
Severity: normal
Priority: NOR
Component: Setup-Database
Assignee: [email protected]
Reporter: [email protected]
Target Milestone: ---
***
If you're not sure this is actually a bug or valid feature request, instead
post about it at https://discuss.kde.org
If you're reporting a crash, attach a backtrace with debug symbols; see
https://community.kde.org/Guidelines_and_HOWTOs/Debugging/How_to_create_useful_crash_reports
Do not paste LLM output.
Please remove this comment after reading and before submitting - thanks!
***
DESCRIPTION
During updating Digikam on windows from 8.5 to 9.1, the MYSQL on an Ubuntu
server updating of the db-schema 16 to 17 doesn't work.
I took teh folling steps to solve it:
STEPS TO Solve
1. Delete the foreigne keys:
ALTER TABLE ImageTagProperties DROP FOREIGN KEY ImageTagProperties_Images;
ALTER TABLE ImageTagProperties DROP FOREIGN KEY ImageTagProperties_Tags;
2. Perform the update of digikam 9.1.0
3. restore the foreign keys:
ALTER TABLE ImageTagProperties
ADD CONSTRAINT ImageTagProperties_Images
FOREIGN KEY (imageid) REFERENCES Images(id) ON DELETE CASCADE ON UPDATE
CASCADE;
ALTER TABLE ImageTagProperties
ADD CONSTRAINT ImageTagProperties_Tags
FOREIGN KEY (tagid) REFERENCES Tags(id) ON DELETE CASCADE ON UPDATE CASCADE;
OBSERVED RESULT:
after performing the above steps, everything worked fine
EXPECTED RESULT
SOFTWARE/OS VERSIONS
Windows 11
Ubuntu 24.04
ADDITIONAL INFORMATION
Please corect the update script of the DB schemas
--
You are receiving this mail because:
You are watching all bug changes.
