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

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
Trying to resize the image in the comments
Hey everyone, Basically I am trying to make the images in the comments smalle...
9 Replies
Posted on Wednesday, 12 August 2009
J5 compatibility for Hotspots
Hi guys, Just started to update my old J3x website. Is there J5 compatibility p...
2 Replies
Posted on Monday, 24 February 2025
  • #Hotspots
  • #hotspots Joomla 5
error message when adding/cofiguring email address
When configuring the email plugin that send a email message to admin when a new ...
0 Replies
Posted on Friday, 09 May 2025