sbb_visitorslog growing exponentially & no way to purge this table

Hi Pat,
I will check that but we have a cron job to clear this table and also we remove that on uninstall.
Anyway, we will double check tomorrow if it is working or something fails (London Timezone).
Cheers,
Bill

Thanks for the fast reply Bill. On the sites in question wp-cron.php has been disabled and a manual cron job set up via cPanel (to speed things up) – in case your plugin is hooking into wp-cron.

I believe the other 2 tables that were not removed on uninstall were sbb_fingerprint and sbb_http_tools.

Thanks for letting me know.
I will double-check that and let you know tomorrow.

Hi Pat,
We just uploaded version 6.10 and fixed the uninstall to remove also that 3 tables.
Yes, the plugin needs the cron jobs working to manage and clear the visitor’s log table.
Otherwise, you need to manage it by PHPmyAdmin and we suggest keep only last 30 days records.
Thanks for the suggestions and for helping us to improve the plugin.
Cheers,
Bill

How to clear the visit log table
Log is too big
And I cannot find any button to clear the table
Plugin is good
Thank you

Hi Pat,

First of all, update your plugin to the last version available.

The plugin delete daily all records with more than 1 month.
The plugin needs the WordPress cron jobs working to manage the visitor’s log table.

You can empty the table with phpMyAdmin utility

command:
delete from sbb_visitorslog WHERE date < CURDATE() – interval 30 day

add the table prefix to name of the table: sbb_visitorslog

If you deinstall the plugin it clear all tables. Then, install again.

Cheers,
Bill

I hope this is sorted, gonna go ahead and mark as “resolved” to help keep things organized. Feel free to post again with any further questions or feedback, etc. Thank you.