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
- Trench J
- Bug report
- Wednesday, 01 April 2015
- Subscribe via email
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
If you have a valid subscription, please login now.
Visit store now
Last questions
Is Ccomment still being supported? It's time for my Pro renewal but I haven't se...
0 Replies
Posted on Thursday, 14 August 2025
We have been using Matukio for quite some time now. Unfortunately, we have been ...
3 Replies
Posted on Sunday, 03 August 2025
Hello,
I’m experiencing an issue when trying to submit a comment on my site u...
0 Replies
Posted on Sunday, 10 August 2025
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
Hi,
On Hotspots extension :
1) is it possible to add our own map layer / v...
0 Replies
Posted on Thursday, 03 July 2025