[rt-users] Upgrade issue - Possible permissions problem? - SOLVED

[jeff rak]

Wasn't a problem at all. I need to go back to school and learn how to 
read directions ;-)

-rak

----------  ::Forwarded Message::  ----------

Subject: Upgrade issue - Possible permissions problem?
Date: Thursday 01 July 2004 11:20 am
From: jeff rak <jeff at theorbitor.com>
To: rt-users at lists.bestpractical.com

Hello all,

Just upgraded from 3.0.11 to 3.2.0. Everything seems to be working
 ok, except when I create a new ticket. As soon as I try to create a
 ticket, I'll hit submit, and it says:

RT Error:
No permission to view newly created ticket #255.

And then this shows up in the error logs:


Jul  1 11:15:50 mis-server RT: DBD::Pg::st execute failed: ERROR:
attributes: Permission denied.
at /usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder.pm line 140.
(/opt/rt3/lib/RT.pm:250)
Jul  1 11:15:50 mis-server RT: DBIx::SearchBuilder error:ERROR:
attributes: Permission denied. ^IQuery String is SELECT main.* FROM
Attributes main   WHERE ((main.ObjectId = 255)) AND ((main.ObjectType
= 'RT::Ticket'))   (/opt/rt3/lib/RT.pm:250)
Jul  1 11:15:50 mis-server RT: DBD::Pg::st fetchrow_hashref failed:
 no statement executing
at /usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder.pm line 158.
(/opt/rt3/lib/RT.pm:250)
Jul  1 11:15:50 mis-server RT:
<rt-3.2.0-255-1276-20.19.0402184022424 at recres.org> #255/1276 - Scrip
20 New ticket via Email (/opt/rt3/lib/RT/Action/SendEmail.pm:208)
Jul  1 11:15:50 mis-server RT: DBD::Pg::st fetchrow failed: no
statement executing
at /usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line
453.  (/opt/rt3/lib/RT.pm:250)
Jul  1 11:15:50 mis-server RT: DBD::Pg::st fetchrow_hashref failed:
 no statement executing
at /usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Record.pm line
908.  (/opt/rt3/lib/RT.pm:250)
Jul  1 11:15:50 mis-server RT: RT::Attachment->Create couldn't, as
 you didn't specify a transaction
(/opt/rt3/lib/RT/Attachment_Overlay.pm:121)
Jul  1 11:15:50 mis-server RT:
<rt-3.2.0-255-1276-20.19.0402184022424 at recres.org> sent To:
jrak at recres.org Cc:  Bcc:  (/opt/rt3/lib/RT/Action/SendEmail.pm:268)
Jul  1 11:15:50 mis-server RT: DBD::Pg::st fetchrow failed: no
statement executing
at /usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line
453.  (/opt/rt3/lib/RT.pm:250)
Jul  1 11:15:50 mis-server RT: DBD::Pg::st fetchrow failed: no
statement executing
at /usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line
453.  (/opt/rt3/lib/RT.pm:250)
Jul  1 11:15:50 mis-server RT: Ticket 255 created in queue 'testing'
by jrak (/opt/rt3/lib/RT/Ticket_Overlay.pm:695)
Jul  1 11:15:50 mis-server RT: WebRT: No permission to view newly
created ticket #255. () (/opt/rt3/share/html/Elements/Error:53)


System is running PostgreSQL v. 7.2.4-5.80
apache:  2.0.40-11.9

-Rak

-------------------------------------------------------