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