Ready to get started?Download WordPress


[resolved] Error editing a comment with an apostrophe (7 posts)

  1. ColinB
    Posted 10 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:

  2. Ryan Boren
    WordPress Dev
    Posted 10 years ago #

    Fixed in CVS.

  3. ColinB
    Posted 10 years ago #

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

  4. mkgago
    Posted 8 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
    Posted 8 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
    Posted 8 years ago #

    awesome -- thanks!

  7. mkgago
    Posted 8 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.

About this Topic