<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Remco,<br>
<br>
Thanks - I installed sqlite3, and ran the commands.<br>
<br>
I got 'integrity_check = ok' for both of them. This would indicate
that the databases are OK.<br>
<br>
Then I ran the second set of commands and got errors. I got the
following: Error: database or disk is full<br>
<br>
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.<br>
<br>
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).<br>
<br>
Any other ideas?<br>
<br>
Thanks,<br>
<br>
Mark.<br>
<br>
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).<br>
<br>
<blockquote cite="mid:2363420.y7Lc4pCpmp@manticore" type="cite">
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px;
margin-right:0px; -qt-block-indent:0; text-indent:0px;
-qt-user-state:0;">> </p>
<p style="-qt-paragraph-type:empty; margin-top:0px;
margin-bottom:0px; margin-left:0px; margin-right:0px;
-qt-block-indent:0; text-indent:0px; "> </p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px;
margin-right:0px; -qt-block-indent:0; text-indent:0px;
-qt-user-state:0;">Ok, that helps. A power failure could indeed
corrupt things.</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px;
margin-right:0px; -qt-block-indent:0; text-indent:0px;
-qt-user-state:0;"><a class="moz-txt-link-freetext" href="http://scribblesandsnaps.wordpress.com/2011/12/19/check-and-optimize-digikams-databases/">http://scribblesandsnaps.wordpress.com/2011/12/19/check-and-optimize-digikams-databases/</a>
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.</p>
<p style="-qt-paragraph-type:empty; margin-top:0px;
margin-bottom:0px; margin-left:0px; margin-right:0px;
-qt-block-indent:0; text-indent:0px; "> </p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px;
margin-right:0px; -qt-block-indent:0; text-indent:0px;
-qt-user-state:0;">the first two commands are the important ones
here:</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px;
margin-right:0px; -qt-block-indent:0; text-indent:0px;
-qt-user-state:0;"><span style=" font-family:'Courier
New,courier';">- sqlite3 -line digikam4.db 'pragma
integrity_check;'<br>
- sqlite3 -line thumbnails-digikam.db 'pragma
integrity_check;'</span></p>
<p style="-qt-paragraph-type:empty; margin-top:0px;
margin-bottom:0px; margin-left:0px; margin-right:0px;
-qt-block-indent:0; text-indent:0px; "> </p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px;
margin-right:0px; -qt-block-indent:0; text-indent:0px;
-qt-user-state:0;">If you get a message 'integrity_check = ok',
the problem is elsewhere, anything else and your database is
probably corrupted.</p>
<p style="-qt-paragraph-type:empty; margin-top:0px;
margin-bottom:0px; margin-left:0px; margin-right:0px;
-qt-block-indent:0; text-indent:0px; "> </p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px;
margin-right:0px; -qt-block-indent:0; text-indent:0px;
-qt-user-state:0;">Let's try this first, and see what we get.</p>
<p style="-qt-paragraph-type:empty; margin-top:0px;
margin-bottom:0px; margin-left:0px; margin-right:0px;
-qt-block-indent:0; text-indent:0px; "> </p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px;
margin-right:0px; -qt-block-indent:0; text-indent:0px;
-qt-user-state:0;">> Sorry that I can't supply more
information - but if you can let me know</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px;
margin-right:0px; -qt-block-indent:0; text-indent:0px;
-qt-user-state:0;">> any commands to run for you - will get
right back to you as soon as I can.</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px;
margin-right:0px; -qt-block-indent:0; text-indent:0px;
-qt-user-state:0;">> </p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px;
margin-right:0px; -qt-block-indent:0; text-indent:0px;
-qt-user-state:0;">> Thanks.</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px;
margin-right:0px; -qt-block-indent:0; text-indent:0px;
-qt-user-state:0;">> </p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px;
margin-right:0px; -qt-block-indent:0; text-indent:0px;
-qt-user-state:0;">> Mark.</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px;
margin-right:0px; -qt-block-indent:0; text-indent:0px;
-qt-user-state:0;">> </p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px;
margin-right:0px; -qt-block-indent:0; text-indent:0px;
-qt-user-state:0;">NP :)</p>
<p style="-qt-paragraph-type:empty; margin-top:0px;
margin-bottom:0px; margin-left:0px; margin-right:0px;
-qt-block-indent:0; text-indent:0px; "> </p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px;
margin-right:0px; -qt-block-indent:0; text-indent:0px;
-qt-user-state:0;">But, please remove any non-relevant quoted
text, it makes helping you faster and more pleasant for your
readers</p>
<p style="-qt-paragraph-type:empty; margin-top:0px;
margin-bottom:0px; margin-left:0px; margin-right:0px;
-qt-block-indent:0; text-indent:0px; "> </p>
</blockquote>
<br>
</body>
</html>