Tobias,
> About fixing the table: Since it can take quite some time this is nothing we
> should put into the upgrade path of dt's database, no one would like to wait
>an hour when starting dt.
Sure, I've not even thought about proposing that :)
> However, since this is a one time thing it might be
> enough to provide a script on the website, maybe along a short news post?
Sure, what about this:
darktable now uses some triggers to enforce consistency in the SQL
database for the tagxtag table. This table is in charge of counting the
tag's cooccurrence to propose the suggestions into the tagging module.
It turns out that with the previous code there were cases where the
counting was not properly conducted and could hinder the tag proposal.
The following two SQL statements can be used to reset the table with
proper values. Note that this needs to be run only once after starting
darktable version 1.6.
UPDATE tagxtag
SET count=(SELECT count(*)
FROM tagged_images
WHERE tagid=id2
AND imgid IN (SELECT imgid FROM tagged_images WHERE tagid=id1));
UPDATE tagxtag SET count = count + 1000000 WHERE id1=id2;
--
Pascal Obry / Magny Les Hameaux (78)
The best way to travel is by means of imagination
http://v2p.fr.eu.org
http://www.obry.net
gpg --keyserver keys.gnupg.net --recv-key F949BD3B
------------------------------------------------------------------------------
Android apps run on BlackBerry 10
Introducing the new BlackBerry 10.2.1 Runtime for Android apps.
Now with support for Jelly Bean, Bluetooth, Mapview and more.
Get your Android app in front of a whole new audience. Start now.
http://pubads.g.doubleclick.net/gampad/clk?id=124407151&iu=/4140/ostg.clktrk
_______________________________________________
darktable-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/darktable-devel
