Errors after upgrade from 3.6.5 to 4.0.13

Jonny_Schulz · June 10, 2013, 3:38pm

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

Kevin_Falcone · June 10, 2013, 3:47pm

[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.

github.com

bestpractical/rt/blob/stable/etc/schema.mysql#L21


      
            Content LONGBLOB NULL  ,
            Headers LONGTEXT NULL  ,
            Creator integer NOT NULL DEFAULT 0  ,
            Created DATETIME NULL  ,
            PRIMARY KEY (id)
          ) ENGINE=InnoDB CHARACTER SET utf8mb4;
          
          CREATE INDEX Attachments2 ON Attachments (TransactionId) ;
          CREATE INDEX Attachments3 ON Attachments (Parent, TransactionId) ;
          CREATE INDEX Attachments4 ON Attachments (Filename) ;
          
          CREATE TABLE Queues (
            id INTEGER NOT NULL  AUTO_INCREMENT,
            Name varchar(200) NOT NULL  ,
            Description varchar(255) NULL  ,
            CorrespondAddress varchar(120) NULL,
            CommentAddress varchar(120) NULL,
            Lifecycle varchar(32) NULL,
            SubjectTag varchar(120) NULL,
            SortOrder integer NOT NULL DEFAULT 0 ,
            Creator integer NOT NULL DEFAULT 0  ,

-kevin

Jonny_Schulz · June 10, 2013, 4:30pm

Hi Kevin,

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

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

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/etc/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