WordPress database error You have an error in your SQL syntax

Viewing 3 replies - 1 through 3 (of 3 total)

  • SELECT psp_link_status FROM wp_blr_bad_links WHERE

    That’s not a standard table so deactivate plugins to see if the errors go away.

    Thread Starter devitor

    (@devitor)

    MichaelH,

    Thank you. I’ll see what plugin is most closely related with that and disable that…but first, I did find that my tables were a mix of UTF-8 and Latin Swedish (posted on another thread). I did manually go in and changed all the structures to UTF-8 as well as all the queries on the affected tables. Every single Table is UTF-8 now without exception.

    I’ll re-check the error log and see if that affected the Syntax. If not, then I’ll disable relevant plugins.

    Thread Starter devitor

    (@devitor)

    MichaelH,

    I re-checked the error log after I made all the tables UTF-8. The illegal collation error I posted about in the other thread ceased. So did this one. The “%20” you see in the code came from some of the tables being Latin-Swedish. The strange characters generated by the illegal collation errors were the root cause of this error, as it has not appeared since Saturday morning.

    This one may be closed and marked “Solved.” Thanks much.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘WordPress database error You have an error in your SQL syntax’ is closed to new replies.