[rt-users] Upgrade problem from 3.2.2 to 3.4.5 regarding mysql schema

David Elze elze at bytemine.net
Fri Apr 7 17:03:48 EDT 2006


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 at bytemine.net              Fax:    (+49)(0)441 - 36116419
http://www.bytemine.net/       PGP/GPG:              5F83FEA2
bytemine  -  Entwicklungsmanufaktur fuer innovative Loesungen
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 189 bytes
Desc: Dies ist ein digital signierter Nachrichtenteil
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20060407/eeb9f936/attachment.sig>


More information about the rt-users mailing list