Upgrade issue - Possible permissions problem? - SOLVED

Wasn’t a problem at all. I need to go back to school and learn how to
read directions :wink:

-rak

---------- ::Forwarded Message:: ----------Subject: Upgrade issue - Possible permissions problem?
Date: Thursday 01 July 2004 11:20 am
From: jeff rak jeff@theorbitor.com
To: rt-users@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@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@recres.org sent To:
jrak@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