Devam Ediyor

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.

Beceriler: PHP

Daha fazlasını görün: value options, products manufacturers, problem categories, panel configuration, new line php, manufacturers products, manufacturers catalog, line problem, 4 tries, p sql, message error, error 0, tries, syntax, server changing, null, mysql error, loaded, error, error php, cre, tried, php sql syntax error, mysql database catalog, 1064 php

İşveren Hakkında:
( 2 değerlendirme ) Holland, United States

Proje NO: #81902

Seçilen:

VladKuznetsov

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.

0 gün içinde 30$ USD
(49 Değerlendirme)
4.9