Insert Product Error 1064

05.08.2016 11:07
#1
Bozhkov
User Bozhkov
Name: Konstantin
17.07.2014
Posts: 74
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: 16516
Quote
Aw: Insert Product Error 1064

Insert Product for joomla content

 
Copyrights MAXXmarketing GmbH. All Rights Reserved