Facebook  Twitter 

SMFHacks.com

+-

SMFHacks.com

+- User Information

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

+- Forum Stats

Members
Total Members: 4200
Latest: [chrisB]
New This Month: 4
New This Week: 1
New Today: 1
Stats
Total Posts: 42599
Total Topics: 7433
Most Online Today: 103
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 2
Guests: 49
Total: 51

Author Topic: Error sending newsletter  (Read 11383 times)

0 Members and 1 Guest are viewing this topic.

Offline Vincent Volmer

  • Hero Member
  • *****
  • Posts: 519
  • 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: 16155
    • 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

  • Hero Member
  • *****
  • Posts: 519
  • 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

  • Hero Member
  • *****
  • Posts: 519
  • 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: 16155
    • 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

  • Hero Member
  • *****
  • Posts: 519
  • 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

  • Hero Member
  • *****
  • Posts: 519
  • 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: 16155
    • 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

  • Hero Member
  • *****
  • Posts: 519
  • 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: 16155
    • 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

  • Hero Member
  • *****
  • Posts: 519
  • 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

  • Hero Member
  • *****
  • Posts: 519
  • 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: 16155
    • 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

  • Hero Member
  • *****
  • Posts: 519
  • 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

  • Hero Member
  • *****
  • Posts: 519
  • 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
6102 Views
Last post October 28, 2008, 03:37:48 am
by clive
2 Replies
5518 Views
Last post December 31, 2008, 05:54:57 am
by ke4obt
7 Replies
6918 Views
Last post July 16, 2009, 12:22:14 am
by SMFHacks
3 Replies
5399 Views
Last post March 26, 2013, 01:40:57 pm
by SMFHacks
1 Replies
736 Views
Last post July 30, 2021, 09:11:45 pm
by SMFHacks

+- Recent Topics

Errors with SMF2WPBridge by [chrisB]
Today at 10:16:59 am

Undefined index: id by SMFHacks
Today at 09:41:30 am

Permissions query by davejo
Today at 01:31:46 am

"Notify all store admins of item purchase" Not Working in SMF 2.1.2 or 2.1.3 by Michael Vail
Today at 01:02:34 am

Additional Recommendations for SMF Store by Michael Vail
November 26, 2022, 12:49:58 pm

SMF Store 5.0 Beta Errors - Trying to access array offset on value of type null by Michael Vail
November 26, 2022, 12:07:42 pm

Modification: Subcategories total in main gallery view by VisiGod
November 26, 2022, 11:27:34 am

Change log for Downloads Pro 6.13 and 6.14 by Nicole
November 20, 2022, 08:24:34 am

Release date? by SMFHacks
November 20, 2022, 08:09:10 am

Can't install due to missing file? by SMFHacks
November 18, 2022, 06:55:45 pm

Powered by EzPortal