Error when updating the plugin

  • Resolved pzh20

    (@pzh20)


    3 years, 11 months ago

    I trued to do an update today and got this error

    Update Failed: WordPress database error: [Unknown column 'is_deleted' in 'where clause']SELECT * FROM devfd_wc_admin_notes WHERE 1=1 AND type IN ('survey') AND status IN ('actioned') AND is_deleted = 0 ORDER BY date_created DESC LIMIT 0, 10WordPress database error: [Unknown column 'is_deleted' in 'where clause']SELECT * FROM devfd_wc_admin_notes WHERE 1=1 AND name IN ('wc-admin-coupon-page-moved') AND is_deleted = 1 ORDER BY date_created DESC LIMIT 0, 10WordPress database error: [Unknown column 'is_deleted' in 'where clause']SELECT * FROM devfd_wc_admin_notes WHERE 1=1 AND status IN ('unactioned') AND name IN ('wc-admin-coupon-page-moved') AND is_deleted = 0 ORDER BY date_created DESC LIMIT 0, 10{“success”:true,”data”:{“update”:”plugin”,”slug”:”wordfence”,”oldVersion”:”Version 7.4.6″,”newVersion”:”Version 7.4.14″,”plugin”:”wordfence\/wordfence.php”,”pluginName”:”Wordfence Security”,”debug”:[“Enabling Maintenance mode…”,”Downloading update from https:\/\/downloads.www.remarpro.com\/plugin\/wordfence.7.4.14.zip…”,”The authenticity of wordfence.7.4.14.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…”]}}

Viewing 1 replies (of 1 total)
  • Plugin Support wfpeter

    (@wfpeter)

    Hi @pzh20, thanks for reaching out to us on the update issue you’re seeing.

    The WordPress database errors for the missing column in wc_admin_notes are for a WooCommerce table. Could a past update have failed, or a backup restore reverted WooCommerce to an older version before the is_deleted column was added? I think it’s worth contacting their support to see if they can shed any light on this as a few searches for the same problem don’t reveal any proven solutions as far as I can see.

    When parsing and validating the JSON for the Wordfence update at the bottom, it is reporting a successful update:

    {
	"success": true,
	"data": {
		"update": "plugin",
		"slug": "wordfence",
		"oldVersion": "Version 7.4 .6",
		"newVersion": "Version 7.4 .14",
		"plugin": "wordfence\/wordfence.php",
		"pluginName": "Wordfence Security",
		"debug": ["Enabling Maintenance mode…", "Downloading update from https: \/\/downloads.www.remarpro.com\/plugin\/wordfence.7.4.14.zip…", "The authenticity of wordfence.7.4.14.zip could not be verified as no signature was found.", "Unpacking the update…", "Installing the latest version…", "Removing the old version of the plugin…", <strong>"Plugin updated successfully."</strong>, "Disabling Maintenance mode…"]
	}
}

    Let us know how you get on!

    Peter.

Viewing 1 replies (of 1 total)
  • The topic ‘Error when updating the plugin’ is closed to new replies.