Zen Cart Logo
Forums / General Questions / sending email error "Query was empty"

sending email error "Query was empty"

Locked

Views: 3,195

Results 1 to 5 of 5
This thread is locked. New replies are disabled.
6 Jun 2006, 8:52 PM
#1
chac416 avatar

chac416

Zen Follower

Join Date:
May 2006
Posts:
102
Plugin Contributions:
0

sending email error "Query was empty"

so, I've just sent my first newsletter to my customers and newsletter subscribers.
We had 100s of emails.
After clicking the Send, it took a while which is normal, but the page crashed.
After refreshing, this showed ...

Please wait .. sending emails ..

Please do not interrupt this process! 1065 Query was empty

so what happened here ?? what that query error means ??

7 Jun 2006, 5:21 AM
#2
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
177

Re: sending email error "Query was empty"

The "technical" reason to get a "query was empty" message ... is that whatever query was looking for data ... came back without any data.

As to "why" you got the message on "that" page after refreshing, I have no idea.

7 Jun 2006, 5:50 PM
#3
chac416 avatar

chac416

Zen Follower

Join Date:
May 2006
Posts:
102
Plugin Contributions:
0

Re: sending email error "Query was empty"

same here. i've got no clue.
I dont know if it's from the scripts, database, or the server couldn't handle those 1000s of emails at a time...

7 Jun 2006, 8:47 PM
#4
chac416 avatar

chac416

Zen Follower

Join Date:
May 2006
Posts:
102
Plugin Contributions:
0

Re: sending email error "Query was empty"

i have just tried another mass mail a while ago, this time not using the 'Newsletter Manager' but the 'Send Email'.
same thing happened. system crashed and couldn't open page. i refreshed, it sent me back to the 'Send Email' original page...

link that the site couldn't open: "http://mysite.com/admin/mail.php?action=send_email_to_user

what is the max load that zencart script can handle. i have 6000+ subscribers and using V 1.2.6

8 Jun 2006, 3:42 AM
#5
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
177

Re: sending email error "Query was empty"

The module is configured for a 10-minute maximum for that page. You could change it to longer if your timeout is happening at the 10 minute point.

/admin/newsletters.php
line 407
zen_set_time_limit(600);

600=10 minutes

If you set it to 0, that's infinity.... which is not recommended.

The max length is dependent on long your server allows the page to process. If your server is configured to ignore the PHP "set_time_limit" setting or is forced to a "max_execution_time" that you are not allowed to override, then you're limited to whatever your hosting company has set it to.

Alternatively, you could always use the Email Address Exporter and send your newsletters from your PC...