[Digikam-users] sqlite step error

Markus Spring m.spring at gmx.de
Fri Jul 11 14:19:56 BST 2008


Arnd Baecker schrieb:
> No real idea. What happens if you do
>   cp digikam3.db /tmp/
>   cd /tmp
>   sqlite3 digikam3.db
>
> 
> SELECT Albums.url||'/'||Images.name FROM Albums,Images  LEFT JOIN
> ImageProperties on Images.id = ImageProperties.imageid WHERE ((Images.name
> LIKE '%1372%')) AND (Albums.id=Images.dirid) LIMIT 500;
> 
sqlite> SELECT Albums.url||'/'||Images.name FROM Albums,Images  LEFT JOIN 
ImageProperties on Images.id = ImageProperties.imageid WHERE ((Images.name LIKE 
'%1372%')) AND (Albums.id=Images.dirid) LIMIT 500;
SQL error: database disk image is malformed

Arnd, I copied your query into the sqlite3 command line and there again I get 
this error 'database disk image is malformed'

No idea where this comes from.

Markus




More information about the Digikam-users mailing list