[rt-users] Re: error when adding a watcher

[Jesse Vincent]

On Fri, Nov 21, 2003 at 07:01:45PM +0100, Malek Shabou wrote:
>  Hi,
>  i think that you have forget a '=' (lower(Domain) = ...).

Right. I cut and pasted from your logs. It was split across a line.
Sorry about that.

>  here the re result:
> 
> rt3db=> SELECT * FROM Groups WHERE lower(Domain) =  'rt::queue-role' AND Instance =  '4' AND lower(Type) =  'cc';
> id | name | description | domain | type | instance
> ----+------+-------------+--------+------+----------
> (0 lignes)

That's bad. how about all of the groups which have an instance of '4'?


> rt3db=>
> 
> 
>  Malek,
> 
> le 21 Nov, Jesse Vincent a écrit :
> > What's the output of:
> > 
> > SELECT * FROM Groups WHERE lower(Domain) 'rt::queue-role' AND Instance =  '4' AND lower(Type) =  'cc'
> > 
> > 
> > -- 
> > http://www.bestpractical.com/rt  -- Trouble Ticketing. Free.
> > _______________________________________________
> > rt-users mailing list
> > rt-users at lists.fsck.com
> > http://lists.fsck.com/mailman/listinfo/rt-users
> > 
> > Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm
> 
> -- 
> Malek Shabou				    E-mail: nic at nic.fr
> AFNIC 				            Tel: +33 1 39 30 83 00
> Immeuble international, 2 rue Stephenson    Fax: +33 1 39 30 83 01 
> Saint-Quentin-En-Yvelines 78180 Montigny-Le-Bretonneux
> 
> ### Utiliser http://www.nic.fr/zonecheck/ pour verifier vos domaines ###
> _______________________________________________
> rt-users mailing list
> rt-users at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-users
> 
> Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm
> 

-- 
http://www.bestpractical.com/rt  -- Trouble Ticketing. Free.