notifications timing out?

Sounds like you have a lot of notifications.
You could let it run – it may time out depending on the php max execution time for your server.

You can always run manual sql via an interface like phpmyadmin.
Make sure you make a backup of the database first.

Thanks for the reply @shanebp …and yes i have tons going back to 2010

i looked at the notifications table and none of them were deleted …i also thought just let it run it might time out but would delete some ….doesn’t appear to unless you think it would start deleting the newest ones in the range first not the oldest ones

so it is safe to just delete any amount of rows in that notifications table?

and then would you be willing to share with me the exact query to run via phpmyadmin to delete all notifications older than 2016 ?

• This reply was modified 6 years, 8 months ago by ds123.

so it is safe to just delete any amount of rows in that notifications table?

Probably – but make a backup of that table before you delete.

Hey @shanebp thanks for getting back this is insanely important and i will pay you if that is something that will help

does your plugin just delete the notifications table rows ? does it do something else ?

if it wasn’t safe to do delete notifications you wouldn’t release a plugin doing it is my thinking yes? and so i somehow need to manually do what your plugin does directly to the database ..those are the instructions i’m hoping you’ll give me

and can i pay you for the sql query ? i’m not a mysql guy and the last thing i want is to just delete everything not knowing what i’m doing ….i’d rather trim it like i used to do with the activity table that kind of query…i used mysql query to do that and worked fine ..that is my hope for notifications …once its a manageable size i should be able to use your plugin for future maintenance

i do understand what you mean by backup the notifications table first ..but what would i be looking for to tell me i need the backup restored? would the site just crash or what would happen? and would other tables get corrupted by this is it a possibility ?

thank you for help i tried to get this resolved literally 5 years ago and did not get any replies

NOTE: It is against the usage policies of this site to use it to provide site-specific support. And we are not accepting freelance work at this time.

This plugin deletes notifications and meta data about those notifications. So 2 db tables are involved.

We suggest you try deleting a month’s worth of notifications. If that does not work, you will need to hire a developer.

thanks @shanebp ok so glad you told me and also glad i didn’t just try deleting the notifications table rows by themselves

i cannot select the option you mean because your plugin doesn’t go back to the first round of notifications …my notifications start in 2010 how do i select 1 month worth ?

@shanepb can you show me how to modify this plugin so i can try selecting dates in 2010 ? or release a fix ?

• This reply was modified 6 years, 7 months ago by ds123.

In bpbd-admin.php find $year = 2012; and change it to $year = 2010;