Bug 181545

Summary:	Digikam crashes unexpectledly while working
Product:	[Applications] digikam	Reporter:	Claus Ilginnis <claus>
Component:	Database-Mysql	Assignee:	Digikam Developers <digikam-bugs-null>
Status:	RESOLVED FIXED
Severity:	crash	CC:	andresbajotierra, caulier.gilles
Priority:	NOR
Version:	0.9.4
Target Milestone:	---
Platform:	Unlisted Binaries
OS:	Linux
Latest Commit:		Version Fixed In:	5.0.0
Sentry Crash Report:
Attachments:	Screenshot taken from start of DigiKam

Description Claus Ilginnis 2009-01-21 23:56:20 UTC

Version:           digiKam: 0.9.4  (using KDE 4.1.2)
OS:                Linux
Installed from:    Unspecified Linux

Digikam told me to submit this Bug!

This is what it told me:

sqlite_step error: database disk image is malformed on query: SELECT Albums.url||'/'||Images.name FROM Images, Albums LEFT JOIN ImageProperties on Images.id = ImageProperties.imageid WHERE ( ( (Images.dirid IN (SELECT id FROM Albums WHERE url LIKE '%winter%')) OR (Images.name LIKE '%winter%') OR (Images.id IN (SELECT ImageTags.imageid FROM ImageTags JOIN TagsTree on ImageTags.tagid = TagsTree.id WHERE TagsTree.pid = (SELECT id FROM Tags WHERE name LIKE '%winter%') OR ImageTags.tagid = (SELECT id FROM Tags WHERE name LIKE '%winter%') )) OR (Images.dirid IN (SELECT id FROM Albums WHERE caption LIKE '%winter%')) OR (Images.dirid IN (SELECT id FROM Albums WHERE collection LIKE '%winter%')) OR (Images.caption LIKE '%winter%') OR (ImageProperties.value LIKE '%winter%' and ImageProperties.property='Rating') ) ) AND (Albums.id=Images.dirid) LIMIT 500;

By the way I have Mysql

Comment 1 caulier.gilles 2009-01-22 05:56:41 UTC

Can you give us a GDB backtrace ?

Gilles Caulier

Comment 2 Claus Ilginnis 2009-01-23 11:26:37 UTC

I'll try to reproduce ... but as long as i remember there was only this error dialog ....

How do I produce a gdb backtrace?

Comment 3 caulier.gilles 2009-01-23 12:13:52 UTC

Look here :

http://www.digikam.org/drupal/contrib

Gilles Caulier

Comment 4 Claus Ilginnis 2009-01-24 00:39:33 UTC

Created attachment 30551 [details]
Screenshot taken from start of DigiKam

Comment 5 Claus Ilginnis 2009-01-24 00:40:09 UTC

(sorry too lazy to compile loaded debug symbols from ubuntu pakets)

Ok something went really wrong here..
DigiKam claims out that there are images missing.
But they still exist only the path is wrong. Look at the attachment.

Comment 6 Claus Ilginnis 2009-01-24 00:43:19 UTC

at almost any picture this error is shown:
Warning: JPEG format error, rc = 5

and there are two things I have to mention:
 * I have 64bit System
 * The images are on a samba drive (Debian) (yes i know i shouldn't but that's my primary image drive)

Comment 7 caulier.gilles 2009-05-19 15:44:20 UTC

Claus,

What's news about this entry. It still valid ?

Can you try to use digiKam 0.10.0 for KDE4 ?

Gilles Caulier

Comment 8 Dario Andres 2009-09-28 01:35:08 UTC

Marking as NEEDSINFO

Comment 9 caulier.gilles 2015-07-04 06:00:53 UTC

New digiKam 4.11.0 is available.

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

Can you reproduce the problem with this release ?

Comment 10 caulier.gilles 2016-07-02 15:38:33 UTC

With 5.0.0, the crash is not reproducible anymore.

I close this file now. Don't hesitate to re-open if necessary.

Gilles Caulier