Database problems with K2 on upgrade
-
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.