array(6) { ["module"]=> string(11) "Destination" ["controller"]=> string(5) "Beach" ["action"]=> string(8) "showlist" ["id"]=> string(27) "javaScript:showSharedSocM()" ["error_handler"]=> object(ArrayObject)#164 (1) { ["storage":"ArrayObject":private]=> array(3) { ["exception"]=> object(Zend_Db_Statement_Exception)#168 (8) { ["_previous":"Zend_Exception":private]=> NULL ["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 ':showSharedSocM() and Beach.public=1) ORDER BY `rating_all` DESC, `Beach`.`id` A' at line 2" ["string":"Exception":private]=> string(0) "" ["code":protected]=> int(42000) ["file":protected]=> string(88) "/var/www/thailandislandguide.com/thailand-island-guide/library/Zend/Db/Statement/Pdo.php" ["line":protected]=> int(234) ["trace":"Exception":private]=> array(13) { [0]=> array(6) { ["file"]=> string(84) "/var/www/thailandislandguide.com/thailand-island-guide/library/Zend/Db/Statement.php" ["line"]=> int(303) ["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(91) "/var/www/thailandislandguide.com/thailand-island-guide/library/Zend/Db/Adapter/Abstract.php" ["line"]=> int(480) ["function"]=> string(7) "execute" ["class"]=> string(17) "Zend_Db_Statement" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> &array(0) { } } } [2]=> array(6) { ["file"]=> string(95) "/var/www/thailandislandguide.com/thailand-island-guide/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]=> object(Zend_Db_Select)#166 (4) { ["_bind":protected]=> array(0) { } ["_adapter":protected]=> object(Zend_Db_Adapter_Pdo_Mysql)#138 (12) { ["_pdoType":protected]=> string(5) "mysql" ["_numericDataTypes":protected]=> array(16) { [0]=> int(0) [1]=> int(1) [2]=> int(2) ["INT"]=> int(0) ["INTEGER"]=> int(0) ["MEDIUMINT"]=> int(0) ["SMALLINT"]=> int(0) ["TINYINT"]=> int(0) ["BIGINT"]=> int(1) ["SERIAL"]=> int(1) ["DEC"]=> int(2) ["DECIMAL"]=> int(2) ["DOUBLE"]=> int(2) ["DOUBLE PRECISION"]=> int(2) ["FIXED"]=> int(2) ["FLOAT"]=> int(2) } ["_defaultStmtClass":protected]=> string(21) "Zend_Db_Statement_Pdo" ["_config":protected]=> array(9) { ["host"]=> string(14) "159.223.93.117" ["port"]=> string(4) "3306" ["username"]=> string(8) "d0192f2f" ["password"]=> string(8) "be@ch123" ["dbname"]=> string(8) "d0192f2f" ["charset"]=> NULL ["persistent"]=> bool(false) ["options"]=> array(3) { ["caseFolding"]=> int(0) ["autoQuoteIdentifiers"]=> bool(true) ["fetchMode"]=> int(2) } ["driver_options"]=> array(0) { } } ["_fetchMode":protected]=> int(2) ["_profiler":protected]=> object(Zend_Db_Profiler)#139 (4) { ["_queryProfiles":protected]=> array(0) { } ["_enabled":protected]=> bool(false) ["_filterElapsedSecs":protected]=> NULL ["_filterTypes":protected]=> NULL } ["_defaultProfilerClass":protected]=> string(16) "Zend_Db_Profiler" ["_connection":protected]=> object(PDO)#163 (0) { } ["_caseFolding":protected]=> int(0) ["_autoQuoteIdentifiers":protected]=> bool(true) ["_allowSerialization":protected]=> bool(true) ["_autoReconnectOnUnserialize":protected]=> bool(false) } ["_parts":protected]=> array(11) { ["distinct"]=> bool(false) ["columns"]=> array(2) { [0]=> array(3) { [0]=> string(5) "Beach" [1]=> string(1) "*" [2]=> NULL } [1]=> array(3) { [0]=> string(6) "Island" [1]=> string(4) "name" [2]=> string(10) "islandName" } } ["union"]=> array(0) { } ["from"]=> array(2) { ["Beach"]=> array(4) { ["joinType"]=> string(4) "from" ["schema"]=> NULL ["tableName"]=> string(5) "Beach" ["joinCondition"]=> NULL } ["Island"]=> array(4) { ["joinType"]=> string(10) "inner join" ["schema"]=> NULL ["tableName"]=> string(6) "Island" ["joinCondition"]=> string(25) "Island.id=Beach.island_id" } } ["where"]=> array(1) { [0]=> string(58) "(island_id=javaScript:showSharedSocM() and Beach.public=1)" } ["group"]=> array(0) { } ["having"]=> array(0) { } ["order"]=> array(2) { [0]=> array(2) { [0]=> string(10) "rating_all" [1]=> string(4) "DESC" } [1]=> array(2) { [0]=> string(8) "Beach.id" [1]=> string(3) "ASC" } } ["limitcount"]=> int(10) ["limitoffset"]=> int(0) ["forupdate"]=> bool(false) } ["_tableCols":protected]=> array(0) { } } [1]=> &array(0) { } } } [3]=> array(6) { ["file"]=> string(91) "/var/www/thailandislandguide.com/thailand-island-guide/library/Zend/Db/Adapter/Abstract.php" ["line"]=> int(737) ["function"]=> string(5) "query" ["class"]=> string(28) "Zend_Db_Adapter_Pdo_Abstract" ["type"]=> string(2) "->" ["args"]=> array(2) { [0]=> object(Zend_Db_Select)#166 (4) { ["_bind":protected]=> array(0) { } ["_adapter":protected]=> object(Zend_Db_Adapter_Pdo_Mysql)#138 (12) { ["_pdoType":protected]=> string(5) "mysql" ["_numericDataTypes":protected]=> array(16) { [0]=> int(0) [1]=> int(1) [2]=> int(2) ["INT"]=> int(0) ["INTEGER"]=> int(0) ["MEDIUMINT"]=> int(0) ["SMALLINT"]=> int(0) ["TINYINT"]=> int(0) ["BIGINT"]=> int(1) ["SERIAL"]=> int(1) ["DEC"]=> int(2) ["DECIMAL"]=> int(2) ["DOUBLE"]=> int(2) ["DOUBLE PRECISION"]=> int(2) ["FIXED"]=> int(2) ["FLOAT"]=> int(2) } ["_defaultStmtClass":protected]=> string(21) "Zend_Db_Statement_Pdo" ["_config":protected]=> array(9) { ["host"]=> string(14) "159.223.93.117" ["port"]=> string(4) "3306" ["username"]=> string(8) "d0192f2f" ["password"]=> string(8) "be@ch123" ["dbname"]=> string(8) "d0192f2f" ["charset"]=> NULL ["persistent"]=> bool(false) ["options"]=> array(3) { ["caseFolding"]=> int(0) ["autoQuoteIdentifiers"]=> bool(true) ["fetchMode"]=> int(2) } ["driver_options"]=> array(0) { } } ["_fetchMode":protected]=> int(2) ["_profiler":protected]=> object(Zend_Db_Profiler)#139 (4) { ["_queryProfiles":protected]=> array(0) { } ["_enabled":protected]=> bool(false) ["_filterElapsedSecs":protected]=> NULL ["_filterTypes":protected]=> NULL } ["_defaultProfilerClass":protected]=> string(16) "Zend_Db_Profiler" ["_connection":protected]=> object(PDO)#163 (0) { } ["_caseFolding":protected]=> int(0) ["_autoQuoteIdentifiers":protected]=> bool(true) ["_allowSerialization":protected]=> bool(true) ["_autoReconnectOnUnserialize":protected]=> bool(false) } ["_parts":protected]=> array(11) { ["distinct"]=> bool(false) ["columns"]=> array(2) { [0]=> array(3) { [0]=> string(5) "Beach" [1]=> string(1) "*" [2]=> NULL } [1]=> array(3) { [0]=> string(6) "Island" [1]=> string(4) "name" [2]=> string(10) "islandName" } } ["union"]=> array(0) { } ["from"]=> array(2) { ["Beach"]=> array(4) { ["joinType"]=> string(4) "from" ["schema"]=> NULL ["tableName"]=> string(5) "Beach" ["joinCondition"]=> NULL } ["Island"]=> array(4) { ["joinType"]=> string(10) "inner join" ["schema"]=> NULL ["tableName"]=> string(6) "Island" ["joinCondition"]=> string(25) "Island.id=Beach.island_id" } } ["where"]=> array(1) { [0]=> string(58) "(island_id=javaScript:showSharedSocM() and Beach.public=1)" } ["group"]=> array(0) { } ["having"]=> array(0) { } ["order"]=> array(2) { [0]=> array(2) { [0]=> string(10) "rating_all" [1]=> string(4) "DESC" } [1]=> array(2) { [0]=> string(8) "Beach.id" [1]=> string(3) "ASC" } } ["limitcount"]=> int(10) ["limitoffset"]=> int(0) ["forupdate"]=> bool(false) } ["_tableCols":protected]=> array(0) { } } [1]=> &array(0) { } } } [4]=> array(6) { ["file"]=> string(111) "/var/www/thailandislandguide.com/thailand-island-guide/application/modules/Destination/models/mappers/Beach.php" ["line"]=> int(367) ["function"]=> string(8) "fetchAll" ["class"]=> string(24) "Zend_Db_Adapter_Abstract" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> object(Zend_Db_Select)#166 (4) { ["_bind":protected]=> array(0) { } ["_adapter":protected]=> object(Zend_Db_Adapter_Pdo_Mysql)#138 (12) { ["_pdoType":protected]=> string(5) "mysql" ["_numericDataTypes":protected]=> array(16) { [0]=> int(0) [1]=> int(1) [2]=> int(2) ["INT"]=> int(0) ["INTEGER"]=> int(0) ["MEDIUMINT"]=> int(0) ["SMALLINT"]=> int(0) ["TINYINT"]=> int(0) ["BIGINT"]=> int(1) ["SERIAL"]=> int(1) ["DEC"]=> int(2) ["DECIMAL"]=> int(2) ["DOUBLE"]=> int(2) ["DOUBLE PRECISION"]=> int(2) ["FIXED"]=> int(2) ["FLOAT"]=> int(2) } ["_defaultStmtClass":protected]=> string(21) "Zend_Db_Statement_Pdo" ["_config":protected]=> array(9) { ["host"]=> string(14) "159.223.93.117" ["port"]=> string(4) "3306" ["username"]=> string(8) "d0192f2f" ["password"]=> string(8) "be@ch123" ["dbname"]=> string(8) "d0192f2f" ["charset"]=> NULL ["persistent"]=> bool(false) ["options"]=> array(3) { ["caseFolding"]=> int(0) ["autoQuoteIdentifiers"]=> bool(true) ["fetchMode"]=> int(2) } ["driver_options"]=> array(0) { } } ["_fetchMode":protected]=> int(2) ["_profiler":protected]=> object(Zend_Db_Profiler)#139 (4) { ["_queryProfiles":protected]=> array(0) { } ["_enabled":protected]=> bool(false) ["_filterElapsedSecs":protected]=> NULL ["_filterTypes":protected]=> NULL } ["_defaultProfilerClass":protected]=> string(16) "Zend_Db_Profiler" ["_connection":protected]=> object(PDO)#163 (0) { } ["_caseFolding":protected]=> int(0) ["_autoQuoteIdentifiers":protected]=> bool(true) ["_allowSerialization":protected]=> bool(true) ["_autoReconnectOnUnserialize":protected]=> bool(false) } ["_parts":protected]=> array(11) { ["distinct"]=> bool(false) ["columns"]=> array(2) { [0]=> array(3) { [0]=> string(5) "Beach" [1]=> string(1) "*" [2]=> NULL } [1]=> array(3) { [0]=> string(6) "Island" [1]=> string(4) "name" [2]=> string(10) "islandName" } } ["union"]=> array(0) { } ["from"]=> array(2) { ["Beach"]=> array(4) { ["joinType"]=> string(4) "from" ["schema"]=> NULL ["tableName"]=> string(5) "Beach" ["joinCondition"]=> NULL } ["Island"]=> array(4) { ["joinType"]=> string(10) "inner join" ["schema"]=> NULL ["tableName"]=> string(6) "Island" ["joinCondition"]=> string(25) "Island.id=Beach.island_id" } } ["where"]=> array(1) { [0]=> string(58) "(island_id=javaScript:showSharedSocM() and Beach.public=1)" } ["group"]=> array(0) { } ["having"]=> array(0) { } ["order"]=> array(2) { [0]=> array(2) { [0]=> string(10) "rating_all" [1]=> string(4) "DESC" } [1]=> array(2) { [0]=> string(8) "Beach.id" [1]=> string(3) "ASC" } } ["limitcount"]=> int(10) ["limitoffset"]=> int(0) ["forupdate"]=> bool(false) } ["_tableCols":protected]=> array(0) { } } } } [5]=> array(6) { ["file"]=> string(105) "/var/www/thailandislandguide.com/thailand-island-guide/application/modules/Destination/services/Beach.php" ["line"]=> int(104) ["function"]=> string(18) "getBeachByIslandId" ["class"]=> string(30) "Destination_Model_Mapper_Beach" ["type"]=> string(2) "->" ["args"]=> array(5) { [0]=> &string(37) "island_id=javaScript:showSharedSocM()" [1]=> &string(15) "rating_all DESC" [2]=> &int(10) [3]=> &NULL [4]=> &bool(true) } } [6]=> array(6) { ["file"]=> string(118) "/var/www/thailandislandguide.com/thailand-island-guide/application/modules/Destination/controllers/BeachController.php" ["line"]=> int(227) ["function"]=> string(18) "getBeachByIslandId" ["class"]=> string(25) "Destination_Service_Beach" ["type"]=> string(2) "->" ["args"]=> array(5) { [0]=> &string(27) "javaScript:showSharedSocM()" [1]=> &string(6) "rating" [2]=> &int(10) [3]=> &NULL [4]=> &bool(true) } } [7]=> array(6) { ["file"]=> string(89) "/var/www/thailandislandguide.com/thailand-island-guide/library/Zend/Controller/Action.php" ["line"]=> int(516) ["function"]=> string(14) "showlistAction" ["class"]=> string(27) "Destination_BeachController" ["type"]=> string(2) "->" ["args"]=> array(0) { } } [8]=> array(6) { ["file"]=> string(102) "/var/www/thailandislandguide.com/thailand-island-guide/library/Zend/Controller/Dispatcher/Standard.php" ["line"]=> int(308) ["function"]=> string(8) "dispatch" ["class"]=> string(22) "Zend_Controller_Action" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> &string(14) "showlistAction" } } [9]=> array(6) { ["file"]=> string(88) "/var/www/thailandislandguide.com/thailand-island-guide/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)#141 (15) { ["_paramSources":protected]=> array(2) { [0]=> string(4) "_GET" [1]=> string(5) "_POST" } ["_requestUri":protected]=> string(58) "/Destination/Beach/showlist/id/javaScript:showSharedSocM()" ["_baseUrl":protected]=> string(0) "" ["_basePath":protected]=> NULL ["_pathInfo":protected]=> string(58) "/Destination/Beach/showlist/id/javaScript:showSharedSocM()" ["_params":protected]=> array(5) { ["module"]=> string(11) "Destination" ["controller"]=> string(5) "Beach" ["action"]=> string(8) "showlist" ["id"]=> string(27) "javaScript:showSharedSocM()" ["error_handler"]=> *RECURSION* } ["_rawBody":protected]=> NULL ["_aliases":protected]=> array(0) { } ["_dispatched":protected]=> bool(true) ["_module":protected]=> string(7) "default" ["_moduleKey":protected]=> string(6) "module" ["_controller":protected]=> string(5) "error" ["_controllerKey":protected]=> string(10) "controller" ["_action":protected]=> string(5) "error" ["_actionKey":protected]=> string(6) "action" } [1]=> object(Zend_Controller_Response_Http)#142 (8) { ["_body":protected]=> array(0) { } ["_exceptions":protected]=> array(1) { [0]=> *RECURSION* } ["_headers":protected]=> array(0) { } ["_headersRaw":protected]=> array(0) { } ["_httpResponseCode":protected]=> int(200) ["_isRedirect":protected]=> bool(false) ["_renderExceptions":protected]=> bool(false) ["headersSentThrowsException"]=> bool(true) } } } [10]=> array(6) { ["file"]=> string(103) "/var/www/thailandislandguide.com/thailand-island-guide/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) { } } [11]=> array(6) { ["file"]=> string(83) "/var/www/thailandislandguide.com/thailand-island-guide/library/Zend/Application.php" ["line"]=> int(366) ["function"]=> string(3) "run" ["class"]=> string(36) "Zend_Application_Bootstrap_Bootstrap" ["type"]=> string(2) "->" ["args"]=> array(0) { } } [12]=> array(6) { ["file"]=> string(71) "/var/www/thailandislandguide.com/thailand-island-guide/public/index.php" ["line"]=> int(36) ["function"]=> string(3) "run" ["class"]=> string(16) "Zend_Application" ["type"]=> string(2) "->" ["args"]=> array(0) { } } } ["previous":"Exception":private]=> object(PDOException)#167 (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 ':showSharedSocM() and Beach.public=1) ORDER BY `rating_all` DESC, `Beach`.`id` A' at line 2" ["string":"Exception":private]=> string(0) "" ["code":protected]=> string(5) "42000" ["file":protected]=> string(88) "/var/www/thailandislandguide.com/thailand-island-guide/library/Zend/Db/Statement/Pdo.php" ["line":protected]=> int(228) ["trace":"Exception":private]=> array(14) { [0]=> array(6) { ["file"]=> string(88) "/var/www/thailandislandguide.com/thailand-island-guide/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(84) "/var/www/thailandislandguide.com/thailand-island-guide/library/Zend/Db/Statement.php" ["line"]=> int(303) ["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(91) "/var/www/thailandislandguide.com/thailand-island-guide/library/Zend/Db/Adapter/Abstract.php" ["line"]=> int(480) ["function"]=> string(7) "execute" ["class"]=> string(17) "Zend_Db_Statement" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> &array(0) { } } } [3]=> array(6) { ["file"]=> string(95) "/var/www/thailandislandguide.com/thailand-island-guide/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]=> object(Zend_Db_Select)#166 (4) { ["_bind":protected]=> array(0) { } ["_adapter":protected]=> object(Zend_Db_Adapter_Pdo_Mysql)#138 (12) { ["_pdoType":protected]=> string(5) "mysql" ["_numericDataTypes":protected]=> array(16) { [0]=> int(0) [1]=> int(1) [2]=> int(2) ["INT"]=> int(0) ["INTEGER"]=> int(0) ["MEDIUMINT"]=> int(0) ["SMALLINT"]=> int(0) ["TINYINT"]=> int(0) ["BIGINT"]=> int(1) ["SERIAL"]=> int(1) ["DEC"]=> int(2) ["DECIMAL"]=> int(2) ["DOUBLE"]=> int(2) ["DOUBLE PRECISION"]=> int(2) ["FIXED"]=> int(2) ["FLOAT"]=> int(2) } ["_defaultStmtClass":protected]=> string(21) "Zend_Db_Statement_Pdo" ["_config":protected]=> array(9) { ["host"]=> string(14) "159.223.93.117" ["port"]=> string(4) "3306" ["username"]=> string(8) "d0192f2f" ["password"]=> string(8) "be@ch123" ["dbname"]=> string(8) "d0192f2f" ["charset"]=> NULL ["persistent"]=> bool(false) ["options"]=> array(3) { ["caseFolding"]=> int(0) ["autoQuoteIdentifiers"]=> bool(true) ["fetchMode"]=> int(2) } ["driver_options"]=> array(0) { } } ["_fetchMode":protected]=> int(2) ["_profiler":protected]=> object(Zend_Db_Profiler)#139 (4) { ["_queryProfiles":protected]=> array(0) { } ["_enabled":protected]=> bool(false) ["_filterElapsedSecs":protected]=> NULL ["_filterTypes":protected]=> NULL } ["_defaultProfilerClass":protected]=> string(16) "Zend_Db_Profiler" ["_connection":protected]=> object(PDO)#163 (0) { } ["_caseFolding":protected]=> int(0) ["_autoQuoteIdentifiers":protected]=> bool(true) ["_allowSerialization":protected]=> bool(true) ["_autoReconnectOnUnserialize":protected]=> bool(false) } ["_parts":protected]=> array(11) { ["distinct"]=> bool(false) ["columns"]=> array(2) { [0]=> array(3) { [0]=> string(5) "Beach" [1]=> string(1) "*" [2]=> NULL } [1]=> array(3) { [0]=> string(6) "Island" [1]=> string(4) "name" [2]=> string(10) "islandName" } } ["union"]=> array(0) { } ["from"]=> array(2) { ["Beach"]=> array(4) { ["joinType"]=> string(4) "from" ["schema"]=> NULL ["tableName"]=> string(5) "Beach" ["joinCondition"]=> NULL } ["Island"]=> array(4) { ["joinType"]=> string(10) "inner join" ["schema"]=> NULL ["tableName"]=> string(6) "Island" ["joinCondition"]=> string(25) "Island.id=Beach.island_id" } } ["where"]=> array(1) { [0]=> string(58) "(island_id=javaScript:showSharedSocM() and Beach.public=1)" } ["group"]=> array(0) { } ["having"]=> array(0) { } ["order"]=> array(2) { [0]=> array(2) { [0]=> string(10) "rating_all" [1]=> string(4) "DESC" } [1]=> array(2) { [0]=> string(8) "Beach.id" [1]=> string(3) "ASC" } } ["limitcount"]=> int(10) ["limitoffset"]=> int(0) ["forupdate"]=> bool(false) } ["_tableCols":protected]=> array(0) { } } [1]=> &array(0) { } } } [4]=> array(6) { ["file"]=> string(91) "/var/www/thailandislandguide.com/thailand-island-guide/library/Zend/Db/Adapter/Abstract.php" ["line"]=> int(737) ["function"]=> string(5) "query" ["class"]=> string(28) "Zend_Db_Adapter_Pdo_Abstract" ["type"]=> string(2) "->" ["args"]=> array(2) { [0]=> object(Zend_Db_Select)#166 (4) { ["_bind":protected]=> array(0) { } ["_adapter":protected]=> object(Zend_Db_Adapter_Pdo_Mysql)#138 (12) { ["_pdoType":protected]=> string(5) "mysql" ["_numericDataTypes":protected]=> array(16) { [0]=> int(0) [1]=> int(1) [2]=> int(2) ["INT"]=> int(0) ["INTEGER"]=> int(0) ["MEDIUMINT"]=> int(0) ["SMALLINT"]=> int(0) ["TINYINT"]=> int(0) ["BIGINT"]=> int(1) ["SERIAL"]=> int(1) ["DEC"]=> int(2) ["DECIMAL"]=> int(2) ["DOUBLE"]=> int(2) ["DOUBLE PRECISION"]=> int(2) ["FIXED"]=> int(2) ["FLOAT"]=> int(2) } ["_defaultStmtClass":protected]=> string(21) "Zend_Db_Statement_Pdo" ["_config":protected]=> array(9) { ["host"]=> string(14) "159.223.93.117" ["port"]=> string(4) "3306" ["username"]=> string(8) "d0192f2f" ["password"]=> string(8) "be@ch123" ["dbname"]=> string(8) "d0192f2f" ["charset"]=> NULL ["persistent"]=> bool(false) ["options"]=> array(3) { ["caseFolding"]=> int(0) ["autoQuoteIdentifiers"]=> bool(true) ["fetchMode"]=> int(2) } ["driver_options"]=> array(0) { } } ["_fetchMode":protected]=> int(2) ["_profiler":protected]=> object(Zend_Db_Profiler)#139 (4) { ["_queryProfiles":protected]=> array(0) { } ["_enabled":protected]=> bool(false) ["_filterElapsedSecs":protected]=> NULL ["_filterTypes":protected]=> NULL } ["_defaultProfilerClass":protected]=> string(16) "Zend_Db_Profiler" ["_connection":protected]=> object(PDO)#163 (0) { } ["_caseFolding":protected]=> int(0) ["_autoQuoteIdentifiers":protected]=> bool(true) ["_allowSerialization":protected]=> bool(true) ["_autoReconnectOnUnserialize":protected]=> bool(false) } ["_parts":protected]=> array(11) { ["distinct"]=> bool(false) ["columns"]=> array(2) { [0]=> array(3) { [0]=> string(5) "Beach" [1]=> string(1) "*" [2]=> NULL } [1]=> array(3) { [0]=> string(6) "Island" [1]=> string(4) "name" [2]=> string(10) "islandName" } } ["union"]=> array(0) { } ["from"]=> array(2) { ["Beach"]=> array(4) { ["joinType"]=> string(4) "from" ["schema"]=> NULL ["tableName"]=> string(5) "Beach" ["joinCondition"]=> NULL } ["Island"]=> array(4) { ["joinType"]=> string(10) "inner join" ["schema"]=> NULL ["tableName"]=> string(6) "Island" ["joinCondition"]=> string(25) "Island.id=Beach.island_id" } } ["where"]=> array(1) { [0]=> string(58) "(island_id=javaScript:showSharedSocM() and Beach.public=1)" } ["group"]=> array(0) { } ["having"]=> array(0) { } ["order"]=> array(2) { [0]=> array(2) { [0]=> string(10) "rating_all" [1]=> string(4) "DESC" } [1]=> array(2) { [0]=> string(8) "Beach.id" [1]=> string(3) "ASC" } } ["limitcount"]=> int(10) ["limitoffset"]=> int(0) ["forupdate"]=> bool(false) } ["_tableCols":protected]=> array(0) { } } [1]=> &array(0) { } } } [5]=> array(6) { ["file"]=> string(111) "/var/www/thailandislandguide.com/thailand-island-guide/application/modules/Destination/models/mappers/Beach.php" ["line"]=> int(367) ["function"]=> string(8) "fetchAll" ["class"]=> string(24) "Zend_Db_Adapter_Abstract" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> object(Zend_Db_Select)#166 (4) { ["_bind":protected]=> array(0) { } ["_adapter":protected]=> object(Zend_Db_Adapter_Pdo_Mysql)#138 (12) { ["_pdoType":protected]=> string(5) "mysql" ["_numericDataTypes":protected]=> array(16) { [0]=> int(0) [1]=> int(1) [2]=> int(2) ["INT"]=> int(0) ["INTEGER"]=> int(0) ["MEDIUMINT"]=> int(0) ["SMALLINT"]=> int(0) ["TINYINT"]=> int(0) ["BIGINT"]=> int(1) ["SERIAL"]=> int(1) ["DEC"]=> int(2) ["DECIMAL"]=> int(2) ["DOUBLE"]=> int(2) ["DOUBLE PRECISION"]=> int(2) ["FIXED"]=> int(2) ["FLOAT"]=> int(2) } ["_defaultStmtClass":protected]=> string(21) "Zend_Db_Statement_Pdo" ["_config":protected]=> array(9) { ["host"]=> string(14) "159.223.93.117" ["port"]=> string(4) "3306" ["username"]=> string(8) "d0192f2f" ["password"]=> string(8) "be@ch123" ["dbname"]=> string(8) "d0192f2f" ["charset"]=> NULL ["persistent"]=> bool(false) ["options"]=> array(3) { ["caseFolding"]=> int(0) ["autoQuoteIdentifiers"]=> bool(true) ["fetchMode"]=> int(2) } ["driver_options"]=> array(0) { } } ["_fetchMode":protected]=> int(2) ["_profiler":protected]=> object(Zend_Db_Profiler)#139 (4) { ["_queryProfiles":protected]=> array(0) { } ["_enabled":protected]=> bool(false) ["_filterElapsedSecs":protected]=> NULL ["_filterTypes":protected]=> NULL } ["_defaultProfilerClass":protected]=> string(16) "Zend_Db_Profiler" ["_connection":protected]=> object(PDO)#163 (0) { } ["_caseFolding":protected]=> int(0) ["_autoQuoteIdentifiers":protected]=> bool(true) ["_allowSerialization":protected]=> bool(true) ["_autoReconnectOnUnserialize":protected]=> bool(false) } ["_parts":protected]=> array(11) { ["distinct"]=> bool(false) ["columns"]=> array(2) { [0]=> array(3) { [0]=> string(5) "Beach" [1]=> string(1) "*" [2]=> NULL } [1]=> array(3) { [0]=> string(6) "Island" [1]=> string(4) "name" [2]=> string(10) "islandName" } } ["union"]=> array(0) { } ["from"]=> array(2) { ["Beach"]=> array(4) { ["joinType"]=> string(4) "from" ["schema"]=> NULL ["tableName"]=> string(5) "Beach" ["joinCondition"]=> NULL } ["Island"]=> array(4) { ["joinType"]=> string(10) "inner join" ["schema"]=> NULL ["tableName"]=> string(6) "Island" ["joinCondition"]=> string(25) "Island.id=Beach.island_id" } } ["where"]=> array(1) { [0]=> string(58) "(island_id=javaScript:showSharedSocM() and Beach.public=1)" } ["group"]=> array(0) { } ["having"]=> array(0) { } ["order"]=> array(2) { [0]=> array(2) { [0]=> string(10) "rating_all" [1]=> string(4) "DESC" } [1]=> array(2) { [0]=> string(8) "Beach.id" [1]=> string(3) "ASC" } } ["limitcount"]=> int(10) ["limitoffset"]=> int(0) ["forupdate"]=> bool(false) } ["_tableCols":protected]=> array(0) { } } } } [6]=> array(6) { ["file"]=> string(105) "/var/www/thailandislandguide.com/thailand-island-guide/application/modules/Destination/services/Beach.php" ["line"]=> int(104) ["function"]=> string(18) "getBeachByIslandId" ["class"]=> string(30) "Destination_Model_Mapper_Beach" ["type"]=> string(2) "->" ["args"]=> array(5) { [0]=> &string(37) "island_id=javaScript:showSharedSocM()" [1]=> &string(15) "rating_all DESC" [2]=> &int(10) [3]=> &NULL [4]=> &bool(true) } } [7]=> array(6) { ["file"]=> string(118) "/var/www/thailandislandguide.com/thailand-island-guide/application/modules/Destination/controllers/BeachController.php" ["line"]=> int(227) ["function"]=> string(18) "getBeachByIslandId" ["class"]=> string(25) "Destination_Service_Beach" ["type"]=> string(2) "->" ["args"]=> array(5) { [0]=> &string(27) "javaScript:showSharedSocM()" [1]=> &string(6) "rating" [2]=> &int(10) [3]=> &NULL [4]=> &bool(true) } } [8]=> array(6) { ["file"]=> string(89) "/var/www/thailandislandguide.com/thailand-island-guide/library/Zend/Controller/Action.php" ["line"]=> int(516) ["function"]=> string(14) "showlistAction" ["class"]=> string(27) "Destination_BeachController" ["type"]=> string(2) "->" ["args"]=> array(0) { } } [9]=> array(6) { ["file"]=> string(102) "/var/www/thailandislandguide.com/thailand-island-guide/library/Zend/Controller/Dispatcher/Standard.php" ["line"]=> int(308) ["function"]=> string(8) "dispatch" ["class"]=> string(22) "Zend_Controller_Action" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> &string(14) "showlistAction" } } [10]=> array(6) { ["file"]=> string(88) "/var/www/thailandislandguide.com/thailand-island-guide/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)#141 (15) { ["_paramSources":protected]=> array(2) { [0]=> string(4) "_GET" [1]=> string(5) "_POST" } ["_requestUri":protected]=> string(58) "/Destination/Beach/showlist/id/javaScript:showSharedSocM()" ["_baseUrl":protected]=> string(0) "" ["_basePath":protected]=> NULL ["_pathInfo":protected]=> string(58) "/Destination/Beach/showlist/id/javaScript:showSharedSocM()" ["_params":protected]=> array(5) { ["module"]=> string(11) "Destination" ["controller"]=> string(5) "Beach" ["action"]=> string(8) "showlist" ["id"]=> string(27) "javaScript:showSharedSocM()" ["error_handler"]=> *RECURSION* } ["_rawBody":protected]=> NULL ["_aliases":protected]=> array(0) { } ["_dispatched":protected]=> bool(true) ["_module":protected]=> string(7) "default" ["_moduleKey":protected]=> string(6) "module" ["_controller":protected]=> string(5) "error" ["_controllerKey":protected]=> string(10) "controller" ["_action":protected]=> string(5) "error" ["_actionKey":protected]=> string(6) "action" } [1]=> object(Zend_Controller_Response_Http)#142 (8) { ["_body":protected]=> array(0) { } ["_exceptions":protected]=> array(1) { [0]=> *RECURSION* } ["_headers":protected]=> array(0) { } ["_headersRaw":protected]=> array(0) { } ["_httpResponseCode":protected]=> int(200) ["_isRedirect":protected]=> bool(false) ["_renderExceptions":protected]=> bool(false) ["headersSentThrowsException"]=> bool(true) } } } [11]=> array(6) { ["file"]=> string(103) "/var/www/thailandislandguide.com/thailand-island-guide/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) { } } [12]=> array(6) { ["file"]=> string(83) "/var/www/thailandislandguide.com/thailand-island-guide/library/Zend/Application.php" ["line"]=> int(366) ["function"]=> string(3) "run" ["class"]=> string(36) "Zend_Application_Bootstrap_Bootstrap" ["type"]=> string(2) "->" ["args"]=> array(0) { } } [13]=> array(6) { ["file"]=> string(71) "/var/www/thailandislandguide.com/thailand-island-guide/public/index.php" ["line"]=> int(36) ["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(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 ':showSharedSocM() and Beach.public=1) ORDER BY `rating_all` DESC, `Beach`.`id` A' at line 2" } } } ["type"]=> string(15) "EXCEPTION_OTHER" ["request"]=> object(Zend_Controller_Request_Http)#165 (15) { ["_paramSources":protected]=> array(2) { [0]=> string(4) "_GET" [1]=> string(5) "_POST" } ["_requestUri":protected]=> string(58) "/Destination/Beach/showlist/id/javaScript:showSharedSocM()" ["_baseUrl":protected]=> string(0) "" ["_basePath":protected]=> NULL ["_pathInfo":protected]=> string(58) "/Destination/Beach/showlist/id/javaScript:showSharedSocM()" ["_params":protected]=> array(4) { ["module"]=> string(11) "Destination" ["controller"]=> string(5) "Beach" ["action"]=> string(8) "showlist" ["id"]=> string(27) "javaScript:showSharedSocM()" } ["_rawBody":protected]=> NULL ["_aliases":protected]=> array(0) { } ["_dispatched":protected]=> bool(true) ["_module":protected]=> string(11) "Destination" ["_moduleKey":protected]=> string(6) "module" ["_controller":protected]=> string(5) "Beach" ["_controllerKey":protected]=> string(10) "controller" ["_action":protected]=> string(8) "showlist" ["_actionKey":protected]=> string(6) "action" } } } ["q"]=> string(58) "/Destination/Beach/showlist/id/javaScript:showSharedSocM()" }