Database Error in Mass Emails.

Tried to send out mass emails to all members.  Get the following error.  Help?

_____________________________________________

Database error in

Query:

INSERT INTO `sys_sbs_queue`(`email`, `subject`, `body`) VALUES('andrew@email.com', 'Message from singles Admin: Message from Singles Admin: Singles.com Test', '<html><head></head><body style="font: 12px Verdana; color:#000000">
<p><b>Dear K9Sports</b>,</p>

<p>Administration of the <a href="singles">Singles</a> is glad to inform you that </p>

<p>=========================</p>
<p style="color:#3B5C8E"><html><head></head><body style="font: 12px Verdana; color:#000000">
<p><b>Dear DaraLynn</b>,</p>

<p>Administration of the <a href="singles">singles</a> is glad to inform you that </p>

<p>=========================</p>
<p style="color:#3B5C8E"><p>Hey ya'll.  Just testing this out.  Please ignore.</p></p>
<p>=========================</p>


 <p style="font-size:10px;">NOTE: You received this message because our records show that you are a registered member of <a href="http://singles/">singles</a> or subscribed to the delivery.
 If you wish to unregister, log in to your member account and hit "Unregister".</p>

<p>-----</p>
<p style="font: bold 10px Verdana; color:red">Singles mail delivery system!!!
Auto-generated e-mail, please, do not reply!!!</p></body></html></p>
<p>=========================</p>


 <p style="font-size:10px;">NOTE: You received this message because our records show that you are a registered member of <a href="singles">Singles</a> or subscribed to the delivery.
 If you wish to unregister, log in to your member account and hit "Unregister".</p>

<p>-----</p>
<p style="font: bold 10px Verdana; color:red">Singles mail delivery system!!!
Auto-generated e-mail, please, do not reply!!!</p></body></html>')

Mysql error: 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 'll.  Just testing this out.  Please ignore.

 

 

======================' at line 1

Found error in the file '/usr/local/www/singles/administration/notifies.php' at line 447.
Called 'query' function with erroneous argument #0.

Quote · 10 Dec 2009

What character are you using during this statement?

Hey ya'll.  Just testing this out.  Please ignore.

What is this .  after ya'll and out

Chris

Nothing to see here
Quote · 10 Dec 2009

Nothing.  I just entered

 

He ya'll.  Just testing.

 

That other character only shows in the error email I get.

 

 

Quote · 10 Dec 2009

STRANGE!!!! I took away all periods (.) and it goes thru!  What's going on there?

 

 

Quote · 10 Dec 2009

LOL, ok you may think Im crazy on this but, try this same email except DO NOT put an apostrophe in the work ya'll. Substitute it for you all or something. This may have something to do with INSERTING an apostrophe into the database. Just a hunch, but give it a shot and see what happens.

Chris

Nothing to see here
Quote · 10 Dec 2009

Ok... deleting the ' did it.  Can keep the .'s.  I wonder if we'll never be able to use that punctuation in emails anymore?

Quote · 10 Dec 2009

Yep, Us southerners are gonna hasta watch how we tawk now. I guess thangs like ya'll and fixin' aren't real words to dem dare daterbases. hahaha

Chris

Nothing to see here
Quote · 10 Dec 2009

Heck, even the proper I'll, we're, they're, it's, and a whole slew of words ain't gunna cut it anymore.  Ya'll know wut I mean?

Quote · 10 Dec 2009
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.