New error with "Send an Email"

[don1]

Hello,

I have just started receiving a new error with "Send an Email".  I am currently using the latest version 1.84 of ListMailPro. I am not quite sure when this started since I do not use the "Send an Email" feature that often...but I do use it a few times a month and I think it has only started since the upgrade to 1.84.

Here is the error I am receiving whenever I try and use "Send an Email"  and then "Send this message" from the Send an Email page.

"Please wait while email is queued to send... Can't open file: 'lm_sendq.MYI' (errno: 144)"

Then nothing else happens and no message is sent.  There is no "resume" or "cancel" buttons available either.  I have tried sending from different lists with the same results.

If I use preview, the message is sent like usual, no problem.

My Dailymail is also working fine...no problems there.

Any ideas what could be causing this to happen?  Is it just my setup or is it a bug in the software?

Thanks,

Don

[DW]

Don,

I suspect there is a problem with MySQL or the lm_sendq MySQL table.  I recommend that you try the following custom MySQL queries via "PhpMyAdmin", a utility usually available in your control panel.

ANALYZE TABLE lm_sendq;

REPAIR TABLE lm_sendq;

If that fails try this:

REPAIR TABLE lm_sendq USE_FRM;

If there's a problem with the lm_sendq table it could/should cause problems with both regular emails and dailymail.

If you get this error often I recommend that you ask your host about the stability of, and disk space available to, MySQL.

Regards

[don1]

Dean,

I just realized that I forgot to thank you for replying to email...

Your suggestion fixed my problem...that was it!  Thanks.


Don

[steve]

Dean,
Talk about brining up an old thread. I've just got the same exact error as listed above.

I ran the queries as listed above, one at a time. The first two ran fine, then I tried to send an e-mail, no joy.

I ran the third query as suggested and got the following:

Code: [Select]

REPAIR TABLE lm_sendq USE_FRM
MySQL said:
#1064 - You have an error in your SQL syntax near 'USE_FRM' at line 1

Any ideas?

It looks like I'm getting the same error on both of my sites that use ListMail. They are at the same host. Maybe they made some sort of change on me? I am checking with them, but if you have any ideas...

[steve]

Dean,
Just tried to back up the database using the interface and got the error - Optimizing tables... DONE Writing backup file - Please wait... db error accessing table lm_sendp

I'm getting this error in both installations. Same server, but totally different databases.

I'm very worried about this, please respond ASAP.

Thanks,
Steve

[steve]

Damn,
After I tried to backup the database, it's now completely gone!

Exporting users, please wait..
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/webadmin/scubashackct.com/html/listmail/edituser.php on line 1084
Done
No data!

[DW]

Hi Steve,

MySQL 4.0.2 and up is required for the helpful "USE_FRM" rebuild command.

http://dev.mysql.com/doc/refman/5.0/en/repair.html

The data can possibly be recovered with a command-line repair with "myisamchk -o". (safe/slow check)  If you are not the web host ask your host for help.   If I am your host let me know your domain (via email).

Regards

[steve]

Dean,
Thanks for the reply, we just got it fixed and were able to rebuild the tables using 'repair table lm_sendp;' (Replacing lm_sendp with the table(s) at issue.

I guess it did not work for me, but they were able to get them fixed, so I'm good now.

That was not a fun few hours for me.