Re: [Tracker] [BUG] tracker-tag does not list all keywords

[jamie <jamiemcc blueyonder co uk>]

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...