1. Trench J
  2. Sherlock Holmes
  3. Bug report
  4. Wednesday, 01 April 2015
  5.  Subscribe via email
Hi Daniel,
After you upgrade to the latest version of Hotspot 5.1.1 I have this error 1054:

Unknown column 'm.state' in 'where clause' SQL=SELECT catid, MIN( gmlat ) AS south, MAX( gmlat ) AS north, MAX( gmlng ) AS east, MIN( gmlng ) AS west FROM `wint_hotspots_marker`AS m LEFT JOIN `wint_categories`AS c ON m.catid = c.id WHERE m.state = 1 AND c.published = 1 AND c.extension = 'com_hotspots' AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2015-04-01 09:19:43') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2015-04-01 09:19:43') GROUP BY catid

What can I do to fix it?
Use: Joomla 3.4.1 + Hotspot 5.1.1

Thanks
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

Veranstaltung im Frontend sichtbar obwohl nicht ve
Hallo, folgendes Problem stellt sich mir: Wenn ich eine Veranstaltung dupl...
4 Replies
Posted on Friday, 09 February 2024
Suche bei der Matukio - Fehler Ö Ä Ü..
Hallo, evtl. könnt ihr mir weiterhelfen. Bei mir funktioniert die suche bei ...
3 Replies
Posted on Wednesday, 15 May 2024
  • New
  • When is CComment compatible with Joomla 5?
    When is CComment compatible with Joomla 5?...
    4 Replies
    Posted on Tuesday, 05 December 2023
    • #CComment
    • #Joomla 5
    _MATUKIO_NO_EVENTS appears in the frontend if no e
    Hello, there ist still the problem, that on the frontpage appears COM_MATUKIO...
    2 Replies
    Posted on Sunday, 12 May 2024
  • New
  • verschiedene URL's für Kursübersicht einer Kategor
    Hallo, ich habe eine Frage in Bezug auf SEO: ein externer Spezialist macht die...
    3 Replies
    Posted on Monday, 29 April 2024