Error in SQL syntax

  • Resolved Gary Darling

    (@garydarling)


    5 years, 10 months ago

    I have a dropdown in my form that selects a custom post type. The query works as the dropdown is populated, but my error log is filling up with the following:

    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

    'condobuilding' ORDER BY post_title asc' at line 1 for query 

    SELECT post_title FROM wp_posts 
WHERE post_type = 'condobuilding' 
ORDER BY post_title asc

    In the error log those single quotes around the name of my custom post type actually show up as the ASCII equivalent (& + #039), but this forum editor is converting them. Are they ASCII in the query code, and is that what is causing all the error messages?

    • This topic was modified 5 years, 10 months ago by Gary Darling.
Viewing 1 replies (of 1 total)
  • Plugin Support Zhanna Khachatryan

    (@zhannak)

    5 years, 10 months ago

    Hello Gary,

    Thanks for your inquiry.

    With our plugin’s latest version, this issue is solved, please update the plugin and check again.

Viewing 1 replies (of 1 total)

The topic ‘Error in SQL syntax’ is closed to new replies.

Tags