Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Manufacturers error message


lbowen

Recommended Posts

Never used OSCommerce before. Using Admin module to remove existing manufacturers. Deleted last one and now cannot add new ones. Here is the error message:

Action 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 1select manufacturers_id, manufacturers_name, manufacturers_image, date_added, last_modified from manufacturers order by manufacturers_name limit -20, 20[TEP STOP]

 

Please advise.

Link to comment
Share on other sites

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

A quick summary of the patch code.....

 

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...