[closed] WordPress database error: Please Help (2 posts)

  1. Articz
    Posted 9 years ago #

    hope this is the right place

    hey there all i resently upgraded to the latest version and for some reason when i select one of the categories i get the following error message please can someone help me?

    'WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GROUP BY year(post_date), month(post_date), dayofmonth(post_date)' at line 1]
    SELECT DISTINCT post_date FROM wp_posts LEFT JOIN wp_post2cat ON (wp_posts.ID = wp_post2cat.post_id) LEFT JOIN wp_categories ON (wp_post2cat.category_id = wp_categories.cat_ID) WHERE 1=1 AND category_id IN (1) AND (post_type = 'post' AND (post_status = 'publish' OR post_status = 'private')) GROUP BY wp_posts.ID GROUP BY year(post_date), month(post_date), dayofmonth(post_date)'

    My Site URL is http://www.uhqp.com

  2. MichaelH
    Posted 9 years ago #

Topic Closed

This topic has been closed to new replies.

About this Topic