vicidial.org

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

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

What version of MySQL are you using?

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

What versions of PHP and Apache are your running?

PHP version 4.4.4

Apache version 2.0.59

Thanks

Devafree

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.