Google Maps Error

  • Sreyam
  • Topic Author
  • Offline
  • New Member
  • New Member
More
10 years 4 months ago #5199 by Sreyam
Google Maps Error was created by Sreyam
Hello, I was using your google maps component, for some reason when I click placemarks I get this error code. I'm just wondering if you have any idea what can be causing this error.

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))
Attachments:

Please Log in or Create an account to join the conversation.

More
10 years 4 months ago #5273 by Dima
Replied by Dima on topic Google Maps Error
Hi.
Sorry for delay, I was on holidays

Do you have latest versions of extension

Do you call component (or plugin or module).

Give me more information, it can be if you have not latest version of component (where table column appeared), and last version of plugin (where that column used)

Don't forget support my developments: post review in JED , donate , help with translation ;)

Please Log in or Create an account to join the conversation.

Time to create page: 0.174 seconds
Powered by Kunena Forum