1064 Error in CRE Loaded

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([url removed, login to view], s.specials_new_products_price, NULL) as specials_new_products_price, IF([url removed, login to view], 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.

Evner: PHP

Se mere: value options, products manufacturers, problem categories, panel configuration, new line in php, manufacturers products, manufacturers catalog, line in problem, 4 tries, creloaded 1064 error sql syntax, 1064 error sql syntax cre loaded, p sql, message error, error 0, tries, syntax, server changing, null, mysql error, loaded, error, error php, cre, cre loaded, tried

Om arbejdsgiveren:
( 2 bedømmelser ) Holland, United States

Projekt ID: #81902

Tildelt til:


Hello Sir. I can help you with your sql problem within right now. I'm available via GMail CHat, MSN or ICQ. Regards Zend Certified PHP Developer Vladimir Kuznetsov.

$30 USD in 0 dage
(49 bedømmelser)