How to debug RT3 better

I’m really don’t know about perl syntax but I’m very familiar with SQL. I
have still some problem with RT3 when upgraded from 3.0.5 to 3.4.5. It’s
currently working except from the approval link which doesn’t show
anything even I selected pending, approved or denied, etc. I already
posted my problem but no one seems bother to answer. I think I have some
problem with SQL query passing to database (PSQL). My question how I can
debug this problem?

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1On 4/29/2006 2:26 AM, rt3@acerhomes.com wrote:

I think I have some problem with SQL query passing to database
(PSQL). My question how I can debug this problem?

http://wiki.bestpractical.com/index.cgi?Debug


Michael S. Liebman m-liebman@northwestern.edu
http://msl521.freeshell.org/
“I have vision and the rest of the world wears bifocals.”
-Paul Newman in “Butch Cassidy & the Sundance Kid”
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.3 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFEU1Ta6UheVG5j+1cRAtRYAJ93wGlZOaPZ8aUIN6G6LdabxjdYEACgq8tH
/G8+p7PwQep/cC+9LT4IIu0=
=Su+w
-----END PGP SIGNATURE-----

It’s currently working except from the approval link which doesn’t
show anything even I > selected pending, approved or denied, etc.

One thing I found when implementing an Approvals system was that testing
is impossible without two user IDs. If you try to open a ticket needing
approval and try to approve it yourself etc., the RT mechanisms to
prevent viscious circle emails and spurious replies mess this up. Create
a test user to open tickets needing approval and if you’re using the
GUI, log them in in a separate browser (I even used IE for the test user
and firefox for the approver because if you’ve every selected “remember
my password” or whatever in a broswer, it’ll auto-log you in when you
click links in the GUI etc.). I could get nothing to appear in the
approvals section until I did this. Approvals is pretty tricky to set
up. You need lots of custom scrips and an idea of how you want it to
work. I have a system for it which may or may not be of use to people
which I can wikify if desireable. It took me a long time to make it work
but it’s not complex once it’s all working.

Hi Philip,

Thanks for your response. My approval system was working when I’am still
using 3.0.5. But after I upgraded to 3.4.5, this no longer works. I still
tried your suggestion. I checked the permissions (even select everything)
and reviewed the wiki. I checked the rt.log (full) and see nothing
there.