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