[rt-users] Simple search using email address fails

[Geoff Roberts]

Hi Huw,

On Thu, 25 Oct 2007 01:15:44 am Huw Selley wrote:
> Can you run that query yourself on your mysql server? At the very least you
> should get an error telling you what mysql thinks is wrong with the query
> which might help.

I ran the query on the database server itself and got the same error:

ERROR 1054 (42S22): Unknown column 'Users_3.id' in 'on clause'

If it take out: AND ( (CachedGroupMembers_2.MemberId = Users_3.id))

I don't get the error. Could it be that using Users_3 before it is defined in 
the following statement (Users as Users_3 WHERE ) is causing the problem?

Kind regards,

Geoff

-- 
___________________________________
From the desk of Geoff Roberts
Implementation Partner
AUSTRALIAN PROJECTS PTY LIMITED

S A F E   K N O W L E D G E
IT Security - Data Protection

Email: geoff at apro.com.au
Mobile: 0416 210 111

NATIONAL HELP DESK SUPPORT
Sydney          02 4231 4222
Melbourne       03 9017 8222
Adelaide        08 6461 6222
Perth           08 8463 1222
Brisbane        07 3137 1555
Hobart          03 6281 2555
Canberra        02 6112 8855
___________________________________