[Digikam-devel] [Bug 272301] Mysql database corruption upon tag hierarchy removal

[Francesco Riosa]

https://bugs.kde.org/show_bug.cgi?id=272301





--- Comment #2 from Francesco Riosa <francesco+kde pnpitalia it>  2011-05-10 23:20:20 ---
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

-- 
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.