Insert Product Error 1064

05.08.2016 11:07
#1
Bozhkov
User Bozhkov
Name: Konstantin
17.07.2014
Posts: 110
Quote
Insert Product Error 1064

При добавлении товара в описание категории происходит ошибка 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 'GROUP BY prod.product_id' at line 6 SQL=SELECT prod.product_id, pr_cat.category_id, prod.`name_uk-UA` as name, prod.`short_description_uk-UA` as short_description, prod.product_ean, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, prod.delivery_times_id, prod.`extra_field_20` , prod.`extra_field_78` , prod.`extra_field_85` , prod.`extra_field_141` , prod.`extra_field_56` , prod.`extra_field_13` , prod.`extra_field_1` , prod.`extra_field_2` , prod.`extra_field_7` , prod.`extra_field_15` , prod.`extra_field_31` , prod.`extra_field_51` , prod.`extra_field_62` , prod.`extra_field_63` , prod.`extra_field_64` , prod.`extra_field_65` , prod.`extra_field_83` , prod.`extra_field_92` , prod.`extra_field_96` , prod.`extra_field_108` , prod.`extra_field_113` , prod.`extra_field_115` , prod.`extra_field_126` , prod.min_count_product , prod.product_unit_id FROM `#__jshopping_products` AS prod LEFT JOIN `#__jshopping_products_to_categories` AS pr_cat USING (product_id) LEFT JOIN `#__jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_id='687' AND prod.product_publish = '1' AND cat.category_publish='1' AND 1=0 OR (pr_cat.category_id IN (41,42,43,44,45,40) AND prod.product_publish = '1' AND prod.access IN (1,1,2,3) AND cat.access IN (1,1,2,3)) GROUP BY prod.product_id GROUP BY prod.product_id


http://kievdah.com.ua/ua/uteplitel.html

 
05.08.2016 12:17
#2
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 19073
Quote
Aw: Insert Product Error 1064

Insert Product for joomla content

 


Copyrights MAXXmarketing GmbH. All Rights Reserved
Durch die Nutzung dieser Website stimme ich zu, dass Cookies zur optimalen Gestaltung der Website sowie zur Analyse der Nutzung der Website verwendet werden. Weiterführende Informationen finden Sie hier. OK, einverstanden.