By Bethany Amborn on Thursday, 21 July 2016
Posted in Technical Issues
Replies 1
Likes 0
Views 198
Votes 0
I'm trying to reduce the incredible size of some of my database history tables. I already know that there is no danger in trimming the social_notifications table, but what about badge and point history? Is anything calculated from this, or can I trim these monsters as well?
hey Beth,

I am sorry for the delay of this reply,

#__social_badges_history
#__social_points_history

Yes, you can truncate both table, it will not affected on Easysocial.

But it will affected on the user achievement and point :
- User point will become zero
- User achievement will show duplicate and all their personal badge rule frequency will reset to 0.

For example :
- Add friend badge rule - 10 Frequency to unblock the badge
- If the existing user already get this badge, after you truncate all the badge history from the database, when the user add friend over 10 Frequency times again, they user profile page will show 2 `add friend` badges.
·
Thursday, 21 July 2016 11:10
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post