Error? problem with DELETE otable query

[support6]

I received this error today when doing a mailing. The mailing goes for about 10% and then stops. When I restart, it stops again.

Any solutions?

[DW]

It sounds like your host is having some MySQL issues OR you have two copies of the same mailing running at the same time.  To be sure your previous mailing has stopped, close the window and re-login to ListMail.  You will see an item 'in queue' at the top of all ListMail pages.  Browse around the program and you will see the number of messages remaining decreasing.  Once they stop decreasing for about a minute, it's safe to Resume.  I will be implementing strict checking for active queues very soon as this seems to be a problem on a number of hosts.

Regards

[dean]

I'm on V1.84 still.

I started getting this same error "problem with DELETE otable query" after sending anywhere from a few to 50 emails out of about 1000.  I resume and the same things happens again and again until all the emails are finally sent.

I had seen this error once of twice before but resume usually worked to finsh the list after one try.

There is only one copy of the mailing running at a time and I am not having any noticable problems with mysql.  

What should I be checking with mysql to figure out if this is the issue?

Thanks!

[DW]

In my experience, this type of error has been because of the MySQL service going down or being restarted.

We might be able to obtain some more information with a small modification to admin.php to output the MySQL error.

Change this (line 1694?):

Code: [Select]

  mysql_query($cmd) or die('problem with DELETE otable query.<br>');
to:

Code: [Select]


   mysql_query($cmd) or die('problem with DELETE otable query.<br>'.mysql_error());

When it happens again please let me know the new error message.

Regards