Deleting Notification Log

  • Resolved crp0004

    (@crp0004)


    3 years, 8 months ago

    My site is experiencing issues because there is over 5.25GB of data in my dun_comments and dun_commentmeta tables from PublishPress/NotificationsLog (1.8 million notifications!). How do I remove this unwanted PublishPress data without deleting 50-100 at a time? I don’t care if all comments are removed from my site.

    • This topic was modified 3 years, 8 months ago by crp0004.
Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Support Riza Maulana Ardiyanto

    (@rizaardiyanto)

    3 years, 8 months ago

    Hi @crp0004

    Have you tried delete all instead: https://i.imgur.com/TVHrl6Y.png?

    Thanks,
    Riza

    Thread Starter crp0004

    (@crp0004)

    3 years, 8 months ago

    Things work well if I select 100-200 at a time to delete, but a higher number or using ‘delete all’ results in this:

    There has been a critical error on this website. Please check your site admin email inbox for instructions.

    Learn more about troubleshooting WordPress.

    Plugin Support Riza Maulana Ardiyanto

    (@rizaardiyanto)

    3 years, 8 months ago

    If your site is showing an error when trying to delete a higher number, it seems there is a limitation from your server. Try to increase the timeout.

    I’m afraid the only way to delete it is through bulk delete or delete all. If you are looking for some database cleaning or something like that, please get in touch with your hosting provider, usually, they can do that through the server.

    Plugin Support Riza Maulana Ardiyanto

    (@rizaardiyanto)

    3 years, 8 months ago

    We haven’t heard back from you in a while, so I’m going to mark this as resolved. If you have any further questions, please reply again here, or you can start a new thread.

    Thanks,

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

The topic ‘Deleting Notification Log’ is closed to new replies.