WordPress.org

Ready to get started?Download WordPress

Forums

Catgeories error (5 posts)

  1. beisbolct
    Member
    Posted 7 years ago #

    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

  2. Trent Adams
    Member
    Posted 7 years ago #

    Maybe check the plugin compatibility list:

    http://wordpress.org/support/topic/101202?replies=1

    As well, 2.1 requires mySQL version of 4 or greater. This suggests that maybe you are using a version of 3 something as I had errors like this for some plugins prior to upgrading to mySQL 4.

    Trent

  3. beisbolct
    Member
    Posted 7 years ago #

    i checked with my host and their servers run MySQL 4.

  4. dunnerz
    Member
    Posted 7 years ago #

    I also have this error when trying to select a category, or any other category/[category_name] page

    I have checked the list, and all of my (active) plugins are compatible,

    example:
    http://www.dunmore.me.uk/blog/category/websites/

    No idea what is causing it / what to do

    Thanks, James.

  5. beisbolct
    Member
    Posted 7 years ago #

    If you are using the same plugin that i am using. it has to be used with the automatic asides plugin for wordpress. otherwise, you need to find an earlier version that is compatible. I fixed the problem by switching to the automattic asides from the sidebar modules...

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags