[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


Volker <neuntoeter at arcor.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |neuntoeter at arcor.de




--- Comment #5 from Volker <neuntoeter arcor de>  2011-05-01 11:20:33 ---
I have now reproduced the same issue with digikam 1.9.0 under KDE 4.6.2.
(Kubuntu 11.04)

I have used the database migration tool to migrate from sqlite to mysql. The
migration shows no error.

The Tags and TagsTree tables are empty. The other tables e.g. Albums contain
entries.

mysql> select * from TagsTree;
Empty set (0.00 sec)

mysql> select * from Tags;
Empty set (0.00 sec)

mysql> select * from Albums;
+-----+-----------+-----------------------------------------------------------------------------------------+------------+---------+---------------------+------+
| id  | albumRoot | relativePath                                               
                            | date       | caption | collection          | icon
|
+-----+-----------+-----------------------------------------------------------------------------------------+------------+---------+---------------------+------+
|   1 |         1 | /albums                                                    
                            | 2008-09-07 | NULL    | NULL                | NULL
|
|   2 |         1 | /albums/sonstige                                           
                            | 2008-09-07 | NULL    | NULL                | NULL
|
|   3 |         1 | /albums/tiere                                              
                            | 2008-09-07 | NULL    | NULL                | NULL
|
|   4 |         1 | /albums/Birding                                            
                            | 2008-09-07 |         | Natur               | NULL
|
|   5 |         1 | /albums/Personen                                           
                            | 2008-09-07 | NULL    | NULL                | NULL
|

-- 
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.