Error Php after update version V2.0

  • Resolved NAROLLES

    (@narolles)


    3 years, 1 month ago

    Good morning
    I encounter this php error (3X) which seems to come from your plugin after update

    [18-Apr-2023 18:54:00 UTC] WordPress database error Duplicate column name ‘reason’ for query ALTER TABLE wp_lockdowns ADD COLUMN <strong>reason</strong> varchar(200) NULL made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, LoginLockdown::init, LoginLockdown_Setup::maybe_upgrade, LoginLockdown_Setup::create_custom_tables, dbDelta

    [18-Apr-2023 18:54:03 UTC] WordPress database error Duplicate column name ‘unlocked’ for query ALTER TABLE wp_lockdowns ADD COLUMN <strong>unlocked</strong> smallint(20) NOT NULL default ‘0’ made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, LoginLockdown::init, LoginLockdown_Setup::maybe_upgrade, LoginLockdown_Setup::create_custom_tables, dbDelta

    The page I need help with: [log in to see the link]

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author Alexandru Tapuleasa

    (@talextech)

    3 years, 1 month ago

    Hi,

    Sorry to hear that 🙁

    It sounds like the upgrade function that should update the plugin tables has failed to do so for some reason. It might try to do it again but if you keep seeing those errors, you will need to delete the old plugin tables by following these steps:
    1. Go to Login Lockdown settings page

    2. In the Login Protection tab go to Advanced subtab

    3. Enable the Wipe Data on Plugin Delete option and click Save Settings

    4. Go to the Plugins page and Deactivate Login Lockdown, then Delete Login Lockdown

    That should get rid of the old log tables and you can then install Login Lockdown again and everything should be OK 🙂

    Thread Starter NAROLLES

    (@narolles)

    3 years, 1 month ago

    Good morning
    thank-you for your prompt response
    I followed your instructions – I leave some time to see if the error comes back

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

The topic ‘Error Php after update version V2.0’ is closed to new replies.