[Digikam-users] Thumbnail creation and updating of thumbnail database, etc.

[Mark Hayes (Hotmail)]

Remco,

Thanks - I installed sqlite3, and ran the commands.

I got 'integrity_check = ok' for both of them.  This would indicate that
the databases are OK.

Then I ran the second set of commands and got errors.  I got the
following:  Error: database or disk is full

The disk is not full - I checked using the partition editor - no
partitions are full at all.  And database sizes are a mere 21.5MB for
the digikam database and 86.0MB for the thumbnail database.

Now I'm really confused again - because the database seems OK, but I
still have very few thumbnails (and leaving the thumbnail re-creation on
for another 20 hours again last night, it was still showing 0% again
when I came back to it this evening).

Any other ideas?

Thanks,

Mark.

P.S.  I just tried adding a tag in again - and it failed.  I've expanded
all trees and I've definitely 'lost' some tags - that are no longer
showing up etc (as well as all my thumbnails).
 
>
> >
>
>  
>
> Ok, that helps. A power failure could indeed corrupt things.
>
> http://scribblesandsnaps.wordpress.com/2011/12/19/check-and-optimize-digikams-databases/
> gives you a few commands to check and correct your databases (copy
> those databases to a safe place before trying this!).You probably will
> have to install a few extra packages, the link I gave tells you which
> ones.
>
>  
>
> the first two commands are the important ones here:
>
> - sqlite3 -line digikam4.db 'pragma integrity_check;'
> - sqlite3 -line thumbnails-digikam.db 'pragma integrity_check;'
>
>  
>
> If you get a message 'integrity_check = ok', the problem is elsewhere,
> anything else and your database is probably corrupted.
>
>  
>
> Let's try this first, and see what we get.
>
>  
>
> > Sorry that I can't supply more information - but if you can let me know
>
> > any commands to run for you - will get right back to you as soon as
> I can.
>
> >
>
> > Thanks.
>
> >
>
> > Mark.
>
> >
>
> NP :)
>
>  
>
> But, please remove any non-relevant quoted text, it makes helping you
> faster and more pleasant for your readers
>
>  
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/digikam-users/attachments/20120228/be325f38/attachment.html>