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

Tom Scholten rtuser at compa.nl
Wed Feb 16 13:43:07 EST 2005


I also tried reinstalling on the testmachine (dropping db, removing old
dir etc. etc.) but same error and no display of ticket contents ...

On Wed, Feb 16, 2005 at 06:11:51PM +0100, Tom Scholten wrote:
> 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 
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> RT Administrator and Developer training is coming to your town soon! (Boston, San Francisco, Austin, Sydney) Contact training at bestpractical.com for details.
> 
> Be sure to check out the RT Wiki at http://wiki.bestpractical.com

-- 
Tom Scholten

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



More information about the rt-users mailing list