Error when adding a watcher

RT Users
1

What’s the output of:

SELECT * FROM Groups WHERE lower(Domain) ‘rt::queue-role’ AND Instance = ‘4’ AND lower(Type) = ‘cc’

Request Tracker — Best Practical Solutions – Trouble Ticketing. Free.

2

Hi,
i think that you have forget a ‘=’ (lower(Domain) = …).

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)

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’

–
Request Tracker... So much more than a help desk — Best Practical Solutions – Trouble Ticketing. Free.

rt-users mailing list
rt-users@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@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

3

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’

–
Request Tracker... So much more than a help desk — Best Practical Solutions – Trouble Ticketing. Free.

rt-users mailing list
rt-users@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@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@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

Request Tracker... So much more than a help desk — Best Practical Solutions – Trouble Ticketing. Free.

4

Jesse Vincent wrote:

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’?

By the way, I’ve tracked a recent disease with the same symptoms to an
error in the RT 3.0.8 upgrade procedure (error is unclear, probably
human failure).

5

Jesse Vincent wrote:

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’?

By the way, I’ve tracked a recent disease with the same symptoms to an
error in the RT 3.0.8 upgrade procedure (error is unclear, probably
human failure).

3.0.8 or 3.0.7? That error in 3.0.7 is what we released 3.0.7_01 to fix
several hours later.

-j

Request Tracker... So much more than a help desk — Best Practical Solutions – Trouble Ticketing. Free.