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

[Vance Vagell]

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,
Vance


On 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
> > 
> >