After upgrade from 3.2.2 -> 3.4.0 can't see history

RT Users
1

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?

Thanks for the help,
Michael

2

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@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
3

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)

4

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

TomOn 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
5

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

The rt-users Archives

RT Administrator and Developer training is coming to your town soon! (Boston, San Francisco, Austin, Sydney) Contact training@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
6

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

Try stopping and then clearing out the rt3/var/mason_data directory
and then restarting.

I had the same problem with no history right after the upgrade to
3.4.1 under FastCgi. Reconfigured to mod_perl and the history
was back. Then re-re-configured back to fastcgi and the history was
was now there.

All I can think of is that something was being cached from the older
version which caused the problems. After clearing the mason_data
area, both mod_perl and fascgi instances (not running at the same
time) both look the same and has everything visable.
Tim Rosmus trosmus@nwnexus.net
Postmaster / USENET / DNS
Northwest Nexus Inc.

7

Round of applause … maybe this should be a ‘known’ in the wiki? It
worked. Thanks Tim!On Wed, Feb 16, 2005 at 11:15:03AM -0800, Tim Rosmus wrote:

On Wed, 16 Feb 2005, Tom Scholten wrote:

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

Try stopping and then clearing out the rt3/var/mason_data directory
and then restarting.

Tom Scholten

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

RT 3.2.2
Mandrake 10.1
Apache 2.0.48
FastCGI
MySQL 4
Perl 5.8.3

When I make a reply or comment via the web gui I get a blank comment
a fraction of a second before the actual comment (see example below,
and notice the time stamp).

When I make a reply via email this behavior doesn’t happen and only
the actual comment is created.

Wed Feb 23 07:18:39 2005 john - Comments added [Reply] [Comment]

Wed Feb 23 07:18:49 2005 john - Comments added [Reply] [Comment]

								Download(untitled)
								text/plain 20b

comment test
-john

Can anyone explain ??
This happens with multiple web browsers from Opera, Mozilla, Firefox and IE.

TIA

John Giles
john@trdlnk.com

9

When I make a reply or comment via the web gui I get a blank comment
a fraction of a second before the actual comment (see example below,
and notice the time stamp).
Your MySQL does not have support for InnoDB tables compiled in, or it
has been turned off in your configuration file. Because of this, MySQL
silently created non-transactional MyISAM tables instead of InnoDB
tables. You will need to use a version of MySQL which supports InnoDB
queries, and convert all MyISAM tables to Innodb using the instructions
in http://dev.mysql.com/doc/mysql/en/converting-tables-to-innodb.html

…this is now a FAQ in the wiki.

  • Alex