am: 23. September 2012, 00:48:24
Habe in meinem News Manager folgende Fehlermeldung
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 'SELECT n.news_id, n.status, n.show_date, DATE_FORMAT(' at line 2
SELECT COUNT(news_id) AS total SELECT n.news_id, n.status, n.show_date, DATE_FORMAT(n.date, '%d.%m.%Y, %H:%i') AS DATE, nd.title, nd.subtitle, nd.shorttext, nd.text, nd.image FROM modul_news n, modul_news_description nd WHERE n.news_id = nd.news_id AND n.status = 0 AND nd.language_id = '2' AND ( nd.title LIKE "%test%" OR nd.subtitle LIKE "%test%" OR nd.shorttext LIKE "%test%" OR nd.text LIKE "%test%" OR nd.image LIKE "%test%" OR nd.download_file LIKE "%test%" OR nd.download_file_title LIKE "%test%" ) AND n.date >= DATE_SUB(NOW(), INTERVAL 7 DAY) ORDER BY n.date DESC
Weiß jemand, wo das Problem liegt?
Danke.
Gerd
Linkback: https://www.modified-shop.org/forum/index.php?topic=22428.0