Facebook  Twitter 

SMFHacks.com

+-

SMFHacks.com

+- User Information

Welcome, Guest.
Please login or register.
 
 
 
Forgot your password?

+- Forum Stats

Members
Total Members: 11845
Latest: SamoanOnion
New This Month: 0
New This Week: 0
New Today: 0
Stats
Total Posts: 42481
Total Topics: 7409
Most Online Today: 33
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 0
Guests: 33
Total: 33

Author Topic: SQL Error when sending NewsLetter  (Read 6905 times)

0 Members and 1 Guest are viewing this topic.

Offline Scoobie

  • Jr. Member
  • **
  • Posts: 63
    • View Profile
SQL Error when sending NewsLetter
« on: July 14, 2009, 11:11:13 pm »
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
« Last Edit: July 14, 2009, 11:17:45 pm by scoobie »

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16112
    • View Profile
Re: SQL Error when sending NewsLetter
« Reply #1 on: July 14, 2009, 11:40:56 pm »
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.
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

Offline Scoobie

  • Jr. Member
  • **
  • Posts: 63
    • View Profile
Re: SQL Error when sending NewsLetter
« Reply #2 on: July 15, 2009, 06:50:50 pm »
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?

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16112
    • View Profile
Re: SQL Error when sending NewsLetter
« Reply #3 on: July 15, 2009, 07:13:11 pm »
Any specials characters in the emails you removed such as ' or " ?
I am interested to see what caused this erorr
Quote
MySQL server version for the right syntax to use near 'EMAIL'),('3','EMAIL'),('3','EMAIL'),'
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

Offline Scoobie

  • Jr. Member
  • **
  • Posts: 63
    • View Profile
Re: SQL Error when sending NewsLetter
« Reply #4 on: July 15, 2009, 11:10:03 pm »
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
« Last Edit: July 15, 2009, 11:19:37 pm by SMFHacks »

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16112
    • View Profile
Re: SQL Error when sending NewsLetter
« Reply #5 on: July 15, 2009, 11:20:21 pm »
Look in your text file and look what is before 'Boyl  for that email address
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

Offline Scoobie

  • Jr. Member
  • **
  • Posts: 63
    • View Profile
Re: SQL Error when sending NewsLetter
« Reply #6 on: July 15, 2009, 11:40:42 pm »
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?...   
« Last Edit: July 16, 2009, 12:22:57 am by SMFHacks »

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16112
    • View Profile
Re: SQL Error when sending NewsLetter
« Reply #7 on: July 16, 2009, 12:22:14 am »
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.
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

 

Related Topics

  Subject / Started by Replies Last post
2 Replies
6089 Views
Last post October 28, 2008, 03:37:48 am
by clive
2 Replies
5476 Views
Last post December 31, 2008, 05:54:57 am
by ke4obt
14 Replies
11354 Views
Last post November 01, 2009, 04:14:02 am
by Vincent Volmer
3 Replies
5370 Views
Last post March 26, 2013, 01:40:57 pm
by SMFHacks
1 Replies
710 Views
Last post July 30, 2021, 09:11:45 pm
by SMFHacks

+- Recent Topics

Delete old file by SMFHacks
October 05, 2022, 08:11:13 am

[Feature Request] Thumbnail on topic list by Shades
October 04, 2022, 11:40:26 am

Undefined index: class_ad_seller by SMFHacks
October 04, 2022, 09:33:36 am

"Custom title" badge by Hatshepsut
September 27, 2022, 10:11:27 pm

Category Selection by Anmer
September 18, 2022, 02:40:06 am

Setting a single free download. by Zaphod
September 12, 2022, 10:18:45 pm

Error message "Data too long for column 'ipaddress' at row 1" by SMFHacks
September 12, 2022, 08:49:02 am

SMF to SMF bridge via WP by SMFHacks
September 11, 2022, 09:44:30 am

Video player included by SMFHacks
September 06, 2022, 10:26:27 pm

Upload hangs / doesn't complete by SMFHacks
August 28, 2022, 08:36:21 am

Powered by EzPortal