ListMailPRO Email Marketing Software Forums

ListMailPRO Email Marketing Software Forums => General Help & How-To => Topic started by: kirtchristensen on February 08, 2007, 02:34:42 pm

Title: Getting an error when sending...
Post by: kirtchristensen on February 08, 2007, 02:34:42 pm

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

Title: Getting an error when sending...
Post by: DW on February 08, 2007, 07:43:54 pm

Hi Kirt,

Thanks for your kind comments!

This looks like a database corruption error.

Quote

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 (http://listmailpro.com/support?t=other).

Regards

Title: Getting an error when sending...
Post by: kirtchristensen on February 09, 2007, 01:01:29 pm

Yep, that worked!

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

Thanks!

Kirt Christensen

Title: Getting an error when sending...
Post by: DW on May 23, 2007, 12:40:49 pm

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 (http://dev.mysql.com/doc/refman/5.0/en/repair-table.html) on the REPAIR command.

Regards