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

Custom Fields: Checkbox not working anymore in J!5
We are still in the support-time-range and have an urgent issue. the customer ca...
0 Replies
Posted on Friday, 12 September 2025
  • New
  • Anzeige von mehrtägigen Events auf Buchungsseite
    We have been using Matukio for quite some time now. Unfortunately, we have been ...
    5 Replies
    Posted on Sunday, 03 August 2025
  • Resolved
  • Is Ccomment still alive?
    Is Ccomment still being supported? It's time for my Pro renewal but I haven't se...
    2 Replies
    Posted on Thursday, 14 August 2025
  • Resolved
  • 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
    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