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 - 16 through 30 (of 30 total)
  • Author
    Posts
  • #7498

    upcomingmedia
    Participant
    Post count: 3

    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

    #25847

    Michiel
    Member
    Post count: 12

    I'm seeing the same error jmdezigns says also without WOOCommerce. For example, I see:

    WordPress database error Unknown column 'wp_posts.post_type' in 'where clause' for query SELECT wp_comments.* FROM wp_comments  WHERE comment_post_ID = '50' 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
    

    I'm using WP Project Manager PRO 0.5.3 and WP Project Manager – Frontend 1.2.1 with buddypress and other several plugins.

    None of the fixes/workarounds suggested on this thread fix them, as they seem to be all applied in these versions (change 10 to 99 in /includes/functions.php is already done in my version, for example).

    Do you have any idea how can I further debug this ?

    Thanks a lot

    #26247

    Sekander Badsha
    Member
    Post count: 2067

    Hello Michiel,
    Take a backup of your site and provide your FTP and site admin login credentials in a private reply. I'll have a look what's going wrong there.

    #26319

    Michiel
    Member
    Post count: 12

    Is that the only option ? I'd like to try some other way first, if possible. I find doing that kind of invasive. I received by email a reply asking for the plugins installed. So, can I just give you that now ? Giving admin access seems like too much as a first step IMHO.

    So, just in case the list of plugins is useful, I'll tell you that I'm using wordpress from debian stable and the plugins installed are:

    add-meta-tags/ version 2.4.3
    akismet/ version 3.0.2
    bp-security-check/ version 1.2.0
    buddypress/ version 2.0.1
    buddypress-activity-plus/ version 1.6
    buddypress-group-email-subscription/ version 3.4
    buddypress-groupomatic/ version 1.0.4
    buddypress-sitewide-activity-widget/ version 1.2
    buddypress-social/ version 2.0
    buddypress-usernames-only/ version 0.6
    editorial-calendar/ version 3.1.1
    export-user-data/ version 0.9.3
    media-vault/ version 0.8.12 (not active)
    restrict-categories/ version 2.6.3 (not active)
    scalable-vector-graphics-svg/ version trunk
    shortcodes-ultimate/ version trunk
    si-captcha-for-wordpress/ version trunk
    stop-spammer-registrations-plugin/ version 5.9.3 (not active)
    syntaxhighlighter/ version 3.1.10
    WP Project Manager – Frontend version 1.2.1
    WP Project Manager PRO Version 0.5.3
    wp-fail2ban/ version 2.2.1
    wp-piwik/ version 0.9.9.8
    wp-status-notifier/ version 1.3.1

    If you want me to test something in particular, just let me know! ๐Ÿ™‚

    #26390

    Sekander Badsha
    Member
    Post count: 2067

    Hello Michiel,
    You can disable all your plugins except Project Manager and switch to a default WordPress theme like- twenty fourteen and see if the issue persists or not.

    If disabling the other plugins help, you'll have to check one by one to know which one is causing the problem.

    #26735

    Michiel
    Member
    Post count: 12

    The problem seems to be the WP Project Manager plugin. I disabled all the plugins except for:

    WP Project Manager – Frontend (version 1.2.1)
    WP Project Manager PRO (version Version 0.5.3)

    Even then, when I go to a URL like: /\/feed the error is shown. If I disable those plugins, the error is not shown.

    So it seems the plugin is having problems with wordpress itself. I'm using wordpress 3.6.1+dfsg-1~deb7u4 from debian stable.

    Is there some other test that can help you fix the bug in WP Project Manager ?

    #26737

    Michiel
    Member
    Post count: 12

    Sorry, the URL is not showing. Something like: /how-phplist-helps-you-follow-canadas-new-casl-spam-law/feed/

    #26785

    Sekander Badsha
    Member
    Post count: 2067

    Hello Michiel,
    Please use the latest version of WordPress and our plugin and see if the issue remains.

    #26987

    Michiel
    Member
    Post count: 12

    It's not an option for us to upgrade wordpress. We use debian stable and we want to use that. And we are using the latest version of your plugin (check the versions I posted and let me know if it's not the last one).

    What can I do to use the plugin on debian stable without errors ?

    #27182

    Sekander Badsha
    Member
    Post count: 2067

    Go to your permalink settings and set it to post name and hit save; even if you have already set the permalink to “post name”. See if the issue solves or not. And please check you have the latest version of MySQL and PHP.

    #27209

    Michiel
    Member
    Post count: 12

    I had it already set the permalink to “post name”. I hit save anyways and didn't changed a bit (the error is exactly the same). It didn't resolve the issue.

    Any other idea ?

    #27430

    Sekander Badsha
    Member
    Post count: 2067

    Please provide your site login credentials in a private reply. I will have a look about what is going wrong there.

    #27468

    Michiel
    Member
    Post count: 12

    Again, I'd really like to avoid that. It seems too invasive. Can't you just tell me what do you want to try or run something with debug so you can further understand what the problem is ?

    #27538

    Sekander Badsha
    Member
    Post count: 2067

    How am I supposed to write about the hundreds of tests we do to check? I can not suggest you anything without having a look.

    #27540

    Michiel
    Member
    Post count: 12

    Can you suggest a safe way to do this, then ? Regarding our users (like hashes for passwords, etc.) and general safety

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

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