Help need

[tonspr]

I few minutes ago I deleted a folder in the catalog screen and went to the main page to check if the folder was gone, to my suprise on the front page, where the previewed items are suppose to be, I find this:

 

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 '-9, 9' at line 1

 

select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from products p, products_description pd, specials s where p.products_status = '1' and s.products_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and s.status = '1' order by s.specials_date_added DESC limit -9, 9

 

 

 

 

Can anyone explain how to fix this problem?

[Guest]

http://www.oscommerce.com/forums/index.php?showtopic=144095

 

The_Bear

[tonspr]

Thanks, but when I checked the site again to see if the error was still there, it was gone. However, some non-existing items where still there. I looked in the catalog section in the Oscommerce menu and it said there were 0 items on the enitre sight, however, if you look at the items section in the actual website, it says about 5000 items are still there.

[tonspr]

NEVERMIND