August 26, 2013 at 11:18 pm #7498
upcomingmediaParticipantPost 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!
-UpcomingMediaAugust 25, 2014 at 8:19 pm #25847
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 lotSeptember 3, 2014 at 5:44 pm #26247
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.September 4, 2014 at 9:12 pm #26319
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! 🙂September 7, 2014 at 2:18 pm #26390
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.September 13, 2014 at 7:14 am #26735
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 ?September 13, 2014 at 8:02 am #26737
Sorry, the URL is not showing. Something like: /how-phplist-helps-you-follow-canadas-new-casl-spam-law/feed/September 14, 2014 at 6:45 pm #26785
Please use the latest version of WordPress and our plugin and see if the issue remains.September 18, 2014 at 7:45 pm #26987
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 ?September 22, 2014 at 4:25 pm #27182
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.September 22, 2014 at 8:38 pm #27209
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 ?September 24, 2014 at 6:29 pm #27430
Please provide your site login credentials in a private reply. I will have a look about what is going wrong there.September 25, 2014 at 12:35 am #27468
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 ?September 25, 2014 at 8:47 pm #27538
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.September 25, 2014 at 9:38 pm #27540
Can you suggest a safe way to do this, then ? Regarding our users (like hashes for passwords, etc.) and general safety
The topic ‘Unknown column 'wp_posts.post_type' in 'where clause'’ is closed to new replies.