I was having a lot of problems since upgrading to 2.1 but with the help of a lot of fine people here and the new release of 2.1.1 I have everything working except one thing. It is minor but very annoying and I could not find anything about this in the forum. I am hoping someone here can point me in the right direction.
When ever I write a post that contains an apostrophe (') WordPress generates a database error that reads:
WordPress database 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 's excerpt that is creating error' at line 1]
UPDATE wp_posts SET post_content = 'The complete text of the post displays here. in this post would be the post's excerpt that is creating the error.' WHERE ID = '628'
So any contractions (like, can't, don't, I'm, etc) generate the error. The error will come up at the first autosave and keeps generating at each save after that. When I finally publish, the post will publish OK so I don't think it is anything major but I sure would love to know what is causing it and how to fix it. Any help would be appreciated.