[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