Facebook  Twitter 

SMFHacks.com

+- +-

SMFHacks.com

+- User Information

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

+- Forum Stats

Members
Total Members: 11795
Latest: LaurieluvsGH
New This Month: 1
New This Week: 0
New Today: 0
Stats
Total Posts: 41468
Total Topics: 7262
Most Online Today: 79
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 0
Guests: 30
Total: 30

Author Topic: Error sending newsletter  (Read 11043 times)

0 Members and 1 Guest are viewing this topic.

Offline Vincent Volmer

  • SMF Gallery Pro Customer
  • Hero Member
  • *****
  • Posts: 517
  • SMF 2.0.17
    • View Profile
    • Digiscrap.nl
Error sending newsletter
« on: September 01, 2009, 02:07:40 am »
Hello Mr SMFHacks,

I get an error when I try to send the newsletter. 4.17% is send already (55 members) but it gives an error at this point:

Code: [Select]
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 '(ID_LETTER,email)
VALUES ('','xxxxxxxxxxxx@hetnet.nl')' at line 2
Bestand: /shared/usr/wzen1234567/DOMAIN/www.digiscrap.nl/HTML/Sources/ManageNews.php
Regel: 980

And

Code: [Select]
URL  http://digiscrap.nl/index.php?action=admin;area=news;sa=mailingsend
8: Undefined variable: ID_LETTER
Bestand: /shared/usr/wzen1234567/DOMAIN/www.digiscrap.nl/HTML/Sources/ManageNews.php
Regel: 976

I changed the email address and that didn't fix it.

Thanks,
Vincent
« Last Edit: September 01, 2009, 02:36:09 am by Vincent Volmer »

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 15689
    • View Profile
Re: Error sending newsletter
« Reply #1 on: September 01, 2009, 06:06:22 pm »
What steps are you taking to send the newsletter?
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 Vincent Volmer

  • SMF Gallery Pro Customer
  • Hero Member
  • *****
  • Posts: 517
  • SMF 2.0.17
    • View Profile
    • Digiscrap.nl
Re: Error sending newsletter
« Reply #2 on: September 02, 2009, 05:45:31 am »
What steps are you taking to send the newsletter?

1) Create message at Messages/Add Message in Newsletter Pro and saved as Nieuwsbrief Template
2) Go to Newsletter
3) - Select the membergroups
4) - Select Used Saved Message (Nieuwsbrief Template)



5) Click on Next (Volgende)


6) Click on Submit (Zenden)

At this point it starts sending the newsletter. When finished 4,17% (55 letters) it gives the error:
Code: [Select]
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 '(ID_LETTER,email)
VALUES ('','xxxxxxxxxxxx@hetnet.nl')' at line 2
Bestand: /shared/usr/wzen1234567/DOMAIN/www.digiscrap.nl/HTML/Sources/ManageNews.php
Regel: 980

SMF is not sending the newsletters all at once. Maybe thats the issue?

Vincent

Offline Vincent Volmer

  • SMF Gallery Pro Customer
  • Hero Member
  • *****
  • Posts: 517
  • SMF 2.0.17
    • View Profile
    • Digiscrap.nl
Re: Error sending newsletter
« Reply #3 on: September 06, 2009, 07:10:33 am »
 
Don't know if this was/is clear to you and if you have information enough?

Thanks,
VIncent

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 15689
    • View Profile
Re: Error sending newsletter
« Reply #4 on: September 06, 2009, 10:56:50 pm »
From what I see it is SMF 1.1.x?
Did it freeze at any time during the mailing or get stuck?
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 Vincent Volmer

  • SMF Gallery Pro Customer
  • Hero Member
  • *****
  • Posts: 517
  • SMF 2.0.17
    • View Profile
    • Digiscrap.nl
Re: Error sending newsletter
« Reply #5 on: September 06, 2009, 11:20:22 pm »
 
From what I see it is SMF 1.1.x?

I'm running SMF2.0RC1.2

Quote
Did it freeze at any time during the mailing or get stuck?

It get stuck (or it stops) after SMF is waiting 2 or 3 seconds befor sending the next couple of newsletters.

It looks like it is missing the ID_LETTER value after this 'waiting time'...... ?

Vincent

Offline Vincent Volmer

  • SMF Gallery Pro Customer
  • Hero Member
  • *****
  • Posts: 517
  • SMF 2.0.17
    • View Profile
    • Digiscrap.nl
Re: Error sending newsletter
« Reply #6 on: September 21, 2009, 07:14:37 am »
Hello Mr. SMFHacks,

Sorry for replaying to this topic but is there any news on this? On the 1st if October we want to send the next newsletter.

Thanks,
Vincent

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 15689
    • View Profile
