DB error for Defender Pro

I have a serious issue that appears to be caused by Defender... See below:

WordPress database error: [Table 'i*******_defender_lockout' doesn't exist]
SELECT id, ip, status, lockout_message, release_time, lock_time, lock_time_404, attempt, attempt_404, meta FROM w***a_defender_lockout WHERE ip = '223.24.62.164' LIMIT 0,1

The first error is from my staging site, which adds ST1 to the DB name. The below one is from the production site.

WordPress database error: [Table '****_defender_lockout' doesn't exist]
SELECT id, ip, status, lockout_message, release_time, lock_time, lock_time_404, attempt, attempt_404, meta FROM ***_defender_lockout WHERE ip = '223.24.62.164' LIMIT 0,1

  • Ash
    • WordPress Hacker

    Hello Joel

    Looks like for some reasons the tables were not created. I have made some adjustment directly in the DB of the staging site. Would you please check the staging site now?

    If it is okay in staging site, then you need to run this SQL in phpmyadmin for the live site DB as well: https://pastebin.com/5yw3DCPn

    Or you can ask me and I can do it.

    Please let us know how it goes. Have a nice day!

    Cheers,
    Ash

Thank NAME, for their help.

Let NAME know exactly why they deserved these points.

Gift a custom amount of points.