Dashboard broken

  • Resolved Grzegorz.Janoszka

    (@grzegorzjanoszka)


    9 years, 5 months ago

    Recently I noticed that the dasboard is broken, the page is empty and the HTML code ends with:

    <script type=”text/javascript”>
    jQuery(document).ready(function(){
    postboxes.add_postbox_toggles(pagenow);

    jQuery(‘#wps_close_nag’).click( function(){
    var data = {
    ‘action’: ‘wp_statistics_close_donation_nag’,
    ‘query’: ”,
    };

    jQuery.ajax({ url: ajaxurl,
    type: ‘get’,
    data: data,
    datatype: ‘json’,
    });

    jQuery(‘#wps_nag’).hide();
    });

    });
    </script>

    When I go to see the referrers I see almost empty page and the HTML code ends with:

    <div class=”wrap”>
    <!– Screen icons are no longer used as of WordPress 3.8. –> <h2>Najlepsze ods?y?aj?ce strony</h2>
    <ul class=”subsubsub”>
    <li class=”all”>Wszystkie <span class=”count”>(235161)</span>

    <div class=”postbox-container” id=”last-log”>
    <div class=”metabox-holder”>
    <div class=”meta-box-sortables”>
    <div class=”postbox”>
    <div class=”handlediv” title=”Kliknij, aby prze??czy?”>
    </div>
    <h3 class=”hndle”><span>Najlepsze ods?y?aj?ce strony</span></h3>
    <div class=”inside”>
    <div class=’log-latest’>

    I asked the colo company to show me the PHP errors, but I haven’t goet them yet. Once I have them I will post them here.

    Thank you for your support!

    https://www.ads-software.com/plugins/wp-statistics/

Viewing 10 replies - 16 through 25 (of 25 total)
  • Plugin Contributor Greg Ross

    (@gregross)

    The bug with the “Treat corrupt browser info as a bot:” will be fixed in the next release.

    Are you comfortable doing a database export and the flushing the database tables to test to see if a clean database resolves the issue?

    Thread Starter Grzegorz.Janoszka

    (@grzegorzjanoszka)

    Which exactly tables would I need to export? All of them starting with wp_statistics_ ?
    And how exactly do that – export and leave empty? Export and remove completely? Or just export and remove the data by the plugin?

    Plugin Contributor Greg Ross

    (@gregross)

    Yes, export the wp_statistics_ tables. If you have access to phpMyAdmin you can easily do an export via that.

    Otherwise you can export them via Statistics->Optimization->Export (phpMyadmin is better as it’s easier to import them back in later).

    Then use phpMyAdmin (or go to Statistics->Optimization->Purging->Empty Table) and flush the data from the tables.

    Thread Starter Grzegorz.Janoszka

    (@grzegorzjanoszka)

    I will try getting it done in the next 2-3 days.

    Thread Starter Grzegorz.Janoszka

    (@grzegorzjanoszka)

    After I dropped all the data I see properly all the pages.
    The size of uncompressed SQL dump of wp_statistics_visitor is about 43MB.

    But now it is completely broken and I can’t import the data anymore. If I try to import wp_statistics_visitor I get:

    INSERT INTO wp_statistics_visitor (ID, last_counter, referred, agent, platform, version, UAString, ip, location, AString, hits, honeypot) VALUES
    (103911, ‘2015-03-18’, ‘https://wposzukiwaniuwlasnejdrogi.blogspot.com/&#8217;, ‘MSIE’, ‘Windows’, ‘11.0’, ”, ‘89.67.109.70’, ‘PL’, NULL, 5, 0),
    (103912, ‘2015-03-18’, ‘https://paleosmak.pl/paleo-styl/higiena/mycie-wlosow-bez-szamponu/&#8217;, ‘Chrome’, ‘Windows’, ‘41.0.2272.89’, ”, ‘178.43.152.52’, ‘PL’, NULL, 3, 0),
    (103913, ‘2015-03-18’, ‘https://paleosmak.pl/paleo-styl/higiena/mycie-wlosow-bez-szamponu/&#8217;, ‘Android Browser’, ‘Android’, ‘4.0’, ”, ‘94.254.129.39’, ‘PL’, NULL, 2, 0),
    (103914, ‘2015-03-18’, ‘https://www.google.pl/&#8217;, ‘Android Browser’, ‘Android’, ‘4.0’, ”, ‘89.228.115.51’, ‘PL’, NULL, 2, 0),
    (103915, ‘2015-03-18’, ‘https://paleosmak.pl/paleo-styl/glodowki-posty/&#8217;, ‘Chrome’, ‘Windows’, ‘39.0.2171.71’, ”, ‘46.151.53.14’, ‘UA’, NULL, 6, 0),
    (103916, ‘2015-03-18’, ‘https://paleosmak.pl/&#8217;, ‘Chrome’, ‘Android’, ‘40.0.22[…]

    MySQL said: Documentation
    #1062 – Duplicate entry ‘103911’ for key ‘PRIMARY’

    Thread Starter Grzegorz.Janoszka

    (@grzegorzjanoszka)

    OK, I fixed it. Despite the maintenance mode there were still new entries appearing and conflicting with the dump. I have disabled the plugin and then imported the DB and everything worked fine.

    After the import all the symptoms are the same – page truncated, nothing in PHP error log.
    With the empty DB everything worked, there was not data though.

    Plugin Contributor Greg Ross

    (@gregross)

    Can you send me your data set, there’s clearly something in it that’s causing the problem.

    You can send it to me via the contact form on wp-statistics.com if it’s not too big.

    Plugin Contributor Greg Ross

    (@gregross)

    Can you try running the following SQL command (after backing up your database of course) and then see if you can load the overview page?

    DELETE FROM wp_statistics_visitor WHERE length(referred) > 128
    Thread Starter Grzegorz.Janoszka

    (@grzegorzjanoszka)

    I will try it today, first with SELECT.

    Thread Starter Grzegorz.Janoszka

    (@grzegorzjanoszka)

    There are lots of such strings. The results will be sent to you via email.

Viewing 10 replies - 16 through 25 (of 25 total)
  • The topic ‘Dashboard broken’ is closed to new replies.