Summary: | Mysql database corruption upon tag hierarchy removal | ||
---|---|---|---|
Product: | [Applications] digikam | Reporter: | Ilia K. <mail4ilia> |
Component: | Database-Mysql | Assignee: | Digikam Developers <digikam-bugs-null> |
Status: | RESOLVED FIXED | ||
Severity: | major | CC: | caulier.gilles, vivo75+kde |
Priority: | NOR | ||
Version: | 2.0.0 | ||
Target Milestone: | --- | ||
Platform: | Unlisted Binaries | ||
OS: | Linux | ||
Latest Commit: | Version Fixed In: | 2.0.0 |
Description
Ilia K.
2011-05-03 04:46:47 UTC
Can you provide the affected database file (private mail is fine) along with a list of the relevant tags? Git commit 559160b3d730439d845329c4a1b367f8a0b3ee03 by Francesco Riosa. Committed on 10/05/2011 at 23:08. Pushed by riosa into branch 'master'. on delete trigger did a bit too much cleanup according to: http://dev.mysql.com/tech-resources/articles/hierarchical-data.html only elemnts between `lft` and `rgt` need to be deleted, not the whole hiearchy, also populate it again is not needed. Maybe during migration or in some other particular case better handling is required. These cases still need to be found and addressed ATM. This possibly close CCBUG: 272301 M +7 -12 data/database/dbconfig.xml.cmake http://commits.kde.org/digikam/559160b3d730439d845329c4a1b367f8a0b3ee03 (In reply to comment #2) this bug is fixed, please reopen if feel otherwise |