April 8, 2013 at 11:27 am 1905
|Michiel||looks like we have a conflict: WordPress database error: [Unknown column 'wp_posts.post_type' in 'where clause'] SELECT * FROM wp_comments JOIN wp_posts as cpm_p ON cpm_p.ID = wp_comments.comment_post_ID WHERE ( comment_approved = '0' OR comment_approved = '1' ) AND cpm_p.post_type NOT IN('project', 'task_list', 'task', 'milestone', 'message') AND wp_posts.post_type NOT IN ('shop_order') ORDER BY comment_date_gmt DESC LIMIT 25 No comments yet.|
April 8, 2013 at 12:45 pm 1909
I guess you’ve woocommerce installed? Seems like it’s creating the problem. Can you confirm?
April 8, 2013 at 2:40 pm 1912
yes we have woocommerce and custom theme.
April 8, 2013 at 7:21 pm 1932
I’ve installed woocommerce along with the project manager and didn’t see any problem.
April 8, 2013 at 8:17 pm 1943
looks like it`s something with theme customization. we have loaded new theme with many extra plugins.
i think it`s something with CustomType, it is theme specific menu. dunno
April 8, 2013 at 10:20 pm 1945
it`s working now, but i dont see menu in admin panel
need to call page directly.
you know why?
April 8, 2013 at 10:42 pm 1946
May be this problem?
April 9, 2013 at 11:05 pm 1981
yes it works now.
but now frontend not working,
i was able to create a project but if i click on it
page just reloads.
April 10, 2013 at 10:19 am 1987
ok found the problem,
just forgot to set $ in nginx config
April 10, 2013 at 10:27 am 1988
Ah it’s fixed, Cool!
June 29, 2013 at 8:03 pm 5412
So what was the solution for this conflict with woocommerce? I am experiencing the same issue.
June 30, 2013 at 6:13 am 5420
I also have woocommerce running on the site.
July 1, 2013 at 12:54 am 5432
Weird problem, try opening
Let me know if that fixes the problem.
July 1, 2013 at 8:08 pm 5479
Getting this error on a site without WOOCommerce.
July 3, 2013 at 2:18 pm 5536
Thats very weird, I don’t get anything like this.
August 26, 2013 at 11:18 pm 7498
I have an Client WooCommerce ready WordPress Website (& theme) installed in a sub-folder of the main WP site. The main website has WP Project Manager and I’m experiencing a similar error on the client WooCommerce site that doesn’t even have the WPPM plugin installed!
[Mon Aug 26 12:35:07 2013] [warn] [client XXX.XX.X.XXX] mod_fcgid: stderr: WordPress database error Unknown column ‘wp_posts.post_type’ in ‘where clause’ for query SELECT wp_comments.* FROM wp_comments WHERE comment_post_ID = ‘880’ AND comment_approved = ‘1’ AND wp_posts.post_type NOT IN(‘project’, ‘task_list’, ‘task’, ‘milestone’, ‘message’) ORDER BY comment_date_gmt DESC LIMIT 10 made by require(‘wp-blog-header.php’), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts, W3_Db->query, W3_DbCache->query, W3_DbCallUnderlying->query, W3_Db->query, W3_DbProcessor->query, W3_Db->default_query
Any ideas, as its stopping me from editing any admin pages in the client WP install!
Any insight would be appreciated!