SQL Error unknown column ‘status’

  • Resolved dcrosbie

    (@dcrosbie)


    9 years, 5 months ago

    When I activate the plugin I get this error. But then I hit refresh and it works ok the 2nd time. Same thing whenever I login or log out, I get this error the first time, then after refresh it goes through fine:

    Database Error; SQL: SELECT DISTINCT t.* FROM wp_posts AS t WHERE ( ( status=’pending’ ) AND ( t.post_type = “media_award_nominati” ) AND ( t.post_status IN ( “publish” ) ) ) ORDER BY t.menu_order, t.post_title, t.post_date; Response: Unknown column ‘status’ in ‘where clause’

    When I deactivate the plugin I get no errors when I log in or log out.

    I am using v1.9 for this plugin. I don’t beleive I was getting this error in a few months ago when I was at a lower version of either the plugin or wordpress or both.

Viewing 1 replies (of 1 total)
  • Plugin Author nsp-code

    (@nsp-code)

    9 years, 5 months ago

    This is not a problem caused by this plugin, as it does not change any sql queries except order by.
    However i suggest to you check the “status” and which code use that, since there’s no column named that way within your wp_posts, but a post_status

    Thanks

Viewing 1 replies (of 1 total)

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