ConnectionManager_Exception Object ( [_query:ConnectionManager_Exception:private] => [message:protected] => Executing error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND `groupedfield` IN (SELECT `shopproduct`.`seriesname` FROM `shopproduct` WH' at line 2 in query: SELECT `shopproduct`.* FROM `shopproduct` WHERE `id` IN ( SELECT `productid` FROM `shopproductgrouped` WHERE `productid` IN ( ) AND `groupedfield` IN (SELECT `shopproduct`.`seriesname` FROM `shopproduct` WHERE (shopproduct.id IN (-1,2750,2753,2755,2818,2852,3156,3569,7338,7356,11061,13230,15150,15663,15666,15673,15676,15677,15678,15679,15680,15682,15688,15691,15692,15702,15842,15848,32843,33748,33756,33757,33771,33773,33781,33782,33783,33784,33788,33816,33817,33819,33820,33860,33867,33870,33875,33884,33888,33889,33895,33904,33905,33906,33916,33926,33935,33938,33940,33946,33947,33952,33954,33956,33957,33969,33977,33990,33991,33992,33998,33999,34001,34002,34005,34007,56723,56728,56761,56766,56767,56770,56784,56785,56796,56806,56809,56812,56819,56826,56835,56838,56839,56848,56856,56859,56861,56863,56866,56868,56879,56884,56889,56891,56893,56897,56900,56903,56909,56914,56920,56921,56943,56944,56946,56948,56952,56955,56967,56978,56987,56988,57017,57078,83962,86362,86608,100142,100144,108449,108519,138769)) AND `shopproduct`.`category2id`='49' AND `shopproduct`.`hidden`='0' AND `shopproduct`.`deleted`='0') ) AND `shopproduct`.`category2id`='49' AND `shopproduct`.`hidden`='0' AND `shopproduct`.`deleted`='0' ORDER BY CASE WHEN avail > 0 THEN 1 ELSE 0 END DESC, rating DESC, pricesell ASC LIMIT 36 [string:Exception:private] => [code:protected] => 0 [file:protected] => /var/www/clients/client30/web102/web/packages/ConnectionManager/ConnectionManager_MySQLi.class.php [line:protected] => 98 [trace:Exception:private] => Array ( [0] => Array ( [file] => /var/www/clients/client30/web102/web/packages/SQLObject/SQLObject.class.php [line] => 1092 [function] => query [class] => ConnectionManager_MySQLi [type] => -> [args] => Array ( [0] => SELECT `shopproduct`.* FROM `shopproduct` WHERE `id` IN ( SELECT `productid` FROM `shopproductgrouped` WHERE `productid` IN ( ) AND `groupedfield` IN (SELECT `shopproduct`.`seriesname` FROM `shopproduct` WHERE (shopproduct.id IN (-1,2750,2753,2755,2818,2852,3156,3569,7338,7356,11061,13230,15150,15663,15666,15673,15676,15677,15678,15679,15680,15682,15688,15691,15692,15702,15842,15848,32843,33748,33756,33757,33771,33773,33781,33782,33783,33784,33788,33816,33817,33819,33820,33860,33867,33870,33875,33884,33888,33889,33895,33904,33905,33906,33916,33926,33935,33938,33940,33946,33947,33952,33954,33956,33957,33969,33977,33990,33991,33992,33998,33999,34001,34002,34005,34007,56723,56728,56761,56766,56767,56770,56784,56785,56796,56806,56809,56812,56819,56826,56835,56838,56839,56848,56856,56859,56861,56863,56866,56868,56879,56884,56889,56891,56893,56897,56900,56903,56909,56914,56920,56921,56943,56944,56946,56948,56952,56955,56967,56978,56987,56988,57017,57078,83962,86362,86608,100142,100144,108449,108519,138769)) AND `shopproduct`.`category2id`='49' AND `shopproduct`.`hidden`='0' AND `shopproduct`.`deleted`='0') ) AND `shopproduct`.`category2id`='49' AND `shopproduct`.`hidden`='0' AND `shopproduct`.`deleted`='0' ORDER BY CASE WHEN avail > 0 THEN 1 ELSE 0 END DESC, rating DESC, pricesell ASC LIMIT 36 ) ) [1] => Array ( [file] => /var/www/clients/client30/web102/web/packages/SQLObject/SQLObject.class.php [line] => 843 [function] => _query [class] => SQLObject [type] => -> [args] => Array ( [0] => SELECT `shopproduct`.* FROM `shopproduct` WHERE `id` IN ( SELECT `productid` FROM `shopproductgrouped` WHERE `productid` IN ( ) AND `groupedfield` IN (SELECT `shopproduct`.`seriesname` FROM `shopproduct` WHERE (shopproduct.id IN (-1,2750,2753,2755,2818,2852,3156,3569,7338,7356,11061,13230,15150,15663,15666,15673,15676,15677,15678,15679,15680,15682,15688,15691,15692,15702,15842,15848,32843,33748,33756,33757,33771,33773,33781,33782,33783,33784,33788,33816,33817,33819,33820,33860,33867,33870,33875,33884,33888,33889,33895,33904,33905,33906,33916,33926,33935,33938,33940,33946,33947,33952,33954,33956,33957,33969,33977,33990,33991,33992,33998,33999,34001,34002,34005,34007,56723,56728,56761,56766,56767,56770,56784,56785,56796,56806,56809,56812,56819,56826,56835,56838,56839,56848,56856,56859,56861,56863,56866,56868,56879,56884,56889,56891,56893,56897,56900,56903,56909,56914,56920,56921,56943,56944,56946,56948,56952,56955,56967,56978,56987,56988,57017,57078,83962,86362,86608,100142,100144,108449,108519,138769)) AND `shopproduct`.`category2id`='49' AND `shopproduct`.`hidden`='0' AND `shopproduct`.`deleted`='0') ) AND `shopproduct`.`category2id`='49' AND `shopproduct`.`hidden`='0' AND `shopproduct`.`deleted`='0' ORDER BY CASE WHEN avail > 0 THEN 1 ELSE 0 END DESC, rating DESC, pricesell ASC LIMIT 36 ) ) [2] => Array ( [file] => /var/www/clients/client30/web102/web/api/db/XShopProduct.class.php [line] => 2112 [function] => getNext [class] => SQLObject [type] => -> [args] => Array ( [0] => ) ) [3] => Array ( [file] => /var/www/clients/client30/web102/web/api/system/ShopProduct.class.php [line] => 24 [function] => getNext [class] => XShopProduct [type] => -> [args] => Array ( [0] => ) ) [4] => Array ( [file] => /var/www/clients/client30/web102/web/contents/shop/shop_product_list_thumbsgrouped.php [line] => 39 [function] => getNext [class] => ShopProduct [type] => -> [args] => Array ( ) ) [5] => Array ( [file] => /var/www/clients/client30/web102/web/packages/Engine/Engine_ContentDriver.class.php [line] => 253 [function] => process [class] => shop_product_list_thumbsgrouped [type] => -> [args] => Array ( ) ) [6] => Array ( [file] => /var/www/clients/client30/web102/web/packages/Engine/Engine_Content.class.php [line] => 101 [function] => displayOne [class] => Engine_ContentDriver [type] => -> [args] => Array ( [0] => shop-product-list-thumbsgrouped ) ) [7] => Array ( [file] => /var/www/clients/client30/web102/web/contents/shop/shop_product_list.php [line] => 287 [function] => render [class] => Engine_Content [type] => -> [args] => Array ( ) ) [8] => Array ( [file] => /var/www/clients/client30/web102/web/packages/Engine/Engine_ContentDriver.class.php [line] => 253 [function] => process [class] => shop_product_list [type] => -> [args] => Array ( ) ) [9] => Array ( [file] => /var/www/clients/client30/web102/web/packages/Engine/Engine_Content.class.php [line] => 101 [function] => displayOne [class] => Engine_ContentDriver [type] => -> [args] => Array ( [0] => shop-product-list ) ) [10] => Array ( [file] => /var/www/clients/client30/web102/web/contents/shop/shop_category.php [line] => 237 [function] => render [class] => Engine_Content [type] => -> [args] => Array ( ) ) [11] => Array ( [file] => /var/www/clients/client30/web102/web/packages/Engine/Engine_ContentDriver.class.php [line] => 253 [function] => process [class] => shop_category [type] => -> [args] => Array ( ) ) [12] => Array ( [file] => /var/www/clients/client30/web102/web/packages/Engine/Engine_ContentDriver.class.php [line] => 120 [function] => displayOne [class] => Engine_ContentDriver [type] => -> [args] => Array ( [0] => shop-category ) ) [13] => Array ( [file] => /var/www/clients/client30/web102/web/packages/Engine/Engine_ContentDriver.class.php [line] => 77 [function] => display [class] => Engine_ContentDriver [type] => -> [args] => Array ( [0] => shop-category ) ) [14] => Array ( [file] => /var/www/clients/client30/web102/web/packages/Engine/Engine.class.php [line] => 122 [function] => getString [class] => Engine_ContentDriver [type] => -> [args] => Array ( [0] => shop-category ) ) [15] => Array ( [file] => /var/www/clients/client30/web102/web/shop.starter.php [line] => 54 [function] => execute [class] => Engine [type] => -> [args] => Array ( ) ) ) [previous:Exception:private] => )
Internal server error
Internal server error
URL: https://yazz.com.ua/spinningovie/filter379=UL/
Date and time: 2016-02-17 14:29:08
ConnectionManager_Exception Object
(
[_query:ConnectionManager_Exception:private] =>
[message:protected] => Executing error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND `groupedfield` IN (SELECT `shopproduct`.`seriesname` FROM `shopproduct` WH' at line 2 in query: SELECT COUNT(*) as sqlobjectCount FROM `shopproduct` WHERE `id` IN (
SELECT `productid` FROM `shopproductgrouped` WHERE `productid` IN ( ) AND `groupedfield` IN (SELECT `shopproduct`.`seriesname` FROM `shopproduct` WHERE (shopproduct.id IN (-1,2750,2753,2755,2818,2852,3156,3569,7338,7356,11061,13230,15150,15663,15666,15673,15676,15677,15678,15679,15680,15682,15688,15691,15692,15702,15842,15848,32843,33748,33756,33757,33771,33773,33781,33782,33783,33784,33788,33816,33817,33819,33820,33860,33867,33870,33875,33884,33888,33889,33895,33904,33905,33906,33916,33926,33935,33938,33940,33946,33947,33952,33954,33956,33957,33969,33977,33990,33991,33992,33998,33999,34001,34002,34005,34007,56723,56728,56761,56766,56767,56770,56784,56785,56796,56806,56809,56812,56819,56826,56835,56838,56839,56848,56856,56859,56861,56863,56866,56868,56879,56884,56889,56891,56893,56897,56900,56903,56909,56914,56920,56921,56943,56944,56946,56948,56952,56955,56967,56978,56987,56988,57017,57078,83962,86362,86608,100142,100144,108449,108519,138769)) AND `shopproduct`.`category2id`='49' AND `shopproduct`.`hidden`='0' AND `shopproduct`.`deleted`='0')
) AND `shopproduct`.`category2id`='49' AND `shopproduct`.`hidden`='0' AND `shopproduct`.`deleted`='0' GROUP BY seriesname
[string:Exception:private] =>
[code:protected] => 0
[file:protected] => /var/www/clients/client30/web102/web/packages/ConnectionManager/ConnectionManager_MySQLi.class.php
[line:protected] => 98
[trace:Exception:private] => Array
(
[0] => Array
(
[file] => /var/www/clients/client30/web102/web/packages/SQLObject/SQLObject.class.php
[line] => 1092
[function] => query
[class] => ConnectionManager_MySQLi
[type] => ->
[args] => Array
(
[0] => SELECT COUNT(*) as sqlobjectCount FROM `shopproduct` WHERE `id` IN (
SELECT `productid` FROM `shopproductgrouped` WHERE `productid` IN ( ) AND `groupedfield` IN (SELECT `shopproduct`.`seriesname` FROM `shopproduct` WHERE (shopproduct.id IN (-1,2750,2753,2755,2818,2852,3156,3569,7338,7356,11061,13230,15150,15663,15666,15673,15676,15677,15678,15679,15680,15682,15688,15691,15692,15702,15842,15848,32843,33748,33756,33757,33771,33773,33781,33782,33783,33784,33788,33816,33817,33819,33820,33860,33867,33870,33875,33884,33888,33889,33895,33904,33905,33906,33916,33926,33935,33938,33940,33946,33947,33952,33954,33956,33957,33969,33977,33990,33991,33992,33998,33999,34001,34002,34005,34007,56723,56728,56761,56766,56767,56770,56784,56785,56796,56806,56809,56812,56819,56826,56835,56838,56839,56848,56856,56859,56861,56863,56866,56868,56879,56884,56889,56891,56893,56897,56900,56903,56909,56914,56920,56921,56943,56944,56946,56948,56952,56955,56967,56978,56987,56988,57017,57078,83962,86362,86608,100142,100144,108449,108519,138769)) AND `shopproduct`.`category2id`='49' AND `shopproduct`.`hidden`='0' AND `shopproduct`.`deleted`='0')
) AND `shopproduct`.`category2id`='49' AND `shopproduct`.`hidden`='0' AND `shopproduct`.`deleted`='0' GROUP BY seriesname
)
)
[1] => Array
(
[file] => /var/www/clients/client30/web102/web/packages/SQLObject/SQLObject.class.php
[line] => 901
[function] => _query
[class] => SQLObject
[type] => ->
[args] => Array
(
[0] => SELECT COUNT(*) as sqlobjectCount FROM `shopproduct` WHERE `id` IN (
SELECT `productid` FROM `shopproductgrouped` WHERE `productid` IN ( ) AND `groupedfield` IN (SELECT `shopproduct`.`seriesname` FROM `shopproduct` WHERE (shopproduct.id IN (-1,2750,2753,2755,2818,2852,3156,3569,7338,7356,11061,13230,15150,15663,15666,15673,15676,15677,15678,15679,15680,15682,15688,15691,15692,15702,15842,15848,32843,33748,33756,33757,33771,33773,33781,33782,33783,33784,33788,33816,33817,33819,33820,33860,33867,33870,33875,33884,33888,33889,33895,33904,33905,33906,33916,33926,33935,33938,33940,33946,33947,33952,33954,33956,33957,33969,33977,33990,33991,33992,33998,33999,34001,34002,34005,34007,56723,56728,56761,56766,56767,56770,56784,56785,56796,56806,56809,56812,56819,56826,56835,56838,56839,56848,56856,56859,56861,56863,56866,56868,56879,56884,56889,56891,56893,56897,56900,56903,56909,56914,56920,56921,56943,56944,56946,56948,56952,56955,56967,56978,56987,56988,57017,57078,83962,86362,86608,100142,100144,108449,108519,138769)) AND `shopproduct`.`category2id`='49' AND `shopproduct`.`hidden`='0' AND `shopproduct`.`deleted`='0')
) AND `shopproduct`.`category2id`='49' AND `shopproduct`.`hidden`='0' AND `shopproduct`.`deleted`='0' GROUP BY seriesname
)
)
[2] => Array
(
[file] => /var/www/clients/client30/web102/web/contents/shop/shop_product_list.php
[line] => 296
[function] => getCount
[class] => SQLObject
[type] => ->
[args] => Array
(
)
)
[3] => Array
(
[file] => /var/www/clients/client30/web102/web/packages/Engine/Engine_ContentDriver.class.php
[line] => 253
[function] => process
[class] => shop_product_list
[type] => ->
[args] => Array
(
)
)
[4] => Array
(
[file] => /var/www/clients/client30/web102/web/packages/Engine/Engine_Content.class.php
[line] => 101
[function] => displayOne
[class] => Engine_ContentDriver
[type] => ->
[args] => Array
(
[0] => shop-product-list
)
)
[5] => Array
(
[file] => /var/www/clients/client30/web102/web/contents/shop/shop_category.php
[line] => 237
[function] => render
[class] => Engine_Content
[type] => ->
[args] => Array
(
)
)
[6] => Array
(
[file] => /var/www/clients/client30/web102/web/packages/Engine/Engine_ContentDriver.class.php
[line] => 253
[function] => process
[class] => shop_category
[type] => ->
[args] => Array
(
)
)
[7] => Array
(
[file] => /var/www/clients/client30/web102/web/packages/Engine/Engine_ContentDriver.class.php
[line] => 120
[function] => displayOne
[class] => Engine_ContentDriver
[type] => ->
[args] => Array
(
[0] => shop-category
)
)
[8] => Array
(
[file] => /var/www/clients/client30/web102/web/packages/Engine/Engine_ContentDriver.class.php
[line] => 77
[function] => display
[class] => Engine_ContentDriver
[type] => ->
[args] => Array
(
[0] => shop-category
)
)
[9] => Array
(
[file] => /var/www/clients/client30/web102/web/packages/Engine/Engine.class.php
[line] => 122
[function] => getString
[class] => Engine_ContentDriver
[type] => ->
[args] => Array
(
[0] => shop-category
)
)
[10] => Array
(
[file] => /var/www/clients/client30/web102/web/shop.starter.php
[line] => 54
[function] => execute
[class] => Engine
[type] => ->
[args] => Array
(
)
)
)
[previous:Exception:private] =>
)