Initial Newsletter Problems

   Community Suite
   SMF Gallery Pro
   SMF Store
   SMF Classifieds
   Newsletter Pro
   Downloads System Pro
   Ad Seller Pro
  
   Hacks and Mods
   Latest SMF Hacks
   TopTen Hacks
   Styles and Themes
   Add a Hack
   Manage Hacks
  
   Earn Money from Your Forum with these tips
   SMF Theme Generator
   SMF Package Parser
   Free SMF Hosting
   HostRocket Webhosting for SMF
  
   Site Showcase

Advanced search

[xhoster1]

@Smfhacks:

I've just attempted to send my first newsletter from my forum, which is version 1.1.11.

First off, I want to mention I really like the mod. But I have two problems preventing me from sending the newsletter this weekend:

1. I have a large list (5000) and 1320 emails were successfully sent. Three minutes later, my isp connection dropped (of course). So I clicked continue, and after no response refreshed the page. The remaining emails were sent, but with a blank newsletter.

Is this error merely the result of refreshing the page?

2. I went back in to try to send the newsletter to the 3700 members who received the blank message and received the following database error:

SELECT would examine more than MAX_JOIN_SIZE rows;

check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay

Would you please tell me exactly how the following line should read?

WHERE l.email IN ('" . implode("', '", addslashes__recursive($send_list)) . "')", __FILE__, __LINE__);

Thank you

-GL

[SMFHacks]

For #2. that is a mysql setting on what line did that error occur? It should say the line number along with the filename for the error.

[SMFHacks]

Posted an update that should help. You will need to uninstall the old version then install the new version.

2.0.6
+Optimized the select query for newsletters removed unused field membername
+Added checks to prevent blank emails from being sent out
+Added code to increase max_execution time in php in case mailing takes a little longer to help prevent connection resets

Download:
http://www.smfhacks.com/index.php/topic,2407.0.html

[xhoster1]

Thanks for the link:

I'll reinstall  to fix the problems. Do I also need to change the mysql settings?

The line I referenced is line #708

Also, do you know whether the smaller lists I have used--along with the opt-out names-- will survive the reinstall?

-GL

[SMFHacks]

Uninstalling does not remove data or lists so your data is safe.

If you get that MAX_JOIN_SIZE error again let me know I have some other options I can do. Reference: http://stackoverflow.com/questions/966815/mysql-max-join-size-errors

[xhoster1]

@Smf Hacks

-Okay, I'll look at that as well. Thanks for the detailed responses.

I'm not able to update from the link you posted. I get a "The topic or board you are looking for appears to be either missing or off limits to you" message.

-GL

[SMFHacks]

To access customer forums go to
http://www.smfhacks.com/index.php?action=license
And enter license key from the email and you will be moved to the customer group.

[xhoster1]

I'll do that

Thanks for the prompt responses

-GL

[xhoster1]

@SMFHacks

I tried sending the newsletter again tonight, after upgrading to the version you recommended.
The progress got to 97% before displaying an error. Under both the “lists” and “reports” tabs.  No e-mails were sent to any members.

I received the following errors

1.   The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay
File: /home/icfreeho/public_html/Sources/Load.php(1733) : eval()'d code
Line: 473

•   I know we’ve discussed this error and would like to modify the code, rather than select an option at start up. Please let me know if you'd like me to send you the actual line of code.

2.    Today at 09:52:13 PM
 65.103.111.253      a9ba67869d730f86e7af363f27451d58
 http://icfreehosting.com/index.php?action=news;sa=mailingsend
8: Undefined index: message
File: /home/icfreeho/public_html/Sources/ManageNews.php
Line: 521

3. Today at 09:52:13 PM
 65.103.111.253      a9ba67869d730f86e7af363f27451d58
 http://icfreehosting.com/index.php?action=news;sa=mailingsend
8: Undefined index: subject
File: /home/icfreeho/public_html/Sources/ManageNews.phpLine: 520
   
 4.    Today at 09:52:12 PM
 65.103.111.253      a9ba67869d730f86e7af363f27451d58
 http://icfreehosting.com/index.php?action=news;sa=mailingsend
8: Undefined index: emails
File: /home/icfreeho/public_html/Sources/ManageNews.php
Line: 510

Thank you
GL

[SMFHacks]

Yes please attach your Sources/ManageNews.php file

[xhoster1]

@SMF Hacks

I've attached that file for you.

Thank you!
GL

[SMFHacks]

Try this ManageNews.php attached. Added code to run SET SQL_BIG_SELECTS=1 and see if that fixes that one max join error.

rename it as ManageNews.php file attached to this post

[xhoster1]

SMFHacks

-I've noticed that your version addresses one of the issues. Does it also contain a fix for issue numbers 2, 3 and 4 from this message?

http://www.smfhacks.com/index.php/topic,5089.msg23150.html#msg23150 

I appreciate your help, but want to be confident that all the issues have been fixed before testing again

Thank you
-GL

[SMFHacks]

The file was missing some code so should help with those as well.

[xhoster1]

Thank you. I'll test it again in several days

-GL

Help Support the SMFHacks.com mod making.