DailyMail error..

[bhl007]

Hi, recently my dailymail seems to stop working.

The dailymail report didn't sent to my email anymore.

So, I go to check the problem, I click on the "Run DailyMail Now" and getting the following error.

"admin-35-Can't open file: 'lm_sendp.MYI' (errno: 144)


I check the last DailyMail running date, it is "21th Jan", it looks like the dailymail is running correctly.... I'm not sure what is happening.

[DW]

Do you know how to run custom SQL queries in PhpMyAdmin?  (Login, click your ListMail database, then click SQL)

The following should do the trick:

Code: [Select]

repair table lm_sendp
Regards

[DW]

I looked up MySQL error 144:

MySQL error code 144: Table is crashed and last repair failed

You could have your host try a more-involved command-line repair, or you can recreate the table with the following SQL statements:

Code: [Select]

drop table lm_sendp

Code: [Select]

CREATE TABLE lm_sendp (
  id mediumint unsigned NOT NULL auto_increment,
  batid varchar(6) NOT NULL,
  qtype char(1) NOT NULL,
  formid varchar(14) NOT NULL,
  started datetime NOT NULL,
  lastact datetime NOT NULL,
  report TEXT NOT NULL,
  completed char(1) NOT NULL,
  PRIMARY KEY (id),
  KEY batid (batid)
)
Note: This table is meant for "queue protection" - destroying and recreating it will only affect items in queue.  If you do not have items in queue this should have no adverse effect on your installation.

I recommend running repair on your other tables.  You should be able to "Select All" tables and choose "Repair" to do them all at once.

Regards

[bhl007]

repair table do works. thanks.