[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