[Digikam-devel] [Bug 298929] cannot assign tags anymore

[Francesco Riosa]

so you're using mysql, and have a problem with user permission on the 
database, these 3 queryes should fix the problem, I'll answer to the bug 
tomorrow, too tired to write english right now

CREATE USER 'digikam'@'%' IDENTIFIED BY '***';

GRANT USAGE ON * . * TO 'digikam'@'%' IDENTIFIED BY 'YOURPASSWORD' ;

GRANT ALL PRIVILEGES ON `local` . * TO 'digikam'@'%' WITH GRANT OPTION ;

regards,
Francesco


Il 30/04/2012 21:32, Kusi ha scritto:
> https://bugs.kde.org/show_bug.cgi?id=298929
>
> --- Comment #2 from Kusi<kusi at forum.titlis.org>  ---
> when I run digikam from console with debug enabled and try to tag a photo with
> "test6", I get
> digikam(7146)/digikam (core) Digikam::TagEditDlg::createTAlbum: ("test6")
> digikam(7146)/digikam (core) Digikam::TagEditDlg::createTAlbum: "test6"  ::
> "/test6"
> digikam(7146)/digikam (core)
> Digikam::DatabaseCoreBackendPrivate::debugOutputFailedQuery: Failure executing
> query:
>   "UPDATE Tags SET rgt = rgt + 2 WHERE rgt>  @myLeft;"
> Error messages: "QMYSQL3: Unable to execute statement" "The user specified as a
> definer ('digikam'@'%') does not exist" 1449 2
> Bound values:  ()
> digikam(7146)/digikam (core)
> Digikam::DatabaseCoreBackendPrivate::debugOutputFailedQuery: Failure executing
> query:
>   "UPDATE Tags SET lft = lft + 2 WHERE lft>  @myLeft;"
> Error messages: "QMYSQL3: Unable to execute statement" "The user specified as a
> definer ('digikam'@'%') does not exist" 1449 2
> Bound values:  ()
> digikam(7146)/digikam (core)
> Digikam::DatabaseCoreBackendPrivate::debugOutputFailedQuery: Failure executing
> query:
>   "UPDATE Tags SET icon=? WHERE id=?;"
> Error messages: "QMYSQL3: Unable to execute statement" "The user specified as a
> definer ('digikam'@'%') does not exist" 1449 2
> Bound values:  (QVariant(qlonglong, 0) ,  QVariant(int, 521) )
>
> what does that mean?
>
> thanks, Kusi
>