[Digikam-devel] [Bug 258409] Tags and TagsTree table is empty after DB migration from sqlite to mysql
neuntoeter at arcor.de
Fri May 6 20:03:31 BST 2011
--- Comment #7 from Volker <neuntoeter arcor de> 2011-05-06 21:03:30 ---
I'm a bit confused. Whe I look in my sqlite database with a sqlite browser, I
don't see a table TagProperties. Is this maybe the problem?
volker at kiste:~/Fotos$ sqlite3 digikam4.db
SQLite version 3.7.4
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> SELECT name FROM sqlite_master
...> WHERE type='table'
...> ORDER BY name;
I'd be willing to test with the patched git version. I there a howto for this?
Will this have impact for the rest of kde?
(In reply to comment #6)
> I've tested this with digikam 2.0 compiled from git sources, and the patch from
> bug #271924 .
> I'm unable to reproduce the bug, the `tags` table is populated with default
> tags and user defined ones.
> The Table `TagTree` is populated, one tag with `id` 25 and `pid` 0 does not
> exists in mysql table
> The Table `TagProperties` is populated, however some tags which exist in the
> sqlite version are not present in the mysql one, namely:
> only those with `property` "internalTag" are present in the mysql version
> The differences DON'T AFFECT tags I've applied to photos, they are all there.
> Volker do you care to retest with git version and the mentioned patch?
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
More information about the Digikam-devel