WordPress.org

Ready to get started?Download WordPress

Forums

WP SlimStat
[resolved] Empty log previous to a date manually? (4 posts)

  1. carbeck
    Member
    Posted 9 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/

  2. carbeck
    Member
    Posted 9 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?

  3. carbeck
    Member
    Posted 9 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 ;)

  4. camu
    Member
    Plugin Author

    Posted 9 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

Reply

You must log in to post.

About this Plugin

About this Topic

Tags

No tags yet.