Bug 281838

Summary: THUMBDB : thumbnail tables are always created in images database
Product: [Applications] digikam Reporter: Francesco Riosa <vivo75+kde>
Component: Database-ThumbsAssignee: Digikam Developers <digikam-bugs-null>
Status: RESOLVED FIXED    
Severity: major CC: caulier.gilles
Priority: NOR    
Version: 2.2.0   
Target Milestone: ---   
Platform: Gentoo Packages   
OS: Linux   
Latest Commit: http://commits.kde.org/digikam/3eefa0b7493ee7abb72d6532e618a3769e181e2f Version Fixed In: 5.0.0
Sentry Crash Report:

Description Francesco Riosa 2011-09-12 00:21:48 UTC 
Version:           2.2.0 (using KDE 4.7.1) 
OS:                Linux

the thumbnail database connection reuse an image connection?
to be fixed before 2.2.0 release

Reproducible: Always

Steps to Reproduce:
Steps to Reproduce

Actual Results:  
Actual Results 	

Expected Results:  
Expected Results
Comment 1 Marcel Wiesweg 2011-09-12 19:24:31 UTC 
May this be related to my commit 0ef1283f? I had this problem with SQLite, but no longer.
Comment 2 Francesco Riosa 2011-09-12 19:37:54 UTC 
(In reply to comment #1)
> May this be related to my commit 0ef1283f? I had this problem with SQLite, but
> no longer.

Don't think it's the cause but a simptom, investigating your commit I've noticed the issue. It's kinda minor (for mysql) as a bug but an annoying one and must be fixed before 2.2.0.
Sure I'll need to change your commit, after discovering were the real bug is. ATM it's more important that sqlite userbase stay safe however.

so thanks for noticing
Comment 3 Andi Clemens 2011-10-24 22:03:48 UTC 
What about this bug? Is it fixed? I can not reproduce the bug, but maybe I misunderstood the bug description (it was rather short).

Andi
Comment 4 Francesco Riosa 2011-10-25 13:20:14 UTC 
(In reply to comment #3)
> What about this bug? Is it fixed? I can not reproduce the bug, but maybe I
> misunderstood the bug description (it was rather short).
> 
> Andi

It's not fixed and and not an easy one, seem that sometimes connections are mixed, thumb used for image for example.

require an in-depth trip into the code
Comment 5 caulier.gilles 2012-06-22 08:50:53 UTC 
Official digiKam 2.6.0 release is out since few days now :

http://www.digikam.org/drupal/node/656

Please, check if this entry still valid, or update report accordingly.

Thanks in advance.

Gilles Caulier
Comment 6 caulier.gilles 2014-08-31 13:12:31 UTC 
Marcel,

This file still valid with current implementation from git/master ?

Gilles
Comment 7 caulier.gilles 2015-05-10 18:42:05 UTC 
Marcel, Maik,

I would to know if thumbnail info are always registered in both Sqlite DB files.

Does a clean digiKam startup can be enough to check if tables are changed/populated in both files, when thumbnails are created from GUI ?

Gilles
Comment 8 caulier.gilles 2015-06-25 13:06:08 UTC 
New digiKam 4.11.0 is available with official PKG installer for OSX.

https://www.digikam.org/node/740

Can you reproduce the problem with this release ?
Comment 9 caulier.gilles 2015-08-13 08:02:40 UTC 
digiKam 4.12.0 is out.

https://www.digikam.org/node/741

Problem still reproducible ?

Gilles Caulier
Comment 10 caulier.gilles 2015-12-02 21:30:26 UTC 
Git commit 3eefa0b7493ee7abb72d6532e618a3769e181e2f by Gilles Caulier.
Committed on 02/12/2015 at 21:28.
Pushed by cgilles into branch 'master'.

Apply patch #95866 to force use of InnoDB engine with all Mysql database table.
Related: bug 331628, bug 355831
FIXED-IN: 5.0.0

M  +3    -1    NEWS
M  +40   -21   data/database/dbconfig.xml.cmake.in

http://commits.kde.org/digikam/3eefa0b7493ee7abb72d6532e618a3769e181e2f