• Resolved stippel404

    (@stippel404)


    Hi there

    I have some issues with my site, can you help me?

    First of all, every day about the clock of 10 a.m. (Amsterdam) our site goes down. Later on the day it happens again, but Always in the morning. When I’m working on a page, there is a problem, the page doesn’t make a concept while I’m working and if I want to make the page, the connection is out.

    I’ve already contact our serverguys, but they have found no problems after control al issues.

    The found some errors in the log:

    “[Mon Apr 10 09:58:56.143312 2017] [lsapi:notice] [pid 369718:tid 140633878324992] [client 217.120.168.160:56190] [host http://www.sitename.info] Backend log: WordPress databasefout You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘searchterms <> “” AND searchterms <> “_” AND referer NOT LIKE “%sitename’ at line 3 bij query \r\n\t\t\tSELECT REPLACE( SUBSTRING_INDEX( SUBSTRING_INDEX( SUBSTRING_INDEX( referer, “://”, -1 ), “/”, 1 ), “.”, -5 ), “www.”, “” ) AS referer_calculated, COUNT(*) counthits\r\n\t\t\tFROM wp_slim_stats\r\n\t\t\tWHERE searchterms IS NOT NULL searchterms <> “” AND searchterms <> “_” AND referer NOT LIKE “%sitename.info%” AND dt BETWEEN 1491004800 AND 1491814735\r\n\t\t\tGROUP BY referer_calculated \r\n\t\t\tORDER BY counthits DESC\r\n\t\t\tLIMIT 0, 1000 gemaakt door wp_dashboard, do_meta_boxes, call_user_func, wp_slimstat_reports::callback_wrapper, call_user_func, wp_slimstat_reports::raw_results_to_html, call_user_func, wp_slimstat_db::get_top, wp_slimstat_db::get_results\n, referer: https://www.sitename.info/wp-login.php?redirect_to=http%3A%2F%2Fwww.sitename.info%2Fwp-admin%2F&reauth=1&#8243;

    I deactivated the Slimstat-plugin, but the problem is the same. There are every day short moments that the site goes down. What can I do now?

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Contributor Jason Crouse

    (@coolmann)

    Hi,

    the two issues are not related, as far as I can tell. The SQL error you discovered will be fixed in the upcoming release. Which is scheduled to be published early next week. Stay tuned.

    Jason.

    • This reply was modified 9 years, 1 month ago by Jason Crouse.
    Thread Starter stippel404

    (@stippel404)

    Hi Jason
    Thanks for your answer.
    I removed Slim Stat but the problem is the same
    I haven’t no idea what to do now, its very difficult for me
    I don’t speak this ‘language’:
    check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘searchterms <> “” AND searchterms <> “_” AND referer NOT LIKE “%sitename’ at line 3 bij query \r\n\t\t\tSELECT REPLACE( SUBSTRING_INDEX( SUBSTRING_INDEX( SUBSTRING_INDEX( referer, “://”, -1 ), “/”, 1 ), “.”, -5 ), “www.”, “” ) AS referer_calculated, COUNT(*) counthits\r\n\t\t\tFROM wp_slim_stats\r\n\t\t\tWHERE searchterms IS NOT NULL searchterms <> “” AND searchterms <> “_” AND referer NOT LIKE “%sitename.info%” AND dt BETWEEN 1491004800 AND 1491814735\r\n\t\t\tGROUP BY referer_calculated \r\n\t\t\tORDER BY counthits DESC\r\n\t\t\tLIMIT 0, 1000 gemaakt door wp_dashboard, do_meta_boxes, call_user_func, wp_slimstat_reports::callback_wrapper, call_user_func, wp_slimstat_reports::raw_results_to_html, call_user_func,
    Its so abacadabra… Shall I give it up?

    Plugin Contributor Jason Crouse

    (@coolmann)

    Hi,

    The SQL error you discovered will be fixed in the upcoming release, which is scheduled to be published in just a few hours.

    Best,
    Jason

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

The topic ‘site goes down by slimstat’ is closed to new replies.