[rt-users] Errors after upgrade from 3.6.5 to 4.0.13

[Jonny Schulz]

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