You have an error in your SQL syntax...

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

Advanced search

[Tom]

Morning guys,

Just had a look at the Newsletter Pro package and was most impressed.  Unfortunately, having purchased and tried it out on myself I'm getting an error when I run the CRON job to publish my first newsletter:

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 ''\' AND ID_LETTER = 2' at line 2
File: *********************/htdocs/PLPMG/SMF/Sources/ManageNews.php
Line: 813

Running SMF 1.1.9 and version 2.0.5 of the Newsletter Pro mod.

Can you help?

Cheers.

[SMFHacks]

It looks like a bad link inside the message that was created. It appears that link was just \ which is causing the escaping to fail.

If you can find the error can you repost the exact message you are trying to send.

[Tom]

Hi, SMFHacks.

Here's the message in it's HTML format...

Code:

<p style="text-align: center;"><span style="font-size: small;"><strong>Submissions to the LPMG Photographer of the Year 2010 June Challenge <span style="color: #0000ff;">Landscape</span> are now open</strong></span></p>
<p style="text-align: left;"><strong><span style="color: #0000ff;">Brief:</span><br /></strong>The weather is warming up and it&rsquo;s time to dust of your camera gear and head out into the great outdoors for a landscape photograph. <br /><br />A landscape is a section or portion of scenery as seen from a single viewpoint. Scenery is the subject of a landscape image. Typically, people and animals are not shown in a landscape, unless they are relatively small in the image and have been included in the composition to show scale. Cityscapes and seascapes are also acceptable&hellip; &nbsp;<br /><br /><span style="color: #0000ff;"><strong>Rules:</strong></span><br />Only <strong>one</strong> submission per person<br /><br />Post-shot Adjustments may be made to your image in a photo editing program, so long as the modification is applied to the whole image. This includes levels, b&amp;w conversion, hue and saturation, sizing and rotating, curves and cropping (or their non-Photoshop equivalents). <br /><br />The use of certain editing and adjustment tools is restricted or prohibited as outlined below.</p>
<ul>
<li>No text may be added to your submission. This includes copyright  statements.</li>
<li>Only adjustment layers may be used</li>
<li>Your submission may include a border, but the border may not contain any  text, clip art, photographs, or other artwork.</li>
</ul>
<p style="text-align: left;"><span style="font-size: small;"><strong>Submission to this category is open from now until midnight on 30th June... Good Luck</strong></span><br /><br /><strong><span style="color: #0000ff;">Entry Intructions:</span></strong><br /><br /></p>
<ul>
<li>Click on the Submit Photo link below to open up an e-mail window.</li>
</ul>
<ul>
<li>Attach your entry in jpg format please (recommended size to be appx. 800px on the longest side)</li>
</ul>
<ul>
<li>Use the Subject field to add the Title of your entry</li>
</ul>
<ul>
<li>I will confirm receipt of your entry by return of e-mail</li>
</ul>
<p style="text-align: center;"><strong><span style="font-size: medium;"><a title="SUBMIT PHOTO" href="mailto:house17doors@photos.flickr.com?cc=chris@pixelstate.com">SUBMIT PHOTO</a></span></strong></p>
<p style="text-align: left;">&nbsp;</p>
<p style="text-align: left;"><br /><br /></p>

[Tom]

I've taken out the only link on the page

mailto:house17doors@photos.flickr.com?cc=chris@pixelstate.com

and the letter is now working, so you're quite right, it's the link that's causing the pain.    Thanks for that.

There's nothing essentially wrong with the link URL though, it is correctly formatted.  I'll have to see if I can get the letter to read off the info some other way.

Cheers

[SMFHacks]

Posted an update to Newsletter Pro that should fix that issue
http://www.smfhacks.com/index.php/topic,2407.0.html

Uninstall old version and install new update to fix the issue.

[Tom]

Thanks for the super swift response.

The URL on your last post isn't working for me though...

"The topic or board you are looking for appears to be either missing or off limits to you. "

[Tom]

Ha!

Working for me now.  Many thanks.  You guys are stars. 

The message is being posted now, but not all of the e-mails are being sent.  Only a reported 494 out of a list of 1159.  I'll post this on a separate thread.

Help Support the SMFHacks.com mod making.