SQL Error Message with 3.2.8.

  • Resolved michael walker

    (@michael-walker)


    10 years, 5 months ago

    I’m not sure this is necessarily an AMR Users issue, but since it only occurs on (public) pages displaying a user list, I thought I’d ask here. I’m running the latest editions of both WP and AMR Users (3.7.1. and 3.6.8 respectively) as a single-site set-up. On any publicly accessible (i.e front-end) page on which I display a user list, it is throwing up the SQL error message shown below. This message always appears at the foot of the page and does not, therefore, detract from the visibility/viewability of the user list table. On the other hand, it does make the site look a bit amateurish! I’ve been running AMR users for some time now and I’m pretty sure this is a relatively new phenomenon, although unfortunately I can’t say with precision exactly when it began to occur. If anyone can throw any light on this – or if I can help with further and better particulars – please let me know. TIA. Here’s the error message

    “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”

    http://wordpress.org/plugins/amr-users/

Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter michael walker

    (@michael-walker)

    10 years, 5 months ago

    Update: I have the WP Jump Menu plug-in installed. De-activating it removes this error message. So I will also raise this matter with the developer of that plug-in, as it appears there may be a conflict.

    Plugin Author anmari

    (@anmari)

    10 years, 5 months ago

    Yup – nothing to do with my plugin. it doesn’t go near the posts table

    Looks like an un-tested bug ?

    Looks like It should be ‘post_title’ not ‘title’
    https://codex.wordpress.org/Database_Description#Table:_wp_posts

    Thread Starter michael walker

    (@michael-walker)

    10 years, 5 months ago

    Thanks for the prompt reply. Odd that it only happens on pages displaying a user list. I’ve raised a query with the developer and if anything noteworthy arises, I’ll post back here.

    Plugin Author anmari

    (@anmari)

    10 years, 5 months ago

    Definitely is weird.

    i’ll bear it in mind in case i see something and would love to hear if anyone has any idea.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘SQL Error Message with 3.2.8.’ is closed to new replies.

Tags