×

Notice

The forum is in read only mode.
Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC: Error after upgrade Hotspot 5.1.1

Error after upgrade Hotspot 5.1.1 9 years 2 weeks ago #30839

  • Trench J
  • Trench J's Avatar Topic Author
  • Offline
  • Senior Boarder
  • Senior Boarder
  • Posts: 41
  • Thank you received: 0
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

Error after upgrade Hotspot 5.1.1 9 years 2 weeks ago #30840

  • Daniel Dimitrov
  • Daniel Dimitrov's Avatar
  • Away
  • Administrator
  • Administrator
  • Posts: 9618
  • Karma: 155
  • Thank you received: 1081
Hey trench,
Sorry about that. Somehow I've managed to deletes few more lines than necessary from the .sql file. Please update to 5.1.2 and everythign should be back to normal.

Regards,
Daniel

Error after upgrade Hotspot 5.1.1 9 years 2 weeks ago #30844

  • Trench J
  • Trench J's Avatar Topic Author
  • Offline
  • Senior Boarder
  • Senior Boarder
  • Posts: 41
  • Thank you received: 0
Hi Daniel,
I no longer have the error on the page, but now I see nothing.

Attachments:

Error after upgrade Hotspot 5.1.1 9 years 2 weeks ago #30845

  • Daniel Dimitrov
  • Daniel Dimitrov's Avatar
  • Away
  • Administrator
  • Administrator
  • Posts: 9618
  • Karma: 155
  • Thank you received: 1081
This looks like a js error. What's the page url again?

Also could you go to your menu and select/deselect any categories and save. Most probably the update didn't make the correct changes to your map menu item.

Regards,
Daniel

Error after upgrade Hotspot 5.1.1 9 years 2 weeks ago #30867

  • Trench J
  • Trench J's Avatar Topic Author
  • Offline
  • Senior Boarder
  • Senior Boarder
  • Posts: 41
  • Thank you received: 0
Daniel now works, perfect! :cheer:
  • Page:
  • 1
Time to create page: 0.136 seconds