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

[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.
https://github.com/bestpractical/rt/blob/stable/etc/schema.mysql#L21

-kevin
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 235 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20130610/cb04b067/attachment.sig>