Title: apostrophe creates database SQL syntax error
Last modified: August 18, 2016

---

# apostrophe creates database SQL syntax error

 *  Resolved [knowtown](https://wordpress.org/support/users/knowtown/)
 * (@knowtown)
 * [19 years, 2 months ago](https://wordpress.org/support/topic/apostrophe-creates-database-sql-syntax-error/)
 * 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.
 * James

Viewing 2 replies - 16 through 17 (of 17 total)

[←](https://wordpress.org/support/topic/apostrophe-creates-database-sql-syntax-error/?output_format=md)
[1](https://wordpress.org/support/topic/apostrophe-creates-database-sql-syntax-error/?output_format=md)
2

 *  Thread Starter [knowtown](https://wordpress.org/support/users/knowtown/)
 * (@knowtown)
 * [19 years, 2 months ago](https://wordpress.org/support/topic/apostrophe-creates-database-sql-syntax-error/page/2/#post-531313)
 * Thanks everyone for the suggestion to upgrade. I completed the upgrade succesfully
   But the problem still occurred. While thouroughly testing I think I found the
   culprit. The issue is being caused by one of the plugins I was using (Scripturizer
   1.5). I thought I had tested all my plugins before but I must have missed this
   one. I started testing each plugin one at a time and this one brings on the problem
   every time. I am not sure what it is about that plugin that was creating the 
   problem but now that I have disabled it, I think all systems are go.
 * Sorry for wasting everyone’s time for a simple test that I thought I had already
   done. I do appreciate all the help though.
 *  [vkaryl](https://wordpress.org/support/users/vkaryl/)
 * (@vkaryl)
 * [19 years, 2 months ago](https://wordpress.org/support/topic/apostrophe-creates-database-sql-syntax-error/page/2/#post-531320)
 * Well, the upgrade was a good idea anyway. And I think there are other similar
   plugins to that one around – maybe one of them will work better!

Viewing 2 replies - 16 through 17 (of 17 total)

[←](https://wordpress.org/support/topic/apostrophe-creates-database-sql-syntax-error/?output_format=md)
[1](https://wordpress.org/support/topic/apostrophe-creates-database-sql-syntax-error/?output_format=md)
2

The topic ‘apostrophe creates database SQL syntax error’ is closed to new replies.

## Tags

 * [sql](https://wordpress.org/support/topic-tag/sql/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 17 replies
 * 3 participants
 * Last reply from: [vkaryl](https://wordpress.org/support/users/vkaryl/)
 * Last activity: [19 years, 2 months ago](https://wordpress.org/support/topic/apostrophe-creates-database-sql-syntax-error/page/2/#post-531320)
 * Status: resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics