Sending Newsletter Problem >> 1053 Server shutdown in progress

[geoman]

Everything's been working just fine... until today. I can send emails and product notifications but no newsletters.

Any ideas or help would be most appreciated.

Kind regards,

GM

---

Here's my error when I try to send a newsletter:

---
Newsletter and Product Notifications Manager

1053 Server shutdown in progress
in:
[SELECT DISTINCT c.customers_email_address as customers_email_address, c.customers_lastname as customers_lastname, c.customers_firstname as customers_firstname FROM zen_customers c LEFT JOIN zen_orders o ON c.customers_id=o.customers_id WHERE o.date_purchased IS NULL ]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

2013 Lost connection to MySQL server during query
in:
[select count(*) as total from zen_sessions where sesskey = 'm1c4urn8kdvl7i9hofueq0mir5']
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

[wilt]

Hi,

have you tried to send since then.


From, your post, it just seems you were incredibly unlucky, in sending your newsletter at exactly the same time as your hosts were doing a reboot

[geoman]

I've tried repeatedly over the span of several hours. Seems to be a problem with Zencart or SQL... Not the server.

Hi,

have you tried to send since then.


From, your post, it just seems you were incredibly unlucky, in sending your newsletter at exactly the same time as your hosts were doing a reboot

[DrByte]

If you are getting repeated error messages from the SQL database, then the problem is SQL ... which ... is part of your server ... which ... is your hosting company's responsibility.
Zen Cart is just passing on the error message it received back while trying to do something that should not normally encounter an error.

[geoman]

I just backed up the database and ran the SQL patch you mentioned in an earlier post.

DELETE FROM query_builder where query_name = 'Customers who have never completed a purchase';

It worked just fine. So, where does the problem lie? Curious!

[DrByte]

Well, the record you deleted doesn't do anything to cause your MySQL server to do a shutdown.

Nevertheless, if you think it's solved and you're satisfied that everything else is just fine, I guess that's the end of the matter.
Granted, you won't be able to send a newsletter to the group whose definition you just deleted.