Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

how do I fix this error message?


Guest

Recommended Posts

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

 

[TEP STOP]

 

 

I get the above error messages in a few options in the oscommerce adim. the one this was takin from was the taxzone option, I need to add NC to the tax zone but have no options avail, this error showed up after i deleted the florida dir in it, like I said there are a few diff places with this error message, it seems to me that If there is no info for it to "look up" i get this message. not sure tho im no programmes. So anyone know how to fix/edit whatever to fix this?

Link to comment
Share on other sites

http://www.oscommerce.com/community/bugs,1605

 

edit /includes/classes/split_page_results.php

find

$this->sql_query .= " limit " . $offset . ", " . $this->number_of_rows_per_page;

(line about 66)

insert before it

if($offset <0 ) $offset = 0;

 

the same in admin//includes/classes/split_page_results.php

do the same, but this time it's line about 38

 

HTH

Tom

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...