• Resolved Paal Joachim Romdahl

    (@paaljoachim)


    I was about to take a backup with Duplicator Pro of a web site that uses WooCommerce and noticed that Burst has added the following to the database:

    wph7_burst_statistics
    Uppercase: 0Rows: 45,938Size: 28.09MB

    I would like to clean up the database the best I can before taking a backup.

    How do I remove the bloat of 28MB from the database? I assumed there would be a clear data from database button but could not locate it.

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Author Rogier Lankhorst

    (@rogierlankhorst)

    If you deactivate the plugin, you can choose to clear all data. Then delete the plugin. The uninstall procedure will delete the tables.

    Thread Starter Paal Joachim Romdahl

    (@paaljoachim)

    Hi Rogier

    I deactivated the plugin and noticed the option to delete all data. I then reactivated the plugin. This is really something that should be added to the Advanced tab inside the plugin settings. Thanks Rogier! Happy New year!

    Plugin Author Rogier Lankhorst

    (@rogierlankhorst)

    Hi @paaljoachim,

    Great this solved it for you. We always want to keep the number of settings to a minimum, so thought this would keep it clean. But I’ll add a reset option to the advanced settings, I can imagine this is sometimes needed even without removing the plugin.

    Thread Starter Paal Joachim Romdahl

    (@paaljoachim)

    An reset option sounds very helpful!

    ch3rub

    (@ch3rub)

    Hi Rogier

    One more vote fore adding a reset button, even better if we could have reset option for specific page as well. What I found is that when page is duplicated, stats for that page are also duplicated. This is a bit of an issue as it’s false data.

    I would imagine it’s the duplicate/copy page plugin that is not taking into the account the fact some data like stats should not be carried over (as it’s not aware of it and probably copies all data related with that page).

    It would be really useful to have an option to reset stats for that page.

    Thank you for this plugin, works well for me so far.

    Plugin Author Rogier Lankhorst

    (@rogierlankhorst)

    @ch3rub @paaljoachim I have added a setting to clear all data in the database:

    https://github.com/Burst-Statistics/burst/tree/reset-option-in-settings
    This will get tested, and merged in one of the upcoming releases (probably not the next).

    For a specific page, you can simply run:

    //the post id you want to clear 
    $post_id = 80;
    delete_post_meta( $post_id, 'burst_total_pageviews_count' );

    Let me know if this answers your question.

    Thread Starter Paal Joachim Romdahl

    (@paaljoachim)

    Hi @rogierlankhorst

    That sounds great! Thank you.

Viewing 7 replies - 1 through 7 (of 7 total)
  • You must be logged in to reply to this topic.