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

[Jonny Schulz]

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.

Jonny


Am 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.
> https://github.com/bestpractical/rt/blob/stable/etc/schema.mysql#L21
>
> -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 at onvista.de
www.onvista-group.de

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