ENCOUNTERED ERROR IN SQL

Newbie Joined: Jun 13, 2006 Posts: 40

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

Newbie Joined: Jun 13, 2006 Posts: 40

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

Newbie Joined: Jun 13, 2006 Posts: 40

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

Site Admin Joined: Jul 18, 2005 Posts: 387

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.

Site Admin/Owner Joined: Feb 12, 2005 Posts: 1360

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

Newbie Joined: Jun 13, 2006 Posts: 40

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

Newbie Joined: Jun 13, 2006 Posts: 40

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

Site Admin/Owner Joined: Feb 12, 2005 Posts: 1360

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

Newbie Joined: Jun 13, 2006 Posts: 40

Thank you kind Sir !!

Site Admin/Owner Joined: Feb 12, 2005 Posts: 1360

You are most welcome!