Home Forums WordPress Plugins Hide My WP WordPress database error table

This topic is: not resolved
Viewing 5 posts - 1 through 5 (of 5 total)
  • Author
    Posts
  • #31494
    virgodesign
    Active
    Post count: 11

    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.
    #31502
    Suman M.
    Post count: 12463

    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 months, 1 week ago by Suman M..
    Attachments:
    You must be logged in to view attached files.
    #31507
    virgodesign
    Active
    Post count: 11

    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.

    #31514
    Suman M.
    Post count: 12463

    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!

    #31565
    virgodesign
    Active
    Post count: 11

    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.

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic.