Hello Kane,

The trackbacks can be prevented if you turn off the trackbacks. Since trackbacks are not so popular these days, you should just turn off trackbacks

As for the jos_discuss_user_history , it keeps a history of user actions. You can truncate the table but it's not advisable to do so since it stores when the user earn points etc.

Thanks Mark... will turn of trackbacks.
But doesn't 240k entries seem a bit high for a community of 500 users, perhaps 100 active?

Hello Kane,

You mean the user's history? History also includes browsing, when you browse or visits a discussion, it logs it down as well

It is a slightly older thread but I have the same problem, 150K in the user history and 180K in the trackback table.

@Mark: I have stopped using trackbacks in the blogs and will remove the entries in the trackback table in the database, but just wanted to confirm ref your post above, do I just let the user history table in the database grow and grow or is there some automatic cut off/purge of entries available (for example the oldest month of entries after 13 months of entries have built up)?

If not it is going to be a huge table as time goes on with a lot of redundant entries.....

Hello Richard,

The user history table stores the user's points achievement history and you can discard them if you want but it's perfectly fine to keep these records as this is only displayed in the back end when you are editing a user, so you can view how they achieved their points.

As for the trackbacks, you should purge it as judging from the number of trackbacks, it's most likely spams

Thank you Mark, yes all trackback spam and now gone, will keep the user history.

You are most welcome