Torsten Brumm wrote:
Hi RT Users,
I think, i found a bug, or i'm too dumb.
I'm trying the following query (from within a website, but also occurs
from the Query Builder)
( Queue = 'GAI_ABF_NW' ) AND ( 'CF.{Tournummer}' = '03376' OR
'CF.{Tournummer}' = '03361' ) AND ( Status = 'new' OR
Hi Rangarajan,
Here is the Output at the error log:
[Mon May 08 16:26:20 2006] [error] [client 10.63.253.97] FastCGI: server
/opt/rt3/bin/mason_handler.fcgi stderr: RR: SearchBuilder.pm:
_DoSearch: QueryString is: SELECT DISTINCT main.* FROM (GroupMembers
main LEFT JOIN Groups Groups_1 ON
Appears that the problem is happening because of presence of main.name
= 'Tournummer'.
The problem happens because main is an alias for Tickets table and the
Tickets table has no column called name.
What you run this SELECT query against the database (I deal with oracle,
you with MySQL) you