[digikam] [Bug 372427] Some pictures do not display

[bugzilla_noreply]

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

caulier.gil...@gmail.com changed:

   What|Removed |Added

  Component|Albums-MainView |Database

-- 
You are receiving this mail because:
You are watching all bug changes.

[digikam] [Bug 372427] Some pictures do not display

[bugzilla_noreply]

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

caulier.gil...@gmail.com changed:

   What|Removed |Added

 Resolution|--- |FIXED
 Status|UNCONFIRMED |RESOLVED

-- 
You are receiving this mail because:
You are watching all bug changes.

[digikam] [Bug 372427] Some pictures do not display

[bugzilla_noreply]

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

caulier.gil...@gmail.com changed:

   What|Removed |Added

   Version Fixed In||5.4.0

--- Comment #7 from caulier.gil...@gmail.com ---
Ok, 

Thanks for your feedback and your investigations.

Gilles Caulier

-- 
You are receiving this mail because:
You are watching all bug changes.

[digikam] [Bug 372427] Some pictures do not display

[Mick Sulley]

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

--- Comment #6 from Mick Sulley  ---
Unfortunately I have largely destroyed the evidence by creating new sub albums
and copying the pictures.  However I thought I would try to see if I could find
out anything using the new appImage.  It gets a bit complicated, sorry.  This
is what I did - 

Created a guest user on my desktop (runs Mint18)
Copied my whole album to the guest account
Downloaded appImage5.4.0
Within the Album I have digikam4.db, my current database and digikam4.db.backup
which was the one in use when I had the problem.  I renamed digikam4.db as .old
and renamed digikam4.db.backup as digikam4.db to make it current again.
I then started DK5.4.0
The sub-album that had pictures missing is displayed, even though it no longer
exists!  It has thumbnails in it, but if I double click any I get the message
'Failed to load image'  File properties shows the folder that was where the
picture was, but that folder no longer exists.
I ran Rebuild Thumbnails and also Scan for new items from  Tools > Maintenance,
the indicators on the bottom of the screen went up to 100% in a few seconds,
however it took more than 2 hours before it actually finished.  When it had
finished I see the original structure with boxes displayed for thumbnails and
all the property information but no metadata.  There is no thumbnail and double
click produces the message 'Failed to load image'.  Presumably this is because
the database holds all of this information.
I then ran Sync Metadata and Database, but that doesn't seem to have changed
anything.

My conclusion to al this is that my original problem was caused by a database
corruption, what caused that I don't know.  I don't really see any point in
pursuing this any further so I suggest that you close it.
Thanks
Mick

-- 
You are receiving this mail because:
You are watching all bug changes.

[digikam] [Bug 372427] Some pictures do not display

[bugzilla_noreply]

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

--- Comment #5 from caulier.gil...@gmail.com ---

Any feedback with current AppImage bundle for Linux ?

https://drive.google.com/drive/folders/0BzeiVr-byqt5Y0tIRWVWelRJenM

Gilles Caulier

-- 
You are receiving this mail because:
You are watching all bug changes.

[digikam] [Bug 372427] Some pictures do not display

[bugzilla_noreply]

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

caulier.gil...@gmail.com changed:

   What|Removed |Added

 CC||caulier.gil...@gmail.com

--- Comment #4 from caulier.gil...@gmail.com ---
The database can be re-constructed from scratch safety if you store all DK
information in image files metadata.

In all case, make a backup of database.

Gilles Caulier

-- 
You are receiving this mail because:
You are watching all bug changes.

[digikam] [Bug 372427] Some pictures do not display

[Mick Sulley]

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

--- Comment #3 from Mick Sulley  ---
I have done a bit more investigation on this, the problem album has id = 1262. 
If I open sqlite from command line and run
select * from images where album = 1262;
it lists a load of records but finishes with 
Error: database disk image is malformed
There are also some child albums as well, a select on any of those finishes
with that error as well.  So I assume that this is why some of the pictures do
not display.
Questions
1) How can I fix it?  Can I recreate the database without losing anything?
2) What could have caused this?

-- 
You are receiving this mail because:
You are watching all bug changes.

[digikam] [Bug 372427] Some pictures do not display

[Mick Sulley]

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

--- Comment #2 from Mick Sulley  ---
(In reply to Maik Qualmann from comment #1)
> Do you use a MySQL or SQLite DB?
> 
> Maik

SQLite

-- 
You are receiving this mail because:
You are watching all bug changes.

[digikam] [Bug 372427] Some pictures do not display

[Maik Qualmann]

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

Maik Qualmann  changed:

   What|Removed |Added

 CC||metzping...@gmail.com

--- Comment #1 from Maik Qualmann  ---
Do you use a MySQL or SQLite DB?

Maik

-- 
You are receiving this mail because:
You are watching all bug changes.