GX-Entwicklung

Wenn MySQL 8 auf dem Datenbankserver läuft, können die E-Mails unter "Kunden->E-Mails" nicht mehr aufgerufen werden.

Es wird folgender Fehler in den Logs geschrieben:

If MySQL 8 is running on the database server, the e-mails under "Customers->E-Mails" can no longer be accessed.

The following error is written in the logs:

Query error: Incorrect DATETIME value: '%%' - Invalid query: SELECT DISTINCT emails.*
FROM emails
LEFT JOIN email_contacts ON email_contacts.email_id = emails.email_id
LEFT JOIN email_attachments ON email_attachments.email_id = emails.email_id
WHERE emails.subject LIKE '%%' ESCAPE '!'
OR emails.content_html LIKE '%%' ESCAPE '!'
OR emails.content_plain LIKE '%%' ESCAPE '!'
OR emails.creation_date LIKE '%%' ESCAPE '!'
OR emails.sent_date LIKE '%%' ESCAPE '!'
OR email_contacts.email_address LIKE '%%' ESCAPE '!'
OR email_contacts.contact_name LIKE '%%' ESCAPE '!'
OR email_attachments.path LIKE '%%' ESCAPE '!'
OR email_attachments.name LIKE '%%' ESCAPE '!'
ORDER BY emails.creation_date DESC