Hi Dima,
I was hoping you could help me out wit an error we are getting on the back end of our website. We have recently added a new group of pages/content to our website specifically for locations. In the past I had used the ZH Maps component in order to create the maps on each of these pages. In order to use the maps with the functionality I had wanted, I created placemarks for each map and a map for each location this way I can have all the maps locations show up on 1 central based map. However, I am trying to follow the same process and create placemarks for new additional locations we had added to our site and we keep getting the following error:
500 Unknown column 'h.access' in 'on clause' SQL=SELECT COUNT(*) FROM werkt_zhgooglemaps_markers as h LEFT JOIN werkt_categories as c on h.catid=c.id LEFT JOIN werkt_zhgooglemaps_maps as m on h.mapid=m.id LEFT JOIN werkt_zhgooglemaps_markergroups as g on h.markergroup=g.id LEFT JOIN werkt_users as usr on h.createdbyuser=usr.id LEFT JOIN werkt_viewlevels as ag ON ag.id = h.access WHERE (h.published IN (0, 1))
Unknown column 'h.access' in 'field list' SQL=SELECT h.id,h.title,h.mapid,h.published,h.publish_up,h.publish_down,h.catid,h.icontype,h.ordering,h.rating_value,h.createdbyuser,h.access,c.title as category,m.title as mapname,g.title as markergroupname, usr.username, usr.name fullusername,ag.title as access_level FROM werkt_zhgooglemaps_markers as h LEFT JOIN werkt_categories as c on h.catid=c.id LEFT JOIN werkt_zhgooglemaps_maps as m on h.mapid=m.id LEFT JOIN werkt_zhgooglemaps_markergroups as g on h.markergroup=g.id LEFT JOIN werkt_users as usr on h.createdbyuser=usr.id LEFT JOIN werkt_viewlevels as ag ON ag.id = h.access WHERE (h.published IN (0, 1)) ORDER BY h.title asc LIMIT 0, 100
Unknown column 'h.access' in 'on clause' SQL=SELECT COUNT(*) FROM werkt_zhgooglemaps_markers as h LEFT JOIN werkt_categories as c on h.catid=c.id LEFT JOIN werkt_zhgooglemaps_maps as m on h.mapid=m.id LEFT JOIN werkt_zhgooglemaps_markergroups as g on h.markergroup=g.id LEFT JOIN werkt_users as usr on h.createdbyuser=usr.id LEFT JOIN werkt_viewlevels as ag ON ag.id = h.access WHERE (h.published IN (0, 1))
I attached a screen shot as well of this error.
Because I cannot get into the placemarks portion of the component I am also unable to edit any of the existing placemarks. Here is a link to our website locations pages.
www.oneconcierge.com/company/a-global-presence
This is our main map called "Locations map". This map has all the place marks on it. If you click on the placemark it will redirect you to the appropriate location. For example if I click on the London placemark it redirects you here:
www.oneconcierge.com/London
If you notice, the map on this page also has all the placemarks on it for the other locations as well. This gives our visitors the ability to view a placemark for any location page no matter what map they are looking at.
Can you help me fix this issue please? You helped us out once a while ago when I kept getting a "gray map" and that was amazing so anything you can do to help now would be really appreciated.