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
--
RT Training in Seattle, June 19-20: http://bestpractical.com/training
