SQL Error

  • michael walker

    (@michael-walker)


    12 years, 6 months ago

    The latest release of this plug-in is generating the following error message at the foot of (some of) my pages:

    “WordPress database error: [Unknown column ‘title’ in ‘order clause’]
    SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND ( ( wp_posts.post_status IN (‘private’, ‘closed’, ‘hidden’, ‘publish’) AND ( ( 1=1 ) ) ) ) AND post_type = ‘page’ AND ( wp_posts.post_status IN (‘publish’,’private’,’closed’,’hidden’) ) ORDER BY title ASC”

    If I deactivate the plug-in, the error disappears.
    ^ Shouldn’t that be ‘post_title’ rather than ‘title’?

    http://wordpress.org/plugins/wp-jump-menu/

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author James Krill

    (@jkrill)

    12 years, 5 months ago

    That seems very strange, as those SQL queries are handled by WordPress’ built in function… and “orderby” => ‘title’ is definitely right. I’ll have to look deeper into this.

    Thread Starter michael walker

    (@michael-walker)

    12 years, 5 months ago

    Thank you. If I can help with any further info, please let me know.

    Plugin Author James Krill

    (@jkrill)

    12 years, 1 month ago

    Try updating to the latest version of the plugin and see if this is fixed? Thanks!

    Thread Starter michael walker

    (@michael-walker)

    12 years, 1 month ago

    Many thanks. I’ve updated as suggested, but I’m afraid it hasn’t helped. Since no-one else (as far as I can see) has reported this problem, I’m kind of concluding it must be something to do with my own set-up – maybe some clash with another plug-in. I’ll research that and post back if I find an answer. Thanks again.

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

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

Tags