WordPress.org

Support

Support » How-To and Troubleshooting » Catgeories error

Catgeories error

  • After upgrading to wordpress 2.1, using my categories widget i get the following error.

    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_ec3_schedule ec3_sch ON ec3_sch.post_id=id WHERE 1=1 AND category_id IN (41) AND (post_type = ‘post’ AND (post_status = ‘publish’ OR post_status = ‘private’)) AND ec3_sch.post_id IS NULL GROUP BY wp_posts.ID GROUP BY year(post_date), month(post_date), dayofmonth(post_date)

    Is this because the plugin isn’t up to date for 2.1. it still shows all the posts in that plugin

Viewing 4 replies - 1 through 4 (of 4 total)
Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Catgeories error’ is closed to new replies.
Skip to toolbar