Title: WP_Widget_PostViews in sidebar causing database error
Last modified: August 30, 2016

---

# WP_Widget_PostViews in sidebar causing database error

 *  Resolved [soflanights](https://wordpress.org/support/users/soflanights/)
 * (@soflanights)
 * [10 years, 5 months ago](https://wordpress.org/support/topic/wp_widget_postviews-in-sidebar-causing-database-error/)
 * [http://www.soflanights.com](http://www.soflanights.com) website constantly getting
   error in PHP error_log:
 * WordPress database error Incorrect key file for table ‘/ramdisk/mysql/tmp/#sql_4216_2.
   MYI’; try to repair it for query SELECT DISTINCT wp_posts.*, (meta_value+0) AS
   views FROM wp_posts LEFT JOIN wp_postmeta ON wp_postmeta.post_id = wp_posts.ID
   WHERE post_date < ‘2016-01-03 08:48:46’ AND post_type = ‘post’ AND post_status
   = ‘publish’ AND meta_key = ‘views’ AND post_password = ” ORDER BY views DESC 
   LIMIT 10 made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-
   loader.php’), include(‘/themes/wooden-mannequin/single.php’), get_header, locate_template,
   load_template, require_once(‘/themes/wooden-mannequin/header.php’), dynamic_sidebar,
   call_user_func_array, WP_Widget->display_callback, WP_Widget_PostViews->widget,
   get_most_viewed
 * [https://wordpress.org/plugins/wp-postviews/](https://wordpress.org/plugins/wp-postviews/)

Viewing 2 replies - 1 through 2 (of 2 total)

 *  Plugin Author [Lester Chan](https://wordpress.org/support/users/gamerz/)
 * (@gamerz)
 * [10 years, 5 months ago](https://wordpress.org/support/topic/wp_widget_postviews-in-sidebar-causing-database-error/#post-6901827)
 * This looks like your DB data for that is corrupted as indicated by the error 
   messge. You will need to repair the tables using PHPMyAdmin.
 *  Thread Starter [soflanights](https://wordpress.org/support/users/soflanights/)
 * (@soflanights)
 * [10 years, 4 months ago](https://wordpress.org/support/topic/wp_widget_postviews-in-sidebar-causing-database-error/#post-6901940)
 * Hi Lester,
    Thanks for suggestion, DB was repaired, but the error continues. 
   According to hosting company Databse environment has a 15 concurrent connection
   limit per mysql user. MySQL connections are made, and then closed very quickly,
   generally in only a matter of milliseconds. If exceeding the 15 concurrent connections
   limit, then you likely have a rogue plugin or script which isn’t properly closing
   its connections.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘WP_Widget_PostViews in sidebar causing database error’ is closed to new
replies.

 * ![](https://ps.w.org/wp-postviews/assets/icon.svg?rev=978002)
 * [WP-PostViews](https://wordpress.org/plugins/wp-postviews/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wp-postviews/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wp-postviews/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-postviews/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-postviews/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-postviews/reviews/)

## Tags

 * [Database Error](https://wordpress.org/support/topic-tag/database-error/)
 * [sidebar](https://wordpress.org/support/topic-tag/sidebar/)

 * 2 replies
 * 2 participants
 * Last reply from: [soflanights](https://wordpress.org/support/users/soflanights/)
 * Last activity: [10 years, 4 months ago](https://wordpress.org/support/topic/wp_widget_postviews-in-sidebar-causing-database-error/#post-6901940)
 * Status: resolved