Removed Custom Fields Not Deleted from Database

  • Resolved prr1313

    (@prr1313)


    5 years, 1 month ago

    I’m using Ultimate Member for a members site I created. I created a few custom fields for questions for a registration form, which users had to populate to complete registration. We no longer needed these fields, so I deleted them through the Ultimate Member interface; however, when I went to export user data, I could still see these fields and the data is still in the database. How can I (safely) delete the data and these fields from the database as well?

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Contributor Champ Camba

    (@champsupertramp)

    5 years, 1 month ago

    Hi @prr1313

    When you say data, did you mean the usermeta? or just the custom fields metadata?

    To delete the custom fields permanently, try adding a new field to show the overlay for field options.
    please see this screenshot:
    https://drive.google.com/file/d/1RIsso0TEz9FcmcJ7g4-bRTqd0pmpmMCm/view?usp=sharing

    Regards,

    Thread Starter prr1313

    (@prr1313)

    5 years, 1 month ago

    Hi @champsupertramp

    Thanks for the response. I’ve done as you’ve denoted in your screenshot to delete the fields; however, if I go into wp_usermeta table in the database, I can see the meta_key and meta_value for those fields are still there. I assumed deleting the field as per your screenshot would’ve removed the underlying data as well, but that doesn’t seem to be the case. Any suggestions on how to (safely) do so? I have access to phpMyAdmin, which is where I’m looking at the table data; I could delete the data through there, but want to make sure I’d be doing it properly and not compromising the integrity of the data or my site in the process.

    Plugin Contributor Champ Camba

    (@champsupertramp)

    5 years, 1 month ago

    Hi @prr1313

    Yes, you have to delete the user metadata manually via PHPmyAdmin. We did it on purpose because there are other plugins that may use the same user meta key and prevent deleting the metadata via UM Form builder.

    Regards,

    Thread Starter prr1313

    (@prr1313)

    5 years, 1 month ago

    Hi @champsupertramp

    That makes sense and thanks for confirming 🙂

    Plugin Contributor Champ Camba

    (@champsupertramp)

    5 years, 1 month ago

    Hi @prr1313

    Thanks for letting us know. I am closing this thread now.

    Regards,

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

The topic ‘Removed Custom Fields Not Deleted from Database’ is closed to new replies.