1064 - You have an error in your SQL syntax.

[j0ly]

Hey guys/girls

I have a fresh install with all the upgrades done (1 through 3) and i can connect to the db no problem, i removed all the packaged sample products, but when i go to add a new product, this is what i get after trying to view it

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 'limit 0, 10' at line 1

select p.products_image, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '22' order by limit 0, 10

[TEP STOP]

ive tried adding new products various different ways, but nothing.... any ideas?

[j0ly]

k this is bizarre, ill tell you abit about my catagorie hiarchy

its a site for car parts for a friend of mine, ( you can check out my problem at www.controlaltdeleted.com/customauto)

basically i have catagories of parts on the site
under the parts is a catagory for what car (brand of car ieL acura) the part can fit on
under that is the year of the car
then the part for that car

i did it this way thinking this is the only way (if someone can make a better suggestion im game for it)

so, heres the funny thing... if i click on the part under latest products i can see it no problem. if i navigate to that part through the catagory hiarchy then i get the error... any ideas???