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

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
CMigrator: Path from Drupal 6 to J5?
(Category s/b CMigrator, but didn't see it on the list) I'm interested in usi...
0 Replies
Posted on Monday, 28 April 2025
Dowload all Hotspots entries
Hi there, I'm looking for a way to dowload all the Hotspots entries. I've got t...
0 Replies
Posted on Sunday, 06 April 2025
  • #kml
  • #download