FAQ
The search/list view shows a SQL error - what can I do?
The search/list view shows the following SQL error:
An exception occurred while executing 'SELECT `geo_ort`, `geo_regionaler_zusatz` FROM `tx_openimmo_domain_model_immobilie` WHERE (`uid` > 0) AND ((`tx_openimmo_domain_model_immobilie`.`deleted` = 0) AND (`tx_openimmo_domain_model_immobilie`.`hidden` = 0) AND (`tx_openimmo_domain_model_immobilie`.`starttime` <= 1634053020) AND ((`tx_openimmo_domain_model_immobilie`.`endtime` = 0) OR (`tx_openimmo_domain_model_immobilie`.`endtime` > 1634053020))) GROUP BY `geo_regionaler_zusatz` ORDER BY `geo_regionaler_zusatz` ASC': Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'dwg-online.tx_openimmo_domain_model_immobilie.geo_ort' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Try to set the SQL mode:
sql_mode = ''
More frequently asked questions
- Fatal error beim Update in einer non-composer Installation?
- After import the connection is not selected in immobilie record, what's wrong?
- How to access a custom/user-defined XML node?
- How to access file/image meta data in Fluid?
- Der Importer wirft bei der Ausführung den Fehler "Exception: No site found in root line of page xy" - woran liegt das?
- The search/list view shows a SQL error - what can I do?
- Why don’t my custom translations appear in the search result email?
- Why are links or images incorrect in the search result email?
- After an update, list entry information is no longer displayed - what can I do?
