Site Log Error Messages

  • Resolved art013

    (@art013)


    9 years, 2 months ago

    Since about 7-Aug, my site error log has been filling up with “WordPress database error Table” messages like these:

    jp_wfNet404s’ doesn’t exist for query insert IGNORE into jp_wfNet404s (sig, ctime, URI) values (UNHEX(MD5(‘/sitemapindex.xml’)), unix_timestamp(), ‘/sitemapindex.xml’) made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), do_action(‘template_redirect’), call_user_func_array, wordfence::templateRedir, wordfence::doEarlyAccessLogging, wfLog->logLeechAndBlock, wfDB->queryWrite

    jp_wfNet404s’ doesn’t exist for query select URI from jp_wfNet404s where ctime > unix_timestamp() – 3600 limit 1000 made by do_action_ref_array, call_user_func_array, wordfence::hourlyCron, wfDB->querySelect

    jp_wfNet404s’ doesn’t exist for query truncate table jp_wfNet404s made by do_action_ref_array, call_user_func_array, wordfence::hourlyCron, wfDB->truncate, wfDB->queryWrite

    Prior to this date, the error log was clean. I removed WordFence and all wf tables a week or so ago and reinstalled with a fresh download thinking the plugin may have been corrupted. But after the new install, I’m seeing the same messages.

    Any thoughts?

    Thanks

    https://www.ads-software.com/plugins/wordfence/

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author WFMattR

    (@wfmattr)

    Usually, removing the tables and reinstalling the plugin (as you did) should cause the table to be re-created, so there seems to be some trouble with your site’s database.

    On the Wordfence Options page, can you click the link “Click to see a list of your system’s database tables in a new window”, near the bottom of the page? If you can post a screenshot of the bottom section of that page (as much as you can fit in the browser), we can see the status of some of the Wordfence tables.

    If the wfNet404s table is missing completely, and your site is using InnoDB tables, your host may need to fix your database. Sometimes tables that are used frequently for temporary data can be broken by the database server by a bug in InnoDB, which prevents the table from being re-created properly.

    Thread Starter art013

    (@art013)

    Yes, the wfNet404s table is missing completely. As are wfHoover and wfVulnScanners according to the database repair I just ran.

    What are the specs for those tables so I can recreate them?

    Thanks!

    Plugin Author WFMattR

    (@wfmattr)

    If Wordfence could not create the tables when you reinstalled it, I don’t think you’ll be able to create them manually — or if you can, they’ll break the next time a scan is run again.

    You could double check that the database user does have all privileges on the database (in case the host changed something), but I think you will need your host’s mysql administrator to fix the database so that the tables can be recreated without problems. They may also be able to see what happened in mysql’s error log, if they match it to the time of the first message from your site’s error log above.

    If you really do want to try manually creating the tables, be sure you have a backup of the whole database first — then you can find the column definitions for each table in wfSchema.php. The rest of the “create” statement is near the bottom of the file.

    I am not posting the whole definition here just because I don’t want other people to think this is an official solution in the future, where they might copy & paste code and break their databases (especially if the schema changes in a newer version of Wordfence). I hope that is ok!

    Thread Starter art013

    (@art013)

    That’s perfect Matt. Thanks.

    I once again removed the WF tables and deleted the WF plugin. I verified there were no WF tables in the database.

    I then reinstalled WF and verified the missing tables were created and then activated WF. Made my modifications to the base set up (enabling Falcon, comparing theme and plugin code, etc.) and again verified the tables are still in the database.

    So, we seem to have a clean install as of now (10:56 pm PDT). I will monitor the error log and see what’s going on. Maybe we can pinpoint when/if the tables disappear.

    Thanks for your hep and explanations. I helped me get my old coding hat back on to dig in a bit deeper.

    I’ll be back if the tables disappear again. ??

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Site Log Error Messages’ is closed to new replies.