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

[Quallenauge]

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


Quallenauge <Hamsi2k at freenet.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |Hamsi2k at freenet.de




--- Comment #1 from Quallenauge <Hamsi2k freenet de>  2010-10-15 12:17:37 ---
Something goes wrong with your dbms configuration.
As the log output states you doesn't have enough privileges in the digikam
schema:

>"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

Can you please check your dbms (mysql server) configuration?

I had made some changes within the gsoc branch, which tries to detect
permission problems by creating and manipulating a table.

The question for me is, why it is needed to have SUPER privileges for this
action. Besides of that, we have no other way to handle the tag hierachy - we
need to use this kind of statements there.

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