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

Set number of hotspots / user groups
Hi, I'm working with Hotspots for my new website and I love it! After trying ...
0 Replies
Posted on Monday, 31 March 2025
  • New
  • J5 compatibility for Hotspots
    Hi guys, Just started to update my old J3x website. Is there J5 compatibility p...
    1 Replies
    Posted on Monday, 24 February 2025
    • #Hotspots
    • #hotspots Joomla 5
    Text size in the comment input form
    Hello. How can I increase the font size in the comment input field? For examp...
    0 Replies
    Posted on Wednesday, 26 February 2025
    • #CComment 6
    Problem with enlarged image
    Hello. When you click on the image in the comments, it does not appear in the ce...
    1 Replies
    Posted on Wednesday, 26 February 2025
    Black square instead of images in comments
    Hello. In comments instead of images I see black squares. Here is an example. h...
    0 Replies
    Posted on Wednesday, 26 February 2025
    • #ccoment pro