This topic contains 29 reply and 6 voices, and was last updated by Michiel 5 years ago
Viewing 15 Posts - 1 through 15 (of 29 total)
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 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 brad

yes we have woocommerce and custom theme.

 

 

thanks

April 8, 2013 at 7:21 pm 1932
Tareq Hasan 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 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 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 Tareq Hasan

May be this problem?

April 9, 2013 at 11:05 pm 1981
brad 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 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 Tareq Hasan

Ah it’s fixed, Cool!

June 29, 2013 at 8:03 pm 5412
jmdezigns 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 jmdezigns

I also have woocommerce running on the site.

July 1, 2013 at 12:54 am 5432
Tareq Hasan Tareq Hasan

Weird problem, try opening /includes/functions.php, change 10 to 99 in line 527.
Should be like this: add_filter( 'comments_clauses', 'cpm_hide_comments', 99 );

Let me know if that fixes the problem.

July 1, 2013 at 8:08 pm 5479
jmdezigns jmdezigns

Getting this error on a site without WOOCommerce.

WordPress database error Unknown column ‘wp_posts.post_type’ in ‘where clause’ for query SELECT wp_comments.* FROM wp_comments WHERE comment_post_ID = ‘864’ AND comment_approved = ‘1’ AND wp_posts.post_type NOT IN(‘project’, ‘task_list’, ‘task’, ‘milestone’, ‘message’) ORDER BY comment_date_gmt DESC LIMIT 5 made by require(‘wp-blog-header.php’), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts

July 3, 2013 at 2:18 pm 5536
Tareq Hasan Tareq Hasan

Thats very weird, I don’t get anything like this.

August 26, 2013 at 11:18 pm 7498
upcomingmedia 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

Viewing 15 Posts - 1 through 15 (of 29 total)