<html><head></head><body>Can you access the old database with a sqlite-tool? Maybe there's an option to dump tables to text and import it to the new one. Of course, work on a copy of the original database.<br>
<br>
Best regards,<br>
<br>
Boudewijn<br>
<br><br><div class="gmail_quote">On November 19, 2016 12:34:35 PM GMT+01:00, Mick Sulley <mick@sulley.info> wrote:<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<pre class="k9mail">I have run self check on the disk and it seems fine.<br /><br /><br />On 17/11/16 21:26, Maik Qualmann wrote:<br /><blockquote class="gmail_quote" style="margin: 0pt 0pt 1ex 0.8ex; border-left: 1px solid #729fcf; padding-left: 1ex;"> I think you should first check their hard drive. It is well possible that it<br /> has defective sectors. It would be a possible explanation for the broken<br /> digiKam DB.<br /><br /> Maik<br /><br /> On Donnerstag, 17. November 2016 21:20:30 CET Mick Sulley wrote:<br /><blockquote class="gmail_quote" style="margin: 0pt 0pt 1ex 0.8ex; border-left: 1px solid #ad7fa8; padding-left: 1ex;"> I seem to have some corruption of my database (sqlite), some pictures do<br /> not display in Digikam.<br /><br /> I just renamed my database and restarted Digikam (4.14) and it recreated<br /> the database, but the old file was 72.7 MB and the new one is 14.4 MB.<br /> The missing pictures do now display.<br /><br /> I have checked through some of the tables and there are big differences<br /> in numbers, e.g. ImageMetadata 46,949 records in the old table, 21,310<br /> in the new table.<br /><br /> I feel that to be safe and not loose data I need to restore the old<br /> database. Any comments, advise? I have loads of tags and I really<br /> don't want to loose them and see no easy way to confirm that they are<br /> all there.<br /><br /> Thanks<br /><br /> Mick<br /></blockquote><br /></blockquote><br /></pre></blockquote></div><br>
-- <br>
Sent without keyboard or normal screen, hence lacking spelling, grammar and layout in greater doses than usually</body></html>