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



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





[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]