Unknown column 'wp_posts.post_type' in 'where clause'
Michiel
9 years, 7 months ago| Author | Posts |
|---|---|
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 | |
Tareq Hasan
| I guess you’ve woocommerce installed? Seems like it’s creating the problem. Can you confirm? |
April 8, 2013 at 2:40 pm 1912 | |
brad
| yes we have woocommerce and custom theme.
thanks |
April 8, 2013 at 7:21 pm 1932 | |
|
Tareq Hasan
| I’ve installed woocommerce along with the project manager and didn’t see any problem. |
April 8, 2013 at 8:17 pm 1943 | |
|
brad
| 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 | |
|
brad
| 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 | |
|
Tareq Hasan
| May be this problem? |
April 9, 2013 at 11:05 pm 1981 | |
|
brad
| 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. no errors
|
April 10, 2013 at 10:19 am 1987 | |
|
brad
| ok found the problem, just forgot to set $ in nginx config /index.php?$args |
April 10, 2013 at 10:27 am 1988 | |
|
Tareq Hasan
| Ah it’s fixed, Cool! |
June 29, 2013 at 8:03 pm 5412 | |
jmdezigns
| So what was the solution for this conflict with woocommerce? I am experiencing the same issue. |
June 30, 2013 at 6:13 am 5420 | |
|
jmdezigns
| I also have woocommerce running on the site. |
July 1, 2013 at 12:54 am 5432 | |
|
Tareq Hasan
| Weird problem, try opening Let me know if that fixes the problem. |
July 1, 2013 at 8:08 pm 5479 | |
|
jmdezigns
| Getting this error on a site without WOOCommerce.
|
July 3, 2013 at 2:18 pm 5536 | |
|
Tareq Hasan
| Thats very weird, I don’t get anything like this. |
August 26, 2013 at 11:18 pm 7498 | |
upcomingmedia
| 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! -UpcomingMedia |
