Автозапчасти и ремонт

г. Москва Чермянский

+7 (495) 589-31-40

0 руб.

Ваша корзина
0 товаров
Zend Framework Default Application

Ошибка12

Application error

object(Zend_Db_Statement_Exception)#370 (8) { ["message":protected]=> string(4906) "SQLSTATE[42000]: Syntax error or access violation: 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 ')) OR (art='1551345' AND brand_id IN (423,5199)) OR (art='0540170011' AND brand_' at line 4, query was: SELECT p.id, p.art, p.sup_id, p.name, p.price, p.quantity, b.image as brand_image, p.brand as brand_title, b2.id as main_brand_id, b2.tecdoc_id as main_brand_tecdoc_id FROM products as p LEFT JOIN brands as b ON b.id=p.brand_id LEFT JOIN brands as b2 ON b2.id=b.main_id WHERE p.quantity>0 AND ((art='118116' AND brand_id IN (901)) OR (art='118119' AND brand_id IN (901)) OR (art='120078N' AND brand_id IN (73,50116,53706)) OR (art='120079N' AND brand_id IN (73,50116,53706)) OR (art='121400N' AND brand_id IN (73,50116,53706)) OR (art='121890N' AND brand_id IN (73,50116,53706)) OR (art='102918' AND brand_id IN (473)) OR (art='MS2286' AND brand_id IN (199,3503,19218)) OR (art='MSA2286' AND brand_id IN (199,3503,19218)) OR (art='0016000052' AND brand_id IN (1252,6610)) OR (art='8MK376714331' AND brand_id IN (2,12,49,91,450,1154,1878,2926,3673,5362,5363,5364,5393,5405,5620,5621,5710,6018,6019,19158,19322,19653,19714,20280,51159,52245,54250,54387,54432)) OR (art='8MK376714334' AND brand_id IN (2,12,49,91,450,1154,1878,2926,3673,5362,5363,5364,5393,5405,5620,5621,5710,6018,6019,19158,19322,19653,19714,20280,51159,52245,54250,54387,54432)) OR (art='DRM17079' AND brand_id IN (63)) OR (art='DRM17080' AND brand_id IN (63)) OR (art='DRM17081' AND brand_id IN (63)) OR (art='8167105' AND brand_id IN (204)) OR (art='DCM2386' AND brand_id IN (204)) OR (art='10016' AND brand_id IN (1189,51164,53673)) OR (art='37595' AND brand_id IN (90,2020,4207,52209)) OR (art='01063056' AND brand_id IN (246)) OR (art='01063057' AND brand_id IN (246)) OR (art='8MK376714331' AND brand_id IN (2,12,49,91,450,1154,1878,2926,3673,5362,5363,5364,5393,5405,5620,5621,5710,6018,6019,19158,19322,19653,19714,20280,51159,52245,54250,54387,54432)) OR (art='8MK376714334' AND brand_id IN (2,12,49,91,450,1154,1878,2926,3673,5362,5363,5364,5393,5405,5620,5621,5710,6018,6019,19158,19322,19653,19714,20280,51159,52245,54250,54387,54432)) OR (art='RA0170550' AND brand_id IN (3831)) OR (art='RA0170580' AND brand_id IN (3831)) OR (art='360600' AND brand_id IN ()) OR (art='1551345' AND brand_id IN (423,5199)) OR (art='0540170011' AND brand_id IN (456)) OR (art='0540170011B' AND brand_id IN (456)) OR (art='350213111009' AND brand_id IN (87,1710,50185,53495,54263)) OR (art='350213121900' AND brand_id IN (87,1710,50185,53495,54263)) OR (art='117071' AND brand_id IN (250,53610,53741,54762)) OR (art='03929' AND brand_id IN (460,4338,5491)) OR (art='62786A' AND brand_id IN (104,50929)) OR (art='DRM17079' AND brand_id IN (327,55050)) OR (art='DRM17080' AND brand_id IN (327,55050)) OR (art='DRM17081' AND brand_id IN (327,55050)) OR (art='53418' AND brand_id IN (166,53541)) OR (art='53419' AND brand_id IN (166,53541)) OR (art='56143' AND brand_id IN (166,53541)) OR (art='2065028' AND brand_id IN (1201)) OR (art='2065081' AND brand_id IN (1201)) OR (art='MS2286' AND brand_id IN (264)) OR (art='MSA2286' AND brand_id IN (264)) OR (art='PR3567A1' AND brand_id IN (472,51070)) OR (art='QER2241' AND brand_id IN (54,1736)) OR (art='171340' AND brand_id IN (706)) OR (art='CU2337' AND brand_id IN (527,6308)) OR (art='CU2749' AND brand_id IN (527,6308)) OR (art='CU2750' AND brand_id IN (527,6308)) OR (art='CU2751' AND brand_id IN (527,6308)) OR (art='T403929' AND brand_id IN (461)) OR (art='1025346SX' AND brand_id IN (440)) OR (art='10937595' AND brand_id IN (123)) OR (art='D7M030TT' AND brand_id IN (407)) OR (art='408893' AND brand_id IN (236)) OR (art='0240176' AND brand_id IN (170,19127)) OR (art='7210013R' AND brand_id IN (58,4443)) OR (art='V301897' AND brand_id IN (133)) OR (art='732741' AND brand_id IN (20,5395,6966,6968,7083,19160,19206,19654,50949,51059)) OR (art='30002286' AND brand_id IN (36,1686,52178)) OR (art='V30601277' AND brand_id IN (149)) OR (art='WG1722297' AND brand_id IN (1188,6051)) OR (art='WG1722298' AND brand_id IN (1188,6051)) OR (art='WG1723084' AND brand_id IN (1188,6051)) OR (art='MK1361' AND brand_id IN (525))) AND p.sup_id IN (1,2,3,5,9,12,13,15,16,17,20,21,23,24,25,26,27,28,29,31,33,35,36,37,38,39,40,42,43,44,46,47,48,49,51,52,53,54,55,61,64,66,67,69,70,72,73,74,75,76,77,78,82,85,87,88,90,91,92,93,95,96,97,98,100,102,103,104,105,106,110,112,113,114,115,116,117,118,119,120,121,123,124,125,128,130,131,132,133,134,136,137,138,139,141,142,143,144,145,146,147,149,151,152,156,159,160,162,164,165,166,167,168,169,171,172,174,177,178,188,190,191,192,194,195,196,198,201,202,206,214,215,218,221,220,211,222,223,230,231,235,240,241,243,244,246,247,251,252,259,260,261,268,271,272,56,242,279,282,286,296,295,294,300,301,302,303,304,305,227)" ["string":"Exception":private]=> string(0) "" ["code":protected]=> int(42000) ["file":protected]=> string(34) "/var/www/Zend/Db/Statement/Pdo.php" ["line":protected]=> int(235) ["trace":"Exception":private]=> array(12) { [0]=> array(5) { ["file"]=> string(30) "/var/www/Zend/Db/Statement.php" ["line"]=> int(303) ["function"]=> string(8) "_execute" ["class"]=> string(21) "Zend_Db_Statement_Pdo" ["type"]=> string(2) "->" } [1]=> array(5) { ["file"]=> string(37) "/var/www/Zend/Db/Adapter/Abstract.php" ["line"]=> int(480) ["function"]=> string(7) "execute" ["class"]=> string(17) "Zend_Db_Statement" ["type"]=> string(2) "->" } [2]=> array(5) { ["file"]=> string(41) "/var/www/Zend/Db/Adapter/Pdo/Abstract.php" ["line"]=> int(238) ["function"]=> string(5) "query" ["class"]=> string(24) "Zend_Db_Adapter_Abstract" ["type"]=> string(2) "->" } [3]=> array(5) { ["file"]=> string(37) "/var/www/Zend/Db/Adapter/Abstract.php" ["line"]=> int(739) ["function"]=> string(5) "query" ["class"]=> string(28) "Zend_Db_Adapter_Pdo_Abstract" ["type"]=> string(2) "->" } [4]=> array(5) { ["file"]=> string(51) "/var/www/artis/application/models/Search/Search.php" ["line"]=> int(1158) ["function"]=> string(8) "fetchAll" ["class"]=> string(24) "Zend_Db_Adapter_Abstract" ["type"]=> string(2) "->" } [5]=> array(5) { ["file"]=> string(81) "/var/www/artis/application/modules/default/controllers/PartscatalogController.php" ["line"]=> int(659) ["function"]=> string(11) "getProducts" ["class"]=> string(31) "Application_Model_Search_Search" ["type"]=> string(2) "->" } [6]=> array(5) { ["file"]=> string(35) "/var/www/Zend/Controller/Action.php" ["line"]=> int(516) ["function"]=> string(11) "indexAction" ["class"]=> string(22) "PartscatalogController" ["type"]=> string(2) "->" } [7]=> array(5) { ["file"]=> string(48) "/var/www/Zend/Controller/Dispatcher/Standard.php" ["line"]=> int(308) ["function"]=> string(8) "dispatch" ["class"]=> string(22) "Zend_Controller_Action" ["type"]=> string(2) "->" } [8]=> array(5) { ["file"]=> string(34) "/var/www/Zend/Controller/Front.php" ["line"]=> int(954) ["function"]=> string(8) "dispatch" ["class"]=> string(35) "Zend_Controller_Dispatcher_Standard" ["type"]=> string(2) "->" } [9]=> array(5) { ["file"]=> string(49) "/var/www/Zend/Application/Bootstrap/Bootstrap.php" ["line"]=> int(105) ["function"]=> string(8) "dispatch" ["class"]=> string(21) "Zend_Controller_Front" ["type"]=> string(2) "->" } [10]=> array(5) { ["file"]=> string(29) "/var/www/Zend/Application.php" ["line"]=> int(400) ["function"]=> string(3) "run" ["class"]=> string(36) "Zend_Application_Bootstrap_Bootstrap" ["type"]=> string(2) "->" } [11]=> array(5) { ["file"]=> string(31) "/var/www/artis/public/index.php" ["line"]=> int(34) ["function"]=> string(3) "run" ["class"]=> string(16) "Zend_Application" ["type"]=> string(2) "->" } } ["previous":"Exception":private]=> object(PDOException)#371 (8) { ["message":protected]=> string(282) "SQLSTATE[42000]: Syntax error or access violation: 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 ')) OR (art='1551345' AND brand_id IN (423,5199)) OR (art='0540170011' AND brand_' at line 4" ["string":"Exception":private]=> string(0) "" ["code":protected]=> string(5) "42000" ["file":protected]=> string(34) "/var/www/Zend/Db/Statement/Pdo.php" ["line":protected]=> int(228) ["trace":"Exception":private]=> array(13) { [0]=> array(5) { ["file"]=> string(34) "/var/www/Zend/Db/Statement/Pdo.php" ["line"]=> int(228) ["function"]=> string(7) "execute" ["class"]=> string(12) "PDOStatement" ["type"]=> string(2) "->" } [1]=> array(5) { ["file"]=> string(30) "/var/www/Zend/Db/Statement.php" ["line"]=> int(303) ["function"]=> string(8) "_execute" ["class"]=> string(21) "Zend_Db_Statement_Pdo" ["type"]=> string(2) "->" } [2]=> array(5) { ["file"]=> string(37) "/var/www/Zend/Db/Adapter/Abstract.php" ["line"]=> int(480) ["function"]=> string(7) "execute" ["class"]=> string(17) "Zend_Db_Statement" ["type"]=> string(2) "->" } [3]=> array(5) { ["file"]=> string(41) "/var/www/Zend/Db/Adapter/Pdo/Abstract.php" ["line"]=> int(238) ["function"]=> string(5) "query" ["class"]=> string(24) "Zend_Db_Adapter_Abstract" ["type"]=> string(2) "->" } [4]=> array(5) { ["file"]=> string(37) "/var/www/Zend/Db/Adapter/Abstract.php" ["line"]=> int(739) ["function"]=> string(5) "query" ["class"]=> string(28) "Zend_Db_Adapter_Pdo_Abstract" ["type"]=> string(2) "->" } [5]=> array(5) { ["file"]=> string(51) "/var/www/artis/application/models/Search/Search.php" ["line"]=> int(1158) ["function"]=> string(8) "fetchAll" ["class"]=> string(24) "Zend_Db_Adapter_Abstract" ["type"]=> string(2) "->" } [6]=> array(5) { ["file"]=> string(81) "/var/www/artis/application/modules/default/controllers/PartscatalogController.php" ["line"]=> int(659) ["function"]=> string(11) "getProducts" ["class"]=> string(31) "Application_Model_Search_Search" ["type"]=> string(2) "->" } [7]=> array(5) { ["file"]=> string(35) "/var/www/Zend/Controller/Action.php" ["line"]=> int(516) ["function"]=> string(11) "indexAction" ["class"]=> string(22) "PartscatalogController" ["type"]=> string(2) "->" } [8]=> array(5) { ["file"]=> string(48) "/var/www/Zend/Controller/Dispatcher/Standard.php" ["line"]=> int(308) ["function"]=> string(8) "dispatch" ["class"]=> string(22) "Zend_Controller_Action" ["type"]=> string(2) "->" } [9]=> array(5) { ["file"]=> string(34) "/var/www/Zend/Controller/Front.php" ["line"]=> int(954) ["function"]=> string(8) "dispatch" ["class"]=> string(35) "Zend_Controller_Dispatcher_Standard" ["type"]=> string(2) "->" } [10]=> array(5) { ["file"]=> string(49) "/var/www/Zend/Application/Bootstrap/Bootstrap.php" ["line"]=> int(105) ["function"]=> string(8) "dispatch" ["class"]=> string(21) "Zend_Controller_Front" ["type"]=> string(2) "->" } [11]=> array(5) { ["file"]=> string(29) "/var/www/Zend/Application.php" ["line"]=> int(400) ["function"]=> string(3) "run" ["class"]=> string(36) "Zend_Application_Bootstrap_Bootstrap" ["type"]=> string(2) "->" } [12]=> array(5) { ["file"]=> string(31) "/var/www/artis/public/index.php" ["line"]=> int(34) ["function"]=> string(3) "run" ["class"]=> string(16) "Zend_Application" ["type"]=> string(2) "->" } } ["previous":"Exception":private]=> NULL ["errorInfo"]=> array(3) { [0]=> string(5) "42000" [1]=> int(1064) [2]=> string(226) "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 ')) OR (art='1551345' AND brand_id IN (423,5199)) OR (art='0540170011' AND brand_' at line 4" } } ["_previous":"Zend_Exception":private]=> NULL }

Войти

Забыли пароль?

У Вас еще нет аккаунта?

Регистрация