WordPress database error table

[virgodesign]

Hi,
I’m using hide_my_wp (v6.1.0) in a wordpress multisite installation (wp v5.4 + php 7.2.0) and I’m having many daily warning inside the debug.log file.
I’ve attached a screenshot of the debug.log file warning.
It seems that hmwp try to reach a db table that does not exist.
Today I’ve updated hmwp from v6.1.0 to v6.2.0 and after a couple of hours I’ve found the debug.log heavely full of these warnings.
I’ve currently revert back to v6.1.0, but the problem persist anyway.
The attached file shows a warning captured with version 6.1.0.

I’m running a multisite environment and we do a daily check and monitor of the debug.log file.
With all this warning it became impossible for us to work and check our debug.log file correctly.

If needed I can provide further informations.

Please let me know if there is a solution to this problem and how to fix it.
Thank you very much in advance.

Virgilio

Attachments:

You must be logged in to view attached files.

[Suman M.]

Hi, thanks for contacting us. The database table _hmwp_blocked_ips seems to be missing (not created) in your site.
Please run the SQL query (using phpMyAdmin) attached below (replace wp123_ with your site’s table prefix before running the query).
Let us know!

• This reply was modified 4 years, 6 months ago by Suman M..

Attachments:

You must be logged in to view attached files.

[virgodesign]

Hi Suman,
thanks for the reply.
The table is missing in every subsite on the network.
So I suppose We have to run this script for every existing subsite.
Also this must be executed when a new blog is created on the network.
I think this routine should be included in a next version of hide my wp.
Thanks for the solution. I will try and let you know.

[Suman M.]

It seems like we don’t have such issue in our test site. However, we will check it. Let us know if the above solution works for you.

Regards!

[virgodesign]

Hi Suman,
sorry for this long delay.

I ran your sql query for every existing subsite, and now there are no more php warnings printed in the debug.log file.

But, the problem persists every time a new blog is created.
It seems like HMWP does not generate the hmwp_blocked_ips db table as a new blog is created.
It seems that the function activate withing the HMWP_MS_IDS class in mute-screamer.php file won’t be executed.

Maybe the problem is that HMWP is network activated in my installation?

For now I’ve resolved hookin into wp_insert_site action and creating here the missing table.
Thanks in advance.

[Author]

Posts