Remove unused columns from wp_participants_database table

  • The database table wp_participants_database has many columns that are no longer used and aren’t listed in the wp_participants_database_fields table. These are columns whose names I changed, sometimes several times, by deleting them in the Manage Database Fields page and creating new ones.

    It seems that deleting them in this way does not automatically remove them from the underlying database. Is there any way in the PDB interface to tidy the database by removing all unused columns? Alternatively do you have any SQL that I could run through phpMyAdmin to remove all the columns that are no longer used? I could go through them all by hand, but as the names of the old unused columns are similar to the names of the new ones this would be error prone.

    • This topic was modified 5 years, 10 months ago by wonderer0.
Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author xnau webdesign

    (@xnau)

    The plugin does not remove the columns from the main table to prevent data loss in case of an accidental field deletion.

    You do need to remove the column manually using phpMyAdmin, just be careful and work with a backup.

    I am new to Participants, but have managed to create a registration form and enter some records. I can list the records OK.

    I have access to the standard WP tables via phpMyAdmin. But I cannot see the wp_participants_database. Could someone tell me how to set up so that I can see that database and its tables?

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Remove unused columns from wp_participants_database table’ is closed to new replies.