Upgraded 3.2.1 to 3.4.4, now no ticket text

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

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.

  • VanceOn 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

Problem solved. After much searching, I found this old thread from rt-
users:

http://www.gossamer-threads.com/lists/rt/users/44913?page=last

The solution is to erase the /opt/rt3/var/mason_data/obj directory.

Regards,
VanceOn Thu, 2005-10-06 at 13:31 -0400, Vance Vagell wrote:

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