Thread

Hi,

I was just creating a database backup and noticed a table called `exp_security_hashes`.

It seems to be storing a lot of data, including ip addresses. Could someone tell me what this is doing and why? I’m a bit concerned about the size of this table, and if it will continue getting bigger! Is there an option in the control panel to switch this off?

Thanks 😊

This table has records written to it each time a form is generated, as part of the Secure Forums feature. It will automatically purge itself every 10 days, but you are safe to truncate it now if you like (just don’t DROP the table—TRUNCATE):

TRUNCATE exp_security_hashes

This will immediately empty out that table.

This table has records written to it each time a form is generated, as part of the Secure Forums feature. It will automatically purge itself every 10 days, but you are safe to truncate it now if you like (just don’t DROP the table—TRUNCATE):

TRUNCATE exp_security_hashes

This will immediately empty out that table.

Thanks for the reply - is it possible to change the automatic setting so the records are purged more frequently?

No, it’s not a configurable option at this point. Feel free to make the appropriate feature request.

Not without hacking a core file, mork.  You might instead wish to trigger faster clearing via the cron plugin.