[rt-users] Re: Upgraded 3.2.1 to 3.4.4, now no ticket text

[Vance Vagell]

Hi again,

I poked around a bit, and found that there are a series of errors logged
in the apache error log each time I attempt to view a ticket.  I see no
errors in the web browser viewing the ticket, just no ticket body text.
Here are the errors from apache (this repeats each time I try to view a
ticket):

[Thu Oct 06 13:27:23 2005] [error] [client 127.0.0.1] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr: Queue->CustomFields is
deprecated, use Queue->TicketCustomFields instead
at /opt/rt3/lib/RT/Queue_Overlay.pm line 524., referer:
http://localhost/rt/
[Thu Oct 06 13:27:23 2005] [error] [client 127.0.0.1] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr: Queue->CustomFields is
deprecated, use Queue->TicketCustomFields instead
at /opt/rt3/lib/RT/Queue_Overlay.pm line 524., referer:
http://localhost/rt/
[Thu Oct 06 13:27:23 2005] [error] [client 127.0.0.1] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr: DBD::mysql::st execute failed:
Unknown column 'Transactions_1.Ticket' in 'where clause'
at /usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm line
493., referer: http://localhost/rt/
[Thu Oct 06 13:27:23 2005] [error] [client 127.0.0.1] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr: RT::Handle=HASH(0x29ae380)
couldn't execute the query 'SELECT DISTINCT main.Id AS id, main.Filename
AS filename, main.ContentType AS contenttype, main.Headers AS headers,
main.Subject AS subject, main.Parent AS parent, main.ContentEncoding AS
contentencoding, main.ContentType AS contenttype, main.TransactionId AS
transactionid, main.Created AS created FROM Attachments main ,
Transactions Transactions_1, Tickets Tickets_2  WHERE
((Tickets_2.EffectiveId = '5502')) AND ((Transactions_1.Ticket =
Tickets_2.id)) AND ((main.TransactionId = Transactions_1.id))     '
at /usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm line
507., referer: http://localhost/rt/
[Thu Oct 06 13:27:23 2005] [error] [client 127.0.0.1] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr: DBD::mysql::st execute failed:
Unknown column 'Transactions_1.Ticket' in 'where clause'
at /usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm line
493., referer: http://localhost/rt/
[Thu Oct 06 13:27:23 2005] [error] [client 127.0.0.1] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr: RT::Handle=HASH(0x29ae380)
couldn't execute the query 'SELECT DISTINCT main.Id AS id, main.Filename
AS filename, main.ContentType AS contenttype, main.Headers AS headers,
main.Subject AS subject, main.Parent AS parent, main.ContentEncoding AS
contentencoding, main.ContentType AS contenttype, main.TransactionId AS
transactionid, main.Created AS created FROM Attachments main ,
Transactions Transactions_1, Tickets Tickets_2  WHERE
((Tickets_2.EffectiveId = '5502')) AND ((Transactions_1.Ticket =
Tickets_2.id)) AND ((main.TransactionId = Transactions_1.id))     '
at /usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm line
507., referer: http://localhost/rt/
[Thu Oct 06 13:27:23 2005] [error] [client 127.0.0.1] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr: DBD::mysql::st execute failed:
Unknown column 'Transactions_1.Ticket' in 'where clause'
at /usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm line
493., referer: http://localhost/rt/
[Thu Oct 06 13:27:23 2005] [error] [client 127.0.0.1] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr: RT::Handle=HASH(0x29ae380)
couldn't execute the query 'SELECT DISTINCT main.id AS id, main.Content
AS content, main.ContentType AS contenttype, main.TransactionId AS
transactionid, main.ContentEncoding AS contentencoding FROM Attachments
main , Transactions Transactions_1, Tickets Tickets_2  WHERE
((Tickets_2.EffectiveId = '5502')) AND ((Transactions_1.Ticket =
Tickets_2.id)) AND ((main.ContentType = 'text/plain')or(main.ContentType
LIKE 'message/%')or(main.ContentType = 'text')) AND ((main.TransactionId
= Transactions_1.id))     '
at /usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm line
507., referer: http://localhost/rt/

I will continue trying to figure this out on my end, but any advice is
greatly appreciated.

- Vance

On Thu, 2005-10-06 at 13:18 -0400, Vance Vagell wrote:
> Hi all,
> 
> I have a clone of a production 3.2.1 RT installation on my local
> machine, full DB and all.  I upgraded it to 3.4.4 (latest version),
> following the instructions in the README file, including the database
> updates.  The new version works relatively well (after I moved the local
> directory to local.old, since some of the old modifications break
> things), but the text of tickets do not show up now.
> 
> For example, if you click on a ticket to bring it up, you do see the
> history of events for the ticket (i.e. emails that went out, CCs being
> added, etc.), but you do not see the actual ticket text.  I also tried
> creating a new ticket, and the same problem occurs.  I gave it some junk
> text, such as "asdkjaskdja", and when I view this ticket, there is no
> text listed.  Additionally, I tried giving my user account every
> permission possible, and I still cannot see the body of the tickets.
> 
> Any ideas?
> 
> Thanks,
> Vance
> 
>