[Digikam-users] sqlite step error

[Andi Clemens]

Another node here... this statement is right and should work:

SELECT
Albums.url||'/'||Images.name FROM Images, Albums LEFT JOIN
ImageProperties on Images.id = ImageProperties.imageid WHERE ((
Images.name LIKE '%12345%')) AND (Albums.id=Images.dirid) LIMIT 500;

These are the issues with your version:

1. the dot between Images and Albums in the second line has to be replaced by 
a comma
2. in the second line, Albums.ur has to be replaced by Albums.url

I really don't know how it's possible to get this query.
Can you describe exactly what you are searching for? What you selected in the 
search dialog? Can you provide a screenshot of that?

Andi

On Monday 07 July 2008 11:57:58 Markus Spring wrote:
> Andi Clemens schrieb:
> > Markus, have you played with the sourcecode? Otherwise I can't explain
> > why this is happening right now.
>
> No - never. I know my limits...
> What might have influenced this error is the fact that I created this
> digikam database on a non-utf8 system (debian pre-sarge) and later migrated
> the whole thing to ubuntu. As I am ultraconservative with file and
> directory names I had no trouble with this side of the migration, but I
> don't know what happens inside sqlite.
>
> Markus