Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

MySQL 5.0 Issues


Tim.Ford

Recommended Posts

Posted

Hi Guys,

 

I getting this error in the admin section under a few items this one links the the Geog Zones

 

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 geo_zone_id, geo_zone_name, geo_zone_description, last_modified, date_added from geo_zones order by geo_zone_name limit -20, 20

 

I have seen this before and have looked through the fourms but can't seem to find anything. Does anyone have any ideas on how i can fix this??

 

Thanks, Tim.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...