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

[Francesco Riosa]

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

Francesco Riosa <francesco+kde at pnpitalia.it> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |francesco+kde at pnpitalia.it

--- Comment #4 from Francesco Riosa <francesco+kde at pnpitalia.it> ---
> I came across this link
> http://www.phplogs.com/the-user-specified-as-a-definer/
> so I dropped all 3 triggers I could find and created two of them again,
> according to what I've found in dbconfig.xml
> 
> delimiter //
> CREATE TRIGGER delete_image AFTER DELETE ON Images
>                     FOR EACH ROW BEGIN
>                         DELETE FROM ImageTags          WHERE imageid=OLD.id;
>                         DELETE From ImageHaarMatrix    WHERE imageid=OLD.id;
>                         DELETE From ImageInformation   WHERE imageid=OLD.id;
>                         DELETE From ImageMetadata      WHERE imageid=OLD.id;
>                         DELETE From ImagePositions     WHERE imageid=OLD.id;
>                         DELETE From ImageComments      WHERE imageid=OLD.id;
>                         DELETE From ImageCopyright     WHERE imageid=OLD.id;
>                         DELETE From ImageProperties    WHERE imageid=OLD.id;
>                         DELETE From ImageHistory       WHERE imageid=OLD.id;
>                         DELETE FROM ImageRelations     WHERE subject=OLD.id
> OR object=OLD.id;
>                         DELETE FROM ImageTagProperties WHERE imageid=OLD.id;
>                         UPDATE Albums SET icon=null    WHERE icon=OLD.id;
>                         UPDATE Tags SET icon=null      WHERE icon=OLD.id;
>                     END; //
> 
> and
> 
> CREATE TRIGGER delete_tag AFTER DELETE ON Tags
>             FOR EACH ROW BEGIN
>                 DELETE FROM ImageTags          WHERE tagid=OLD.id;
>                 DELETE FROM TagProperties      WHERE tagid=OLD.id;
>                 DELETE FROM ImageTagProperties WHERE tagid=OLD.id;
>             END; //
> 
> I couldn't find anything for move_tagtree, is that correct?

Hi, that's correct, there is no move_tagtree currently, did you have it in the
database?
check that your dbconfig.xml is near to this:
https://projects.kde.org/projects/extragear/graphics/digikam/repository/revisions/f7ff8f23a5d279973ec5b3fccf93de248b623c53/raw/data/database/dbconfig.xml.cmake

it should have been dropped, also from your previous comment its visible that
user "digikam@%" don't exist but it's what digikam is trying to use, maybe you
had a user "digikam at localhost" instead.

digikam does a database upgrade check at every start, and need permissions to
modify the database schema

Now to repair the tree, that's not an easy task, but it's doable, especially if
tags are not too many, otherwise you can send me a dump of the table (possibly
with obfuscated tags name) and I'll try to repair it for you.

-- 
You are receiving this mail because:
You are the assignee for the bug.