[Digikam-devel] [Bug 277242] Using different MySQL databases for images metadata and thumbnail cache is broken

[Geoff King]

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


Geoff King <gsking1 at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |gsking1 at gmail.com




--- Comment #23 from Geoff King <gsking1 gmail com>  2011-08-24 18:29:21 ---
hello, 
I'm testing out digikam 2.0.0 using the fedora 15 kde-unstable packages and ran
into this problem. 

Failed to initialize thumbnail  ..
Error Message: The database is not valid: the "DBThumbnailsVersion" setting
does not exist. The current database schema version cannot be verified. Try to
start with an empty database.

The error message was displayed, but the program appeared to operate okay.   I
also did get an error after initial load of images, but didn't write that down.
 This was with a new mysql database and not using the migration assistant. 

Following the guidance above the following sql statements into mysql seem to
fix the problem.  

insert into digikamthumb.Settings(keyword,value)
VALUES('DBThumbnailsVersionRequired','1');
insert into digikamthumb.Settings(keyword,value)
VALUES('DBThumbnailsVersion','2');

Looks like you already have seen this, but thought I'd mention it anyway..

Geoff

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