Jim, thanks a lot for the try. But the system is running a long time without a problem and suddenly this problem occured without making a source change. My guess it's an db issue. My problem is I don't know where to start looking into the problem other then checking the db and that didn't help. Maybe some more ideas outside ? Thank you, Sven On Tuesday 10 October 2006 00:03, Jim Wright wrote:

Hi, I guess we have different versions because I dont have AgentQueueView.pm - but hopefully this will help anyway.

In Perl you can't use the @ symbol without escaping it, otherwise Perl thinks it's an array (I had this problem myself). So if you've edited any Perl files yourself and put in any @ symbols make sure you escape them.

I believe this is only necessary in strings delimited with ", eg. "webmaster@d.com", but not strings delimited with ', eg. 'webmaster@d.com'

This means, if you have this in a perl file

"foo@bar"

you need to change it to

"foo\@bar"

This could be a complete red-herring but I thought I'd throw it in incase it helps!

Good luck Jim

----- Original Message ----- From: To: Sent: Monday, October 09, 2006 2:39 AM Subject: [otrs] Software error

...

Hi,

we are using OTRS 1.3 with mysql 3.23.37 on a SuSE Linux and today we had

a

...

problem with the server. After reboot we used myisamchk -r *.MYI to check and repair the DB. Now we can still login, but a click to the "QueueView" link brings up this:

Software error:

Can't use an undefined value as an ARRAY reference at /opt/otrs//Kernel/Modules/AgentQueueView.pm line 480.

For help, please send mail to the webmaster ([no address given]), giving

this

...

error message and the time and date of the error.

Searching for tickets via the "Search" link leads to no tickets found...

Please help, as you may understand, we need the system running!

Thank you very much in advance,

Sven -- ----------------------------------------------------------------------- See our Docs, FAQs, etc at: http://snom.com/wiki -----------------------------------------------------------------------

_______________________________________________ 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 Support orr consulting for your OTRS system? => http://www.otrs.com/

-- ----------------------------------------------------------------------- See our Docs, FAQs, etc at: http://snom.com/wiki -----------------------------------------------------------------------

Maybe something more about "AgentQueueView.pm line 480", this is the source where it's complaining about: sub _MaskQueueView { my $Self = shift; my %Param = @_; my $QueueID = $Param{QueueID} || 0; my @QueuesNew = @{$Param{Queues}}; # this is line 480 my $QueueIDOfMaxAge = $Param{QueueIDOfMaxAge} || -1; my %AllQueues = %{$Param{AllQueues}}; my %Counter = (); my %UsedQueue = (); my @ListedQueues = (); my $Level = 0; $Self->{HighlightAge1} = $Self->{ConfigObject}->Get('HighlightAge1'); $Self->{HighlightAge2} = $Self->{ConfigObject}->Get('HighlightAge2'); $Self->{HighlightColor1} = $Self->{ConfigObject}->Get('HighlightColor1'); $Self->{HighlightColor2} = $Self->{ConfigObject}->Get('HighlightColor2'); my $CustomQueue = $Self->{ConfigObject}->Get('CustomQueue'); $CustomQueue = $Self->{LayoutObject}->{LanguageObject}->Get($CustomQueue); $Param{SelectedQueue} = $AllQueues{$QueueID} || $CustomQueue; my @MetaQueue = split(/::/, $Param{SelectedQueue}); $Level = $#MetaQueue+2; [...] Regards, Sven On Tuesday 10 October 2006 09:22, fischer@snom.de wrote:

Hi,

some more output from the logs:

Tue Oct 10 09:13:14 2006 error OTRS-CGI-10 Got error 127 from table handler, SQL: 'SELECT ar.id as ca, st.name, ti.id, ar.create_by, ti.create_time_unix, ti.until_time, ts.name, tst.name FROM ticket ti, article ar, article_sender_type st, ticket_state ts, ticket_state_type tst WHERE ti.ticket_lock_id not in ( 3, 1 ) AND ti.user_id = 2 AND ar.ticket_id = ti.id AND st.id = ar.article_sender_type_id AND ts.id = ti.ticket_state_id AND ts.type_id = tst.id ORDER BY ar.create_time DESC'

Tue Oct 10 08:32:06 2006 error OTRS-CGI-10 Found no $QueueID for Support::Box-Support! Tue Oct 10 08:32:06 2006 error OTRS-CGI-10 Found no $QueueID for Support::NATF-Suppo

Looks like something is wrong with QueueID ?!? Also "AgentQueueView.pm line 480" has something todo with Queues...

But still I'm receiving emails indicating new tickets.

Thanks,

Sven

On Monday 09 October 2006 11:39, fischer@snom.de wrote:

...

Hi,

we are using OTRS 1.3 with mysql 3.23.37 on a SuSE Linux and today we had a problem with the server. After reboot we used myisamchk -r *.MYI to check and repair the DB. Now we can still login, but a click to the "QueueView" link brings up this:

Software error:

Can't use an undefined value as an ARRAY reference at /opt/otrs//Kernel/Modules/AgentQueueView.pm line 480.

For help, please send mail to the webmaster ([no address given]), giving this error message and the time and date of the error.

Searching for tickets via the "Search" link leads to no tickets found...

Please help, as you may understand, we need the system running!

Thank you very much in advance,

Sven --

See our Docs, FAQs, etc at: http://snom.com/wiki -----------------------------------------------------------------------