1. PcWorms, s.r.o.
  2. General
  3. Friday, 02 May 2014
  4.  Subscribe via email
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
Responses (4)


There are %s replies to this question. If you want to see them you need a valid subscription.
If you have a valid subscription, please login now.
Visit store now

Last questions

Anzeige von mehrtägigen Events auf Buchungsseite
We have been using Matukio for quite some time now. Unfortunately, we have been ...
5 Replies
Posted on Sunday, 03 August 2025
  • Resolved
  • Is Ccomment still alive?
    Is Ccomment still being supported? It's time for my Pro renewal but I haven't se...
    2 Replies
    Posted on Thursday, 14 August 2025
  • Resolved
  • Assistance Needed – Error When Posting Comments
    Hello, I’m experiencing an issue when trying to submit a comment on my site u...
    0 Replies
    Posted on Sunday, 10 August 2025
    Hotspots Pro 6.0.13 compatability with Joomla 5.3.
    Running Hotspots Pro 6.0.13 on Joomla 4.4.13 and want to upgrade to Joomla 5.3.1...
    2 Replies
    Posted on Friday, 04 July 2025
    some questions on Hotspots
    Hi, On Hotspots extension : 1) is it possible to add our own map layer / v...
    0 Replies
    Posted on Thursday, 03 July 2025