Getting an error when sending...

[kirtchristensen]

Hi!

I've used LMP for months, and I gotta say, it rocks!

Congrats on a great product

Right now, I'm getting an error, I've never seen before:

Please wait while email is queued to send... admin-35-Can't open file: 'lm_sendp.MYI' (errno: 144)

Get it when I try to send a broadcast message...

Thanks!

Kirt Christensen

[DW]

Hi Kirt,

Thanks for your kind comments!

This looks like a database corruption error.

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

Currently you must manually run a MySQL query to repair the database.  This can be done with a script called PhpMyAdmin, commonly available from your hosting control panel.

The command to run is as follows:

Code: [Select]

REPAIR TABLE lm_sendp;
From PhpMyAdmin you might also simply click the table and choose "Repair".

If repairing the table fails it would need to be recreated such as with the following two custom SQL queries:

Code: [Select]

DROP TABLE lm_sendp
(Note: This does not affect your data because lm_sendp is a "queue protect" table that simply stores temporary/non-sensitive data)

..and the create code

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)
);
If you absolutely require hands-on assistance for this fix please submit your info.

Regards

[kirtchristensen]

Yep, that worked!

(The "auto" repair option in PHPMYAdmin didn't work, but doing the query solved the problem...)

Thanks!

Kirt Christensen

[DW]

For further reference if the first REPAIR fails, try this (PHP 4+)

Code: [Select]

REPAIR TABLE lm_sendp USE_FRM
This should repair the table and possibly save some data.

Here's the documentation on the REPAIR command.

Regards