Details
-
Bug
-
Resolution: Fixed
-
Medium
-
2.5.6
-
None
-
ezpublish-kernel: 7.5.6
ezplatform-form-builder:1.2.5Postgres 11 Database
Description
From time to time, the form elements of a form are reordered in a uncontrolled way, when editing a form.
Steps to reproduce:
- Create a form with 10 fields
- Edit the form
- see if error occurs
- if not, discard the draft and repeat at step 2.
Solution:
There is no explicit order given in the database query, so it's up to the database if it is going to sort it by id or not. In most cases it does, but in few cases it doesn't.
The following patch would solve the problem:
--- src/lib/FieldType/Storage/DoctrineGateway.php +++ src/lib/FieldType/Storage/DoctrineGateway.fixed.php @@ -345,7 +345,8 @@ $selectQuery ->from($this->connection->quoteIdentifier(self::TABLE_FIELDS)) ->where('form_id = :form_id') - ->setParameter(':form_id', $formId, ParameterType::INTEGER); + ->setParameter(':form_id', $formId, ParameterType::INTEGER) + ->orderBy('id'); $statement = $selectQuery->execute();
Attachments
Issue Links
- testing discovered
-
EZEE-3389 Fields are not sorted numerically on Submissions tab
- Confirmed