Re: Error sending newsletter
« Reply #7 on: September 21, 2009, 07:15:59 am »
Will check it out this week.
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 Vincent Volmer

  • SMF Gallery Pro Customer
  • Hero Member
  • *****
  • Posts: 517
  • SMF 2.0.17
    • View Profile
    • Digiscrap.nl
Re: Error sending newsletter
« Reply #8 on: September 21, 2009, 07:17:16 am »
Okay, thanks

Vincent

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 15689
    • View Profile
Re: Error sending newsletter
« Reply #9 on: September 28, 2009, 11:20:50 pm »
!Fixing missing ID_LETTER if sending takes more than one page reload for SMF 2.0

Finishing up final testing hopefully by tomorrow night for a release.
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 Vincent Volmer

  • SMF Gallery Pro Customer
  • Hero Member
  • *****
  • Posts: 517
  • SMF 2.0.17
    • View Profile
    • Digiscrap.nl
Re: Error sending newsletter
« Reply #10 on: September 28, 2009, 11:27:13 pm »
 ;D :D ;D :D ;D

I'm very happy!! Thanks for your support!

Vincent  ::)

Offline Vincent Volmer

  • SMF Gallery Pro Customer
  • Hero Member
  • *****
  • Posts: 517
  • SMF 2.0.17
    • View Profile
    • Digiscrap.nl
Re: Error sending newsletter
« Reply #11 on: October 02, 2009, 03:28:47 pm »
Hello Mr. SMFHacks

Sadly..... in v2.0.2 still the same error..... and same problem. :'(
Error appears at 3.98%

Code: [Select]
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 '(ID_LETTER,email)
VALUES ('49','xxxxxxxxxx@xxxxxx.nl')' at line 2
Bestand: /shared/usr/wzen1234567/DOMAIN/www.digiscrap.nl/HTML/Sources/ManageNews.php
Regel: 1021

Error in the log:

Code: [Select]
http://digiscrap.nl/index.php?action=admin;area=news;sa=mailingsend
Databaseerror: 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 '(ID_LETTER,email)
VALUES ('49','xxxxxxxxxx@xxxxxx.nl')' at line 2
Bestand: /shared/usr/wcen7085654/DOMAIN/www.digiscrap.nl/HTML/Sources/ManageNews.php
Regel: 1021

I'm a bit sad...... what to do next?

Vincent

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 15689
    • View Profile
Re: Error sending newsletter
« Reply #12 on: October 02, 2009, 07:51:11 pm »
2.0.3
!Fixed bug in SMF 2.0 empty $context['list_tableid'] not being passed

Re grab the latest version
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 Vincent Volmer

  • SMF Gallery Pro Customer
  • Hero Member
  • *****
  • Posts: 517
  • SMF 2.0.17
    • View Profile
    • Digiscrap.nl
Re: Error sending newsletter
« Reply #13 on: October 03, 2009, 01:22:26 am »
tnx!

Will test it on the 1st of november. I already send the newsletters on the alternative way which is also working correct now.

Vincent

Offline Vincent Volmer

  • SMF Gallery Pro Customer
  • Hero Member
  • *****
  • Posts: 517
  • SMF 2.0.17
    • View Profile
    • Digiscrap.nl
Re: Error sending newsletter
« Reply #14 on: November 01, 2009, 04:14:02 am »
Hello Mr. SMFHacks,

All is working fine now. Sending the 1467 newsletters went fine (without any error...) this morning.
Great work!

And, I found some issues with the message editor but I'll post that later. Need to make some screenshots first.

Thanks, Vincent

 

Related Topics

  Subject / Started by Replies Last post
2 Replies
5838 Views
Last post October 28, 2008, 03:37:48 am
by clive
2 Replies
5036 Views
Last post December 31, 2008, 05:54:57 am
by ke4obt
7 Replies
6370 Views
Last post July 16, 2009, 12:22:14 am
by SMFHacks
3 Replies
4862 Views
Last post March 26, 2013, 01:40:57 pm
by SMFHacks
1 Replies
134 Views
Last post July 30, 2021, 09:11:45 pm
by SMFHacks

+- Recent Topics

Question (Gallery Pro) by mickjav
Today at 11:59:10 am

Image View by SMFHacks
October 14, 2021, 11:55:21 am

From SMF Gallery Lite to SMF Gallery Pro by SMFHacks
October 11, 2021, 08:00:29 am

Picture Orientation by mickjav
October 09, 2021, 01:25:54 pm

4. Global Headers and Footers by mickjav
October 07, 2021, 12:22:09 am

S3 System For SMF Attachments by shuban
October 06, 2021, 07:58:50 am

Download Page images by mickjav
October 04, 2021, 01:28:07 pm

Agree To Licence by mickjav
October 03, 2021, 10:00:27 am

Install Problems by mickjav
October 01, 2021, 01:33:14 pm

Can SMF2WPBridge bridge SMF membergroups into WP? by SMFHacks
September 30, 2021, 02:07:34 pm

Powered by EzPortal