[Digikam-devel] [Bug 258409] Tags and TagsTree table is empty after DB migration from sqlite to mysql

[Volker]

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





--- Comment #7 from Volker <neuntoeter arcor de>  2011-05-06 21:03:30 ---
Hi Francesco, 

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;
AlbumRoots
Albums
DownloadHistory
ImageComments
ImageCopyright
ImageHaarMatrix
ImageInformation
ImageMetadata
ImagePositions
ImageProperties
ImageTags
Images
Searches
Settings
Tags
TagsTree
sqlite> 


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?

regards, 

Volker

(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:
> 4;person
> 5;unknowPerson
> 10;tagKeyboardShortcut
> 25;tagKeyboardShortcut
> 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.