Script is taking too long and SQL is timing out.

I should have thought of this before, but I changed the limit on the number of recipients per e-mail to 10.

And this time I got a 500 server error. When I checked the logs in C-panel here's what is says:

SUEXEC error_log:
--------------------------------------------------------------------------------
[2008-11-17 22:03:47]: uid: (907/alumn) gid: (908/alumn) cmd: fcgiwrapper

Does that mean anything to anybody? "alumn" is my user ID for the webhost (I altered it since this is a public board).

Again, any help would be appreciated.

-JV

Despite the 500 Server Error a number of my e-mails were received (I estimate 30-40). I will check with my web host on the error.

Server error seems to have been caused by fastCGI, which (according to my host, bluehost) doesn't handle large files very well.

Now, the module seems to send out all 180+ emails, but now I'm getting an error that says (note I've replaced my domain or account id with "[mydomain]"):

Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (15, 'php', 'MySQL server has gone away\nquery: SELECT * FROM node_type WHERE type = 'mass_contact' in /home/[mydomain]/public_html/portal/includes/database.mysql.inc on line 174.', 2, '', 'http://[mydomain].org/portal/mass_contact', 'http://[mydomain]/portal/mass_contact', '198.49.157.11', 1227549853) in /home/[mydomain]/public_html/portal/includes/database.mysql.inc on line 174

There were additional errors as well but they were similar to this one.

Here's the response from my hosting company:

[this error] mean[s] the script is running longer then 60 seconds. With MySQL everything has to run within 60 seconds or the server will go away. So you need to find a way to make the page reload after every couple items being processed. See if your script has an option to send the items out in batches.

Any suggestions?

-JV

I've changed the Priority to Critical because, without some sort of page refresh mechanism, this module is unusable with hosts that restrict BCC recipients.

-JV

I too am having the same exact issue as jvinci. I am NO longer able to send out any emails without receiving the "500 server error". I too also have BlueHost. PLEASE HELP this module is vital to my online community.

This module was working fine until the last update - now I too receive the 500 Server Error.

Please help, I really need this module to work. 500 server error is unfixable.

I'm having the same sort of error: Page not found.

Some people on my list are getting it b/c I've had some replies but I didn't get mine...

@jvinci: Does this happen whether you save a copy as a node or not?

@scotese: the versions that were updated were 6.x-1.x-dev and 5.x-2.x-dev not the 6.x-1.0-beta2 version you set this issue to. Which version are you using? If you are using 6.x-1.x-dev, maybe you could try 6.x-1.0-beta2 and see if your problem goes away. If you are using 6.x-1.0-beta2, then it is on your end, as nothing has changed in that code since October 2008.