WordPress.org

1. houmidity
   Member
   Posted 3 years ago #

   Please, if you could help us out with this, it would be an amazingly great help. I've been struggling with this all week, and I'll reward anyone who helps me resolve this with a post on our site about how awesome you are.

   Since upgrading to 2.0.3, we get this error on our Dashboard, when trying to upload images, and when trying to publish a post that has apostrophes (') quotations (") or the phrase "David Hasselhoff" in it. (The David Hasselhoff part is a joke. The rest, unfortunately, is not.)

   Here's the error, with profanity edited. You know how MySQL can have a filthy mouth:
   ---------------BEGIN ERROR---------------------
   WordPress database error: [You have an error in your motherf**cking SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Happenstance in the mothaf**kin\' house!

   And just for good measure, l' at line 4]
   INSERT IGNORE INTO wp_posts (post_author, post_date, post_date_gmt, post_content, post_content_filtered, post_title, post_excerpt, post_status, comment_status, ping_status, post_password, post_name, to_ping, pinged, post_modified, post_modified_gmt, post_parent, menu_order, post_mime_type) VALUES ('3', '2006-06-16 14:08:27', '2006-06-16 20:08:27', '

   Okay, that worked. But what if we add some apostrophes and quotes in the mix?

   Lil\' Happenstance in the mothaf**kin\' house!

   -------------------END ERROR-----------------------

   I've tried other forum posts that recommend removing whitespace from various files, no luck. I've tried deleting my wordpress directory entirely and reinstalling a clean copy. No dice.

   Can anyone please help us break the WordPress Apostrophe, Quotation, and David Hasselhoff Curse? Seriously!?!?!

   Should we just switch back to an older version of WordPress? Or did something go wrong during the 2.0.3 database upgrade?

   Thanks in advance for your help and your time.

2. Chris_K
   Administrator
   Posted 3 years ago #

   2.0.3? Try this plugin: http://txfx.net/code/wordpress/wordpress-203-tuneup/

3. houmidity
   Member
   Posted 3 years ago #

   HandySolo, thanks a lot for the quick reply.

   Okay I tried that and it didn't work. When I tried to activate I got a similar error. Here's a screenshot of the error I got when I hit Activate.

   I've also got a screenshot of what happens when I try to publish anything with an apostrophe or quote. This pretty much means we can't have any HTML inside our posts.

4. samboll
   moderator
   Posted 3 years ago #

   Start with the basics.
   Disable the wysiwyg editor:
   admin -> users -> scroll to bottom left

   Uncheck box for "WordPress should correct invalidly nested XHTML automatically"
   admin -> options -> writing

5. houmidity
   Member
   Posted 3 years ago #

   Samboll,

   Did both on the options, updated options, but no dice. Same errors on uploading and publishing. BTW, no plugins are activated at all.

   But thanks for the suggestion!

6. Nazgul
   Member
   Posted 3 years ago #

   It sounds like a NO_BACKSLASH_ESCAPES issue with MySQL. Did you or your hoster recently change anything to the MySQL Settings?

   See this topic for more info.

7. houmidity
   Member
   Posted 3 years ago #

   Nazgul, you are the winner!!!! Thank you so much. Brinkster is our host, so this is where the issue is. It just so happened they changed their server options without telling anyone right around the time we upgraded.

   Just fired off an email to Brinkster.

   Whenever we get our site working again, we're going to have a 'NAZGUL ROCKS' post. Sound good?

8. Nazgul
   Member
   Posted 3 years ago #

   Great. :)

Topic Closed

This topic has been closed to new replies.