• after deleting this plugin i am facing some problem that is it creates some error log that also increase my server load also i am deleting this plugin for over loading my server.
    The error is :

    [17-Jun-2015 07:30:36 UTC] WordPress database error Lost connection to MySQL server during query for query SELECT p.ID FROM newsite1_posts AS p INNER JOIN newsite1_term_relationships AS tr ON p.ID = tr.object_id INNER JOIN newsite1_term_taxonomy tt ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE p.post_date > ‘2015-05-28 02:04:02’ AND p.post_type = ‘post’ AND p.post_status = ‘publish’ AND tt.taxonomy = ‘category’ AND tt.term_id IN (3,1) ORDER BY p.post_date ASC LIMIT 1 made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/as2/single.php’), next_post_link, get_next_post_link, get_adjacent_post_link, get_adjacent_post, W3_Db->query, W3_DbCache->query, W3_DbCallUnderlying->query, W3_Db->query, W3_DbProcessor->query, W3_Db->default_query
    [17-Jun-2015 07:30:50 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘) GROUP BY newsite1_posts.ID ORDER BY newsite1_postmeta.meta_value+0 DESC LIMIT’ at line 1 for query SELECT SQL_CALC_FOUND_ROWS newsite1_posts.ID FROM newsite1_posts INNER JOIN newsite1_postmeta ON (newsite1_posts.ID = newsite1_postmeta.post_id) WHERE 1=1 AND newsite1_posts.post_type = ‘post’ AND (newsite1_posts.post_status = ‘publish’) AND (newsite1_postmeta.meta_key = ‘post_views_count’ ) AND newsite1_posts.ID not in(0322178,322209,322187,322201,0322230,0322214,0322242,0322241,0322254,0322236,0322265,322260,322255,322243,322249,322238,322211,322223,322212,322188,322156,322194,322184,322114,322097,322181,322177,322170,322157,322123,322141,322019,322132,322131,322129,322115,322117,322089,0321952,321946,321927,321822,321876,321835,321825,321795,321638,321633,321475,321459,0322028,321096,321080,321065,320917,321040,0322079,322020,321997,321830,321698,321689,0321666,321660,321609,321496,0322071,322029,322007,321855,320493,0321967,321347,321123,0321688,320966,320936,00322103,321861,321842,321806,321788,321756,321751,321729,321735,321728,321721,321708,0320722,320387,320300,320012,0321157,320658,313987,310926,299392,299540,) GROUP BY newsite1_posts.ID ORDER BY newsite1_postmeta.meta_value+0 DESC LIMIT 0, 10 made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/as2/index.php’), query_posts, WP_Query->query, WP_Query->get_posts, W3_Db->query, W3_DbCache->query, W3_DbCallUnderlying->query, W3_Db->query, W3_DbProcessor->query, W3_Db->default_query

    Now how can solve this problem ?

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Ajay

    (@ajay)

    Hi,

    The error log above is not generated by my plugin. Top 10 doesn’t save anyting in the postmeta table for post views.

    thnx for your reply but i didn’t use any other code or plugins. I am trying to find out the problem but it only shows the error of

    [22-Jul-2015 12:08:38 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘) GROUP BY newsite1_posts.ID ORDER BY newsite1_postmeta.meta_value+0 DESC LIMIT’ at line 1 for query SELECT SQL_CALC_FOUND_ROWS newsite1_posts.ID FROM newsite1_posts INNER JOIN newsite1_postmeta ON (newsite1_posts.ID = newsite1_postmeta.post_id) WHERE 1=1 AND newsite1_posts.post_type = ‘post’ AND (newsite1_posts.post_status = ‘publish’ OR newsite1_posts.post_status = ‘private’) AND (newsite1_postmeta.meta_key = ‘post_views_count’ ) AND newsite1_posts.ID not in(…………..) GROUP BY newsite1_posts.ID ORDER BY newsite1_postmeta.meta_value+0 DESC LIMIT 0, 10 made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/as2/index.php’), query_posts, WP_Query->query, WP_Query->get_posts, W3_Db->query, W3_DbCache->query, W3_DbCallUnderlying->query, W3_Db->query, W3_DbProcessor->query, W3_Db->default_query

    i am sure that this is happening from this plugin. Can u suggest me how to solve the issue.
    I had avoid this issue for long time but now it crashes my sql . SO i need to solve the issue asap.
    PLease suggest me.

    Plugin Author WebberZone

    (@webberzone)

    Hi,

    I’m not sure as to why you think it is Top 10. The errors you posted above have nothing to do with the plugin.

    Also, if a plugin is deleted, WordPress will never let the plugin produce any output or error log.

    Looking at the error above, I suspect it might be W3 Total Cache. e.g. please see: W3_DbCache or another plugin. You’re best shot is to disable all your plugins and start activating them one by one and then see which one starts creating the problem.

    https://www.google.com/search?q=W3_DbCache

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘error log’ is closed to new replies.