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 8 SQL=SELECT prod.parent_article, prod.`alias_ru-RU` AS prodalias, cat.`alias_ru-RU` as catalias, m.`alias_ru-RU` AS manalias, cat.category_parent_id AS parent, prod.product_id, pr_cat.category_id, prod.`name_ru-RU` as name, prod.`short_description_ru-RU` 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.`extra_field_12` , prod.`extra_field_16` , prod.`extra_field_4` , prod.`extra_field_5` , prod.`extra_field_11` , prod.`extra_field_7` , prod.`extra_field_8` , prod.`extra_field_3` , prod.`extra_field_6` , IF (prod.product_price = 0, 0, 1) AS orderprice, IF (prod.extra_field_8 IN (97,107, 108, 109,112,437,547,548,637,643,757), 1, 0) AS decor, m.`name_ru-RU` AS manufacturer_name, cat.`name_ru-RU` AS catname, prod.price_desc, prod.extra_field_12 AS article, prod.extra_field_14 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 LEFT JOIN `#__jshopping_categories_add` AS a ON a.category_id = cat.category_id LEFT JOIN `#__jshopping_manufacturers` AS m ON a.manufacturer = m.manufacturer_id WHERE prod.product_publish=1 AND cat.category_publish=1 AND prod.product_id IN () GROUP BY prod.product_id

Ошибка: 1064

