How to clear report data

Hi,

The db table you’re referring to should spend the majority of its time empty… it’s only used to process the scanners and when the scans are completed, the table is emptied.

If it’s not being emptied, something has gone wrong somewhere along the way. You could try deleting that particular table. Shield will recreate it if necessary.

thanks Paul! I don’t exactly know how to delete just one table in a DB as this does not happen automatically when you deactivate and delete the plugin from the looks of it.

there are also a few other tables it claims has gotten large. is there any way to reset anything that this plugin may have been storing about blocked IP addresses or anything else it stores about connections it has blocked?

Chad

Under the plugin’s General setting, there’s an option to “Delete on deactivate”, this should get you most of what you need. Try that and let us know.

that should be perfect. thank you very much!!

BTW, here are a couple of the errors I have been seeing so far:

0011.816 (0) [Warning] Table wp_h9i2j5l7_icwp_wpsf_reporting has very many rows (1263782). You may need to either remove data from this table, or contact your hosting company to request more resources.

0144.718 (0) [Warning] Table wp_h9i2j5l7_itsec_logs has very many rows (893014). You may need to either remove data from this table, or contact your hosting company to request more resources.

I tried but sadly that did not work. just ran a BKUP again and get the same 2 warnings about the same 2 tables. I even deleted and reinstalled the plugin.

thanks anyhow!! I really appreciate your time and especially your rapid response. I am a webmaster and have your software on all 50 or so of my sites, many of which have the pro version too. so I appreciate your support here on this free version. this site is for a water & waste management company and they are el cheapo.

_itsec_logs isn’t our database table.

Also, the _icwp_wpsf_reporting table probably isn’t being deleted because it isn’t a database used by Shield any longer. At some point, in the code, we will have put in code to automatically delete that. Then after a few releases, we remove that code – so I’m guessing there was a point where you hadn’t upgraded Shield for a long time and this got missed.

If you don’t know how to delete a MySQL database table, please contact your host and ask them to do this for you. Or read their docs – they’ll have docs on how to do this. That will be the only way to delete this table as it’s no longer handled by the Shield plugin.