Hello,

I have run into an issue that I cannot seem to understand how to fix it. I think I may have seen an area in the forum that covers this but it is in another language.

I believe that ever since I have installed Matukio in my Joomla 3.1.4 site that the main Joomla search function will not work. When I type something in the search i get this 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 ') 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=560&view=event&id=',a.id) AS href, '2' AS browsernav, 'Matukio - Events' AS section, b.title AS category FROM fs50a_matukio AS a LEFT JOIN fs50a_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

Any help will be greatly appreciated.