• Hi,

    I’ve been using WordFence for a couple of weeks now on a few websites and one of them is creating a long error log full of database issues which I can’t resolve. Most of them look like this:

    [08-Jan-2015 08:44:34 UTC] WordPress databasefout Table ‘hypmain_L3rQ.wp_wfVulnScanners’ doesn’t exist bij query select INET_NTOA(IP) as IP from wp_wfVulnScanners where ctime > unix_timestamp() – 3600 gemaakt door do_action_ref_array, call_user_func_array, wordfence::hourlyCron, wfDB->querySelect
    [08-Jan-2015 08:44:34 UTC] WordPress databasefout Table ‘hypmain_L3rQ.wp_wfVulnScanners’ doesn’t exist bij query truncate table wp_wfVulnScanners gemaakt door do_action_ref_array, call_user_func_array, wordfence::hourlyCron, wfDB->truncate, wfDB->queryWrite

    When looking in phpMyAdmin the table seems to exist at first sight in the very left overview panel of all database tables. However when I click on that table I do receive an error message that the table doesn’t exist. See the screenshot at the following link: http://grab.by/DCdu

    I’ve already tried to deactivate the plugin and remove it and then manually removed all wp_wf tables in phpMyAdmin. When I reinstall te plugin I’m getting different error messages, again with database tables that don’t exist like:

    Wordfence generated an error on activation. The output we received during activation was: WordPress database error: [Table ‘hypmain_L3rQ.wp_wfVulnScanners’ doesn’t exist] create table IF NOT EXISTS wp_wfVulnScanners ( IP int UNSIGNED PRIMARY KEY, ctime int UNSIGNED NOT NULL, hits int UNSIGNED NOT NULL )

    And

    Wordfence generated an error on activation. The output we received during activation was: WordPress database error: [Table ‘hypmain_L3rQ.wp_wfConfig’ doesn’t exist] select val from wp_wfConfig where name=’disableConfigCaching’ WordPress database error: [Table ‘hypmain_L3rQ.wp_wfConfig’ doesn’t exis…[output truncated]

    Is there any way to resolve these database errors? Wordfence is scanning though even with these errors but I would like to keep my error log as clean as possible.

    Thanks in advance.

    https://wordpress.org/plugins/wordfence/

Viewing 11 replies - 1 through 11 (of 11 total)
  • Have you tried using Wordfence to remove all tables on deactivation before reinstalling?:

    Options -> Other options -> Delete Wordfence tables and data on deactivation?

    Or, there is also: https://wordpress.org/plugins/wordfence-assistant/

    Thread Starter Niels Pilon

    (@nielspilon)

    Hi Barnez,

    Thanks for your suggestion. I hadn’t tried that yet but just did. The ‘wp_wfVulnScanners’ table is now fully deleted but I’m still getting the same error that the ‘wp_wfConfig’ doesn’t exist when activating the plugin.

    Doing a new scan now and I’m not getting any error messages so far.

    Thread Starter Niels Pilon

    (@nielspilon)

    Looking back at the error log after a few hours and scans and I’m still getting the same error message as before:

    [09-Jan-2015 03:35:40 UTC] WordPress databasefout Table ‘hypmain_L3rQ.wp_wfVulnScanners’ doesn’t exist bij query delete from wp_wfVulnScanners gemaakt door do_action_ref_array, call_user_func_array, wordfence::hourlyCron, wfDB->truncate, wfDB->queryWrite

    Why keeps this happening even after a full reinstall and clean database without any Wordfence tables left?

    Ok, not sure I understand here. You removed the tables and deleted the plugin then reinstalled wordfence from scratch?

    tim

    When a table appears to exist, but also gives errors when trying to use it, it is probably a MySQL InnoDB issue, and not Wordfence itself.

    I don’t work for Wordfence, but I remember a post here by another user a few months ago who refused to believe that it was a MySQL issue. (Tim might remember — the user was extremely rude!)

    Make sure to back up your databases before trying anything! But here are a couple pages that explain possible solutions — though if your hosting company offers support for database issues, you might also see if they can fix it — they may have seen the problem before, with any InnoDB table:

    http://dba.stackexchange.com/questions/69656/cant-create-table-but-table-doesnt-exist

    http://forums.cpanel.net/f354/innodb-tables-exist-but-phpmyadmin-gives-error-1146-table-xxx-doesnt-exist-393491.html

    @mwrusnak Yeah I remember that guy, but not the specifics. I believe my butt still has his teeth marks! lol I can’t find the original post either. πŸ™

    I’d also make sure you aren’t running into an issue with the db user permissions. Might be a good idea to verify.

    tim

    Thread Starter Niels Pilon

    (@nielspilon)

    @tim, yes that way and also the suggested way by Barnez; using the option to remove the tables during deactivation.

    I’ve installed the plugin on many sites that I update and manage from the Infinite WordPress (IWP) control panel. It seems that this isn’t the only database effected any that many, but not all, sites that have WordFence installed through IWP have the same issue. And unfortunately that causes our database server to crash from time to time.

    So I’m currently deactivating the plugin to prevent the database server from crashing again. My hosting company suggested my to contact WordFence as thay can’t do anything. Well. that’s what they say at least…

    I’ll have a look at the link posted by mwrusnak and see if that has some usefull information. Besides that I’ll have a look later on and see if I can notice any difference between the databases with WordFence that don’t give these errors and the databases that gives the error.

    Thread Starter Niels Pilon

    (@nielspilon)

    @tim, regarding the user permissions, the db user has full access / full permissions.

    So is it all the sites with IWP? Or just some?

    tim

    Thread Starter Niels Pilon

    (@nielspilon)

    No, just some Tim. I just checked it and it’s completely random.

    I also looked with more detail into the affected and non-affected database and at first sight it looked like all affected databases are using latin1_swedish_ci collocation and the unaffected utf8_general_ci. But also some unaffected databases are using latin1_swedish_ci as collocation so that shouldn’t be the cause of the problem. But I’m totally not a mySQL/database expert so I could be totally wrong.

    I’m having a similar problem.

    But here the tables really don’t exists.
    I installed and reinstalled the plugin several times (Both local machine and AWS).

Viewing 11 replies - 1 through 11 (of 11 total)

The topic ‘Error log full of missing database tables’ is closed to new replies.