1. Vadim Tshuprakov
  2. General
  3. Sunday, 16 February 2014
  4.  Subscribe via email
Mandatory information about my setup:

Have I searched the tickets before posting? yes
Have I searched the forum before posting? no
Have I read the documentation before posting (which pages?)? No
Joomla! version: 3.2.2
PHP version: 5.4.24
MySQL version: 5.6.14
Matukio version: 3.0.8
Direct link to the page that shows the issue: http://karellkiirabi.ee/et/koolitused/registreerimine


Description of my issue:

After ugrading i have an 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 > '2014-02-15 16:32:44' AND (a.semnum LIKE '%%' OR a.gmaploc LIKE '%%' OR' at line 2 SQL=SELECT a.* FROM kark13_matukio AS a LEFT JOIN kark13_categories AS cat ON cat.id = a.catid WHERE a.published = '1' AND a.pattern = '' AND a.catid IN () AND > '2014-02-15 16:32:44' 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 '%%')

How can i fix it?
thanks
Saturday, 15 February 2014 18:47 UTC
Hi Vadim,
from which version did you update? Something is missing here:
AND > '2014-02-15 16:32:44'

Do you have any Matukio settings in the backend? Maybe they were not properly updated - can you try reseting them (Hit reset in the settings view).
Best regards
Yves

[color=red]Hi Yves,[/color]
[color=red]this error appears only if I use modern template!!![/color]
Responses (2)


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

Is Ccomment still alive?
Is Ccomment still being supported? It's time for my Pro renewal but I haven't se...
0 Replies
Posted on Thursday, 14 August 2025
  • New
  • Anzeige von mehrtägigen Events auf Buchungsseite
    We have been using Matukio for quite some time now. Unfortunately, we have been ...
    3 Replies
    Posted on Sunday, 03 August 2025
    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
  • New
  • 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