[Digikam-users] sqlite step error

[Andi Clemens]

Can you provide us with your database? Or is the data too sensible?
I'd like to test some things... Maybe you can send me the db to my private 
mail address?

Andi

On Friday 11 July 2008 15:19:56 Markus Spring wrote:
> 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
>
> _______________________________________________
> Digikam-users mailing list
> Digikam-users at kde.org
> https://mail.kde.org/mailman/listinfo/digikam-users