2.4.2 dashboard does not work after upgrade

As soon as I click the new "dashboard" link :-( Software error: Can't use an undefined value as an ARRAY reference at /opt/otrs//Kernel/System/Ticket/IndexAccelerator/RuntimeDB.pm line 210. For help, please send mail to the webmaster (support@recognia.com), giving this error message and the time and date of the error. ---snip--- [root@mon-one:/opt/otrs]# perl -cw /opt/otrs//Kernel/System/Ticket/IndexAccelerator/RuntimeDB.pm /opt/otrs//Kernel/System/Ticket/IndexAccelerator/RuntimeDB.pm syntax OK -- “Don't eat anything you've ever seen advertised on TV” - Michael Pollan, author of "In Defense of Food"

Hi Alan, it seems that you do not have a standard installation. It looks that you did some changes in SysConfig regarding viewable 'lock' settings. Please be care with this kind of setting. Only change it if you know what you are doing. You have IMO 2 possible ways. a) Remove all your custom changes and all config changes to remove this error (rm Kernel/Config/Files/ZZZAuto.pm and changes done directly in Kernel/Config.pm) b) Go to hhttp://www.otrs.com/de/support/enterprise-subscription/ to get help Thanks, -Martin On Jul 31, 2009, at 16:47 , Alan McKay wrote:
As soon as I click the new "dashboard" link :-(
Software error:
Can't use an undefined value as an ARRAY reference at /opt/otrs//Kernel/System/Ticket/IndexAccelerator/RuntimeDB.pm line 210.
For help, please send mail to the webmaster (support@recognia.com), giving this error message and the time and date of the error.
---snip---
[root@mon-one:/opt/otrs]# perl -cw /opt/otrs//Kernel/System/Ticket/IndexAccelerator/RuntimeDB.pm /opt/otrs//Kernel/System/Ticket/IndexAccelerator/RuntimeDB.pm syntax OK
-- “Don't eat anything you've ever seen advertised on TV” - Michael Pollan, author of "In Defense of Food" --------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/

it seems that you do not have a standard installation. It looks that you did some changes in SysConfig regarding viewable 'lock' settings.
I have not made any changes in the area of "viewable locks". I don't even know what that is. But I can return the given files to their defaults to see what happens. thanks, -Alan -- “Don't eat anything you've ever seen advertised on TV” - Michael Pollan, author of "In Defense of Food"

OK, in Kernel/Config.pm the only changes I have are to configure the DB, and also these (I've removed their actually values) : # $DIBI$ $Self->{'FQDN'} = $Self->{'HttpType'} = $Self->{'AdminEmail'} = $Self->{'Organization'} = And that ZZZAuto file looks like this (some values change to "example.com" ): # OTRS config file (automaticaly generated!) # VERSION:1.1 package Kernel::Config::Files::ZZZAuto; sub Load { my ($File, $Self) = @_; $Self->{'Ticket::Frontend::AgentTicketClose'}->{'ArticleTypes'} = { 'note-external' => '1', 'note-internal' => '0', 'note-report' => '0' }; $Self->{'SwitchToUser'} = '1'; $Self->{'SendmailModule::Host'} = 'mail.example.com'; $Self->{'DefaultUsedLanguages'} = { 'en' => 'English', 'fr' => 'Français' }; $Self->{'Organization'} = 'Example'; $Self->{'AdminEmail'} = 'support2@example.com'; $Self->{'HttpType'} = 'https'; $Self->{'FQDN'} = 'support.example.com'; $Self->{'SecureMode'} = '1'; } 1; -- “Don't eat anything you've ever seen advertised on TV” - Michael Pollan, author of "In Defense of Food"

Hi Alan,
does the line 210 read:
. " ti.ticket_lock_id NOT IN ( ${\(join ', ', @{$Self->{ViewableLockIDs}})}
) "
-- because that was in 2.3.4
-- What is the file revison?
Please check the file from:
http://source.otrs.org/viewvc.cgi/otrs/Kernel/System/Ticket/IndexAccelerator...
Also, do you have apache::reload installed?? Otherwise
--
Michiel Beijen
Software Consultant
+31 6 - 457 42 418
Bee Free IT + http://beefreeit.nl
On Fri, Jul 31, 2009 at 17:13, Alan McKay
OK, in Kernel/Config.pm the only changes I have are to configure the DB, and also these (I've removed their actually values) :
# $DIBI$ $Self->{'FQDN'} = $Self->{'HttpType'} = $Self->{'AdminEmail'} = $Self->{'Organization'} =
And that ZZZAuto file looks like this (some values change to "example.com" ):
# OTRS config file (automaticaly generated!) # VERSION:1.1 package Kernel::Config::Files::ZZZAuto; sub Load { my ($File, $Self) = @_; $Self->{'Ticket::Frontend::AgentTicketClose'}->{'ArticleTypes'} = { 'note-external' => '1', 'note-internal' => '0', 'note-report' => '0' }; $Self->{'SwitchToUser'} = '1'; $Self->{'SendmailModule::Host'} = 'mail.example.com'; $Self->{'DefaultUsedLanguages'} = { 'en' => 'English', 'fr' => 'Français' }; $Self->{'Organization'} = 'Example'; $Self->{'AdminEmail'} = 'support2@example.com'; $Self->{'HttpType'} = 'https'; $Self->{'FQDN'} = 'support.example.com'; $Self->{'SecureMode'} = '1'; } 1;
-- “Don't eat anything you've ever seen advertised on TV” - Michael Pollan, author of "In Defense of Food" --------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/

does the line 210 read:
. " ti.ticket_lock_id NOT IN ( ${\(join ', ', @{$Self->{ViewableLockIDs}})}
. " ar.ticket_id = ti.id AND "
-- What is the file revison?
# -- # Kernel/System/Ticket/IndexAccelerator/RuntimeDB.pm - realtime database # queue ticket index module # Copyright (C) 2001-2009 OTRS AG, http://otrs.org/ # -- # $Id: RuntimeDB.pm,v 1.68 2009/03/16 08:21:13 martin Exp $ # --
Also, do you have apache::reload installed?? Otherwise
Yes, in my config file I have this : # Apache::Reload - Reload Perl Modules when Changed on Disk PerlModule Apache2::Reload PerlInitHandler Apache2::Reload PerlModule Apache2::RequestRec -- “Don't eat anything you've ever seen advertised on TV” - Michael Pollan, author of "In Defense of Food"

Hi Alan, On Jul 31, 2009, at 17:08 , Alan McKay wrote:
it seems that you do not have a standard installation. It looks that you did some changes in SysConfig regarding viewable 'lock' settings.
I have not made any changes in the area of "viewable locks".
I don't even know what that is.
But I can return the given files to their defaults to see what happens.
The source code at this point gives me this feedback. If not, please create a bug report and attach/send a support package of this installation. http://www.youtube.com/watch?v=IVljPaMqFfY THANKS! -Martin PS: It would be glad if you post your questions only on one list. Many thanks for that!

PS: It would be glad if you post your questions only on one list. Many thanks for that!
OK, sorry. It appeared to me as though there were different experts on each list so it seemed to make sense. I'll stick with english for this problem, then. -- “Don't eat anything you've ever seen advertised on TV” - Michael Pollan, author of "In Defense of Food"
participants (3)
-
Alan McKay
-
Martin Edenhofer
-
Michiel Beijen