[Digikam-devel] [Bug 254182] New: Can't create mysql-entries for new tags

[Frank Hommes]

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

           Summary: Can't create mysql-entries for new tags
           Product: digikam
           Version: 1.5.0
          Platform: Compiled Sources
        OS/Version: Linux
            Status: UNCONFIRMED
          Severity: normal
          Priority: NOR
         Component: Database
        AssignedTo: digikam-devel at kde.org
        ReportedBy: freanki at gmx.net


Version:           1.5.0 (using KDE 4.5.1) 
OS:                Linux

Since I installed Digikam new on my new system I can't create new tags anymore.
They are not shown anyway and I get the following error in the console:
"digikam(10172)/digikam (core) Digikam::TagEditDlg::createTAlbum: "some person"
 ::  "some person"
digikam(10172)/digikam (core)
Digikam::DatabaseCoreBackendPrivate::debugOutputFailedQuery: Failure executing
query:
 "UPDATE Tags SET rgt = rgt + 2 WHERE rgt > @myLeft;" 
Error messages: "Access denied; you need the SUPER privilege for this operation
QMYSQL3: Unable to execute statement" 1227 2 "Access denied; you need the SUPER
privilege for this operation" "QMYSQL3: Unable to execute statement"
QSqlError(-1, "", "") 
Bound values:  ()
QSqlDatabasePrivate::removeDatabase: connection 'digikamDatabase-24358144' is
still in use, all queries will cease to work."

I'm using digikam 1.5 self compiled on kde with a mysql-server on the remote
server. The user digikam has all rights granted for the database digikam.


Reproducible: Always

Steps to Reproduce:
Create a tag

Actual Results:  
Digikam shows the new tag in the list. The tag at the picture is any of my
tags.

Expected Results:  
There should be a new tag...

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