- Posts: 10
- Thank you received: 0
Unknown column 'h.access' in 'on clause' SQL=SELECT COUNT(*) FROM database_zhgooglemaps_markers as h LEFT JOIN database_categories as c on h.catid=c.id LEFT JOIN database_zhgooglemaps_maps as m on h.mapid=m.id LEFT JOIN database_zhgooglemaps_markergroups as g on h.markergroup=g.id LEFT JOIN database_users as usr on h.createdbyuser=usr.id LEFT JOIN database_viewlevels as ag ON ag.id = h.access WHERE (h.published IN (0, 1))
Unknown column 'h.ordering' 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 database_zhgooglemaps_markers as h LEFT JOIN database_categories as c on h.catid=c.id LEFT JOIN database_zhgooglemaps_maps as m on h.mapid=m.id LEFT JOIN database_zhgooglemaps_markergroups as g on h.markergroup=g.id LEFT JOIN database_users as usr on h.createdbyuser=usr.id LEFT JOIN database_viewlevels as ag ON ag.id = h.access WHERE (h.published IN (0, 1)) ORDER BY h.title asc LIMIT 0, 20
Unknown column 'h.access' in 'on clause' SQL=SELECT COUNT(*) FROM database_zhgooglemaps_markers as h LEFT JOIN database_categories as c on h.catid=c.id LEFT JOIN database_zhgooglemaps_maps as m on h.mapid=m.id LEFT JOIN database_zhgooglemaps_markergroups as g on h.markergroup=g.id LEFT JOIN database_users as usr on h.createdbyuser=usr.id LEFT JOIN database_viewlevels as ag ON ag.id = h.access WHERE (h.published IN (0, 1))
Please Log in or Create an account to join the conversation.
Please Log in or Create an account to join the conversation.
Please Log in or Create an account to join the conversation.
Please Log in or Create an account to join the conversation.
Please Log in or Create an account to join the conversation.
Please Log in or Create an account to join the conversation.
© 2011- Жук Це-Це. Design by Dmitry Zhuk