Support » Fixing WordPress » Database problems with K2 on upgrade

  • ChrisH

    (@chrish)


    I just upgraded to 2.1.2 from 2.0, and upgraded my plugins and templates at the same time. The template I’m using right now it Triple2K, and when I bring up the page, I get a blank header and the following text:

    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) WHERE 1=1 AND wp_posts.ID NOT IN (169, 184, 185, 191, 193, 288, 290, 291, 294, 319, 322, 330) 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)'

    Can anyone tell me what’s happening? And how to rectify it? A few points:

    1) So far, I haven’t gotten this on any of the other templates;
    2) I am not using a scheme, and all the plugins are turned off;
    3) I have not gotten similar errors with another blog hosted in the same database, which is also using version 2.1.2 and TripleK2;
    4) I get the exact same error using 3K2, which is an older version of this template.

  • The topic ‘Database problems with K2 on upgrade’ is closed to new replies.