ListMailPRO Email Marketing Software Forums

ListMailPRO Email Marketing Software Forums => General Help & How-To => Topic started by: dean on April 20, 2006, 10:12:00 am

Title: admin-26-Lost connection to MySQL server during query
Post by: dean on April 20, 2006, 10:12:00 am

I have a list of ~2500 subscribers on V1.85 that I am having a problem with.

About every 4th time we email this list (schedulled or manually) we get this error:

admin-26-Lost connection to MySQL server during query

'Resume' gives the same results no matter how many times we try it.

To get the mailing to go I have to delete the first record from the 'lm_sendq' table manually.

After deleting this record the I can resume the list.  At some point (again randomlly) the process again stops (after sending from 10 to 1500) again and I have to again delete the first record from  'lm_sendq' table.

Here is the last one I deleted - i don't see anything wrong with it.

 id                                                    bat       battype mtype uid    mid xtra
628c6d04c084e0e4c33f1d9fae634042  81f133 2           1        5343 135    

And the coresponding record from the 'lm_users' table:

id      uid      list      fname      lname      email      user1      user2      user3      user4      user5      user6      user7      user8      user9      user10      cseq      cdel      cnf      dateadd      ipaddr      refurl      htmail      bounces
5343    479de3a    4    Dickinson    Scott    edited@ott.net                                                      1    0    1    2005-12-15    Unknown    Imported    1    0

NOTE: Other instances of the same version on the same servers with more records have never had this problem.

Thanks,

Dean Craig

Title: admin-26-Lost connection to MySQL server during query
Post by: DW on April 20, 2006, 10:49:15 am

Hi Dean,

It seems that ListMail could be incorrectly interpreting the SMTP response for  non-existent domains on your server.  A similar issue is being discussed right now in this post (http://listmailpro.com/forum/index.php?topic=1191.0).

Would you mind submitting your information (http://listmailpro.com/support?t=other) so I can do some hands-on testing?

Regards,
DW