object(JDatabaseExceptionExecuting)#6765 (8) { ["query":"JDatabaseExceptionExecuting":private]=> string(1702) "SELECT prod.parent_article, prod.`alias_ru-RU` AS prodalias, cat.`alias_ru-RU` as catalias, m.`alias_ru-RU` AS manalias, cat.category_parent_id AS parent, prod.product_id, pr_cat.category_id, prod.`name_ru-RU` as name, prod.`short_description_ru-RU` 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.`extra_field_12` , prod.`extra_field_16` , prod.`extra_field_4` , prod.`extra_field_5` , prod.`extra_field_11` , prod.`extra_field_7` , prod.`extra_field_8` , prod.`extra_field_3` , prod.`extra_field_6` , IF (prod.product_price = 0, 0, 1) AS orderprice, IF (prod.extra_field_8 IN (97,107, 108, 109,112,437,547,548,637,643,757), 1, 0) AS decor, m.`name_ru-RU` AS manufacturer_name, cat.`name_ru-RU` AS catname, prod.price_desc, prod.extra_field_12 AS article, prod.extra_field_14 FROM `ply2v_jshopping_products` AS prod LEFT JOIN `ply2v_jshopping_products_to_categories` AS pr_cat USING (product_id) LEFT JOIN `ply2v_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id LEFT JOIN `ply2v_jshopping_categories_add` AS a ON a.category_id = cat.category_id LEFT JOIN `ply2v_jshopping_manufacturers` AS m ON a.manufacturer = m.manufacturer_id WHERE prod.product_publish=1 AND cat.category_publish=1 AND prod.product_id IN () GROUP BY prod.product_id" ["message":protected]=> string(1882) "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 8 SQL=SELECT prod.parent_article, prod.`alias_ru-RU` AS prodalias, cat.`alias_ru-RU` as catalias, m.`alias_ru-RU` AS manalias, cat.category_parent_id AS parent, prod.product_id, pr_cat.category_id, prod.`name_ru-RU` as name, prod.`short_description_ru-RU` 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.`extra_field_12` , prod.`extra_field_16` , prod.`extra_field_4` , prod.`extra_field_5` , prod.`extra_field_11` , prod.`extra_field_7` , prod.`extra_field_8` , prod.`extra_field_3` , prod.`extra_field_6` , IF (prod.product_price = 0, 0, 1) AS orderprice, IF (prod.extra_field_8 IN (97,107, 108, 109,112,437,547,548,637,643,757), 1, 0) AS decor, m.`name_ru-RU` AS manufacturer_name, cat.`name_ru-RU` AS catname, prod.price_desc, prod.extra_field_12 AS article, prod.extra_field_14 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 LEFT JOIN `#__jshopping_categories_add` AS a ON a.category_id = cat.category_id LEFT JOIN `#__jshopping_manufacturers` AS m ON a.manufacturer = m.manufacturer_id WHERE prod.product_publish=1 AND cat.category_publish=1 AND prod.product_id IN () GROUP BY prod.product_id" ["string":"Exception":private]=> string(0) "" ["code":protected]=> int(1064) ["file":protected]=> string(77) "/var/www/gres/data/www/grescom.ru/libraries/joomla/database/driver/mysqli.php" ["line":protected]=> int(660) ["trace":"Exception":private]=> array(12) { [0]=> array(6) { ["file"]=> string(70) "/var/www/gres/data/www/grescom.ru/libraries/joomla/database/driver.php" ["line"]=> int(1689) ["function"]=> string(7) "execute" ["class"]=> string(21) "JDatabaseDriverMysqli" ["type"]=> string(2) "->" ["args"]=> array(0) { } } [1]=> array(6) { ["file"]=> string(77) "/var/www/gres/data/www/grescom.ru/components/com_jshopping/tables/product.php" ["line"]=> int(1385) ["function"]=> string(14) "loadObjectList" ["class"]=> string(15) "JDatabaseDriver" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> string(10) "product_id" } } [2]=> array(6) { ["file"]=> string(77) "/var/www/gres/data/www/grescom.ru/components/com_jshopping/tables/product.php" ["line"]=> int(1358) ["function"]=> string(15) "getProductsById" ["class"]=> string(12) "jshopProduct" ["type"]=> string(2) "->" ["args"]=> array(2) { [0]=> array(0) { } [1]=> array(0) { } } } [3]=> array(6) { ["file"]=> string(83) "/var/www/gres/data/www/grescom.ru/components/com_jshopping/controllers/products.php" ["line"]=> int(134) ["function"]=> string(20) "productsToCategories" ["class"]=> string(12) "jshopProduct" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> array(0) { } } } [4]=> array(6) { ["file"]=> string(72) "/var/www/gres/data/www/grescom.ru/libraries/legacy/controller/legacy.php" ["line"]=> int(702) ["function"]=> string(7) "display" ["class"]=> string(27) "JshoppingControllerProducts" ["type"]=> string(2) "->" ["args"]=> array(0) { } } [5]=> array(6) { ["file"]=> string(72) "/var/www/gres/data/www/grescom.ru/components/com_jshopping/jshopping.php" ["line"]=> int(25) ["function"]=> string(7) "execute" ["class"]=> string(17) "JControllerLegacy" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> string(0) "" } } [6]=> array(4) { ["file"]=> string(68) "/var/www/gres/data/www/grescom.ru/libraries/cms/component/helper.php" ["line"]=> int(405) ["args"]=> array(1) { [0]=> string(72) "/var/www/gres/data/www/grescom.ru/components/com_jshopping/jshopping.php" } ["function"]=> string(12) "require_once" } [7]=> array(6) { ["file"]=> string(68) "/var/www/gres/data/www/grescom.ru/libraries/cms/component/helper.php" ["line"]=> int(380) ["function"]=> string(16) "executeComponent" ["class"]=> string(16) "JComponentHelper" ["type"]=> string(2) "::" ["args"]=> array(1) { [0]=> string(72) "/var/www/gres/data/www/grescom.ru/components/com_jshopping/jshopping.php" } } [8]=> array(6) { ["file"]=> string(68) "/var/www/gres/data/www/grescom.ru/libraries/cms/application/site.php" ["line"]=> int(191) ["function"]=> string(15) "renderComponent" ["class"]=> string(16) "JComponentHelper" ["type"]=> string(2) "::" ["args"]=> array(1) { [0]=> string(13) "com_jshopping" } } [9]=> array(6) { ["file"]=> string(68) "/var/www/gres/data/www/grescom.ru/libraries/cms/application/site.php" ["line"]=> int(230) ["function"]=> string(8) "dispatch" ["class"]=> string(16) "JApplicationSite" ["type"]=> string(2) "->" ["args"]=> array(0) { } } [10]=> array(6) { ["file"]=> string(67) "/var/www/gres/data/www/grescom.ru/libraries/cms/application/cms.php" ["line"]=> int(257) ["function"]=> string(9) "doExecute" ["class"]=> string(16) "JApplicationSite" ["type"]=> string(2) "->" ["args"]=> array(0) { } } [11]=> array(6) { ["file"]=> string(43) "/var/www/gres/data/www/grescom.ru/index.php" ["line"]=> int(50) ["function"]=> string(7) "execute" ["class"]=> string(15) "JApplicationCms" ["type"]=> string(2) "->" ["args"]=> array(0) { } } } ["previous":"Exception":private]=> NULL }

Вы не можете посетить текущую страницу по причине:

Пожалуйста, перейдите на одну из следующих страниц: