XenForo 2.0 Easy but technical question

[godxdfg]

Hello, do not be tired I had a problem on my forum tabs that the table size xf_user_alert has reached 9 GB Is this normal or not, I have to clean it

 

[sucre13]

by law if you can TRUNCATE but make a backup by warning you can use this command in sql TRUNCATE TABLE xf_user_alert;

 

[Soft4Win]

Well, that doesn't seems to be quite well, alert records get deleted once the alert has been viewed by the users. Maybe you have some configuration issues with how long the error is retained in server.

Once check here :- /admin.php?options/groups/alerts/#alertExpiryDays - Make sure the alert expiry days is less, as alert table doesn't supposed to be that big.