Mass delete Meta Fields "created by" and "IP Address" without losing entries

Get Help
, , , ,
1

Hi!

I have a lot of entries (100k+) that I need for certain processing steps. However, I would like to delete the PII fields in all existing entries without risking to destroy anything.

Is there a tested process to achieve this?

Thanks a lot!

2

Hi AK. There is no provision in Gravity Forms to do that. The simplest way is with something like phpMyAdmin.

First, make a database backup, because you always risk destroying things when working with the database directly.

Then, using phpMyAdmin, perform a query like this, assuming your database table prefix is wp_:

SELECT id, created_by, ip 
FROM wp_gf_entry
ORDER BY id ASC;

That will show you all the data that will be deleted by the next query. Review the data to be sure it is what you want to delete.

UPDATE wp_gf_entry
SET created_by = NULL, ip = NULL;

That will set the values for the created_by and ip columns in the wp_gf_entry table to NULL.

Be sure you have a database backup first, or, perform this on a staging site copy of your live data to see how it works before you do this on a production site. If you have any questions, ask before performing the queries.

3

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.