Zend Framework Default Application
Ошибка12
Application error
object(Zend_Db_Statement_Exception)#364 (8) {
["message":protected]=>
string(5378) "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='0540160022' AND brand_id IN (456)) OR (art='0540160025' AND brand_id' 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='300659' AND brand_id IN (1102)) OR (art='43189' AND brand_id IN (901)) OR (art='43336' AND brand_id IN (901)) OR (art='122019N' AND brand_id IN (73,50116,53706)) OR (art='122025N' AND brand_id IN (73,50116,53706)) OR (art='10500654' AND brand_id IN (351)) OR (art='161316' AND brand_id IN (948,4754)) OR (art='161340' AND brand_id IN (948,4754)) OR (art='103806' AND brand_id IN (473)) OR (art='105403' AND brand_id IN (473)) OR (art='MS5360D' AND brand_id IN (199,3503,19218)) OR (art='MS5435D' AND brand_id IN (199,3503,19218)) OR (art='MSA5435D' AND brand_id IN (199,3503,19218)) OR (art='8FC351303411' 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='8FC351317501' 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='8FC351317504' 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='BSG60525013' AND brand_id IN (403,53455,53694)) OR (art='BSG60525015' AND brand_id IN (403,53455,53694)) OR (art='1223382' AND brand_id IN (426,6792,7089,53828)) OR (art='1223382X' AND brand_id IN (426,6792,7089,53828)) OR (art='TSP0225329' AND brand_id IN (81)) OR (art='TSP0225657' AND brand_id IN (81)) OR (art='TSP0225703' AND brand_id IN (81)) OR (art='DCN17005' AND brand_id IN (63)) OR (art='DCN17023' AND brand_id IN (63)) OR (art='DCN17026' AND brand_id IN (63)) OR (art='DCN17035' AND brand_id IN (63)) OR (art='DCC1693' AND brand_id IN (204)) OR (art='30M0107' AND brand_id IN (1148,5662)) OR (art='667105' AND brand_id IN (188,50156)) OR (art='08062014' AND brand_id IN (246)) OR (art='08062093' AND brand_id IN (246)) OR (art='260421' AND brand_id IN (509,50069)) OR (art='260422' AND brand_id IN (509,50069)) OR (art='8FC351303411' 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='8FC351317501' 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='8FC351317504' 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='717M55' AND brand_id IN (3831)) OR (art='392900' AND brand_id IN ()) OR (art='0540160022' AND brand_id IN (456)) OR (art='0540160025' AND brand_id IN (456)) OR (art='940100' AND brand_id IN (104,50929)) OR (art='94794' AND brand_id IN (104,50929)) OR (art='DCN17005' AND brand_id IN (327,55050)) OR (art='35623' AND brand_id IN (166,53541)) OR (art='35893' AND brand_id IN (166,53541)) OR (art='7110401' AND brand_id IN (422)) OR (art='MS5360D' AND brand_id IN (264)) OR (art='MS5435D' AND brand_id IN (264)) OR (art='MSA5435D' AND brand_id IN (264)) OR (art='QCN444' AND brand_id IN (54,1736)) OR (art='QCN644' AND brand_id IN (54,1736)) OR (art='F443189' AND brand_id IN (3750)) OR (art='F443336' AND brand_id IN (3750)) OR (art='171360B' AND brand_id IN (706)) OR (art='171360C' AND brand_id IN (706)) OR (art='73385' AND brand_id IN (527,6308)) OR (art='73636' AND brand_id IN (527,6308)) OR (art='1045125SX' AND brand_id IN (440)) OR (art='1045577SX' AND brand_id IN (440)) OR (art='KTT110273' AND brand_id IN (407)) OR (art='KTT110405' AND brand_id IN (407)) OR (art='0240288' AND brand_id IN (170,19127)) OR (art='0240289' AND brand_id IN (170,19127)) OR (art='818200' AND brand_id IN (20,5395,6966,6968,7083,19160,19206,19654,50949,51059)) OR (art='30005435' AND brand_id IN (36,1686,52178)) OR (art='V30621035' AND brand_id IN (149)) OR (art='V30621048' AND brand_id IN (149)) OR (art='8880400352' AND brand_id IN (89)) OR (art='8880400483' AND brand_id IN (89)) OR (art='82D0225657A' AND brand_id IN (235)) OR (art='82D0226280MA' AND brand_id IN (235))) 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,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)#365 (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='0540160022' AND brand_id IN (456)) OR (art='0540160025' AND brand_id' 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='0540160022' AND brand_id IN (456)) OR (art='0540160025' AND brand_id' at line 4"
}
}
["_previous":"Zend_Exception":private]=>
NULL
}