Wenn ich das Matukio - Search Plugin aktiviert habe, erhalte ich bei der Eingabe im Joomla Suchfeld 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 ') AND a.published = '1' AND a.pattern = '' AND a.begin > '' AND (a.semnum LIKE '' at line 2 SQL=SELECT a.title AS title, a.begin AS begin, a.publishdate AS created, a.shortdesc AS text, CONCAT( 'index.php?option=com_matukio&Itemid=1212&view=event&id=',a.id) AS href, '2' AS browsernav, 'Matukio - Events' AS section, b.title AS category FROM hupy_matukio AS a LEFT JOIN hupy_matukio AS b ON b.id = a.catid WHERE a.catid IN () AND a.published = '1' AND a.pattern = '' AND a.begin > '' AND (a.semnum LIKE '%%' OR a.gmaploc LIKE '%%' OR a.target LIKE '%%' OR a.place LIKE '%%' OR a.teacher LIKE '%%' OR a.title LIKE '%%' OR a.shortdesc LIKE '%%' OR a.description LIKE '%%')ORDER BY a.id DESC LIMIT 0, 50
Es funktioniert problemlos in Joomla 2.5.14, in Joomla 3.1.5 jedoch erhalte ich diese Fehlermeldung.
Gruss Patrik