feinhorn Posted August 29, 2006 Share Posted August 29, 2006 Hi everyone! Please help me... When I add a geo_zone I cant see what is inside it... When I try to access I get: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-6, 6' at line 1 select a.association_id, a.zone_country_id, c.countries_name, a.zone_id, a.geo_zone_id, a.last_modified, a.date_added, z.zone_name from zones_to_geo_zones a left join countries c on a.zone_country_id = c.countries_id left join zones z on a.zone_id = z.zone_id where a.geo_zone_id = 4 order by association_id limit -6, 6 [TEP STOP] Anyone can help meee? Thank youu!! Fede Link to comment Share on other sites More sharing options...
feinhorn Posted September 5, 2006 Author Share Posted September 5, 2006 Hi everyone! Please help me... When I add a geo_zone I cant see what is inside it... When I try to access I get: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-6, 6' at line 1 select a.association_id, a.zone_country_id, c.countries_name, a.zone_id, a.geo_zone_id, a.last_modified, a.date_added, z.zone_name from zones_to_geo_zones a left join countries c on a.zone_country_id = c.countries_id left join zones z on a.zone_id = z.zone_id where a.geo_zone_id = 4 order by association_id limit -6, 6 [TEP STOP] Anyone can help meee? Thank youu!! Fede SOMEONE???? PLEASEEEEE!!! Link to comment Share on other sites More sharing options...
Jan Zonjee Posted September 5, 2006 Share Posted September 5, 2006 SOMEONE???? PLEASEEEEE!!! Update your store (see link on the top of index.php here). That will take care of the limit -6,6 error too. Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.