Bug 281838 - THUMBDB : thumbnail tables are always created in images database
Summary: THUMBDB : thumbnail tables are always created in images database
Status: RESOLVED FIXED
Alias: None
Product: digikam
Classification: Applications
Component: Database-Thumbs (show other bugs)
Version: 2.2.0
Platform: Gentoo Packages Linux
: NOR major
Target Milestone: ---
Assignee: Digikam Developers
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-09-12 00:21 UTC by Francesco Riosa
Modified: 2017-06-29 14:54 UTC (History)
1 user (show)

See Also:
Latest Commit:
Version Fixed In: 5.0.0
Sentry Crash Report:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
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