BuddyDev

Search

wp_bp_notifications removing entries

Tagged: 

  • Participant
    Level: Initiated
    Posts: 2
    Joseph on #16465

    @brajesh your plugin for notifications only deletes on a per user basis correct?

    is it safe to delete old notifications from this table? wp_bp_notifications

    can i just delete all of them? of would someone be so kind as to give me the mysql command to delete notifications that are before a certain date?

    i’ve tried bp bulk delete but is not working on notifications i suspect because there are too many

  • Keymaster
    Level: Yogi
    (BuddyDev Team)
    Posts: 2459
    Ravi on #16466

    Hello Joseph,

    Thank you for posting here. yes, it is perfectly okay to delete old notifications. You can use the following Mysql query to delete notification from the table. This query will delete all the notifications before the given date.

    
    
    DELETE FROM wp_bp_notifications WHERE date_notified <= '2018-07-01 00:00:00';
    
    

    Replace the date as per your requirement. Let me know if there is an issue.

    Thank you
    Ravi

    • This reply was modified 4 years, 2 months ago by Ravi.

You must be logged in to reply to this topic.

This topic is: not resolved