1. Paul Adamson
  2. Bug report
  3. Friday, 29 September 2017
  4.  Subscribe via email
Hi, I just upgraded to Hotspots Pro 5.3.9 and now I get the following error:

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 m.catid IN ('32','33','34') AND m.state = 1 AND (m.publish_up = '0000-00-0' at line 3


The full SQL looks like this:
SELECT SQL_CALC_FOUND_ROWS m.id as hotspots_id, m.*
FROM j7vtr_hotspots_marker as m
WHERE AND m.catid IN ('32','33','34') AND m.state = 1 AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2017-09-29 18:32:02') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2017-09-29 18:32:02') AND m.access IN (1,1,5)
ORDER BY m.title ASC LIMIT 25


It looks like the sql is not being built correctly.

Thanks for your help,
Paul
Responses (6)


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

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