Errors after upgrade from 3.6.5 to 4.0.13

Hi,

I encountered an error after I upgraded from rt version 3.6.5 to 4.0.13.

The upgrade itself runs without problems and it’s possible to login.

After the login I receive the following error message:

“An internal RT error has occurred. Your administrator can find more
details in RT’s log files.”

From the logfile:

[Mon Jun 10 14:34:33 2013] [error]: The ‘message’ parameter ("Unknown
field ‘QueueObj’ in ’ Owner = ‘Nobody’ AND ( Status = ‘new’ OR Status =
‘open’ OR Status = ‘stalled’ ) AND QueueObj.HideOnPage = ‘0’ ’ at
/opt/rt4/sbin/…/lib/RT/Tickets_SQL.pm line 197.

Stack:
[/opt/rt4/sbin/…/lib/RT/Tickets_SQL.pm:197]
[/opt/rt4/sbin/…/lib/RT/SQL.pm:177]
[/opt/rt4/sbin/…/lib/RT/Tickets_SQL.pm:237]
[/opt/rt4/sbin/…/lib/RT/Tickets_SQL.pm:293]
[/opt/rt4/share/html/Elements/CollectionList:51]
[/opt/rt4/share/html/Elements/ShowSearch:54]
[/opt/rt4/share/html/Widgets/TitleBox:56]
[/opt/rt4/share/html/Elements/ShowSearch:55]
[/opt/rt4/share/html/Elements/MyRT:97]
[/opt/rt4/share/html/index.html:78]
[/opt/rt4/sbin/…/lib/RT/Interface/Web.pm:635]
[/opt/rt4/sbin/…/lib/RT/Interface/Web.pm:335]
[/opt/rt4/share/html/autohandler:53]

It’s possible to serve all other sites, only the Homepage returns this
error.

Do you have an idea?

How I upgraded:

make upgrade-database # 3.6.5 - 3.7.87
perl -I /opt/rt4/local/lib -I /opt/rt4/lib etc/upgrade/shrink_cgm_table.pl
perl etc/upgrade/split-out-cf-categories
perl -I /opt/rt4/local/lib -I /opt/rt4/lib
etc/upgrade/shrink_transactions_table.pl
perl etc/upgrade/vulnerable-passwords --fix
perl etc/upgrade/upgrade-mysql-schema.pl rt4 root xxxxxxxxx > queries.sql
mysql rt4 < queries.sql
make upgrade-database # 3.7.87 - current
cd /opt/rt4/var
rm -rf mason_data/obj/1704187875 mason_data/obj/.__obj_create_marker

The database name is rt4 because I import the database on a freshly
installed linux box.

Cheers
Jonny

[Mon Jun 10 14:34:33 2013] [error]: The ‘message’ parameter
("Unknown field ‘QueueObj’ in ’ Owner = ‘Nobody’ AND ( Status =
‘new’ OR Status = ‘open’ OR Status = ‘stalled’ ) AND
QueueObj.HideOnPage = ‘0’ ’ at
/opt/rt4/sbin/…/lib/RT/Tickets_SQL.pm line 197.

Stack:
[/opt/rt4/sbin/…/lib/RT/Tickets_SQL.pm:197]
[/opt/rt4/sbin/…/lib/RT/SQL.pm:177]
[/opt/rt4/sbin/…/lib/RT/Tickets_SQL.pm:237]
[/opt/rt4/sbin/…/lib/RT/Tickets_SQL.pm:293]
[/opt/rt4/share/html/Elements/CollectionList:51]
[/opt/rt4/share/html/Elements/ShowSearch:54]
[/opt/rt4/share/html/Widgets/TitleBox:56]
[/opt/rt4/share/html/Elements/ShowSearch:55]
[/opt/rt4/share/html/Elements/MyRT:97]
[/opt/rt4/share/html/index.html:78]
[/opt/rt4/sbin/…/lib/RT/Interface/Web.pm:635]
[/opt/rt4/sbin/…/lib/RT/Interface/Web.pm:335]
[/opt/rt4/share/html/autohandler:53]

It’s possible to serve all other sites, only the Homepage returns
this error.

Did you have a bunch of 3.6 customizations and did you port them?

HideOnPage isn’t a core Queue field and QueueObj isn’t valid
TicketSQL. If HideOnPage was a standard field, then Queue.HideOnPage
= 0 would work.

I’d start by comparing your Queues database table to the standard
schema and looking for missed customizations.

-kevin

Hi Kevin,

yes, you are right. There are tons of customizations.

The rt version was installed from the company Netways with lots of
modification. :frowning:

Thank you for your help.

JonnyAm 06/10/2013 05:47 PM, schrieb Kevin Falcone:

On Mon, Jun 10, 2013 at 05:38:06PM +0200, Jonny Schulz wrote:

[Mon Jun 10 14:34:33 2013] [error]: The ‘message’ parameter
("Unknown field ‘QueueObj’ in ’ Owner = ‘Nobody’ AND ( Status =
‘new’ OR Status = ‘open’ OR Status = ‘stalled’ ) AND
QueueObj.HideOnPage = ‘0’ ’ at
/opt/rt4/sbin/…/lib/RT/Tickets_SQL.pm line 197.

Stack:
[/opt/rt4/sbin/…/lib/RT/Tickets_SQL.pm:197]
[/opt/rt4/sbin/…/lib/RT/SQL.pm:177]
[/opt/rt4/sbin/…/lib/RT/Tickets_SQL.pm:237]
[/opt/rt4/sbin/…/lib/RT/Tickets_SQL.pm:293]
[/opt/rt4/share/html/Elements/CollectionList:51]
[/opt/rt4/share/html/Elements/ShowSearch:54]
[/opt/rt4/share/html/Widgets/TitleBox:56]
[/opt/rt4/share/html/Elements/ShowSearch:55]
[/opt/rt4/share/html/Elements/MyRT:97]
[/opt/rt4/share/html/index.html:78]
[/opt/rt4/sbin/…/lib/RT/Interface/Web.pm:635]
[/opt/rt4/sbin/…/lib/RT/Interface/Web.pm:335]
[/opt/rt4/share/html/autohandler:53]

It’s possible to serve all other sites, only the Homepage returns
this error.

Did you have a bunch of 3.6 customizations and did you port them?

HideOnPage isn’t a core Queue field and QueueObj isn’t valid
TicketSQL. If HideOnPage was a standard field, then Queue.HideOnPage
= 0 would work.

I’d start by comparing your Queues database table to the standard
schema and looking for missed customizations.
rt/schema.mysql at stable · bestpractical/rt · GitHub

-kevin

Mit freundlichen Grüßen

Jonny Schulz
Operations Specialist

OnVista Media GmbH
Sophienstr. 3
D-51149 Köln
T +49 2203 9146-129
F +49 2203 180640
E jonny.schulz@onvista.de
www.onvista-group.de

Handelsregister beim Amtsgericht Köln HRB 37240
Geschäftsführer: Lars Merle