Scans not completing, various errors and stuck points

  • Resolved bdd

    (@bws-online)


    1 year, 6 months ago

    I’m having problems getting scans to complete on a few sites. Different problems/errors at different times. They’re set up just like other sites that are working (on the same hosting account), so I’m not sure what’s going on. (I updated the sites today, updating plugins, WP core files, and theme, so everything’s current.)

    One problem when I run the scan shows it repeating a line that starts with:

    Calling Wordfence API v2.26:https://noc1.wordfence.com/v2.26/

    This is happening sometimes, too (even after I disabled all plugins on one site):

    Error writing value for wf_summaryItems (MySQLi error: [2000] Unknown or undefined error code)

    It was also just freezing on a file (no errors, not looping on a single file over and over, it just stopped), and I saw this a bunch of times:

    The current scan looks like it has failed

    I’ve tried a variety of things, but nothing’s helped yet. (For example, I tried excluding BackWPup backup files and thought that worked, but then it stopped working again. I tried deactivating BackWPup when I thought it was failing on those files, still no good.)

    I just tried rolling back to 7.11.7 in case the update cause a problem, but that didn’t help.

    Any direction you can provide on this greatly appreciated. Thanks.

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Support wfmargaret

    (@wfmargaret)

    1 year, 6 months ago

    Hi @bws-online,

    Thanks for reaching out.  I’m sorry to hear your scans are failing.  The MySQL error may be worth checking with your host about. Are there any other errors related to MySQL in your error logs, or only the one mentioning the table wf_summaryItems?

    Can you please provide details on which stages of the scan you’ve seen the scan fail at? Even though the scans are failing in different places, I’d also like to get a debugging log and diagnostics report from you.  If you could do the following steps for me:

    • Go to the Wordfence > Tools > Diagnostics page
    • In the “Debugging Options” section check the circle “Enable debugging mode” 
    • Click to “Save Changes”.
    • CANCEL any current scan and start a NEW scan
    • Click the “Email Activity Log” link once the scan finishes and send that to wftest @ wordfence.com and respond here after you have sent it.

    Wordfence > Tools > Diagnostic > Debugging Screenshot

    This will help me see exactly what is happening when the scan fails.

    Then, can you send a diagnostic report to wftest @ wordfence . com? You can find the link to do so at the top of the Wordfence > Tools > Diagnostics page. Then click on “Send Report by Email”. Please add your forum username where indicated and respond here after you have sent it.

    NOTE: It should look as follows – Screenshot of Tools > Diagnostic > Send by Email

    Let me know if you have any questions!

    Thanks,
    Margaret

    Thread Starter bdd

    (@bws-online)

    1 year, 5 months ago

    I’m sorry I missed this — wanted to post now to keep this open. I’ll explore the current situation and reply. Thanks.

    Thread Starter bdd

    (@bws-online)

    1 year, 5 months ago

    Thanks again @wfmargaret — just sent you the log and report as requested from one of the sites that’s having the problem (from when it failed last night).

    Thread Starter bdd

    (@bws-online)

    1 year, 5 months ago

    @wfmargaret Just went through and did the debug and a manual scan on all 7 sites. Some of them had messages that a scan had failed to complete about 2+ hours ago (automatic scans), but 5 of the manual scans just ran through okay. Two got stuck.

    One seemed to lock up at /wp-content/plugins/backwpup/languages/backwpup-ru_RU.po (no error message). I stopped it and started again, and it gave the “Error writing value for wf_summaryItems (MySQLi error: [2000] Unknown or undefined error code)” error and locked up at /wp-content/plugins/backwpup/vendor/microsoft/microsoft-graph/src/Beta/Microsoft/Graph/Model/AssignmentFilterEvaluateRequest.php. (When I switch to see the full log, it’s not showing the recent scan info — it’s still showing the backwpup-ru_RU.po file as the last one, where it got stuck before.) Okay, now it says “Scan Failed. The current scan looks like it has failed. Its last status update was 5 minutes ago. You may continue to wait in case it resumes or stop and restart the scan. Some sites may need adjustments to run scans reliably.”

    The other (the one that had the problem earlier that I’d already sent the requested info for) gave the “Error writing value for wf_summaryItems (MySQLi error: [2000] Unknown or undefined error code)” error and locked up at /wp-content/plugins/backwpup/vendor/microsoft/azure-storage-blob/src/Blob/Models/ListContainersResult.php Now it says “Scan Failed. The current scan looks like it has failed. Its last status update was 9 minutes ago. You may continue to wait in case it resumes or stop and restart the scan. Some sites may need adjustments to run scans reliably.”

    I just sent the latest log and report for those two to you.

    Side note: Don’t think it was an issue, but lowered max_execution_time back down to 300 in the process (I saw the WF message that 3000 was too high and it looked like it reduced it to 90, but looked around online and saw recommendations for 300 instead — hosting default was 1600).

    Thanks.

    Plugin Support wfmargaret

    (@wfmargaret)

    1 year, 5 months ago

    Hey @bws-online,

    Thanks for sending those over and all the additional details! I see both of the scans failed with a MySQLi error. On the two impacted sites, please add this line of code to your WordPress wp-config.php configuration file:

    ​define('WORDFENCE_ALLOW_DIRECT_MYSQLI', false);

    NOTE: You must insert this code ABOVE the line below:

    /* That's all, stop editing! Happy blogging. */

    Since you’re on LiteSpeed servers, you may also need to add our noabort code to your .htaccess. This prevents LiteSpeed from silently stopping the scan partway. Depending on your server configuration, you may need to use one of the alternate options. All three options are outlined here: https://www.wordfence.com/help/advanced/system-requirements/litespeed/

    Please let me know how it goes! If you find the scans failing in a different location, please send me updated activity logs and diagnostics at wftest @ wordfence . com and let me know here.

    Thanks,
    Margaret

    Thread Starter bdd

    (@bws-online)

    1 year, 5 months ago

    Thank you so much @wfmargaret!

    One site finished okay with the wp-config update. The other needed one of the .htaccess options (I tried the first one), too.

    I’m going to keep an eye on things and I’ll have these solutions if any of the other sites act up, but I think we’ll consider this resolved for now. Thanks again.

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

The topic ‘Scans not completing, various errors and stuck points’ is closed to new replies.

Tags