ListMailPRO Email Marketing Software Forums

ListMailPRO Email Marketing Software Forums => General Help & How-To => Topic started by: kirtchristensen on May 31, 2007, 12:16:35 pm

Title: New Error On Sending..
Post by: kirtchristensen on May 31, 2007, 12:16:35 pm

Hey DW,

Quick tech support question:

I got an error similiar to:

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

Prior to this (months ago) I had an error with sendp, so looking at the tables, I figured that they were both temporary tables, so I dropped the table and recreated it, the same as I had with the sendp table error a while ago...

 I guess that the tables weren't the same, I'm getting an error:

Please wait while email is queued to send... Unknown column 'bat' in 'field list'

So, long story short, can you show me how to drop and recreate the sendq table correctly?

I'm guessing that that is the issue.

Thanks!

Kirt Christensen

Title: New Error On Sending..
Post by: mike2 on June 01, 2007, 09:49:16 am

Before Dean replies you may want to try simply repairing the tables to see if that fixes it.

It would be easier if it works.  ( If you don't know how to repair them, do a search here as I remember seeing it in a few posts before ).

Title: New Error On Sending..
Post by: kirtchristensen on June 01, 2007, 10:45:28 am

Tried that, didn't work.

I'm guessing that the table (sendq) needs to be setup differently than the other one that I had trouble with (sendp) a few months ago:

http://listmailpro.com/forum/index.php?topic=1693.0

Kirt

Title: New Error On Sending..
Post by: DW on June 01, 2007, 11:57:18 am

Try repairing again.

If this doesn't work:

Code: [Select]

REPAIR TABLE lm_sendq
Try this (MySQL 4+) as it could save some of your data:

Code: [Select]

REPAIR TABLE lm_sendq USE_FRM

The creation code for the lm_sendq table for v1.87d is as follows:

Code: [Select]

CREATE TABLE lm_sendq (
  id varchar(32) NOT NULL default '',
  bat varchar(6) NOT NULL default '',
  battype char(1) NOT NULL default '',
  mtype char(1) NOT NULL default '',
  uid mediumint(9) unsigned NOT NULL default '0',
  mid varchar(10) NOT NULL default '',
  xtra varchar(10) NOT NULL default '',
  PRIMARY KEY  (id)
);
Regards

Title: New Error On Sending..
Post by: kirtchristensen on June 01, 2007, 01:05:57 pm

Hi Dean,

Here's what I'm getting now:

====

SQL query:

CREATE TABLE lm_sendq(

id varchar( 32 ) NOT NULL default '',
bat varchar( 6 ) NOT NULL default '',
battype char( 1 ) NOT NULL default '',
mtype char( 1 ) NOT NULL default '',
uid mediumint( 9 ) unsigned NOT NULL default '0',
mid varchar( 10 ) NOT NULL default '',
xtra varchar( 10 ) NOT NULL default '',
PRIMARY KEY ( id )
)
MySQL said:  

#1 - Can't create/write to file './listmailpro/lm_sendq.MYD' (Errcode: 28

====

Title: New Error On Sending..
Post by: DW on June 03, 2007, 04:25:54 am

With access to a linux shell you can investigate error #s by using "perror":

Quote

perror 28
Error code  28:  No space left on device

Looks like you need to free up some space !

Regards