Facebook  Twitter 

SMFHacks.com

+-

SMFHacks.com

+- User Information

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

+- Forum Stats

Members
Total Members: 4255
Latest: andreios
New This Month: 3
New This Week: 1
New Today: 0
Stats
Total Posts: 43259
Total Topics: 7518
Most Online Today: 193
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 0
Guests: 190
Total: 190

Author Topic: Error sending newsletter  (Read 12678 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: 16436
    • 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: 16436
    • 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: 16436
    • 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: 16436
    • 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: 16436
    • 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
6990 Views
Last post October 28, 2008, 03:37:48 am
by clive
2 Replies
6449 Views
Last post December 31, 2008, 05:54:57 am
by ke4obt
7 Replies
7891 Views
Last post July 16, 2009, 12:22:14 am
by SMFHacks
3 Replies
6506 Views
Last post March 26, 2013, 01:40:57 pm
by SMFHacks
1 Replies
1255 Views
Last post July 30, 2021, 09:11:45 pm
by SMFHacks

+- Recent Topics

No thumbnails on new uploads by SMFHacks
March 27, 2024, 02:10:41 pm

Display the Contact Page for guests by SMFHacks
March 27, 2024, 10:55:43 am

is it possible to add support for odysee.com by fvlog19
March 21, 2024, 08:47:51 am

Request for admin notification by davejo
March 10, 2024, 01:31:59 am

I need help with torrent upload by Ineedsmfhelp
March 09, 2024, 10:01:13 pm

an idea for new mod (( content type with different display )) by SMFHacks
February 27, 2024, 01:36:27 pm

[Mod] RSS Feed Poster by SMFHacks
February 27, 2024, 11:57:18 am

find duplicate pictures by fvlog19
February 14, 2024, 02:22:40 pm

Error uploading video. by SMFHacks
February 08, 2024, 02:04:16 pm

Gallery icon as last added image by fvlog19
February 01, 2024, 01:04:56 pm

Powered by EzPortal