[Digikam-devel] [Bug 258409] Tags and TagsTree table is empty after DB migration from sqlite to mysql
Volker
neuntoeter at arcor.de
Sun May 8 15:57:15 BST 2011
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.
More information about the Digikam-devel
mailing list