apostrophe creates database SQL syntax error

  • Resolved knowtown

    (@knowtown)


    19 years, 2 months ago

    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)
1 2
  • Thread Starter knowtown

    (@knowtown)

    19 years, 2 months ago

    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

    (@vkaryl)

    19 years, 2 months ago

    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)
1 2

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

Tags