This page will list out possible scenarios when malformed query error is raised.
Please note the majority of these errors occur when using temporal filter or when the form/field names are edited after the queries have been saved.
| Table of Contents |
|---|
Recognition exception at input
This error occurs in the following scenarios:
- The function used in the temporal expression is invalid or non-existent. The error highlights the incorrect function name.
- Fix: Refer to the document for the correct function name and its usage.
- The field name starts with a number like '260280ratio'. The error highlights the form having the erroneous field name.
- Fix: Edit the form to rename the field. All form fields should start with an English alphabet (a-z or A-Z).
Invalid form or field name
This error occurs when an invalid field is referenced in the query. The error highlights the erroneous field name. This error occurs in the following scenarios:
- User is creating a temporal filter and typed incorrect field name.
- Fix: Edit the temporal filter and choose the fields from the suggestions offered by the wizard.
- The form fields were renamed after the query was created. To fix the error, delete and recreate the filter
- Fix: When the offending field is in the filter, delete and recreate the filter.
- Fix: When the offending field is in the results view, open columns wizard, first unselect all the fields and finally reselect the required fields.
Too many tables
This error occurs when large number of fields are selected in the results view. This is the limitation imposed by the underlying database (esp. MySQL/MariaDB) and not the query interface itself.
- Fix: Open columns wizard, and remove sub-form fields selection that will reduce the number of table lookups.