WordPress.org

Ready to get started?Download WordPress

Forums

amr users
[resolved] SQL Error Message with 3.2.8. (5 posts)

  1. michael walker
    Member
    Posted 9 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/

  2. michael walker
    Member
    Posted 9 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.

  3. anmari
    Member
    Plugin Author

    Posted 9 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

  4. michael walker
    Member
    Posted 9 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.

  5. anmari
    Member
    Plugin Author

    Posted 9 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.

Reply

You must log in to post.

About this Plugin

About this Topic

Tags