Zur Unternavigation | Direkt zum Inhalt


Inhalt:

Datenbank-Fehler

Datenbank-Fehler

Die SQL-Datenbank meldete folgenden Fehler:
Error 1054: Unknown column '0D' in 'where clause'

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_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 io.name IN('Anreisser', 'Direktlink') AND t.info_type_id IN (303%0D) ORDER BY i.date_from DESC "