1064 Error in CRE Loaded

1064 Error in CRE Loaded is project number 81902 posted at GetAFreelancer.com. Click here to post your own project.

Status:	Closed (Selected Service Provider)
Selected Providers:	selected service provider VladKuznetsov
Budget:	$30-100
Created:	08/17/2006 at 21:09 EDT
Bidding Ends:	08/22/2006 at 21:09 EDT
Project Creator:	zachthomas   Buyer Rating: (2 reviews)
Description:	I was changing some stuff in the admin section today, and in the “Configuration” panel I clicked on “Category/Display Products Order”. It then gave me 4 options to choose from in the right hand column, but when I tried to choose an option and update it, the “Category/Display Products Order” value was set to 0 and now I can’t change it. Now in the catalog side when a customer tries to click on anything in categories up comes this message: "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, 15' at line 11 select p.products_image, p.products_model, 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 p left join specials_retail_prices s using(products_id) ) left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_description pd, products_to_categories p2c 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 = '1' order by limit 0, 15" I haven’t changed this value since getting the new CRE Loaded cart, so I assume it is problem that arose when the database was converted, but I don't know. I want someone who knows exactly what the problem is so I can get this resolved quickly.
Job Type:	PHP
Database:	MySQL
Operating system:	Linux
Bid count:	1
Average bid:	$ 30