UBB.threads PHP Forum Software Community Forums Resources and Customizing How Do I? ubbt_REFERER_LOG

Hi, the tabel ubbt_REFERER_LOG contains 4,8 mio records and is 650mb big. Too big.. what is this table? How can I shrink it?

That is basically a table that holds referer information (what link people clicked on to get to your forum). Since you have so many rows in there, the little pruning tool we have might timeout, but should be able to delete them after being run a few times. If it won't delete any, you might try using something like phpmyadmin, if you have access to it, to empty the table.

We need to get an auto prune setup for that for version 8.

Did you build something in the admin tool to view this table?

If I just empty the table via phpmyadmin (yes I have access to that), nothing gets 'broken'? No relation to other tables?

Nancy

Just goto the UBB control panel>>logs.
Select the View Referer Logs Tab
And use the Purge Entries older than option
You can view and or delete them there.
Delete a chunk at a time if it times out.

Thanks, I never used or even saw that option

You can also turn them off if you don't use them:

CP > Primary Settings > Logging > Referer Logging > Enable Referer Logging (remove the check from the box)

You know I forgot that you can disable the referer logs.
I prune them on a regular basis. But in this case it would be best to disable it. Unless needed on occasion. Then just turn it on for a while.

Thank you for the reminder to prune the log.

Hmm, I don't think I've ever used that function...