[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 #11 from Volker <neuntoeter arcor de>  2011-05-08 16:57:14 ---
Hi, 
I investigated a bit more...

I turned on mysql full logging. The last statements are the following:

------
[...]
                    2 Query     CREATE TABLE IF NOT EXISTS TagProperties
                            (tagid INTEGER,
                             property TEXT CHARACTER SET utf8,
                             value LONGTEXT CHARACTER SET utf8)
                    2 Query     CREATE TABLE IF NOT EXISTS ImageTagProperties
                            (imageid INTEGER,
                             tagid INTEGER,
                             property TEXT CHARACTER SET utf8,
                             value LONGTEXT CHARACTER SET utf8)
                    2 Query     COMMIT
                    2 Query     BEGIN WORK
                    2 Query     CALL
create_index_if_not_exists('Images','dir_index','album')
                    2 Query     COMMIT
                    2 Quit
-------

I tried to execute the "create index" manually to see what happens. When I do
this I get a collation error:
-------
volker at kiste:~$ mysql
--socket=/home/volker/Private/.kde/share/apps/digikam/db_misc/mysql.socket
Your MySQL connection id is 5
Server version: 5.1.54-1ubuntu4-log (Ubuntu)
mysql> use digikam;
mysql> SET NAMES Utf8; 
Query OK, 0 rows affected (0.00 sec)
mysql> CALL create_index_if_not_exists('Images','dir_index','album');
ERROR 1253 (42000): COLLATION 'utf8_general_ci' is not valid for CHARACTER SET
'latin1'
------- 

I'm not sure if this is the cause for the error in digikam.

I will look into it a bit more...

regards, 

Volker

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