Search Builder problems

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I have a REALLY strange problem going on.

There are a few tickets in the database that cant be located with Query
Builder and don’t show up on the quick search results page for the
queue. It also doesn’t show up if I do a Query Builder search on
id=.

I can enter the ticket number in the Simple Search box and the ticket
will display but if I enter the ticket subject I get nothing.

I have checked the contents in the tickets table and nothing looks out
of place.

Here is a quick rundown of the system…

RT-3.6.1 on FreeBSD 6.1 under apache, fastcgi talking to postgres 7.4.13
on remote machine.

I am attaching the contents of the system configuration page.

Any suggestions would be appreciated.

J.D. Meek
Sr. Systems Administrator
Edgenet Inc.
jdmeek@edgenet.com
Office: 615.237.3820
Cell: 615.438.9551
Fax: 615.371.3023

IBM eServer Certified Specialist

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.4 (MingW32)

iQCVAwUBRT5bvc5LTlS7P9VGAQJlyQP/ZMzCVOsm/eDhzCOK+jj4BEnnMQ11/jnI
7MlvV8i5a5je5FHVc4/AB2T0ygwUYnlH1PY6xBk7yqSJ0L1Nv+9u4pkufrEav9FN
pYFib5sIwLIL9VjilkZrQUxs9aSnhsm2rt+4RebO/wNY6utRgSHGKFqI8rwxNdmt
tNYRxXxZUWM=
=rYFD
-----END PGP SIGNATURE-----

NOTICE: This email and any attached files are confidential and intended solely for the use of the addressee. If you have received this email in error, please notify the sender and delete it immediately, without disclosing or using its contents for any purpose. Edgenet Inc. accepts no liability for any damage caused by any virus transmitted by this email.

RT-SysConfig.txt (9.23 KB)

J.D.

What are the status's of those tickets? I believe that Deleted tickets 

don’t show in a search, unless when searching by ticket #.

Kenn
LBNL

J.D. Meek wrote:

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Both were new. I opened one of them and checked the search again to
test and it still doesn’t show up.

Thanks.

J.D.

J.D.

What are the status's of those tickets? I believe that Deleted

tickets don’t show in a search, unless when searching by ticket #.

Kenn
LBNL

J.D. Meek wrote:

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I have a REALLY strange problem going on.

There are a few tickets in the database that cant be located with
Query
Builder and don’t show up on the quick search results page for the
queue. It also doesn’t show up if I do a Query Builder search on
id=.

I can enter the ticket number in the Simple Search box and the ticket
will display but if I enter the ticket subject I get nothing.

I have checked the contents in the tickets table and nothing looks out
of place.

Here is a quick rundown of the system…

RT-3.6.1 on FreeBSD 6.1 under apache, fastcgi talking to postgres
7.4.13
on remote machine.

I am attaching the contents of the system configuration page.

Any suggestions would be appreciated.

J.D. Meek
Sr. Systems Administrator
Edgenet Inc.
jdmeek@edgenet.com
Office: 615.237.3820
Cell: 615.438.9551
Fax: 615.371.3023

IBM eServer Certified Specialist

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.4 (MingW32)

iQCVAwUBRT5bvc5LTlS7P9VGAQJlyQP/ZMzCVOsm/eDhzCOK+jj4BEnnMQ11/jnI
7MlvV8i5a5je5FHVc4/AB2T0ygwUYnlH1PY6xBk7yqSJ0L1Nv+9u4pkufrEav9FN
pYFib5sIwLIL9VjilkZrQUxs9aSnhsm2rt+4RebO/wNY6utRgSHGKFqI8rwxNdmt
tNYRxXxZUWM=
=rYFD
-----END PGP SIGNATURE-----

NOTICE: This email and any attached files are confidential and
intended solely for the use of the addressee. If you have received this
email in error, please notify the sender and delete it immediately,
without disclosing or using its contents for any purpose. Edgenet Inc.
accepts no liability for any damage caused by any virus transmitted by
this email.


The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.4 (MingW32)

iQCVAwUBRT5t6s5LTlS7P9VGAQKl8QQAyzPvkl/ilqiTC3WhXN1s7bHJt5KzqwX2
K72LxAFRi5TX/IN0X7VpoTHigI32h2OIRAXQF1d9GcS5kTDRqKsC0/xMw9DOY4n7
CDyePHaErbyTL7oB92k6cCz720+3MVn3cDvks0Cg2cxtZfcljBrG9PfmphnWZvy7
92js2HHxJvk=
=cL7k
-----END PGP SIGNATURE-----

NOTICE: This email and any attached files are confidential and intended solely for the use of the addressee. If you have received this email in error, please notify the sender and delete it immediately, without disclosing or using its contents for any purpose. Edgenet Inc. accepts no liability for any damage caused by any virus transmitted by this email.