Obviously your MySQL table is crashed (error: 145). You should repair it... http://dev.mysql.com/doc/refman/5.0/en/repair-table.html Buchner, Daniel wrote:
Weirdest thing ever. I am able to perform all operations except the ones which require the genericAgent.pl when i had a closer look I got the below. Question is - has anyone else come across this? I have not made any changes, nor has anyone else. Don't really know who or what would have removed the schema...odd.
otrs@morphix:/opt/otrs$ $HOME/bin/GenericAgent.pl -c db DBD::mysql::st execute failed: Can't open file: 'generic_agent_jobs.MYI'. (errno: 145) at /opt/otrs/Kernel/System/DB.pm line 440, <PRODUCT> line 4. mask=[Error][Kernel::System::GenericAgent::JobList][Line:638]: Can't open file: 'generic_agent_jobs.MYI'. (errno: 145), SQL: 'SELECT job_name FROM generic_agent_jobs' ERROR: OTRS-GenericAgent-10 Perl: 5.8.4 OS: linux Time: Thu Mar 9 16:38:32 2006
Message: Can't open file: 'generic_agent_jobs.MYI'. (errno: 145), SQL: 'SELECT job_name FROM generic_agent_jobs'
Traceback (7840): Module: Kernel::System::GenericAgent::JobList (v1.11 ) Line: 638 Module: /opt/otrs//bin/GenericAgent.pl (v1.36) Line: 131
DBD::mysql::st fetchrow_array failed: fetch() without execute() at /opt/otrs/Kernel/System/DB.pm line 477, <PRODUCT> line 4. arg=otrs@morphix:/opt/otrs$
Daniel Buchner BigPond Operations
Desk: +61 2 8255 0618 Mobile:+61 428 225 476 Email: daniel.buchner@team.telsra.com
The information transmitted in this document is intended only for the person or entity to whom it is addressed. It may contain confidential or privileged material. Any review, retransmission, dissemination or other use or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete all copies of the material.
------------------------------------------------------------------------
_______________________________________________ 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 oder Consulting für Ihr OTRS System? => http://www.otrs.de/