plugins all show “Update failed” when I try to update them

  • Resolved robertadamsnextraq

    (@robertadamsnextraq)


    2 years, 10 months ago

    I just upgraded to WordPress 5.9.2 and started updating plugins. Initially, they worked but then any plugin I try to update gives an error the one below (not specific to any plugin, this happens to many). Interestingly, when I refresh the page, it seems the update was successful.

    Update failed: {"success":true,"data":{"update":"plugin","slug":"duplicate-page","oldVersion":"Version 4.4.7","newVersion":"Version 4.4.8","plugin":"duplicate-page\/duplicatepage.php","pluginName":"Duplicate Page","debug":["Enabling Maintenance mode…","Downloading update from https:\/\/downloads.www.remarpro.com\/plugin\/duplicate-page.zip…","The authenticity of duplicate-page.zip could not be verified as no signature was found.","Unpacking the update…","Installing the latest version…","Removing the old version of the plugin…","Plugin updated successfully.","Disabling Maintenance mode…"]}}WordPress database error: [Unknown column 'client_ip' in 'field list']REPLACE INTOwpe7_wsal_occurrences(site_id,alert_id,created_on,client_ip,severity,object,event_type,user_agent,user_roles,username,user_id,session_id,post_status,post_type,post_id) VALUES (1, 5004, '1652468888.508225', '', '', '', '', '', '', NULL, NULL, '', '', '', 0)WordPress database error: [Unknown column 'client_ip' in 'field list']REPLACE INTOwpe7_wsal_occurrences(site_id,alert_id,created_on,client_ip,severity,object,event_type,user_agent,user_roles,username,user_id,session_id,post_status,post_type,post_id) VALUES (1, 5004, '1652468888.508225', '192.168.243.45', 250, 'plugin', 'updated', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.54 Safari/537.36', 'administrator', NULL, 24, '', '', '', 0)

    Thanks,
    Robert

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

  • It looks as though one of the plugins relies on a custom database column called “client_ip”. The prefix is wsal: if you can recognise which plugin this relates to, then you could try ensuring that the plugin has set up the database correctly. Either by re-installing it or by contacting the plugin author to explain the problem.

    Thread Starter robertadamsnextraq

    (@robertadamsnextraq)

    Thanks Mark,
    This appears to be “WP Activity Log” then:

    `[[email protected]: /var/www/html]# more ./wp-content/plugins/wp-security-audit-log/classes/Adapters/MySQL/MetaAdapter.php
    <?php
    /**
    * Adapter: Meta data.
    *
    * MySQL database Metadata class.
    *
    * @package wsal
    */

    // Exit if accessed directly.
    if ( ! defined( ‘ABSPATH’ ) ) {
    exit;
    }

    /**
    * MySQL database Metadata class.
    *
    * MySQL wsal_metadata table used for to store the alert meta data:
    * username, user_roles, client_ip, user_agent, post_id, post_title, etc.
    *
    * @package wsal
    */

    I have reached out to them, thank you for pointing me in the correct direction.
    Robert

    No problem!

    Thread Starter robertadamsnextraq

    (@robertadamsnextraq)

    Disabling the plugin does indeed resolve the issue, I have marked this a resolved. Thanks again for your help.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘plugins all show “Update failed” when I try to update them’ is closed to new replies.