On Mon, 2007-07-16 at 00:43 +0200, Marcus Fritzsch wrote:
> Huh,
>
> the same actually happens when searching for tags --- did I missed
> something and the tag/keywords are currently under heavy development?
>
> Here is what trackerd printed when I searched for the keyword 'programming':
>
> -----snip-----
> executing keyword search on 'programming'
> Select distinct S.Path || '/' || S.Name as EntityName from Services
> S, ServiceKeywordMetaData M where S.ID = M.ServiceID and M.MetaDataID
> in (15) and M.MetaDataValue in ('programming') and (S.ServiceTypeID
> in (select TypeId from ServiceTypes where TypeName = Files or Parent =
> Files)) Limit 0,512
> query Select distinct S.Path || '/' || S.Name as EntityName from
> Services S, ServiceKeywordMetaData M where S.ID = M.ServiceID and
> M.MetaDataID in (15) and M.MetaDataValue in ('programming') and
> (S.ServiceTypeID in (select TypeId from ServiceTypes where TypeName =
> Files or Parent = Files)) Limit 0,512 failed with error : no such
> column: Files
All instances of the word Files in that query should be in single quotes
EG 'Files'
I have not noticed this before and it was working before im sure - maybe
an eeoneous patch slipped thorugh and caused the bug...
_______________________________________________
tracker-list mailing list
[email protected]
http://mail.gnome.org/mailman/listinfo/tracker-list
