Forms Documentation

Forms Version 6.0.0 changes the way form entries are stored in the database. These changes remove prior limitations on the number of fields that can be created in an install. Prior to version 6.0.0, each form field added a new column to the entry database table. This could lead to a table that is too large to be used on a site with many forms and many form fields.

Forms Version 6.0.0 adds a new table called exp_form_entries_new and a new format for storing form entry data. New entries and edits will use the new table, while existing data are still stored in the existing exp_form_entries table.

If your site is hitting the issue of the old table becoming too large, you will also need to run a CLI command to migrate your data to the new table. If you are not hitting this issue, you can skip this CLI command and forms will continue to work with both your old and new tables, without limited the number of fields that can be added.

In order to migrate existing data to the new format, you will need to do two things:

First, make a backup of your database. The CLI command alters data and will truncate your old table. Make a backup of your database before running the command, in a worst case senerio you can roll back and use this backup.

Secondly, run the CLI command to migrate your data to the new table.

You may review how to set up and run CLI commands in the docs CLI Usage.

Run: php eecli.php forms:update_6

Support

Having problems setting up and/or using Forms? Support is offered from 10am to 4pm EST weekdays. Send us an email at help@eeharbor.com and we will respond as quickly as we can.