Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Manufacturers error message


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


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


edit /includes/classes/split_page_results.php


$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




Link to comment
Share on other sites


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

  • Create New...