marciehunter Posted December 6, 2006 Posted December 6, 2006 In the admin when I click on the folder icon next to a Zone I get the following error: 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 '-20, 20' 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 = 2 order by association_id limit -20, 20 [TEP STOP] Can someone help me to fix this error? Thanks Quote
Jan Zonjee Posted December 6, 2006 Posted December 6, 2006 In the admin when I click on the folder icon next to a Zone I get the following error: 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 '-20, 20' at line 1 You must have searched very hard for this error message because it comes up at least once a day for the past year or more. Update your osC installation: top navigation bar -> Solutions -> Downloads. Quote
marciehunter Posted December 6, 2006 Author Posted December 6, 2006 You must have searched very hard for this error message because it comes up at least once a day for the past year or more. Update your osC installation: top navigation bar -> Solutions -> Downloads. I actually did search for it, but I got 1000's of results and I read through a couple pages without finding exactly what I wanted. Sorry! Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.