TYPO3 OpenImmo
Frequently asked questions
After an update, list entry information is no longer displayed - what can I do?
The TypoScript settings from settings.list. * have been removed because they were outdated. Changes must be transferred over into settings.search. *.
In addition, the for-each loop in the Property / Search / Item.html Partial must be changed.
From:
<f:for each="{settings.list.fieldsets}" as="fieldset" key="fieldsetKey">To:
<f:for each="{settings.search.fieldsets}" as="fieldset" key="fieldsetKey">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_byTry to set the SQL mode:
sql_mode = ''
