[digikam] [Bug 383326] Moving a tag does not update the parent tag correctly

[meku]

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

--- Comment #5 from meku  ---
How can I repair this corrupt lft/rgt data in the Tags table without clearing
the database?

Re-importing all the metadata would cause loss of details for all the videos in
the database due to Bug #375570 (XMP sidecar files are not read for videos when
importing metadata).

-- 
You are receiving this mail because:
You are watching all bug changes.

[digikam] [Bug 383326] Moving a tag does not update the parent tag correctly

[Maik Qualmann]

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

Maik Qualmann  changed:

   What|Removed |Added

   Version Fixed In||5.8.0
 Status|REOPENED|RESOLVED
 Resolution|--- |FIXED

-- 
You are receiving this mail because:
You are watching all bug changes.

[digikam] [Bug 383326] Moving a tag does not update the parent tag correctly

[Maik Qualmann]

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

Maik Qualmann  changed:

   What|Removed |Added

 CC||metzping...@gmail.com
   Version Fixed In|5.8.0   |
 Resolution|FIXED   |---
 Status|RESOLVED|REOPENED

-- 
You are receiving this mail because:
You are watching all bug changes.

[digikam] [Bug 383326] Moving a tag does not update the parent tag correctly

[Maik Qualmann]

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

Maik Qualmann  changed:

   What|Removed |Added

 Resolution|--- |FIXED
 Status|CONFIRMED   |RESOLVED
  Latest Commit||https://commits.kde.org/dig
   ||ikam/74ea34d9fa0247a91c341e
   ||e99e6f001caa8020c3
   Version Fixed In||5.8.0

--- Comment #4 from Maik Qualmann  ---
Git commit 74ea34d9fa0247a91c341ee99e6f001caa8020c3 by Maik Qualmann.
Committed on 10/11/2017 at 18:35.
Pushed by mqualmann into branch 'master'.

fix updating lft/rgt columns in the Tags table with MySQL
Related: bug 386606
FIXED-IN: 5.8.0

M  +0-11   app/dragdrop/tagdragdrop.cpp
M  +26   -10   data/database/dbconfig.xml.cmake.in
M  +10   -12   libs/database/coredb/coredb.cpp
M  +0-7libs/database/coredb/coredb.h

https://commits.kde.org/digikam/74ea34d9fa0247a91c341ee99e6f001caa8020c3

-- 
You are receiving this mail because:
You are watching all bug changes.

[digikam] [Bug 383326] Moving a tag does not update the parent tag correctly

[Elle Stone]

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

Elle Stone  changed:

   What|Removed |Added

 CC||e...@ninedegreesbelow.com

-- 
You are receiving this mail because:
You are watching all bug changes.

[digikam] [Bug 383326] Moving a tag does not update the parent tag correctly

[Mario Frank]

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

--- Comment #3 from Mario Frank  ---
Hey meku,

yes, I saw these errors yesterday, too. Getting rid of the errors is easy but
does not solve the main problem that lft and rgt are not updated properly.

If noone does solve the problem before I do, I will try again to solve it
tomorrow.

-- 
You are receiving this mail because:
You are watching all bug changes.

[digikam] [Bug 383326] Moving a tag does not update the parent tag correctly

[meku]

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

meku  changed:

   What|Removed |Added

 CC||kde.b...@meku.org

--- Comment #2 from meku  ---
Looking at the trace there are two consecutive MySQL errors:

"
digikam.dbengine: Prepare failed!
digikam.dbengine: Failure executing query:
 "LOCK TABLE Tags WRITE;"
Error messages: "QMYSQL3: Unable to prepare statement" "This command is not
supported in the prepared statement protocol yet" 1295 2
Bound values:  ()
digikam.dbengine: Prepare failed!
digikam.dbengine: Failure executing query:
 "UNLOCK TABLES;"
Error messages: "QMYSQL3: Unable to prepare statement" "This command is not
supported in the prepared statement protocol yet" 1295 2
Bound values:  ()
digikam.general: Delete Shortcut assigned to tag  1272
"

-- 
You are receiving this mail because:
You are watching all bug changes.

[digikam] [Bug 383326] Moving a tag does not update the parent tag correctly

[Mario Frank]

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

Mario Frank  changed:

   What|Removed |Added

 Status|UNCONFIRMED |CONFIRMED
 Ever confirmed|0   |1

-- 
You are receiving this mail because:
You are watching all bug changes.

[digikam] [Bug 383326] Moving a tag does not update the parent tag correctly

[Mario Frank]

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

--- Comment #1 from Mario Frank  ---
I got a small MySQL database to work right now and was able to reproduce

the corruption. I even got an error message in the trace:

"

digikam.dbengine: Prepare failed!
digikam.dbengine: Failure executing query:
 "LOCK TABLE Tags WRITE;"
Error messages: "QMYSQL3: Der Befehl konnte nicht initialisiert werden" "This
command is not supported in the prepared statement protocol yet" 1295 2

"

So there definitely is a problem and as I see it, this will have not worked for
a longer time. Looks like an incomplete migration from dbconfig to source code.

I will try to fix it.

-- 
You are receiving this mail because:
You are watching all bug changes.