• Resolved sgoifo

    (@sgoifo)


    Hello to every one,

    I’m getting an error in the log file every second, it is filling my server with this. The file already has many GBs due to this.

    How can I stop it?

    This is the error:

    Mon Mar 23 20:14:27.368427 2020] [proxy_fcgi:error] [pid 4118:tid 139659287308032] [client 172.26.7.9:38230] AH01071: Got error ‘hq.INTO’ doesn’t exist for query SHOW FULL COLUMNS FROM INTO made by do_action(‘wp_ajax_nopriv_wordfence_doScan’), WP_Hook->do_action, WP_Hook->apply_filters, wordfence::ajax_doScan_callback, wfScan::wfScanMain, wfScanEngine->go, wfScanEngine->doScan, wfScanEngine->scan_fileContents_main, wordfenceScanner->scan, wordfenceURLHoover->hoover, wordfenceURLHoover->writeHosts, wfDB->queryWrite\nPHP message: WordPress database error Table ‘wp_yellowletterhq.INTO’ doesn’t exist for query SHOW FULL COLUMNS FROM INTO made by do_action(‘wp_ajax_nopriv_wordfence_doScan’), WP_Hook->do_action, WP_Hook->apply_filters, wordfence::ajax_doScan_callback, wfScan::wfScanMain, wfScanEngine->go, wfScanEngine->doScan, wfScanEngine->scan_fileContents_main, wordfenceScanner->scan, wordfenceURLHoover->hoover, wordfenceURLHoover->writeHosts, wfDB->queryWrite\nPHP message: WordPress database error Table ‘wp_yellowletterhq.INTO’ doesn’t exist for query SHOW FULL COLUMNS FROM INTO made by do_action(‘wp_ajax_nopriv_wordfence_doScan’), WP_Hook->do_action, WP_Hook->apply_filters, wordfence::ajax_doScan_callback, wfScan::wfScanMain, wfScanEngine->go, wfScanEngine->doScan, wfScanEngine->scan_fileContents_main, wordfenceScanner->scan, wordfenceURLHoover->hoover, wordfenceURLHoover->writeHosts, wfDB->queryWrite\nPHP message: WordPress database error Table ‘wp_yellowletterhq.INTO’ doesn’t exist for query SHOW FULL COLUMNS FROM INTO made by do_action(‘wp_ajax_nopriv_wordfence_doScan’), WP_Hook->do_action, WP_Hook->apply_filters, wordfence::ajax_doScan_callback, wfScan::wfScanMain, wfScanEngine->go, wfScanEngine->doScan, wfScanEngine->scan_fileContents_main, wordfenceScanner->scan, wordfenceURLHoover->hoover, wordfenceURLHoover->writeHosts, wfDB->queryWrite\nPHP message: WordPress database error Table ‘wp_yellowletterhq.INTO’ doesn’t exist for query SHOW FULL COLUMNS FROM INTO made by do_action(‘wp_ajax_nopriv_wordfence_doScan’), WP_Hook->do_action, WP_Hook->apply_filters, wordfence::ajax_doScan_callback, wfScan::wfScanMain, wfScanEngine->go, wfScanEngine->doScan, wfScanEngine->scan_fileContents_main, wordfenceScanner->scan, wordfenceURLHoover->hoover, wordfenceURLHoover->writeHosts, wfDB->queryWrite\nPHP message: WordPress database error Table ‘wp_yellowletterhq.INTO’ doesn’t exist for query SHOW FULL COLUMNS FROM INTO made by do_action(‘wp_ajax_nopriv_wordfence_doScan’), WP_Hook->do_action, WP_Hook->apply_filters, wordfence::ajax_doScan_callback, wfScan::wfScanMain, wfScanEngine->go, wfScanEngine->doScan, wfScanEngine->scan_fileContents_main, wordfenceScanner->scan, wordfenceURLHoover->hoover, wordfenceURLHoover->writeHosts, wfDB->queryWrite\nPHP message: WordPress database error Table ‘wp_yellowletterhq.INTO’ doesn’t exist for query SHOW FULL COLUMNS FROM INTO made by do_action(‘wp_ajax_nopriv_wordfence_doScan’), WP_Hook->do_action, WP_Hook->apply_filters, wordfence::ajax_doScan_callback, wfScan::wfScanMain, wfScanEngine->go, wfScanEngine->doScan, wfScanEngine->scan_fileContents_main, wordfenceScanner->scan, wordfenceURLHoover->hoover, wordfenceURLHoover->writeHosts, wfDB->queryWrite\nPHP message: WordPress database error Table ‘wp_yellowletterhq.INTO’ doesn’t exist for query SHOW FULL COLUMNS FROM INTO made by do_action(‘wp_ajax_nopriv_wordfence_doScan’), WP_Hook->do_action, WP_Hook->apply_filters, wordfence::ajax_doScan_callback, wfScan::wfScanMain, wfScanEngine->go, wfScanEngine->doScan, wfScanEngine->scan_fileContents_main, wordfenceScanner->scan, wordfenceURLHoover->hoover, wordfenceURLHoover->writeHosts, wfDB->queryWrite\nPHP message: WordPress database error Table ‘wp_yellowletterhq.INTO’ doesn’t exist for query SHOW FULL COLUMNS FROM INTO made by do_action(‘wp_ajax_nopriv_wordfence_doScan’), WP_Hook->do_action, WP_Hook->apply_filters, wordfence::ajax_doScan_callback, wfScan::wfScanMain, wfScanEngine->go, wfScanEngine->doScan, wfScanEngine->scan_fileContents_main, wordfenceScanner->scan, wordfenceURLHoover->hoover, wordfenceURLHoover->writeHosts, wfDB->queryWrite\nPHP message: WordPress database error Table ‘wp_yellowletterhq.INTO’ doesn’t exist for query SHOW FULL COLUMNS FROM INTO made by do_action(‘wp_ajax_nopriv_wordfence_doScan’), WP_Hook->do_action, WP_Hook->apply_filters, wordfence::ajax_doScan_callback, wfScan::wfScanMain, wfScanEngine->go, wfScanEngine->doScan, wfScanEngine->scan_fileContents_main, wordfenceScanner->scan, wordfenceURLHoover->hoover, wordfenceURLHoover->writeHosts, wfDB->queryWrite\nPHP message: WordPress database error Table ‘wp_yellowletterhq.INTO’ doesn’t exist for query SHOW FULL COLUMNS FROM INTO made by do_action(‘wp_ajax_nopriv_wordfence_doScan’), WP_Hook->do_action, WP_Hook->apply_filters, wordfence::ajax_doScan_callback, wfScan::wfScanMain, wfScanEngine->go, wfScanEngine->doScan, wfScanEngine->scan_fileContents_main, wordfenceScanner->scan, wordfenceURLHoover->hoover, wordfenceURLHoover->writeHosts, wfDB->queryWrite\nPHP message: WordPress database error Table ‘wp_yellowletterhq.INTO’ doesn’t exist for query SHOW FULL COLUMNS FROM INTO made by do_action(‘wp_ajax_nopriv_wordfence_doScan’), WP_Hook->do_action, WP_Hook->apply_filters, wordfence::ajax_doScan_callback, wfScan::wfScanMain, wfScanEngine->go, wfScanEngine->doScan, wfScanEngine->scan_fileContents_main, wordfenceScanner->scan, wordfenceURLHoover->hoover, wordfenceURLHoover->writeHosts,wfDB->queryWrite\nPHP message: WordPress database error Table ‘wp_yellowletterhq.INTO’ doesn’t exist for query SHOW FULL COLUMNS FROM INTO made by do_action(‘wp_ajax_nopriv_wordfence_doScan’), WP_Hook->do_action, WP_Hook->apply_filters, wordfence::ajax_doScan_callback, wfScan::wfScanMain, wfScanEngine->go, wfScanEngine->doScan, wfScanEngine->scan_fileContents_main, wordfenceScanner->scan, wordfenceURLHoover->hoover, wordfenceURLHoover->writeHosts, wfDB->queryWrite\nPHP message: WordPress database error Table ‘wp_yellowletterhq.INTO’ doesn’t exist for query SHOW FULL COLUMNS FROM INTO made by do_action(‘wp_ajax_nopriv_wordfence_doScan’), WP_Hook->do_action, WP_Hook->apply_filters, wordfence::ajax_doScan_callback, wfScan::wfScanMain, wfScanEngine->go, wfScanEngine->doScan, wfScanEngine->scan_fileContents_main, wordfenceScanner->scan, wordfenceURLHoover->hoover, wordfenceURLHoover->writeHosts, wfDB->queryWrite\nPHP message: WordPress database error Table ‘wp_yellowletterhq.INTO’ doesn’t exist for query SHOW FULL COLUMNS FROM INTO made by do_action(‘wp_ajax_nopriv_wordfence_doScan’), WP_Hook->do_action, WP_Hook->apply_filters, wordfence::ajax_doScan_callback, wfScan::wfScanMain, wfScanEngine->go, wfScanEngine->doScan, wfScanEngine->scan_fileContents_main, wordfenceScanner->scan, wordfenceURLHoover->hoover, wordfenceURLHoover->writeHosts, wfDB->queryWrite\nPHP message: WordPress database error Table ‘wp_yellowletterhq.INTO’ doesn’t exist for query SHOW FULL COLUMNS FROM INTO made by do_action(‘wp_ajax_nopriv_wordfence_doScan’), WP_Hook->do_action, WP_Hook->apply_filters, wordfence::ajax_doScan_callback, wfScan::wfScanMain, wfScanEngine->go, wfScanEngine->doScan, wfScanEngine->scan_fileContents_main, wordfenceScanner->scan, wordfenceURLHoover->hoover, wordfenceURLHoover->writeHosts, wfDB->queryWrite\nPHP message: WordPress database error Table ‘wp_yellowletterhq.INTO’ doesn’t exist for query SHOW FULL COLUMNS FROM INTO made by do_action(‘wp_ajax_nopriv_wordfence_doScan’), WP_Hook->do_action, WP_Hook->apply_filters, wordfence::ajax_doScan_callback, wfScan::wfScanMain, wfScanEngine->go, wfScanEngine->doScan, wfScanEngine->scan_fileContents_main, wordfenceScanner->scan, wordfenceURLHoover->hoover, wordfenceURLHoover->writeHosts, wfDB->queryWrite\nPHP message: WordPress database error Table ‘wp_yellowletterhq.INTO’ doesn’t exist for query SHOW FULL COLUMNS FROM INTO made by do_action(‘wp_ajax_nopriv_wordfence_doScan’), WP_Hook->do_action, WP_Hook->apply_filters, wordfence::ajax_doScan_callback, wfScan::wfScanMain, wfScanEngine->go, wfScanEngine->doScan, wfScanEngine->scan_fileContents_main, wordfenceScanner->scan, wordfenceURLHoover->hoover

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Wordfence Security

    (@mmaunder)

    Looks like a DB error. Is there anything non-standard about your database setup? Are you running a windows server?

    The query appears to be a ‘Show full columns from’ query so does your DB user have permissions to perform a ‘show columns’ query?

    I’m filling in for our support team today. Wanted to get you a reply quickly. If you can get that data and reply here, the team will be able to help when they get to your post.

    Thanks,

    Mark.

    Hey @sgoifo,

    I’d like to follow up here.

    Have you had a chance to follow-up with your host to see if the permissions are correct as Mark suggested?

    If you’re still having the issue, and your permissions are correct can you please try completely resetting Wordfence?

    https://www.wordfence.com/help/advanced/remove-or-reset/#remove-or-reset

    Please let me know.

    Thanks,

    Gerroald

    Hey @sgoifo,

    We haven’t heard back from you in a while, so I’ve gone ahead and marked this thread as resolved.

    Please feel free to open another thread if you’re still having issues with Wordfence.

    Thanks,

    Gerroald

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Log error every one second’ is closed to new replies.