Author Topic: DailyMail error..  (Read 1762 times)

bhl007

  • Posts: 75
    • View Profile
DailyMail error..
« 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.

DW

  • Administrator
  • Posts: 3787
    • View Profile
    • https://legacy.listmailpro.com
DailyMail error..
« Reply #1 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
Dean Wiebe
ListMailPRO Author & Developer - Help | Support | Hosting

DW

  • Administrator
  • Posts: 3787
    • View Profile
    • https://legacy.listmailpro.com
DailyMail error..
« Reply #2 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
Dean Wiebe
ListMailPRO Author & Developer - Help | Support | Hosting

bhl007

  • Posts: 75
    • View Profile
DailyMail error..
« Reply #3 on: January 21, 2007, 07:17:41 pm »
repair table do works. thanks.