WP_Widget_PostViews in sidebar causing database error

  • Resolved soflanights

    (@soflanights)


    10 years, 4 months ago

    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://ww.wp.xz.cn/plugins/wp-postviews/

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author Lester Chan

    (@gamerz)

    10 years, 4 months ago

    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

    (@soflanights)

    10 years, 4 months ago

    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.