WordPress.org

1. ColinB
   Member
   Posted 8 years ago #
   

   When I edit a comment that contains an apostrophe (single quote) I get an SQL error:
   Database error: [You have an error in your SQL syntax near 'with' some apostropeh'ees', comment_author = 'crb', comment_author_email =' at line 3]
   UPDATE plog_comments SET comment_content = 'a comment' with' some apostropeh'ees', comment_author = 'crb', comment_author_email = '', comment_author_url = '' WHERE comment_ID = 206
   I'm using wordpress 1.2. I noticed this error has been reported before:
   http://wordpress.org/support/6/5222

2. Ryan Boren
   WordPress Dev
   Posted 8 years ago #
   

   Fixed in CVS.

3. ColinB
   Member
   Posted 8 years ago #
   

   Wow, that was fast. Thanks for the info. Me === happy WordPress user ;-)

4. mkgago
   Member
   Posted 6 years ago #
   

   I'm having a related problem with WP 2.0.3. When I edit a published comment that contains a single or double quotation mark, the quotation marks show up with escape slashes in front of them after the comment is republished.

   For example, if I edit a comment that says:

   >> I don't know why you say this is a "problem."

   It shows up like this after the editing:

   >> I don\'t know why you say this is a \"problem.\"

   Is this a known issue? Is there any way to resolve it? Thanks in advance for your help.

5. Chris_K
   Member
   Posted 6 years ago #
   

   Yes, known issue. one resolution was already mentioned in this thread. However, there's a plugin that will help you out as well: http://txfx.net/code/wordpress/wordpress-203-tuneup/

6. mkgago
   Member
   Posted 6 years ago #
   

   awesome -- thanks!

7. mkgago
   Member
   Posted 6 years ago #
   

   Final note for any future readers: I installed the plugin from the link above, but got a php error when I used WP afterwards.

   The author of the plugin provides a direct download link in this comment; using that worked for me.

Topic Closed

This topic has been closed to new replies.