Database errors

  • Resolved andreywp

    (@andreywp)


    5 years ago

    Hello.
    I see such database errors
    https://drive.google.com/file/d/1otYxNE8axQKsmeG1KsqlJRAngrxKWAen/view?usp=sharing
    In version 7.2.5 there were no such errors. Appeared after updating version 7.2.5, but after that update there were 4 errors. After the next update, 6 errors appeared. I didn’t write right away, because I thought I would fix it in the next update. Updated to version Version 7.4.1, but errors remained.
    And one more thing, 2FA does not work (I tried to configure it in version 7.4.0).
    Look here please.

Viewing 8 replies - 1 through 8 (of 8 total)
  • WFGerroald

    (@wfgerald)

    Hey @andreywp,

    This looks like it may have been a WordPress plugin update that didn’t go well. Can you please try resetting Wordfence and let me know if it helps?

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

    Also, please let me know if it helps with Two-Factor. If it doesn’t, please share any errors and/or behavior you’re experiencing.

    Thanks,

    Gerroald

    Thread Starter andreywp

    (@andreywp)

    Resetting and removing the plugin did not help, errors remained. These errors are not in version 7.2.5

    Thread Starter andreywp

    (@andreywp)

    To the previous answer.
    My tables are not added:
    wp_wfls_2fa_secrets
    wp_wfls_settings
    I tried a reset during deactivation and a complete reinstall.

    WFGerroald

    (@wfgerald)

    Hey @andreywp,

    Thanks for the update. I’m not sure why the tables aren’t being created when you reinstall it.

    Can you send me a Diagnostics report so I can get a better overview of your environment? Please navigate to Wordfence > Tools > Diagnostics. Here you can select SEND REPORT BY EMAIL. Please include your www.remarpro.com username and update this thread after you’ve sent it.

    Please let me know.

    Thanks,

    Gerroald

    Thread Starter andreywp

    (@andreywp)

    Hello.
    The report sent as you requested. Before that, I tried to reset it again, but mistakenly remained and 2FA did not work.
    I also noticed that on the login security tab there are 49 database errors and 1 PHP error:
    array_sum () expects parameter 1 to be array, null given
    wp-content / plugins / wordfence / modules / login-security / views / options / option-captcha-threshold.php: 126
    Maybe this will help.

    Thread Starter andreywp

    (@andreywp)

    Moved to another hosting. Errors disappeared and database tables appeared:
    wp_wfls_2fa_secrets
    wp_wfls_settings
    (on the old hosting Wordfence completely deleted, but installed on a new one).
    I have not tried setting 2fa yet, but I think it will work now.

    Hey @andreywp,

    When you moved to the new host they probably support InnoDB storage engine which creates these tables. Though I’m still not sure why your previous installation wasn’t creating them. It could’ve been a permissions issue.

    https://www.wordfence.com/help/advanced/system-requirements/#database

    Either, was, please let us know how it goes

    Thanks,

    Gerroald

    Hey @andreywp,

    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 8 replies - 1 through 8 (of 8 total)
  • The topic ‘Database errors’ is closed to new replies.