Topic: wp-postviews widget shows N/A problem but plugin works fine.

[turnkey]

postview plugin works fine but widget shows N/A time to time (Happened more than 10 times this year.). And it starts working 4-5hours later itself normally or when ı disable and re enable plugin (not every time fixes), or when I refresh permalinks.
Maybe the reason is, there is a conflict with my arthemia premium theme (Another user experienced it also). But it is very certain that there is bug in widget.

I checked error log and I found this;( a lot of them)

[28-Dec-2009 08:58:51] require, require_once, include, get_footer, locate_template, load_template, require_once, dynamic_sidebar, call_user_func_array, WP_Widget->display_callback, WP_Widget_PostViews->widget, get_most_viewed_category tarafından yapılan SELECT DISTINCT wp_posts.*, (meta_value+0) AS views FROM wp_posts LEFT JOIN wp_postmeta ON wp_postmeta.post_id = wp_posts.ID INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_term_taxonomy ON (wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id) WHERE post_date < '2009-12-28 10:58:51' AND wp_term_taxonomy.taxonomy = 'category' AND wp_term_taxonomy.term_id IN (63) AND post_type = 'post' AND post_status = 'publish' AND meta_key = 'views' AND post_password = '' ORDER  BY views DESC LIMIT 4 for inquiry WordPress database error  Got error 28 from storage engine

[28-Dec-2009 08:58:56] require, require_once, include, get_sidebar, locate_template, load_template, require_once, dynamic_sidebar, call_user_func_array, WP_Widget->display_callback, WP_Widget_PostViews->widget, get_most_viewed_category tarafından yapılan SELECT DISTINCT wp_posts.*, (meta_value+0) AS views FROM wp_posts LEFT JOIN wp_postmeta ON wp_postmeta.post_id = wp_posts.ID INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_term_taxonomy ON (wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id) WHERE post_date < '2009-12-28 10:58:56' AND wp_term_taxonomy.taxonomy = 'category' AND wp_term_taxonomy.term_id IN (59,60,67,61,30,22,83,62,76) AND post_type = 'post' AND post_status = 'publish' AND meta_key = 'views' AND post_password = '' ORDER  BY views DESC LIMIT 10 for inquiry WordPress database error Got error 28 from storage engine



I am using
Wordpress 2.9
MySql and PHP versions are up to date.

[GaMerZ]

I just tested it over my end and it works fine. Instead it looks like a problem with your DB judging from the error log

Do a google, http://superaff.com/archives/2006/11/11/wordpress-database-error-got-error-28-from-storage-engine/

[turnkey]

Ok, my site just suspended by hosting due to the exceeding the cpu limit and they sent me this log. any idea?

Top Process     %CPU 66.9       /usr/bin/php /home/tarihve1/public_html/wp-content/plugins/wp-postviews/wp-postviews.php
Top Process     %CPU 54.0       /usr/bin/php /home/tarihve1/public_html/wp-admin/plugins.php
Top Process     %CPU 28.0       /usr/bin/php /home/tarihve1/public_html/wp-admin/options-general.php

[GaMerZ]

You may want to read through this http://forums.lesterchan.net/index.php/topic,4348.0.html

A lot of hosts OVERSELL their hosting by cramping in 1000+ accounts onto one server and that explains the CPU limit. It happen to me on Dreamhost before. I was pretty pissed and I changed host and it works fine now.

[turnkey]

Thanks, I will change my hosting to hostgator, by the way justhost sucks.

[turnkey]

I think I found the problem, wp-cache plugin conflicts with wp-postviews plugin.
I disable wp-cache everything fine now.