[rt-users] after upgrade from 3.2.2 -> 3.4.0 can't see history

[Tom Scholten]

Viewing the mailinglist archives i found the following mail from
Michael;
> Michael Hess mhess at greenhillsschool.org
> Sun Feb 6 19:26:18 EST 2005
> 
>     * Previous message: [rt-users] Does RT start threshing if mysql has
>     * a problem.
>     * Next message: [rt-users] Reporting and stats
>     * Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
> 
> I have upgraded from 3.2.2 to 3.4. I ran one set of schema changes.
> Everything in the web interface seems to work just great, however when I
> view a ticket, all I see is the history bar, and no comments or
> correspondence.  If I go back to 3.2.2 it works great.

> Does anyone know what is going on?
> Can I provide anyone with more information?
I can't help with it, but after upgrading both my instances (test and
prod) to 3.4.1 i experience the same problem.

>From 3.2.2 (fbsd port install) -> 3.4.1 (manual upgrade using the
tarball). I read the upgrading, made upgrade and ran the 3.3.0 and
3.3.11 upgrades from etc/upgrade as suggested (no errors/warnings) and
all seemed running fine, but when viewing a ticket i DO see the lines
what has happened, but i can't view what it is;

Zo. jan. 30 13:13:45 2005       user at somehwere - Ticket created           
Zo. jan. 30 21:29:49 2005       tom - Genomen            
Zo. jan. 30 21:33:02 2005       tom - Correspondentie toegevoegd               
Zo. jan. 30 21:33:06 2005       tom - Status veranderd van nieuw naar open

Viewing this ticket creates a errors in the webserver log shown below.
One of the main problems could be "Unknown column 'Transactions_1.Ticket'". 
I don't see any column Ticket in the Transactions table either. In this
case it shows the last two errors (ref. the sql errors) three times.

Any suggestions? Or other db-schema updates?

FastCGI:
server "/usr/local/rt3/bin/mason_handler.fcgi" stderr:
Queue->CustomFields is deprecated, use Queue->TicketCustomFields instead
at /usr/local/rt3/lib/RT/Queue_Overlay.pm line 507., referer:
http://hidden/

FastCGI:
server "/usr/local/rt3/bin/mason_handler.fcgi" stderr: DBD::mysql::st
execute failed: Unknown column 'Transactions_1.Ticket' in 'where clause'
at /usr/local/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm
line 475., referer: http://hidden/

FastCGI:
server "/usr/local/rt3/bin/mason_handler.fcgi" stderr:
RT::Handle=HASH(0x9366560) 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 =
'166')) AND ((Transactions_1.Ticket = Tickets_2.id)) AND
((main.TransactionId = Transactions_1.id)) ' at
/usr/local/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm line
489., referer: http://hidden/

-- 
Tom Scholten

       System shutdown, (A)bort, (R)etry, (I)nfluence with large hammer