XF 2.1 How to Clear Notifications?

jpishgar

jpishgar

Member
Recently our forum went down after one of our users reached 66k unread alerts. This broke our mysql database since it went over the value limit for what is allowed (65,535). We're wondering if there is a way to clear unread alerts from the system and if so how to do that.

We have another number of users approaching that upper limit so any quick fixes would be helpful.

Thanks
 
Sort by date Sort by votes
You likely accidentally clicked right align, although I don't know how since that is in a drop down. Click on edit and check in source code mode.

Page source: <div style="text-align: right">What version of 2.1 are you running?&#8203;</div>
 
Upvote 0 Downvote
There is nothing built in to the UI which allows alerts to be cleared.

You would have to clear them manually by editing the database.

I would be interested to know how members are amassing such massive numbers of unread alerts.
 
Upvote 0 Downvote
You must log in or register to reply here.

Similar threads

frm
  • Question Question
XF 2.3 How to enable push notifications if previously denied?
Replies
10
Views
54
frm
frm
Y
  • Question Question
XF 2.2 How to style the push notifications
Replies
0
Views
584
Yort
Y
D
  • Question Question
XF 2.2 How to clear report counter
Replies
2
Views
471
djbaxter
D
M
  • Question Question
XF 2.2 "Use push notifications" - How do I update all members to Yes
Replies
7
Views
559
Paul B
P
R
  • Question Question
MG 2.2 How to clear all users Media Watched categories?
Replies
8
Views
514
Mike
Mike
Back
Top Bottom