Hi Kevin,

I've been having this RS error that is disrupting the call for the Recent Comments widget so that no results are returned and the error is also eating up a problematic amount of server resources:

WordPress database error Column 'post_status' in where clause is ambiguous for query SELECT DISTINCT * from wp_comments INNER JOIN wp_posts ON wp_posts.ID = wp_comments.comment_post_ID LEFT JOIN wp_posts as parent ON parent.ID = wp_posts.post_parent AND parent.post_type IN ('post', 'page') AND wp_posts.post_type = 'attachment' WHERE  ( ( wp_posts.post_type = 'post'  AND (  ( post_status IN ('private', 'publish') AND (  (  (  ( 1=1 ) OR ( wp_posts.post_author = '4' )  )  )  ) ) ) ) OR ( wp_posts.post_type = 'page'  AND (  ( post_status IN ('private', 'publish') AND (  (  (  ( 1=1 ) OR ( wp_posts.post_author = '4' )  )  )  ) ) ) ) OR ( wp_posts.post_type = 'attachment' AND parent.post_type = 'post'  AND (  ( post_status IN ('private', 'publish') AND (  (  (  ( 1=1 ) OR ( parent.post_author = '4' )  )  )  ) ) ) ) OR ( wp_posts.post_type = 'attachment' AND parent.post_type = 'page'  AND (  ( post_status IN ('private', 'publish') AND (  (  (  ( 1=1 ) OR ( parent.post_author = '4' )  )  )  ) ) ) ) ) AND comment_approved= '1' AND ( comment_type = 'trackback' OR comment_type = 'pingback' ) ORDER BY comment_date DESC LIMIT 0,15 made by require, require_once, include, get_sidebar, locate_template, load_template, require_once, include, dynamic_sidebar, call_user_func_array, widget_get_recent_comments, get_recent_comments, kjgrc_cache, kjgrc_create_recent_trackbacks, kjgrc_get_comments2

I have confirmed that this is RS related, when RS is deactivated, this error stops

Really appreciate your help with solving this!

Thanks Kevin! Just uploaded it, will follow up with the results.

Cheers!

Hi

Sorry I'm a beginner. I have the same kind of error as Kevin. I uploaded the dev code but I don't know  how to change the file  get_ recent_comments.php :

- what means @@ -1061,12 +1061,30 @@ : line number ? and what to do whit what is after …

I suppose - at the beginning of a line means delete it and a + means add it …

Thanks !

Here it is (WP 2.0.5)

WordPress database error: [MySQL server has gone away]
SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id = '725' ORDER BY post_id, meta_key
WordPress database error: [MySQL server has gone away]
SELECT COUNT(*) FROM wp_comments WHERE comment_post_ID = '725' AND comment_approved = '1'
WordPress database error: [MySQL server has gone away]
SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id = '725' ORDER BY post_id, meta_key
WordPress database error: [MySQL server has gone away]
SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id = '725' ORDER BY post_id, meta_key
WordPress database error: [MySQL server has gone away]
SELECT * FROM wp_comments WHERE comment_post_ID = '725' AND comment_approved = '1' ORDER BY comment_date ASC LIMIT 0, 50
86 commentai

WordPress database error: [Query execution was interrupted]
SELECT DISTINCT wp_comments.* FROM wp_comments LEFT JOIN wp_posts ON wp_posts.ID=wp_comments.comment_post_ID WHERE (post_status = 'publish' OR post_status = 'static') AND comment_approved= '1' AND post_password = '' AND comment_type = '' ORDER BY comment_date DESC LIMIT 200
WordPress database error: [MySQL server has gone away]
SELECT DISTINCT wp_comments.* FROM wp_comments LEFT JOIN wp_posts ON wp_posts.ID=wp_comments.comment_post_ID WHERE (post_status = 'publish' OR post_status = 'static') AND comment_approved= '1' AND post_password = '' AND ( comment_type = 'trackback' OR comment_type = 'pingback' ) ORDER BY comment_date DESC LIMIT 5
WordPress database error: [MySQL server has gone away]
SELECT option_value FROM wp_options WHERE option_name = 'kjgrc_cache' LIMIT 1
WordPress database error: [MySQL server has gone away]
SELECT option_value FROM wp_options WHERE option_name = 'kjgrc_cache' LIMIT 1
WordPress database error: [MySQL server has gone away]
INSERT INTO wp_options (option_name, option_value, option_description, autoload) VALUES ('kjgrc_cache', 'a:2:{s:8:\"comments\";s:44:\"PGxpPjwhLS0gbm8gY29tbWVudHMgeWV0IC0tPjwvbGk+\";s:10:\"trackbacks\";s:44:\"PGxpPjwhLS0gbm8gY29tbWVudHMgeWV0IC0tPjwvbGk+\";}', '', 'yes')

WordPress database error: [MySQL server has gone away]
SELECT DISTINCT MONTH(post_date) AS month, YEAR(post_date) AS year FROM wp_posts WHERE post_date < '2011-01-01' AND post_status = 'publish' ORDER BY post_date DESC LIMIT 1
WordPress database error: [MySQL server has gone away]
SELECT DISTINCT MONTH(post_date) AS month, YEAR(post_date) AS year FROM wp_posts WHERE post_date > '2011-01-01' AND post_date < '2011-01-30 17:04:21' AND MONTH( post_date ) != MONTH( '2011-01-01' ) AND post_status = 'publish' ORDER BY post_date ASC LIMIT 1
WordPress database error: [MySQL server has gone away]
SELECT DISTINCT DAYOFMONTH(post_date) FROM wp_posts WHERE MONTH(post_date) = '01' AND YEAR(post_date) = '2011' AND post_status = 'publish' AND post_date < '2011-01-30 17:04:21'
WordPress database error: [MySQL server has gone away]
SELECT post_title, DAYOFMONTH(post_date) as dom FROM wp_posts WHERE YEAR(post_date) = '2011' AND MONTH(post_date) = '01' AND post_date < '2011-01-30 17:04:21' AND post_status = 'publish'

These messages are shown in the right sidebar for Recent comments and archives.

I can eliminate the problem for one or to days if I optimize the involved tables.

WORDPRESS 2.0.5

http://www.skyfall.fr/

I'm not the creator of the blog …(born in 2006) …

OK, thank you !

Just a trip down memory lane. I recommend upgrading WP if possible. But let me know if you need support for an older installation.