SQL Error when sending NewsLetter

   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

[Scoobie]

I'm getting this:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'EMAIL'),('3','EMAIL'),('3','EMAIL'),' at line 3
File: /home/ACCOUNT/public_html/Sources/ManageNews.php
Line: 531

....email addresses replaced with 'EMAIL'

When Sending a newsletter,

Sending out to 5400+ members, the script gets down to 30% or somewhere in there- had to get some pop while it was cooking & came back to this error.

Running SMF 1.1.9

[SMFHacks]

Hmm, what options did you select when creating the newsletter? What groups did you send to do? Did you copy and paste a list into the texbox?

If it was not copied and paste can you attempt to resend to the exact same people but do NOT send.

Just copy the emails to a text file and save it. Then try to search for "EMAIL" inside that text file and see if you can find it.

[Scoobie]

Selected all Groups,

Did not copy and paste a list into the textbox.- The Script did that for me,

When I posted the error message onto this forum I removed the email addresses and replaced them with 'EMAIL' to protect my users (or at least two) ...  No where in all the email addresses (text box) is there the text 'EMAIL'

The server is running a very new version of MySQL 5 something... issue?

Any thoughts?

[SMFHacks]

Any specials characters in the emails you removed such as ' or " ?
I am interested to see what caused this erorr

MySQL server version for the right syntax to use near 'EMAIL'),('3','EMAIL'),('3','EMAIL'),'

[Scoobie]

Here is the exact message w/email addresses- after you see them could you edit this message and remove? 
.. I kept it in a text file on my desktop...

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near  at line 3
File: /home/fordpint/public_html/Sources/ManageNews.php
Line: 531

[SMFHacks]

Look in your text file and look what is before 'Boyl  for that email address

[Scoobie]

k,-- Can you delete these also...

 was in the text file but the error had  om') ... Ahhhh...

SO, I've got a user that entered an email address bad,, yes?


Is that what you see?...   

[SMFHacks]

Yup that was it. the ' mesesed it up.
What you could do to send the rest is grab all the emails after the ones that were sent and send the newsletter out to those.

I am working on newslette pro 2.0 which should released after I finish the last updates for the gallery.

Help Support the SMFHacks.com mod making.