Error sending newsletter

   Community Suite
   SMF Gallery
   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
   Free SMF Hosting
   HostGator Webhosting for SMF
  
   Site Showcase

Advanced search

[Vincent Volmer]

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:

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:

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

[SMFHacks]

What steps are you taking to send the newsletter?

[Vincent Volmer]

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:

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

[Vincent Volmer]

 
Don't know if this was/is clear to you and if you have information enough?

Thanks,
VIncent

[SMFHacks]

From what I see it is SMF 1.1.x?
Did it freeze at any time during the mailing or get stuck?

[Vincent Volmer]

 

From what I see it is SMF 1.1.x?

I'm running SMF2.0RC1.2

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

[Vincent Volmer]

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

[SMFHacks]

Will check it out this week.

[Vincent Volmer]

Okay, thanks

Vincent

[SMFHacks]

!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.

[Vincent Volmer]

 

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

Vincent 

[Vincent Volmer]

Hello Mr. SMFHacks

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

Code:

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:

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

[SMFHacks]

2.0.3
!Fixed bug in SMF 2.0 empty $context['list_tableid'] not being passed

Re grab the latest version

[Vincent Volmer]

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

[Vincent Volmer]

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

Help Support the SMFHacks.com mod making.