very strange code SQL error appearing

[Guest]

Hi there, i installed my template fine and was setting it up with my products and i was in the manufactures heading an d i delete the manufaucters they had so i could enter my ones and once i deleted the last one a strange error code came up that i have never sen before. now i can add any new manufacturers here is what it says

 

Manufacturers

 

Manufacturers 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 1

 

select manufacturers_id, manufacturers_name, manufacturers_image, date_added, last_modified from manufacturers order by manufacturers_name limit -20, 20

 

[TEP STOP]

 

i went through the rest of my headings and found it also appearing on others but some of them i could fix. eg it happened on products reviews btu i wrote a fake rview on my website and now it is fixed. it happened on products expected but i again created a fake product that isnt due in until the end odf the year and it fixed that. it i as though since nothing is there, it puts this error it, but it is stoppnig mr from creating new manufactures. i also cant stop it from appearing on others such as specials

 

Specials

 

Products Products Price Status 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 1

 

select p.products_id, pd.products_name, p.products_price, s.specials_id, s.specials_new_products_price, s.specials_date_added, s.specials_last_modified, s.expires_date, s.date_status_change, s.status from products p, specials s, products_description pd where p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = s.products_id order by pd.products_name limit -20, 20

 

[TEP STOP]

 

 

and also one main one i am worried about in the tools heading called newsletter manager

 

Newsletter Manager

 

Newsletters Size Module Sent Status 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 1

 

select newsletters_id, title, length(content) as content_length, module, date_added, date_sent, status, locked from newsletters order by date_added desc limit -20, 20

 

[TEP STOP]

 

i tried sending a newsletter thinking this would fix it but it didnt. come someone help me?

[Jack_mcs]

Download the latest oscommerce update (above menu - Solutions->Downloads) and either install the whole update (recommended) or just do the one for the split_page_result.php file and that will fix it.

 

Jack