Montego Scripts: Forums
 

 

View next topic
View previous topic
Post new topic   Reply to topic
Author Message
xGSTQ
Newbie
Newbie



Joined: Jun 13, 2006
Posts: 40

PostPosted: Sat Jul 22, 2006 7:35 pm Reply with quote

Hi

I just recieved this error whilst sending my first newsletter out

Quote:
ENCOUNTERED ERROR IN SQL: 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 's July 2006 Newsletter', 'Admin', '1153611267.php', '2006-07-22

SQL = INSERT INTO `nuke_hnl_newsletters` VALUES (NULL, '2', 'UDesign Me's July 2006 Newsletter', 'Admin', '1153611267.php', '2006-07-22', '1', '', '0')

ERROR IN MODULE: HTML_Newsletter

ERROR MSG: Was not able to insert the newsletter into the database


Ive modified the Deep Blue template for one of my own, i was wondering if this could be the problem ?

Strange thing is i can send it to myself as admin and it works fine ?

Im using 7.6 Ultra which is platinum based.

Thx Ped
 
View user's profile Send private message
xGSTQ
Newbie
Newbie



Joined: Jun 13, 2006
Posts: 40

PostPosted: Sun Jul 23, 2006 11:07 am Reply with quote

another little question is probably my error !!

my modified template is http://www.udesign.me.uk/modules.php?name=HTML_Newsletter&op=msnl_nls_view&msnl_nid=17

Now when i send it out as a test to the admin all the links turn to the horrible blue/purple colour http://www.upixs.com/87/Tghi0/5234.jpg

is there an easy way around this that you know off ?

thx


Last edited by xGSTQ on Sun Jul 23, 2006 4:34 pm; edited 1 time in total 
View user's profile Send private message
xGSTQ
Newbie
Newbie



Joined: Jun 13, 2006
Posts: 40

PostPosted: Sun Jul 23, 2006 4:32 pm Reply with quote

ok i fixed the colour of the links

just added that around the links !! <font color={links}</font>

rather straight foward !!

i can send the newsletter to other emails to i just cant mass email all my members
 
View user's profile Send private message
Guardian
Site Admin
Site Admin



Joined: Jul 18, 2005
Posts: 401

PostPosted: Sun Jul 23, 2006 7:51 pm Reply with quote

Your error seems to indicate the number of fields or data in the 'insert' does not match the number of fields in the newsletter template.
I'm not sure why this occurs as the HNL Newsletter uses its own table and I have not seen this issue before.
 
View user's profile Send private message
montego
Site Admin/Owner
Site Admin/Owner



Joined: Feb 12, 2005
Posts: 1393

PostPosted: Sun Jul 23, 2006 9:16 pm Reply with quote

Actually, it is the single quote in your newsletter title that is causing the issue. Try removing that.

The really odd thing is that I could have sworn that I would have done an addslashes() around that prior to inserting! I am really concerned about that.

I am away right now but will definitely look at this in the morning first thing. I should not be allowing that to occur. Again, not sure how I missed that! Shame on me! Embarassed Embarassed Embarassed

_________________
“To err is human, but when the eraser wears out ahead of the pencil, you’re overdoing it.”
-- Josh Jenkins 
View user's profile Send private message Visit poster's website
xGSTQ
Newbie
Newbie



Joined: Jun 13, 2006
Posts: 40

PostPosted: Mon Jul 24, 2006 3:00 am Reply with quote

Thanks for the help guys, but me being a little thick in the coding department doesnt understand what a quote looks like !! lol

and by you saying around the title does that mean {EMAILTOPIC}

ill have a play when ive woken up properly !!

thanks again
 
View user's profile Send private message
xGSTQ
Newbie
Newbie



Joined: Jun 13, 2006
Posts: 40

PostPosted: Mon Jul 24, 2006 3:49 am Reply with quote

It sent okay in the end , i changed the email title to just UDesign i thinkthats what you were meaning

http://www.udesign.me.uk/modules.php?name=HTML_Newsletter&op=msnl_nls_view&msnl_nid=21

thx for your fast responces

and as usual keep up the grand work Wink
 
View user's profile Send private message
montego
Site Admin/Owner
Site Admin/Owner



Joined: Feb 12, 2005
Posts: 1393

PostPosted: Mon Jul 24, 2006 9:35 am Reply with quote

I really goofed! I had this well in hand in the other db updates and somehow missed it here. I know why I missed it, but I should not have.

Here is the fix:

http://montegoscripts.com/ftopict-74.html

_________________
“To err is human, but when the eraser wears out ahead of the pencil, you’re overdoing it.”
-- Josh Jenkins 
View user's profile Send private message Visit poster's website
xGSTQ
Newbie
Newbie



Joined: Jun 13, 2006
Posts: 40

PostPosted: Mon Jul 24, 2006 9:50 am Reply with quote

Thank you kind Sir !!
 
View user's profile Send private message
montego
Site Admin/Owner
Site Admin/Owner



Joined: Feb 12, 2005
Posts: 1393

PostPosted: Tue Jul 25, 2006 7:21 am Reply with quote

You are most welcome!

_________________
“To err is human, but when the eraser wears out ahead of the pencil, you’re overdoing it.”
-- Josh Jenkins 
View user's profile Send private message Visit poster's website
Display posts from previous:       
Post new topic   Reply to topic

View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 4 Hours
 
Forums ©
linear-bunch
linear-bunch