New Error On Sending..

[kirtchristensen]

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

[mike2]

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 ).

[kirtchristensen]

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

[DW]

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

[kirtchristensen]

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

====

[DW]

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

perror 28
Error code  28:  No space left on device

Looks like you need to free up some space !

Regards