| Table of Contents |
|---|
Issues with forms having an auto-number field after upgrade
With ConfiForms version 2.x we have updated and improved the storage service, the way how we store and manage your ConfiForms data is very different to what it was in version 1. We have optimized a lot of requests and functions and made ConfiForms perform a lot better with larger datasets.
These improvements have affected the way we generate auto-number for each new record you save in ConfiForms.
We don't analyze the data you have and don't try to find the greatest number used but we do a simple count over the data stored, adding +1 to the found number.
This logic works fine for migrated data as well, as long as you have all the records in the form. If you have deleted any of the records in the forms with auto-number fields then there will be an issue with duplicates.
We have fixed the data migration logic in ConfiForms 2.0.9. So, if you are upgrading from ConfiForms version 1.x to 2.0.9 there is nothing to worry about. However, if you have migrated to the version prior to 2.0.9 then there is a need to fix the data on the database layer (fastest fix for now, while we are developing an automatic service for you)
ConfiForms stores data in the table "AO_CEFA84_CONFI_FORMS_ENTITY"
You will need to count how many records are missing and do the SQL INSERTs into the mentioned table with "deleted" flag set to true
| Code Block |
|---|
INSERT INTO AO_CEFA84_CONFI_FORMS_ENTITY (CONTENT_ID, ENTRY_ID, ENTRY_VALUE, FORM_NAME, DELETED) VALUES (<PAGE_ID>, '', null, '<FORM_NAME>', true) |
Where parameters are:
- <PAGE_ID> - page id where the form is defined
- <FORM_NAME> - name of the form