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
}
Вы не можете посетить текущую страницу по причине:
- просроченная закладка/избранное
- поисковый механизм, у которого просрочен список для этого сайта
- пропущен адрес
- у вас нет права доступа на эту страницу
- Запрашиваемый ресурс не найден.
- В процессе обработки вашего запроса произошла ошибка.
Пожалуйста, перейдите на одну из следующих страниц: