[otrs] Software error

[fischer at snom.de]

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 at 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
-----------------------------------------------------------------------