Upgrade problem from 3.2.2 to 3.4.5 regarding mysql schema

RT Users
1

Hi,

I successfully updated from rt 3.2.2 to 3.4.5 on OpenBSD 3.8 using
mysql, following the instructions in the readme regarding the upgrade
process and set up the schema-changes via ‘rt-setup-database’ like
mentioned without any errors on the command line. Furthermore, I removed
mason_data/obj and restarted my apache.

RT works (meaning ticket creation, comments, answers, ticket closing,
usual stuff), but unfortunately I can see the following error three
times in my logfile everytime I click on a ticket to see its details:

RT: DBD::mysql::st execute failed: Unknown column
‘Transactions_1.Ticket’ in ‘where clause’
at /usr/local/libdata/perl5/site_perl/DBIx/SearchBuilder/Handle.pm line
492. (/usr/local/lib/RT.pm:287)

This seems to be the reason that in the history of a Ticket, I can only
see lines like “Mon Apr 03 21:56:52 2006 RT_System - Outgoing email
recorded” but no content below it (which I can only view via clicking
[Show]).

In the mailinglist archives, I found this error but the only hints were
to clean the mason-cache (done) and adapt the database schema via
rt-setup-database (done).

So I reviewed my table ‘Transactions’ and the file
etc/upgrade/3.3.0/schema.mysql in the source-tree and found out, that in
rt 3.2.2 there was the column ‘Ticket’ but it is not in rt 3.4.5 any
more.

Additionally, I find the following error message in the logfile, maybe
this is related to my problem:

RT: Queue->CustomFields is deprecated, use Queue->TicketCustomFields
instead at
(HTML::Mason::Commands:/var/www/htdocs/rt/html/Ticket/Elements/ShowSummary:56) at /usr/local/lib/RT/Queue_Overlay.pm line 524. (/usr/local/lib/RT.pm:287)

If anyone has a hint or even a rtfm for me I would really appreciate it!
Thanks a lot for your time…

CU
David

David Elze Tel: (+49)(0)441 - 36116410
elze@bytemine.net Fax: (+49)(0)441 - 36116419
http://www.bytemine.net/ PGP/GPG: 5F83FEA2
bytemine - Entwicklungsmanufaktur fuer innovative Loesungen

signature.asc (189 Bytes)

2

Hi,

I successfully updated from rt 3.2.2 to 3.4.5 on OpenBSD 3.8 using
mysql, following the instructions in the readme regarding the upgrade
process and set up the schema-changes via ‘rt-setup-database’ like
mentioned without any errors on the command line. Furthermore, I removed
mason_data/obj and restarted my apache.

The error strongly suggests that you either have stale RT 3.2 mason/obj
code lying around, which might be the case if you didn’t stop apache
fully during the upgrade, or that you have some local customization or
addon that’s not compatible with 3.4.

Jesse

3

Hi,

first of all, thanks a lot for your reaction 'cause I really running out
of ideas to get rt working again :slight_smile:

The error strongly suggests that you either have stale RT 3.2 mason/obj
code lying around, which might be the case if you didn’t stop apache
fully during the upgrade,

Well, I really made sure that there is absolutely no mason/obj code
lying around anywhere on the machine. You’re right, I didn’t stop apache
while upgrading rt but did this afterwards.

So I did the upgrade-procedure again (make upgrade) while apache was
shut down and also made sure that really no mason-obj is anywhere on the
machine but the error remains the same.

or that you have some local customization or addon that’s not compatible with 3.4.

Apart from rtfm 2.0.4 there are no special knobs on my installation and
this thing should not interfere with the “normal” display of tickets,
should it!?

If there is any lead left I could follow this would be great.

CU
David

David Elze Tel: (+49)(0)441 - 36116410
elze@bytemine.net Fax: (+49)(0)441 - 36116419
http://www.bytemine.net/ PGP/GPG: 5F83FEA2
bytemine - Entwicklungsmanufaktur fuer innovative Loesungen

signature.asc (191 Bytes)

4

Hi,

for the archives: I solved it by simply deleting my old
rt/html-directory completely (datadir), copying the new files from the
rt3.4.5 source directory to it and copying my old Callbacks. I thought
‘make upgrade’ would make the appropriate changes but with my
configuration, this didn’t work out.

Again, thanks for your help Jesse!

CU
David

David Elze Tel: (+49)(0)441 - 36116410
elze@bytemine.net Fax: (+49)(0)441 - 36116419
http://www.bytemine.net/ PGP/GPG: 5F83FEA2
bytemine - Entwicklungsmanufaktur fuer innovative Loesungen

signature.asc (191 Bytes)