1. Jan
  2. General
  3. Sunday, 22 November 2015
  4.  Subscribe via email
There is an SQL-Error in the search plugin with the exact search:

plugins\search\matukio\matukio.php line 176 ff:

case 'exact':
$text = $database->quote(trim($text));
$suche = "\nAND (r.semnum LIKE '%" . $text . "%' OR a.gmaploc LIKE '%" . $text . "%' OR a.target LIKE '%" . $text
. "%' OR a.place LIKE '%" . $text . "%' OR a.teacher LIKE '%" . $text . "%' OR a.title LIKE '%" . $text
. "%' OR a.shortdesc LIKE '%" . $text . "%' OR a.description LIKE '%" . $text . "%' "
. "OR cat.title LIKE '%" . $text . "%')";
break;
[18:15:34] …


should be

case 'exact':
$text = $database->quote('%' . $database->escape($word, true) . '%', false);
$suche = "\nAND (r.semnum LIKE " . $text . " OR a.gmaploc LIKE " . $text . " OR a.target LIKE " . $text
. " OR a.place LIKE " . $text . " OR a.teacher LIKE " . $text . " OR a.title LIKE " . $text
. " OR a.shortdesc LIKE " . $text . " OR a.description LIKE " . $text . " "
. "OR cat.title LIKE " . $text . ";)";
break;
Responses (1)


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