[otrs] mysql - otrs problems

Morning/Afternoon, I had a few issue with crashed tables last week and haven't been able to resolve these. Since last week I have repaired all associated database tables (ALL tables), with "mysql repair table ..." and via myisamchk. Either repair function returns an all clean yet the GenericAgent.pl is still not able to select from any of the Pre-Composed Answers. It simply halts and doesn't return anything. Yet manual queries return the information out of the database just fine. See below. By manual queries I mean the select statements which are being issued through otrs to the db, what isn't happening is for the information selected out of the db to be passed back to the app. ######################################

From otrs@morphix Thu Mar 09 16:11:22 2006 Envelope-to: otrs@morphix Delivery-date: Thu, 09 Mar 2006 16:11:22 +1100 From: root@morphix (Cron Daemon) To: otrs@morphix Subject: Cron test -x $HOME/bin/GenericAgent.pl && $HOME/bin/GenericAgent.pl -c db >> /dev/null X-Cron-Env: X-Cron-Env: X-Cron-Env: X-Cron-Env: Date: Thu, 09 Mar 2006 16:10:42 +1100

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. ERROR: OTRS-GenericAgent-10 Perl: 5.8.4 OS: linux Time: Thu Mar 9 16:10:02 2006 Message: Can't open file: 'generic_agent_jobs.MYI'. (errno: 145), SQL: 'SELECT job_name FROM generic_agent_jobs' Traceback (6938): 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. ###################################### Mysql Log when selecting a pre composed answer: 33009 Query SELECT salutation, first_name, last_name, login, pw, email, customer_id, comments, valid_id, login FROM customer_user WHERE login = 'blahblah@blahblah.com mailto:'carezcgc@bigpond.com ' 33009 Query SELECT sa.value0, sa.value1 FROM system_address sa, queue sq WHERE sq.id = 5 and sa.id = sq.system_address_id 33009 Query SELECT text FROM standard_response WHERE id = 16 33009 Query SELECT text FROM salutation sa, queue sq WHERE sq.id = 5 and sq.salutation_id = sa.id 33009 Query SELECT text FROM signature si, queue sq WHERE sq.id = 5 and sq.signature_id = si.id 33009 Query SELECT login , salutation, first_name, last_name FROM customer_user WHERE login = 'blahblah@blahblah.com' LIMIT 1 ###################################### Manual queries return: mysql> SELECT salutation, first_name, last_name, login, pw, email, customer_id, comments, valid_id, login FROM customer_user WHERE login = ' mailto:'carezcgc@bigpond.com blah@blahblah.com'; Empty set (0.00 sec) mysql> SELECT sa.value0, sa.value1 FROM system_address sa, queue sq WHERE sq.id = 5 and sa.id = sq.system_address_id; +------------------------+--------------------+ | value0 | value1 | +------------------------+--------------------+ | postmaster@bigpond.com | BigPond Postmaster | +------------------------+--------------------+ 1 row in set (0.00 sec) mysql> SELECT text FROM standard_response WHERE id = 16 -> ; +-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | text | +-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Thank you for your email. The error was caused by BigPond's mail server being blacklisted as a result of a spammer on the BigPond network. We have terminated the services of the spammer and requested a de-listing of our mail server which should be effective within the next 48 hours. Plesae re-send your message. |+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec) mysql> SELECT text FROM salutation sa, queue sq WHERE sq.id = 5 and sq.salutation_id = sa.id; +--------------------------------------+ | text | +--------------------------------------+ | Dear , | +--------------------------------------+ 1 row in set (0.00 sec) mysql> SELECT text FROM signature si, queue sq WHERE sq.id = 5 and sq.signature_id = si.id; +---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | text | +---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Sincerely, Bigpond Postmaster BigPond Broadband & Dial-up Internet Access [faq] http://www.bigpond.com/help/faqs/ [email faq] http://www.bigpond.com/help/email/ [security] http://www.bigpond.com/help/security/ | +---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec) mysql> SELECT login , salutation, first_name, last_name FROM customer_user WHERE login = 'blah@blahblah.com' LIMIT 1; Empty set (0.00 sec) Any ideas anyone? ;) Rgs, 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.