Empty log previous to a date manually?

  • Resolved carbeck

    (@carbeck)


    10 years, 7 months ago

    It seems like running Slimstat for 9 months now without clearing the backlog has amassed so much data that PHP now crashes on my server (8010 entries in wp_slim_stats, 1.3 MiB). At least I get things like

    Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 122880 bytes) in /wp-admin/includes/dashboard.php on line 89

    now with Slimstat activated whenever I want to access the admin are of WordPress. What SQL statement do I need to pass in order to delete everything before, say, June 1, 2013? Of course, this would only be for testing – I made a backup of the database just in case. I have PHPMyAdmin, so I can issue SQL commands easily.

    Or do I just need to set s:10:"auto_purge";i:372; in wp_options.slimstat_options to 180 instead of 372 and then reactivate?

    http://wordpress.org/plugins/wp-slimstat/

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter carbeck

    (@carbeck)

    10 years, 7 months ago

    I’ve already looked at http://wordpress.org/support/topic/fatal-error-allowed-memory-size-of-33554432-bytes-exhausted-14 about what to do to increase the memory available to PHP, but it seems that my hosts limits it to 32 MB and you can’t (easily) override this.

    On the other hand, that line in dashboard.php has to do with checking user rights. So maybe the error I’m experiencing might have to do with Slimstat’s options management hiccuping again?

    Thread Starter carbeck

    (@carbeck)

    10 years, 7 months ago

    I’ve talked to my host now and they said they’ve grandfathered PHP 5.3 and increasing PHP memory isn’t possible anymore. They suggested changing to PHP 5.4, since that doesn’t use a memory limit anymore. Indeed, this solved my problem.

    I’d still like to have my original question answered, if possible, just for the record 😉

    Plugin Author Jason Crouse

    (@coolmann)

    10 years, 7 months ago

    This is currently not possible via WP SlimStat, but you can do that via phpmyadmin. Just keep in mind that the datestamp for each pageview is simply the Unix Timestamp 😉

    http://en.wikipedia.org/wiki/Unix_time

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Empty log previous to a date manually?’ is closed to new replies.