Error wp_postmeta.meta_key = 'post_views_count_7_day_tota

Posted in: Newspaper
Post count: 14

I’m getting the following errors

Anyone know how to fix it?

wp_postmeta.meta_key = ‘post_views_count_7_day_total’
AND
( mt1.meta_key = ‘post_views_count_7_day_last_date’ AND CAST(mt1.meta_value AS SIGNED) > ‘1542650380’ )
) AND wp_posts.post_type = ‘post’ AND ((wp_posts.post_status = ‘publish’)) GROUP BY wp_posts.ID ORDER BY CAST(wp_postmeta.meta_value AS SIGNED) DESC LIMIT 0, 2 feita por require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/Newspaper/category.php’), td_api_category_top_posts_style::_helper_show_category_top_posts_style, td_category_top_posts_style_4->show_top_posts, td_category_top_posts_style->render_posts_to_buffer, td_block_big_grid_4->render, td_block->render, td_data_source::get_wp_query, WP_Query->__construct, WP_Query->query, WP_Query->get_posts
[26-Nov-2018 18:02:27 UTC] Erro de banco de dados do WordPress Lost connection to MySQL server during query para a consulta SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) INNER JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id ) WHERE 1=1 AND (
wp_term_relationships.term_taxonomy_id IN (42,227,304,5123,5202,6102,6113,8083,8299,8331)

Post count: 35449

Hi,

This may happen due to the 7 days post sorting feature which makes requests to the server to update the counter and keep track of the “most popular posts”if you have it set please try without it, it will lower the number of database queries.

Please read this topics:
-> https://forum.tagdiv.com/topic/urgent-speed-issue/
-> https://forum.tagdiv.com/topic/help-me-how-to-resolve-this-error/

Thank you for your understanding.

Viewing 2 posts - 1 through 2 (of 2 total)
The forum ‘Newspaper’ is closed to new topics and replies.