Mandatory information about my setup:
Have I searched the tickets before posting? No
Have I searched the forum before posting? No
Have I read the documentation before posting (which pages?)? No
Joomla! version: Joomla! 3.3.0 Stable [ Ember ] 30-April-2014 14:00 GMT
PHP version: 5.3.18
MySQL version: 5.1.61
Matukio version: (unknown)
Direct link to the page that shows the issue: http://www.pcworms.sk/sopza/
Description of my issue:
Hi several day ago my customer informed me about issue. There is some MySQL relevant issue with error code 1064
So I moved side to the test location (http://www.pcworms.sk/sopza/) (for test you can use user name: compojoom and password: compojoom)
there is 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.begin > '2014-05-02 21:46:27' AND (a.semnum LIKE '%%' OR a.gmaploc LIKE ' at line 2 SQL=SELECT a.* FROM spz_matukio AS a LEFT JOIN spz_categories AS cat ON cat.id = a.catid WHERE a.published = '1' AND a.pattern = '' AND a.catid IN () AND a.begin > '2014-05-02 21:46:27' 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 '%%')
whe I try to open "eventlist" link
can you plese help me?
thank you for your support
Best regards
Michal