• Resolved karmicbuzz

    (@karmicbuzz)


    Hi. my wordfence scan repeatedly shows this and does not complete the scan. Tried it a number of times.
    It says,’Scan Failed
    The previous scan has failed. Some sites may need adjustments to run scans reliably’.

    I referred to one of the similar forum topics (not exactly the same problem) and followed the steps by clicking the debug mode. I am pasting the last 20 lines of the show log after the scan stopped—

    Oct 17 22:29:50] Scanning contents: wp-content/plugins/wordpress-seo-premium/vendor/yoast/wordpress-seo/admin/endpoints/class-endpoint-file-size.php (Size: 1.7 KB Mem: 22 MB)
    [Oct 17 22:29:50] Scanning contents: wp-content/plugins/wordpress-seo-premium/vendor/yoast/wordpress-seo/src/helpers/indexable-helper.php (Size: 7.1 KB Mem: 22 MB)
    [Oct 17 22:29:50] Scanning contents: wp-content/plugins/astra-addon/addons/lifterlms/classes/class-astra-customizer-lifterlms-panels-and-sections.php (Size: 2.02 KB Mem: 22 MB)
    [Oct 17 22:29:50] Scanning contents: wp-content/plugins/astra-addon/classes/modules/target-rule/select2.js (Size: 146.07 KB Mem: 22 MB)
    [Oct 17 22:29:50] Scanning contents: wp-content/plugins/elementor-pro/modules/forms/classes/ajax-handler.php (Size: 8.82 KB Mem: 22 MB)
    [Oct 17 22:29:50] Scanning contents: wp-content/plugins/astra-addon/classes/builder/type/header/off-canvas/dynamic-css/dynamic.css.php (Size: 1.96 KB Mem: 22 MB)
    [Oct 17 22:29:50] Scanning contents: wp-content/plugins/wp-rocket/inc/3rd-party/plugins/seo/yoast-seo.php (Size: 3.18 KB Mem: 22 MB)
    [Oct 17 22:29:50] Scanning contents: wp-content/plugins/wordpress-seo-premium/vendor/yoast/wordpress-seo/src/helpers/pagination-helper.php (Size: 3.47 KB Mem: 22 MB)
    [Oct 17 22:29:50] Scanning contents: wp-content/plugins/wp-rocket/inc/Engine/Optimization/RUCSS/Database/Schemas/UsedCSS.php (Size: 1.89 KB Mem: 22 MB)
    [Oct 17 22:29:51] Scanning contents: wp-content/plugins/elementor-pro/docs/modules/payments/classes/payment-button.php.md (Size: 1.98 KB Mem: 22 MB)
    [Oct 17 22:29:51] Scanning contents: wp-content/plugins/wordpress-seo-premium/vendor/yoast/wordpress-seo/src/config/wincher-client.php (Size: 3.82 KB Mem: 22 MB)
    [Oct 17 22:29:51] Scanning contents: wp-content/plugins/wordpress-seo-premium/vendor/yoast/wordpress-seo/admin/roles/class-role-manager-wp.php (Size: 1.42 KB Mem: 22 MB)
    [Oct 17 22:29:51] Scanning contents: wp-content/plugins/astra-addon/classes/builder/type/base/configurations/class-astra-divider-component-configs.php (Size: 13.18 KB Mem: 22 MB)
    [Oct 17 22:29:51] Scanning contents: wp-content/plugins/elementor-pro/assets/js/app.min.js (Size: 150.95 KB Mem: 22 MB)
    [Oct 17 22:29:51] Scanning contents: wp-content/plugins/wordpress-seo-premium/vendor/yoast/wordpress-seo/vendor/composer/ClassLoader.php (Size: 15.69 KB Mem: 22 MB)
    [Oct 17 22:29:51] Scanning contents: wp-content/plugins/wordpress-seo-premium/vendor/yoast/wordpress-seo/src/schema-templates/recipe-name.block.php (Size: 347 B Mem: 22 MB)
    [Oct 17 22:29:51] Scanning contents: wp-content/plugins/wordpress-seo-premium/vendor/yoast/wordpress-seo/vendor_prefixed/wordproof/wordpress-sdk/app/Helpers/TimestampHelper.php (Size: 3.38 KB Mem: 22 MB)
    [Oct 17 22:29:51] Scanning contents: wp-content/plugins/wp-rocket/assets/js/cpcss-removal.js (Size: 784 B Mem: 22 MB)
    [Oct 17 22:29:51] Scanning contents: wp-content/plugins/elementor-pro/modules/theme-builder/documents/archive-single-base.php (Size: 1.39 KB Mem: 22 MB)
    [Oct 17 22:29:51] Scanning contents: wp-content/plugins/wp-rocket/vendor/monolog/monolog/src/Monolog/Handler/GelfHandler.php (Size: 1.95 KB Mem: 22 MB)
    [Oct 17 22:29:51] Scanning contents: wp-content/plugins/wordpress-seo-premium/vendor/yoast/wordpress-seo/src/conditionals/admin/post-conditional.php (Size: 736 B Mem: 22 MB)
    [Oct 17 22:29:51] No files remaining for malware scan.
    [Oct 17 22:29:51] Scanned contents of 3898 additional files at 34.76 per second
    [Oct 17 22:29:51] Asking Wordfence to check URLs against malware list.
    [Oct 17 22:29:51] Gathering host keys.
    [Oct 17 22:29:51] Using MySQLi directly.
    [Oct 17 22:29:51] Done file contents scan
    [Oct 17 22:29:51] Calling Wordfence API v2.26:https://noc1.wordfence.com/v2.26/?k=b8f91acd3c14708018c43ba6bf632c97a0a25a4b486d053c498ffa907637db37d9d8565ebccc6bdb5acd67096aca833f2da87fb84d3d08bcaf3c83ebebb82e98c7b9e6985ef5c36dabb8a91acd4cea5d&s=eyJ3cCI6IjYuMC4yIiwid2YiOiI3LjcuMSIsIm1zIjpmYWxzZSwiaCI6Imh0dHBzOlwvXC9rYXJtaWNidXp6LmNvbSIsInNzbHYiOjI2OTQ4ODM5OSwicHYiOiI3LjQuMzIiLCJwdCI6ImxpdGVzcGVlZCIsImN2IjoiNy43MS4wIiwiY3MiOiJPcGVuU1NMXC8xLjEuMXAiLCJzdiI6IkxpdGVTcGVlZCIsImR2IjoiMTAuMy4zNi1NYXJpYURCIiwibGFuZyI6IiJ9&action=record_scan_metrics
    [Oct 17 22:29:51] Scan terminated with error: Unable to query database
Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Support wfpeter

    (@wfpeter)

    Hi @karmicbuzz,

    When I’ve seen the Unable to query database message in the past, it is related to a missing database table. A complete re-install of Wordfence might be a good step. It’s always best to make a backup of the site and database before installing/removing plugins, just to be safe.

    Additionally, you can backup your Wordfence settings via the Export option. Navigate to Wordfence > Tools > Import/Export Options and click Export. You can also take note of the current Whitelisted URLs you have in Wordfence > Firewall > All Firewall Options > Whitelisted URLs as these are NOT included in the Import/Export, and will be lost during the re-install.
    Here is what is exported: https://www.wordfence.com/help/tools/import-export/
    During the export, you will be given a long string of text. Keep this safe, you’ll need it in a few minutes.

    After that, enable the option to Delete Wordfence tables and data on deactivation in All Options > General Wordfence Options. You will want to remember to disable this after you reinstall Wordfence again.

    After you enable that option, you can deactivate Wordfence from the Plugins area of your site, then delete it. Next, from the plugins area, search for and re-install Wordfence like normal.

    It will be like setting Wordfence up for the first time. You will need to enter an email address, and then go into Tools > Import/Export Options and paste that string of text into the Import Wordfence Options field and click the button there.

    The firewall will be in Learning Mode by default for 7 days. I would recommend switching this to Enabled and Protected as soon as possible.

    Let me know how you get on!

    Peter.

    Thread Starter karmicbuzz

    (@karmicbuzz)

    Hi Peter,

    Yes the database tables were missing. I did exactly asyou mentioned in the trailing mail and had a fress install of wordfence. Also, I cannot see wp-maintenance mode anymore and the last login details do not show.

    Kindly advise.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘The scan has failed repeatedly. Kindly help’ is closed to new replies.