[rt-users] after upgrade from 3.2.2 -> 3.4.0 can't see history
Mathew Walker
lmw94002 at hotmail.com
Wed Feb 16 11:48:43 EST 2005
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: Table
'rt3.ObjectCustomFields' doesn't exist at
/usr/local/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm line 480.
(/opt/rt3/lib/RT.pm:277)
Feb 16 10:01:47 localhost RT: RT::Handle=HASH(0x93d4078) couldn't execute
the query 'SELECT main.* FROM CustomFields main , ObjectCustomFields
ObjectCustomFields_1 WHERE ((ObjectCustomFields_1.ObjectId =
'1')OR(ObjectCustomFields_1.ObjectId = '0')) AND ((main.Disabled = '0')) AND
((main.LookupType = 'RT::Queue-RT::Ticket')) AND ((main.id =
ObjectCustomFields_1.CustomField)) ORDER BY ObjectCustomFields_1.ObjectId
ASC, ObjectCustomFields_1.SortOrder ASC' at
/usr/local/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm line 494.
(/opt/rt3/lib/RT.pm:277)
Feb 16 10:01:47 localhost RT: DBD::mysql::st execute failed: Unknown column
'Transactions_1.ObjectId' in 'where clause' at
/usr/local/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm line 480.
(/opt/rt3/lib/RT.pm:277)
Feb 16 10:01:47 localhost RT: RT::Handle=HASH(0x93d4078) 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 = '7')) AND
((Transactions_1.ObjectId = Tickets_2.id)) AND ((Transactions_1.ObjectType =
'RT::Ticket')) AND ((main.TransactionId = Transactions_1.id)) ' at
/usr/local/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm line 494.
(/opt/rt3/lib/RT.pm:277)
Feb 16 10:01:47 localhost RT: DBD::mysql::st execute failed: Unknown column
'Transactions_1.ObjectId' in 'where clause' at
/usr/local/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm line 480.
(/opt/rt3/lib/RT.pm:277)
Feb 16 10:01:47 localhost RT: RT::Handle=HASH(0x93d4078) 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 = '7')) AND
((Transactions_1.ObjectId = Tickets_2.id)) AND ((Transactions_1.ObjectType =
'RT::Ticket')) AND ((main.TransactionId = Transactions_1.id)) ' at
/usr/local/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm line 494.
(/opt/rt3/lib/RT.pm:277)
Feb 16 10:01:47 localhost RT: DBD::mysql::st execute failed: Unknown column
'Transactions_1.ObjectId' in 'where clause' at
/usr/local/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm line 480.
(/opt/rt3/lib/RT.pm:277)
Feb 16 10:01:47 localhost RT: RT::Handle=HASH(0x93d4078) 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 = '7')) AND
((Transactions_1.ObjectId = Tickets_2.id)) AND ((Transactions_1.ObjectType =
'RT::Ticket')) AND ((main.ContentType = 'text/plain')or(main.ContentType
LIKE 'message/%')or(main.ContentType = 'text')) AND ((main.TransactionId =
Transactions_1.id)) ' at
/usr/local/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm line 494.
(/opt/rt3/lib/RT.pm:277)
Feb 16 10:01:47 localhost RT: DBD::mysql::st execute failed: Unknown column
'main.ObjectId' in 'where clause' at
/usr/local/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm line 480.
(/opt/rt3/lib/RT.pm:277)
Feb 16 10:01:47 localhost RT: RT::Handle=HASH(0x93d4078) couldn't execute
the query 'SELECT DISTINCT main.* FROM Transactions main , Tickets Tickets_1
WHERE ((Tickets_1.EffectiveId = '7')) AND ((main.ObjectId = Tickets_1.id))
AND ((main.ObjectType = 'RT::Ticket')) ORDER BY main.Created ASC, main.id
ASC' at /usr/local/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm
line 494. (/opt/rt3/lib/RT.pm:277)
>From: Tom Scholten <rtuser at compa.nl>
>To: rt-users at lists.bestpractical.com
>Subject: [rt-users] after upgrade from 3.2.2 -> 3.4.0 can't see history
>Date: Wed, 16 Feb 2005 12:56:28 +0100
>MIME-Version: 1.0
>Received: from diesel.bestpractical.com ([69.25.201.132]) by
>mc5-f33.hotmail.com with Microsoft SMTPSVC(6.0.3790.211); Wed, 16 Feb 2005
>04:09:10 -0800
>Received: from localhost.localdomain (localhost.localdomain [127.0.0.1])by
>diesel.bestpractical.com (Postfix) with ESMTP id AF5574D80EB;Wed, 16 Feb
>2005 07:10:31 -0500 (EST)
>Received: from mail.compa.nl (compa.nl [213.84.231.217])by
>diesel.bestpractical.com (Postfix) with ESMTP id ECAD74D80BCfor
><rt-users at lists.bestpractical.com>;Wed, 16 Feb 2005 07:10:25 -0500 (EST)
>Received: from localhost (localhost [127.0.0.1])by mail.compa.nl (Postfix)
>with ESMTP id 09D8C1CC71for <rt-users at lists.bestpractical.com>;Wed, 16 Feb
>2005 13:08:51 +0100 (CET)
>Received: from mail.compa.nl ([127.0.0.1])by localhost (archangel.compa.nl
>[127.0.0.1]) (amavisd-new, port 10024)with ESMTP id 51740-17 for
><rt-users at lists.bestpractical.com>;Wed, 16 Feb 2005 13:08:49 +0100 (CET)
>Received: by mail.compa.nl (Postfix, from userid 125)id 812E81CC70; Wed, 16
>Feb 2005 13:08:45 +0100 (CET)
>Received: from localhost (localhost [127.0.0.1])by mail.compa.nl (Postfix)
>with ESMTP id 6974D1CC85;Wed, 16 Feb 2005 12:56:32 +0100 (CET)
>Received: from mail.compa.nl ([127.0.0.1])by localhost (archangel.compa.nl
>[127.0.0.1]) (amavisd-new, port 10024)with ESMTP id 51740-15; Wed, 16 Feb
>2005 12:56:28 +0100 (CET)
>Received: by mail.compa.nl (Postfix, from userid 1001)id C08A41CC70; Wed,
>16 Feb 2005 12:56:28 +0100 (CET)
>X-Message-Info: JGTYoYF78jF9cQPQT0yRenkrtvi/WlqhGbsgr+oyrbM=
>X-Original-To: rt-users at lists.bestpractical.com
>Delivered-To: rt-users at diesel.bestpractical.com
>X-Greylist: delayed 739 seconds by postgrey-1.16 at diesel;Wed, 16 Feb 2005
>07:10:25 EST
>X-PGP-Fingerprint: 4359 6ED2 CF21 0652 302A 37A4 325B 732F A2AF 315E
>User-Agent: Mutt/1.5.6i
>X-Virus-Scanned: amavisd-new at compa.nl
>X-Virus-Scanned: amavisd-new at compa.nl
>X-BeenThere: rt-users at lists.bestpractical.com
>X-Mailman-Version: 2.1.5
>Precedence: list
>List-Id: "For users of RT: Request Tracker"
><rt-users.lists.bestpractical.com>
>List-Unsubscribe:
><http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users>,<mailto:rt-users-request at lists.bestpractical.com?subject=unsubscribe>
>List-Archive: <http://bestpractical.com/pipermail/rt-users>
>List-Post: <mailto:rt-users at lists.bestpractical.com>
>List-Help: <mailto:rt-users-request at lists.bestpractical.com?subject=help>
>List-Subscribe:
><http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users>,<mailto:rt-users-request at lists.bestpractical.com?subject=subscribe>
>Errors-To: rt-users-bounces at lists.bestpractical.com
>Return-Path: rt-users-bounces at lists.bestpractical.com
>X-OriginalArrivalTime: 16 Feb 2005 12:09:10.0918 (UTC)
>FILETIME=[52B74A60:01C51420]
>
>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
>_______________________________________________
>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
More information about the rt-users
mailing list