1. Jean Machuron
  2. Sherlock Holmes
  3. Bugs
  4. Friday, 31 January 2020
  5.  Subscribe via email
Hello Daniel

Found a bug in hotspots.
We created a new category but don't want to display it on frontend maps. When accessing a single hotpot it is fine, when accessing a map, it is fine also, but if someone type the path to the category, then we have a mysql error which is :

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND type_alias = 'com_hotspots.hotspot'' at line 3

This is instead of a correct redirect to a 404 page or to the main hotspots page maybe.

Mind to check ?
Thanks
Jean
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

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
  • New
  • 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