Database error when delete user

  • Resolved Jeff Starr

    (@specialk)


    2 years, 5 months ago

    Hello,

    Whenever you delete a user (like via the WP Users screen), the following error occurs:

    AH01071: Got error 'PHP message: WordPress database error Duplicate entry '' for key 'email' for query UPDATE wp_edd_customers SET user_id = 0, email = '', name = 'Pat Smith', status = 'active', purchase_value = '0', purchase_count = '0', date_created = '2022-10-13 16:21:47', date_modified = '2022-10-16 19:53:20', uuid = 'urn:uuid:123-000-123-abc-xyz' WHERE id = '1234' made by wp_delete_user, do_action('delete_user'), WP_Hook->do_action, WP_Hook->apply_filters, edd_detach_deleted_user, EDD_Customer->update, edd_update_customer, do_action('edd_customer_updated'), WP_Hook->do_action, WP_Hook->apply_filters, edd_process_customer_updated, EDD\\Database\\Query->update_item'

    • This topic was modified 2 years, 5 months ago by Jeff Starr.
    • This topic was modified 2 years, 5 months ago by Jeff Starr.
    • This topic was modified 2 years, 5 months ago by Jeff Starr.
    • This topic was modified 2 years, 5 months ago by Jeff Starr.
Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author Chris Klosowski

    (@cklosows)

    @specialk Can you confirm by looking in the database, if this user may have had multiple customer accounts somehow?

    Thread Starter Jeff Starr

    (@specialk)

    As far as I know, it’s any/all registered users that have their purchases/orders deleted. For example Pat has one order. Delete Pat’s order, then delete Pat will trigger the error.

    Plugin Support Mihai Joldis

    (@misulicus)

    I’m not able to replicate this on my end at all. Tried deleting the order, then the WP user account and then the Customer record.

    Thread Starter Jeff Starr

    (@specialk)

    It may be an issue specifically with Software Licensing. I will test further and report back.

    Plugin Support Mihai Joldis

    (@misulicus)

    Hey @specialk

    Can we mark this as resolved and if needed you can open a new topic? If it’s an issue related to a premium extension then please open a support topic with our team.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Database error when delete user’ is closed to new replies.