Home Forums Plugin Support WP Project Manager – Free Unknown column 'wp_posts.post_type' in 'where clause'

This topic is: not resolved

This topic contains 29 replies, has 6 voices, and was last updated by  Michiel 4 years, 8 months ago.

Viewing 15 posts - 1 through 15 (of 30 total)
  • Author
    Posts
  • #1905

    brad
    Participant
    Post count: 6

    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.

    #1909

    Tareq Hasan
    Keymaster
    Post count: 2831

    I guess you've woocommerce installed? Seems like it's creating the problem. Can you confirm?

    #1912

    brad
    Participant
    Post count: 6

    yes we have woocommerce and custom theme.

     

     

    thanks

    #1932

    Tareq Hasan
    Keymaster
    Post count: 2831

    I've installed woocommerce along with the project manager and didn't see any problem.

    #1943

    brad
    Participant
    Post count: 6

    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

    #1945

    brad
    Participant
    Post count: 6

    it`s working now, but i dont see menu in admin panel

    need to call page directly.

     

    you know why?

    #1946

    Tareq Hasan
    Keymaster
    Post count: 2831

    May be this problem?

    #1981

    brad
    Participant
    Post count: 6

    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

     

     

    #1987

    brad
    Participant
    Post count: 6

    ok found the problem,

    just forgot to set $ in nginx config

    /index.php?$args

    #1988

    Tareq Hasan
    Keymaster
    Post count: 2831

    Ah it's fixed, Cool!

    #5412

    jmdezigns
    Participant
    Post count: 5

    So what was the solution for this conflict with woocommerce? I am experiencing the same issue.

    #5420

    jmdezigns
    Participant
    Post count: 5

    I also have woocommerce running on the site.

    #5432

    Tareq Hasan
    Keymaster
    Post count: 2831

    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.

    #5479

    jmdezigns
    Participant
    Post count: 5

    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

    #5536

    Tareq Hasan
    Keymaster
    Post count: 2831

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

Viewing 15 posts - 1 through 15 (of 30 total)

The topic ‘Unknown column 'wp_posts.post_type' in 'where clause'’ is closed to new replies.