footer--> object(Zend_Db_Statement_Exception)#56 (8) { ["_previous":"Zend_Exception":private]=> NULL ["message":protected]=> string(248) "SQLSTATE[42000]: Syntax error or access violation: 1064 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 'order by publishdate desc, shootingdate desc' at line 4" ["string":"Exception":private]=> string(0) "" ["code":protected]=> int(42000) ["file":protected]=> string(47) "/var/www/Zend/library/Zend/Db/Statement/Pdo.php" ["line":protected]=> int(234) ["trace":"Exception":private]=> array(11) { [0]=> array(6) { ["file"]=> string(43) "/var/www/Zend/library/Zend/Db/Statement.php" ["line"]=> int(300) ["function"]=> string(8) "_execute" ["class"]=> string(21) "Zend_Db_Statement_Pdo" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> &array(0) { } } } [1]=> array(6) { ["file"]=> string(50) "/var/www/Zend/library/Zend/Db/Adapter/Abstract.php" ["line"]=> int(479) ["function"]=> string(7) "execute" ["class"]=> string(17) "Zend_Db_Statement" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> &array(0) { } } } [2]=> array(6) { ["file"]=> string(54) "/var/www/Zend/library/Zend/Db/Adapter/Pdo/Abstract.php" ["line"]=> int(238) ["function"]=> string(5) "query" ["class"]=> string(24) "Zend_Db_Adapter_Abstract" ["type"]=> string(2) "->" ["args"]=> array(2) { [0]=> &string(293) "SELECT photoset_t.* , girl_t.* , shop_t.shopid, shop_t.carry FROM `photoset_t` left join girl_t on photoset_t._girlid = girl_t.girlid join shop_t on girl_t.shopid = shop_t.shopid where girl_t.shopid = "" and girl_t.girlid != order by publishdate desc, shootingdate desc " [1]=> &array(0) { } } } [3]=> array(6) { ["file"]=> string(46) "/var/www/application/models/photoset.class.php" ["line"]=> int(80) ["function"]=> string(5) "query" ["class"]=> string(28) "Zend_Db_Adapter_Pdo_Abstract" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> &string(293) "SELECT photoset_t.* , girl_t.* , shop_t.shopid, shop_t.carry FROM `photoset_t` left join girl_t on photoset_t._girlid = girl_t.girlid join shop_t on girl_t.shopid = shop_t.shopid where girl_t.shopid = "" and girl_t.girlid != order by publishdate desc, shootingdate desc " } } [4]=> array(6) { ["file"]=> string(55) "/var/www/application/controllers/PhotosetController.php" ["line"]=> int(100) ["function"]=> string(6) "getRow" ["class"]=> string(8) "photoset" ["type"]=> string(2) "->" ["args"]=> array(2) { [0]=> &array(2) { ["girl_t.shopid"]=> NULL ["not_girl_t.girlid"]=> NULL } [1]=> &string(35) "publishdate desc, shootingdate desc" } } [5]=> array(6) { ["file"]=> string(48) "/var/www/Zend/library/Zend/Controller/Action.php" ["line"]=> int(513) ["function"]=> string(12) "detailAction" ["class"]=> string(18) "PhotosetController" ["type"]=> string(2) "->" ["args"]=> array(0) { } } [6]=> array(6) { ["file"]=> string(61) "/var/www/Zend/library/Zend/Controller/Dispatcher/Standard.php" ["line"]=> int(295) ["function"]=> string(8) "dispatch" ["class"]=> string(22) "Zend_Controller_Action" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> &string(12) "detailAction" } } [7]=> array(6) { ["file"]=> string(47) "/var/www/Zend/library/Zend/Controller/Front.php" ["line"]=> int(954) ["function"]=> string(8) "dispatch" ["class"]=> string(35) "Zend_Controller_Dispatcher_Standard" ["type"]=> string(2) "->" ["args"]=> array(2) { [0]=> object(Zend_Controller_Request_Http)#28 (15) { ["_paramSources":protected]=> array(2) { [0]=> string(4) "_GET" [1]=> string(5) "_POST" } ["_requestUri":protected]=> string(47) "/photoset/detail/photosetid/123/?photonumber=12" ["_baseUrl":protected]=> string(0) "" ["_basePath":protected]=> NULL ["_pathInfo":protected]=> string(32) "/photoset/detail/photosetid/123/" ["_params":protected]=> array(4) { ["controller"]=> string(8) "photoset" ["action"]=> string(6) "detail" ["photosetid"]=> string(3) "123" ["module"]=> string(7) "default" } ["_rawBody":protected]=> NULL ["_aliases":protected]=> array(0) { } ["_dispatched":protected]=> bool(true) ["_module":protected]=> string(7) "default" ["_moduleKey":protected]=> string(6) "module" ["_controller":protected]=> string(8) "photoset" ["_controllerKey":protected]=> string(10) "controller" ["_action":protected]=> string(6) "detail" ["_actionKey":protected]=> string(6) "action" } [1]=> object(Zend_Controller_Response_Http)#29 (8) { ["_body":protected]=> array(0) { } ["_exceptions":protected]=> array(0) { } ["_headers":protected]=> array(0) { } ["_headersRaw":protected]=> array(0) { } ["_httpResponseCode":protected]=> int(200) ["_isRedirect":protected]=> bool(false) ["_renderExceptions":protected]=> bool(false) ["headersSentThrowsException"]=> bool(true) } } } [8]=> array(6) { ["file"]=> string(62) "/var/www/Zend/library/Zend/Application/Bootstrap/Bootstrap.php" ["line"]=> int(97) ["function"]=> string(8) "dispatch" ["class"]=> string(21) "Zend_Controller_Front" ["type"]=> string(2) "->" ["args"]=> array(0) { } } [9]=> array(6) { ["file"]=> string(42) "/var/www/Zend/library/Zend/Application.php" ["line"]=> int(366) ["function"]=> string(3) "run" ["class"]=> string(36) "Zend_Application_Bootstrap_Bootstrap" ["type"]=> string(2) "->" ["args"]=> array(0) { } } [10]=> array(6) { ["file"]=> string(18) "/var/www/index.php" ["line"]=> int(73) ["function"]=> string(3) "run" ["class"]=> string(16) "Zend_Application" ["type"]=> string(2) "->" ["args"]=> array(0) { } } } ["previous":"Exception":private]=> object(PDOException)#55 (8) { ["message":protected]=> string(248) "SQLSTATE[42000]: Syntax error or access violation: 1064 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 'order by publishdate desc, shootingdate desc' at line 4" ["string":"Exception":private]=> string(0) "" ["code":protected]=> string(5) "42000" ["file":protected]=> string(47) "/var/www/Zend/library/Zend/Db/Statement/Pdo.php" ["line":protected]=> int(228) ["trace":"Exception":private]=> array(12) { [0]=> array(6) { ["file"]=> string(47) "/var/www/Zend/library/Zend/Db/Statement/Pdo.php" ["line"]=> int(228) ["function"]=> string(7) "execute" ["class"]=> string(12) "PDOStatement" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> array(0) { } } } [1]=> array(6) { ["file"]=> string(43) "/var/www/Zend/library/Zend/Db/Statement.php" ["line"]=> int(300) ["function"]=> string(8) "_execute" ["class"]=> string(21) "Zend_Db_Statement_Pdo" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> &array(0) { } } } [2]=> array(6) { ["file"]=> string(50) "/var/www/Zend/library/Zend/Db/Adapter/Abstract.php" ["line"]=> int(479) ["function"]=> string(7) "execute" ["class"]=> string(17) "Zend_Db_Statement" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> &array(0) { } } } [3]=> array(6) { ["file"]=> string(54) "/var/www/Zend/library/Zend/Db/Adapter/Pdo/Abstract.php" ["line"]=> int(238) ["function"]=> string(5) "query" ["class"]=> string(24) "Zend_Db_Adapter_Abstract" ["type"]=> string(2) "->" ["args"]=> array(2) { [0]=> &string(293) "SELECT photoset_t.* , girl_t.* , shop_t.shopid, shop_t.carry FROM `photoset_t` left join girl_t on photoset_t._girlid = girl_t.girlid join shop_t on girl_t.shopid = shop_t.shopid where girl_t.shopid = "" and girl_t.girlid != order by publishdate desc, shootingdate desc " [1]=> &array(0) { } } } [4]=> array(6) { ["file"]=> string(46) "/var/www/application/models/photoset.class.php" ["line"]=> int(80) ["function"]=> string(5) "query" ["class"]=> string(28) "Zend_Db_Adapter_Pdo_Abstract" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> &string(293) "SELECT photoset_t.* , girl_t.* , shop_t.shopid, shop_t.carry FROM `photoset_t` left join girl_t on photoset_t._girlid = girl_t.girlid join shop_t on girl_t.shopid = shop_t.shopid where girl_t.shopid = "" and girl_t.girlid != order by publishdate desc, shootingdate desc " } } [5]=> array(6) { ["file"]=> string(55) "/var/www/application/controllers/PhotosetController.php" ["line"]=> int(100) ["function"]=> string(6) "getRow" ["class"]=> string(8) "photoset" ["type"]=> string(2) "->" ["args"]=> array(2) { [0]=> &array(2) { ["girl_t.shopid"]=> NULL ["not_girl_t.girlid"]=> NULL } [1]=> &string(35) "publishdate desc, shootingdate desc" } } [6]=> array(6) { ["file"]=> string(48) "/var/www/Zend/library/Zend/Controller/Action.php" ["line"]=> int(513) ["function"]=> string(12) "detailAction" ["class"]=> string(18) "PhotosetController" ["type"]=> string(2) "->" ["args"]=> array(0) { } } [7]=> array(6) { ["file"]=> string(61) "/var/www/Zend/library/Zend/Controller/Dispatcher/Standard.php" ["line"]=> int(295) ["function"]=> string(8) "dispatch" ["class"]=> string(22) "Zend_Controller_Action" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> &string(12) "detailAction" } } [8]=> array(6) { ["file"]=> string(47) "/var/www/Zend/library/Zend/Controller/Front.php" ["line"]=> int(954) ["function"]=> string(8) "dispatch" ["class"]=> string(35) "Zend_Controller_Dispatcher_Standard" ["type"]=> string(2) "->" ["args"]=> array(2) { [0]=> object(Zend_Controller_Request_Http)#28 (15) { ["_paramSources":protected]=> array(2) { [0]=> string(4) "_GET" [1]=> string(5) "_POST" } ["_requestUri":protected]=> string(47) "/photoset/detail/photosetid/123/?photonumber=12" ["_baseUrl":protected]=> string(0) "" ["_basePath":protected]=> NULL ["_pathInfo":protected]=> string(32) "/photoset/detail/photosetid/123/" ["_params":protected]=> array(4) { ["controller"]=> string(8) "photoset" ["action"]=> string(6) "detail" ["photosetid"]=> string(3) "123" ["module"]=> string(7) "default" } ["_rawBody":protected]=> NULL ["_aliases":protected]=> array(0) { } ["_dispatched":protected]=> bool(true) ["_module":protected]=> string(7) "default" ["_moduleKey":protected]=> string(6) "module" ["_controller":protected]=> string(8) "photoset" ["_controllerKey":protected]=> string(10) "controller" ["_action":protected]=> string(6) "detail" ["_actionKey":protected]=> string(6) "action" } [1]=> object(Zend_Controller_Response_Http)#29 (8) { ["_body":protected]=> array(0) { } ["_exceptions":protected]=> array(0) { } ["_headers":protected]=> array(0) { } ["_headersRaw":protected]=> array(0) { } ["_httpResponseCode":protected]=> int(200) ["_isRedirect":protected]=> bool(false) ["_renderExceptions":protected]=> bool(false) ["headersSentThrowsException"]=> bool(true) } } } [9]=> array(6) { ["file"]=> string(62) "/var/www/Zend/library/Zend/Application/Bootstrap/Bootstrap.php" ["line"]=> int(97) ["function"]=> string(8) "dispatch" ["class"]=> string(21) "Zend_Controller_Front" ["type"]=> string(2) "->" ["args"]=> array(0) { } } [10]=> array(6) { ["file"]=> string(42) "/var/www/Zend/library/Zend/Application.php" ["line"]=> int(366) ["function"]=> string(3) "run" ["class"]=> string(36) "Zend_Application_Bootstrap_Bootstrap" ["type"]=> string(2) "->" ["args"]=> array(0) { } } [11]=> array(6) { ["file"]=> string(18) "/var/www/index.php" ["line"]=> int(73) ["function"]=> string(3) "run" ["class"]=> string(16) "Zend_Application" ["type"]=> string(2) "->" ["args"]=> array(0) { } } } ["previous":"Exception":private]=> NULL ["errorInfo"]=> array(3) { [0]=> string(5) "42000" [1]=> int(1064) [2]=> string(192) "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 'order by publishdate desc, shootingdate desc' at line 4" } } }