How to clean 'discuss_notifications' table after spamming
By Henri on Thursday, 25 October 2018
Posted in General Issues
Likes 0
Views 612
Votes 0
Hello

Due to grant access to 'guest' to create a discussion forum in EasyDiscuss (permission by default !), my site was spammed.
I delete the wrong rows in many discuss_xxx tables but I don't know how to clean the discuss_notifications.

This table is far too big (43422 rows !!, 9.8MB, etc.).
I would remove all the rows but I am not 100% sure there is no dependencies with other discuss_xxx tables.

My question is :
- can you check of I can remove all rows from discuss_notifications table ?
- if not, please provide me the SQL request to select the rows I have to delete.

Thanks
Henri
Hi Henri,

Regarding the notifications table, the safer option you can use this feature: http://take.ms/Dn5UP

You can set it to 1 day then when the cronjob or pageload triggers, the notification items that is older than 1 day will be deleted. With this way, you do not need to manually run any queries and let the system takes care of it.
Raymond
·
Thursday, 25 October 2018 11:24
·
0 Likes
·
0 Votes
·
0 Comments
·
Thx Ray

I set a 3 days instead of 30 and I will see the result ... tomorrow I presume?
Henri
·
Thursday, 25 October 2018 16:24
·
0 Likes
·
0 Votes
·
0 Comments
·
Hey Henri,

Thanks for the update.

You will see the result as soon as someone loads an EasyDiscuss page in the frontend(provided the 'Prune notifications on page load' setting is enabled).

If you use cronjob, you will see the result as soon as the cronjob runs.

Basically the system will check and delete notification items that were generated older than 3 days before the current date.
Raymond
·
Thursday, 25 October 2018 17:41
·
0 Likes
·
0 Votes
·
0 Comments
·
sounds VERY good

thx Ray!
Henri
·
Thursday, 25 October 2018 17:50
·
0 Likes
·
0 Votes
·
0 Comments
·
You're most welcome Henri.

Regards.
Raymond
·
Thursday, 25 October 2018 18:00
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post