ListMailPRO Email Marketing Software Forums

ListMailPRO Email Marketing Software Forums => General Help & How-To => Topic started by: bhl007 on January 21, 2007, 04:57:13 pm

Title: DailyMail error..
Post by: bhl007 on January 21, 2007, 04:57:13 pm

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.

Title: DailyMail error..
Post by: DW on January 21, 2007, 07:00:07 pm

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

Title: DailyMail error..
Post by: DW on January 21, 2007, 07:02:46 pm

I looked up MySQL error 144:

Quote

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

Title: DailyMail error..
Post by: bhl007 on January 21, 2007, 07:17:41 pm

repair table do works. thanks.