[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