mysql errors

[devafree]

Hello,
I am getting the following errors.
In vicidial Admin for a campaign (it was running OK before)

Warning: mysql_query() [function.mysql-query]: Unable to save result set in /usr/local/apache2/htdocs/vicidial/admin.php on line 6710

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /usr/local/apache2/htdocs/vicidial/admin.php on line 6711
This campaign has 0 leads to be dialed in those lists -

When I try to run AST_VDhopper.pl also the below error keeps coming : -
DBD::mysql::st fetchrow_array failed: fetch() without execute() at /usr/share/astguiclient/AST_VDhopper.pl line 961.

Please advise what to do to rectify.

Thanks
Devafree

[devafree]

Error
SQL query:

SELECT count( * ) , list_id,
STATUS , called_since_last_reset, gmt_offset_now
FROM vicidial_list
GROUP BY list_id,
STATUS , called_since_last_reset, gmt_offset_now
LIMIT 0 , 30

MySQL said:

#1030 - Got error 127 from table handler

I am used phpMyAdmin

[mflorell]

What version of MySQL are you using?

[devafree]

I am using mysql 4.0.27 and as per scratch install.

I am seeing recurring error no.145 or 144 , but disk space totally used is less than 15 %. i.e the free space available is more than 85 % on a 40 GB IDE.

I have to run >usr/bin/myisamchk -r /usr/local/var/asterisk/<tablename.MYI> to rectify. This has occurred several times. After i run this the table is OK, and the calls go well. But some of the tables is corrupted again in a few days' time.

Please help.
Devafree

[mflorell]

What versions of PHP and Apache are your running?

[devafree]

PHP version 4.4.4

Apache version 2.0.59

Thanks

Devafree

[mflorell]

Have you tested your hard drives for bad sectors?

I just did an install with those exact versions of MySQL/PHP/Apache and had no issues like this.