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

[Tom Scholten]

Then it must be something in the calling script thats wrong, because
your error shows a fail on 'ObjectId' while mine shows 'Ticket' in the
Transactions table.

Unknown column 'Transactions_1.Ticket' in 'where clause'

The ObjectId is in my schema so thats not the problem ... ill dive a
little deeper in the tarball and my own tree and try to figure where it
goes wrong, if anyone has suggestions ... thanks

Tom

On Wed, Feb 16, 2005 at 11:48:43AM -0500, Mathew Walker wrote:
> I had a very similar situation (my log is pasted below) where all my 
> History was missing.  I didn't receive any errors when running the scripts 
> originally.  I went back and re-ran the 3.3.0 and 3.3.11 upgrade scripts 
> for acl/schema/insert and voila, it started working.  not sure why the 
> re-running of the scripts fixed it...
> 
> -Mat
> 
> Feb 16 10:01:47 localhost RT: DBD::mysql::st execute failed: Unknown column 
> 'Transactions_1.ObjectId' in 'where clause' at 
> 
> 
> >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
> >>
> >>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;
> >
> >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: 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/
> >

-- 
Tom Scholten

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