Failure to upgrade 1.4 to 1.5

[John B. Egger]

When I booted up this afternoon there was a Digikam error box about this
failure to upgrade, with advice to move "digikam4.db" [and
"digikam3.db"] from my albums' folder and allow Digikam to recreate it.
I did so, but have lost one album's captions and tags. (The other
albums' captions and tags, thank goodness, seem OK.)

Is there any efficient way to get back the lost captions and tags? I
opened the bad "digikam4.db" (the one I'd removed from the Album folder)
using Kwrite, found the captions' text, and copy-paste'd them to a new
text file, but I'd hate to have to do that with more than that
particular album's 25 photographs.

As my signature shows, I'm using Kubuntu 10.10 with KDE 4.5.1, and
Digikam 1.4.0.

---John
Registered Linux User #291592
Kubuntu Maverick Meerkat, KDE 4.5.1

_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users

[Marcel Wiesweg]

Please note that there is no database upgrade from 1.4 to 1.5. Something else
must have gone wrong.
The command "PRAGMA integrity_check;" can check for db file corruption (but
not repair...)

> Is there any efficient way to get back the lost captions and tags? I
> opened the bad "digikam4.db" (the one I'd removed from the Album folder)
> using Kwrite, found the captions' text, and copy-paste'd them to a new
> text file, but I'd hate to have to do that with more than that
> particular album's 25 photographs.

The sqlite3 tool is able to dump a table into a text format (.dump <TABLE>).
You can also chain it:
echo .dump ImageTags | sqlite3 digikam4.db.broken | sqlite digikam4.db-new
would for example copy the ImageTags table.

Marcel
_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users

[John B. Egger]

On 12/05/2010 02:07 PM, Marcel Wiesweg wrote:

> Please note that there is no database upgrade from 1.4 to 1.5. Something else
> must have gone wrong.
> The command "PRAGMA integrity_check;" can check for db file corruption (but
> not repair...)
>
>> Is there any efficient way to get back the lost captions and tags? I
>> opened the bad "digikam4.db" (the one I'd removed from the Album folder)
>> using Kwrite, found the captions' text, and copy-paste'd them to a new
>> text file, but I'd hate to have to do that with more than that
>> particular album's 25 photographs.
> The sqlite3 tool is able to dump a table into a text format (.dump <TABLE>).
> You can also chain it:
> echo .dump ImageTags | sqlite3 digikam4.db.broken | sqlite digikam4.db-new
> would for example copy the ImageTags table.
>
> Marcel
> _______________________________________________
> Digikam-users mailing list
> [hidden email]
> https://mail.kde.org/mailman/listinfo/digikam-users
>

Thanks very much, Marcel. Obviously I'm new to Digikam and appreciate
any comments or suggestions.

--
---John
Registered Linux User #291592
Kubuntu Maverick Meerkat, KDE 4.5.1

_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users

[Dan Vy]

Mario












Sent from my iPhone

On Dec 5, 2010, at 2:07 PM, Marcel Wiesweg <[hidden email]>  
wrote:

>
> Please note that there is no database upgrade from 1.4 to 1.5.  
> Something else
> must have gone wrong.
> The command "PRAGMA integrity_check;" can check for db file  
> corruption (but
> not repair...)
>
>> Is there any efficient way to get back the lost captions and tags? I
>> opened the bad "digikam4.db" (the one I'd removed from the Album  
>> folder)
>> using Kwrite, found the captions' text, and copy-paste'd them to a  
>> new
>> text file, but I'd hate to have to do that with more than that
>> particular album's 25 photographs.
>
> The sqlite3 tool is able to dump a table into a text format (.dump  
> <TABLE>).
> You can also chain it:
> echo .dump ImageTags | sqlite3 digikam4.db.broken | sqlite  
> digikam4.db-new
> would for example copy the ImageTags table.
>
> Marcel
> _______________________________________________
> Digikam-users mailing list
> [hidden email]
> https://mail.kde.org/mailman/listinfo/digikam-users

_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users