Loading...

Please enable JavaScript for enjoying all features of this page!

Please note that this documentation is for the most recent version of this extension. It may not be relevant for older versions. Related documentation can be found in the documentation directory of the extension.

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 = ''

Stop! Playing in the meantime?

Stop! Playing in the meantime?

Stop! Playing in the meantime?

Break the highscore

Name *

Emailaddress *

Message *

Privacy *

Yes, I have read and understood the privacy policy and agree that information I have provided will be collected and stored electronically. My data will be used strictly for the purpose of processing and responding to my inquiry.
By sending this contact form I authorize the processing of my data.

Security question *

SCU_________IXY______
7______8____6_____S73
9NI___ZYR___IAX______
4_E____G______G___CFY
LCI_________6CT______

We use cookies on our website. Some of them are essential, while others help us to improve this website and your experience. You can optionally decide which cookies or rather which use you approve to at any time under "cookies settings". You can find further information regarding this, as well as your constant right of cancellation under our Data Protection Declaration. Our Imprint can be found here.

accept Necessary cookies

This technology is required to activate the core functionality of this website.

Compiled data
This list contains all (personal) data that is saved in the cookie during the ordering process:

Company
VAT ID
First name
Last name
Phone
Street
House number
Postcode
City
Land
Email

Cookies

Name	Purpose	Lifetime	Type	Provider
CookieConsent	Saves your consent to using cookies.	1 year	HTML	Website
PayPal	This is a payment service.	session	HTTP	PayPal
fe_typo_user	Core functions of the website, e.g. B. Shopping cart	session	HTTP	Website
piwik_ignore	If you opt out of tracking using the cookie method or the iframe opt-out method, Matomo will set a piwik_ignore cookie on the domain of your Matomo server.	session	HTML	Matomo
MATOMO_SESSID	MATOMO_SESSID is a temporary, short-lived cookie that provides a nonce - basically a random number - to prevent CSRF security issues while users disable tracking.	session	HTML	Matomo
mtm_consent	We have asked for your consent to tracking via the Matomo software. This cookie was created for this purpose.	session	HTML	Matomo
mtm_consent_removed	We have asked for your consent to tracking via the Matomo software. This cookie was created for this purpose.	session	HTML	Matomo

accept Statistic cookies

With the help of these cookies we strive to improve our offer for our users. By means of anonymized data of website users we can optimize the user flow. This enables us to improve ads and website content.

Google Analytics & Google Tag Manager

Nature and scope of processing

On our website we use Google Analytics a service of Google Ireland Limited, Gordon House, Barrow Street, Dublin 4, Ireland (hereinafter "Google"). Analytics is loaded via the Google Tag Manager on this page.

Google Tag Manager allows us to manage website tags through one interface and enables us to accurately control the exact integration of services on our website

With the help of the tag manager, we can services flexibly.

With the help of Google Analytics, a web analytics service, we analyze how you how you as a visitor use our website. In this way we want to better understand user behavior and optimize the design optimize the design of our website. Google collects and processes data from visitors to our website (e.g. pages viewed, access time pages viewed, access time, referrer, operating system, browser, IP address and interactions). Google Analytics uses Cookies, which are set after your consent.

Purpose of processing

We process data with the Google Analytics service to compile reports on the activities on our website. compiled. The data enables us to optimize the website.

Legal basis of Processing

We process data with the help of Google Analytics on the basis of your consent according to Art. 6 para. 1 lit. a. DSGVO in conjunction with. § 25 para. 1 TTDSG.

Data transfer to a Third country

In the rule, the personal data collected by Google Analytics are transmitted to a server in the USA and stored there. At present, there is neither an adequacy decision, nor are there any suitable guarantees for this transfer. It can therefore not be ensured that a level of protection equivalent to the GDPR equivalent level of protection for this personal data is guaranteed.

Storage duration

The specific storage period of the processed data cannot be influenced by us, but is but is determined by the service provider. You can find more information in the privacy policy of Google Analytics: https://policies.google.com/privacy and Google Tag Manager: https://marketingplatform.google.com/about/analytics/tag-manager/use-policy/.

Revocation of processing

You can revoke your consent at any time. Open these settings via the "Cookies" link at the bottom of the page. On the data processing of Google we have no influence.

Microsoft Clarity

Microsoft Clarity

We partner with Microsoft Clarity and Microsoft Advertising to capture how you use and interact with our website through behavioral metrics, heatmaps, and session replay to improve and market our products/services. Website usage data is captured using first and third-party cookies and other tracking technologies to determine the popularity of products/services and online activity. Additionally, we use this information for site optimization, fraud/security purposes, and advertising. For more information about how Microsoft collects and uses your data, visit the Microsoft Privacy Statement.

Purpose of processing

We process data with the Microsoft Clarity service to compile reports on the activities on our website. compiled. The data enables us to optimize the website.

Legal basis of Processing

We process data with the help of Microsoft Clarity on the basis of your consent according to Art. 6 para. 1 lit. a. DSGVO in conjunction with. § 25 para. 1 TTDSG.

Data transfer to a Third country

In the rule, the personal data collected by Microsoft Clarity are transmitted to a server in the USA and stored there. At present, there is neither an adequacy decision, nor are there any suitable guarantees for this transfer. It can therefore not be ensured that a level of protection equivalent to the GDPR equivalent level of protection for this personal data is guaranteed.
Information about which data Microsoft Clarity collects and which cookies are created for this purpose can be found at the following URL: https://learn.microsoft.com/en-us/clarity/setup-and-installation/clarity-data

Storage duration

The specific storage period of the processed data cannot be influenced by us, but is but is determined by the service provider. You can find more information in the privacy policy of Microsoft Clarity: https://privacy.microsoft.com/privacystatement.

Revocation of processing

You can revoke your consent at any time. Open these settings via the "Cookies" link at the bottom of the page. On the data processing of Google we have no influence.