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


There are 6 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

Categories

General
  1. 3 subcategories
Billing
  1. 4 subcategories
Hotspots
  1. 11 subcategories
CComment
  1. 11 subcategories
Matukio
  1. 6 subcategories
CMigrator
  1. 4 subcategories
CForms
  1. 2 subcategories
International Zone
  1. 10 subcategories
Free extensions
  1. 47 subcategories
Archive
  1. 15 subcategories

Last questions

500 error...
Hi I have updated matukio to the latest version, but when I go on an event it gi...
4 Replies
Posted on Wednesday, 21 February 2018
  • New
  • K2 image on hotspots location
    Hello, I have just installed the hotspots pro version, very nice job by the w...
    0 Replies
    Posted on Wednesday, 21 February 2018
  • New
  • Alter wording in matukiofees Default Booking Form
    Attached is an image of the booking form I find in my front end. I would like t...
    2 Replies
    Posted on Thursday, 15 February 2018
  • Resolved
  • New
  • First Data gateway for Matukio - Ignite?
    On your landing page for Matukio you list Ignite (First Data) as a gateway, but ...
    5 Replies
    Posted on Thursday, 15 February 2018
  • New
  • Standart Buchungsformular Show in Overviews geht n
    Das Standart Buchungsformular habe ich angepasst das gewisse Felder aus dem Comm...
    17 Replies
    Posted on Thursday, 04 January 2018