Inhalt:

Datenbank-Fehler

Die SQL-Datenbank meldete folgenden Fehler:
Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'all%0D) ORDER BY i.issue_date_from DESC' at line 48

Die verursachende SQL-Anweisung war: "SELECT DISTINCT i.sys_pk, i.worktitle, ia.sys_pk as info_asset_id, i.date_from, i.date_to, i.time, i.location, i.pressenr, DATE_FORMAT(i.issue_date_from, '%d.%m.%Y') AS vdate, IF(i.date_from = i.date_to, CONCAT( IF (i.date_from = '0000-00-00', '', DATE_FORMAT(i.date_from, '%d.%m.%Y') )), CONCAT(DATE_FORMAT(i.date_from, '%d.%m'),' - ',DATE_FORMAT(i.date_to, '%d.%m.%Y')) ) AS date, t.info_type AS news_name, t.info_type_id, ia.text AS headtext, ia.headline, ia.link, ia.fk_sitemap_intern, ia.subline FROM t_info i INNER JOIN tr_info_art art ON i.sys_pk = art.fk_info INNER JOIN t_info_arten arten ON art.fk_art = arten.sys_pk INNER JOIN tr_info_type tt ON tt.fk_info = i.sys_pk INNER JOIN t_info_type t ON tt.fk_info_type = t.sys_pk INNER JOIN t_status s ON i.fk_status = s.sys_pk INNER JOIN t_info_assets ia ON ia.fk_info = i.sys_pk INNER JOIN t_languages l ON l.sys_pk = ia.fk_languages INNER JOIN t_info_objects io ON fk_info_objects = io.sys_pk WHERE i.issue_date_from <= NOW() AND i.issue_date_to >= NOW() AND s.status_id=1 AND l.kuerzel = 'de' AND arten.tech_id = 'aktuelles' AND io.name IN('Anreisser', 'Direktlink') AND t.info_type_id IN (all%0D) ORDER BY i.issue_date_from DESC "