MySQL Error while trying to edit a Zone

[marciehunter]

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

[Jan Zonjee]

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.

[marciehunter]

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!