Support » Fixing WordPress » Unknown column ‘post_type’ in ‘where clause’

  • Hi Everyone,
    Does anyone know why I’m getting these errors or how to fix them?

    WordPress database error: [Unknown column ‘post_type’ in ‘where clause’]
    SELECT SQL_CALC_FOUND_ROWS el_posts.* FROM el_posts WHERE 1=1 AND post_type = ‘post’ AND (post_status = ‘publish’) ORDER BY post_date DESC LIMIT 0, 3

    WordPress database error: [Unknown column ‘post_date’ in ‘field list’]
    SELECT DISTINCT YEAR(post_date) AS year, MONTH(post_date) AS month, count(ID) as posts FROM el_posts WHERE post_type = ‘post’ AND post_status = ‘publish’ GROUP BY YEAR(post_date), MONTH(post_date) ORDER BY post_date DESC

    I did a search in Google and found several sites with the same error.

    It was working okay when I upgraded it when it was running on localhost, but once I moved it online it gave me this error.

    Thanks for any help.

  • The topic ‘Unknown column ‘post_type’ in ‘where clause’’ is closed to new replies.