Bootstrap trace array(11) {
[0] => array(6) {
["file"] => string(65) "/sites/belarushotels.by/application/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(72) "/sites/belarushotels.by/application/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(76) "/sites/belarushotels.by/application/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(444) "SELECT `h`.*, `t`.*, `hc`.`currency`, `c`.`cityId`, `c`.`cityName`, `c`.`cityPath` FROM `hotels_hotels` AS `h`
LEFT JOIN `site_translates` AS `t` ON t.translateName = h.hotelDescriptionName
LEFT JOIN `hotels_hotel_currency` AS `hc` ON h.hotelId = hc.hotelId
LEFT JOIN `hotels_cities` AS `c` ON h.cityId = c.cityId WHERE (h.hotelPath = 'comfort') AND (h.isActive = 1) AND (t.translateLang = 'it') AND (c.cityPath = 'minsk') GROUP BY `hotelId`"
[1] => array(0) {
}
}
}
[3] => array(6) {
["file"] => string(62) "/sites/belarushotels.by/application/library/Zend/Db/Select.php"
["line"] => int(711)
["function"] => string(5) "query"
["class"] => string(28) "Zend_Db_Adapter_Pdo_Abstract"
["type"] => string(2) "->"
["args"] => array(1) {
[0] => object(Zend_Db_Select)#53 (4) {
["_bind":protected] => array(0) {
}
["_adapter":protected] => object(Zend_Db_Adapter_Pdo_Mysql)#21 (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(8) {
["host"] => string(9) "localhost"
["username"] => string(11) "prod_hotels"
["password"] => string(12) "b8NQw{uVYi{9"
["dbname"] => string(11) "prod_hotels"
["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)#22 (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)#23 (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(6) {
[0] => array(3) {
[0] => string(1) "h"
[1] => string(1) "*"
[2] => NULL
}
[1] => array(3) {
[0] => string(1) "t"
[1] => string(1) "*"
[2] => NULL
}
[2] => array(3) {
[0] => string(2) "hc"
[1] => string(8) "currency"
[2] => NULL
}
[3] => array(3) {
[0] => string(1) "c"
[1] => string(6) "cityId"
[2] => NULL
}
[4] => array(3) {
[0] => string(1) "c"
[1] => string(8) "cityName"
[2] => NULL
}
[5] => array(3) {
[0] => string(1) "c"
[1] => string(8) "cityPath"
[2] => NULL
}
}
["union"] => array(0) {
}
["from"] => array(4) {
["h"] => array(4) {
["joinType"] => string(4) "from"
["schema"] => NULL
["tableName"] => string(13) "hotels_hotels"
["joinCondition"] => NULL
}
["t"] => array(4) {
["joinType"] => string(9) "left join"
["schema"] => NULL
["tableName"] => string(15) "site_translates"
["joinCondition"] => string(40) "t.translateName = h.hotelDescriptionName"
}
["hc"] => array(4) {
["joinType"] => string(9) "left join"
["schema"] => NULL
["tableName"] => string(21) "hotels_hotel_currency"
["joinCondition"] => string(22) "h.hotelId = hc.hotelId"
}
["c"] => array(4) {
["joinType"] => string(9) "left join"
["schema"] => NULL
["tableName"] => string(13) "hotels_cities"
["joinCondition"] => string(19) "h.cityId = c.cityId"
}
}
["where"] => array(4) {
[0] => string(25) "(h.hotelPath = 'comfort')"
[1] => string(20) "AND (h.isActive = 1)"
[2] => string(28) "AND (t.translateLang = 'it')"
[3] => string(26) "AND (c.cityPath = 'minsk')"
}
["group"] => array(1) {
[0] => string(7) "hotelId"
}
["having"] => array(0) {
}
["order"] => array(0) {
}
["limitcount"] => NULL
["limitoffset"] => NULL
["forupdate"] => bool(false)
}
["_tableCols":protected] => array(0) {
}
}
}
}
[4] => array(6) {
["file"] => string(53) "/sites/belarushotels.by/application/models/Hotels.php"
["line"] => int(431)
["function"] => string(5) "query"
["class"] => string(14) "Zend_Db_Select"
["type"] => string(2) "->"
["args"] => array(0) {
}
}
[5] => array(6) {
["file"] => string(80) "/sites/belarushotels.by/application/modules/main/controllers/IndexController.php"
["line"] => int(159)
["function"] => string(32) "getHotelPublicDataWithTranslates"
["class"] => string(6) "Hotels"
["type"] => string(2) "->"
["args"] => array(4) {
[0] => string(9) "hotelPath"
[1] => string(7) "comfort"
[2] => string(2) "it"
[3] => string(5) "minsk"
}
}
[6] => array(6) {
["file"] => string(70) "/sites/belarushotels.by/application/library/Zend/Controller/Action.php"
["line"] => int(516)
["function"] => string(11) "hotelAction"
["class"] => string(15) "IndexController"
["type"] => string(2) "->"
["args"] => array(0) {
}
}
[7] => array(6) {
["file"] => string(83) "/sites/belarushotels.by/application/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(11) "hotelAction"
}
}
[8] => array(6) {
["file"] => string(69) "/sites/belarushotels.by/application/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)#124 (15) {
["_paramSources":protected] => array(2) {
[0] => string(4) "_GET"
[1] => string(5) "_POST"
}
["_requestUri":protected] => string(24) "/it/hotels/minsk/comfort"
["_baseUrl":protected] => string(0) ""
["_basePath":protected] => NULL
["_pathInfo":protected] => string(24) "/it/hotels/minsk/comfort"
["_params":protected] => array(6) {
["lang"] => string(2) "it"
["cityPath"] => string(5) "minsk"
["hotelPath"] => string(7) "comfort"
["module"] => string(4) "main"
["controller"] => string(5) "index"
["action"] => string(5) "hotel"
}
["_rawBody":protected] => NULL
["_aliases":protected] => array(0) {
}
["_dispatched":protected] => bool(true)
["_module":protected] => string(4) "main"
["_moduleKey":protected] => string(6) "module"
["_controller":protected] => string(5) "index"
["_controllerKey":protected] => string(10) "controller"
["_action":protected] => string(5) "hotel"
["_actionKey":protected] => string(6) "action"
}
[1] => object(Zend_Controller_Response_Http)#125 (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(56) "/sites/belarushotels.by/application/system/Bootstrap.php"
["line"] => int(152)
["function"] => string(8) "dispatch"
["class"] => string(21) "Zend_Controller_Front"
["type"] => string(2) "->"
["args"] => array(0) {
}
}
[10] => array(6) {
["file"] => string(33) "/sites/belarushotels.by/index.php"
["line"] => int(17)
["function"] => string(5) "start"
["class"] => string(9) "Bootstrap"
["type"] => string(2) "::"
["args"] => array(0) {
}
}
}
URL: /it/hotels/minsk/comfort
File: /sites/belarushotels.by/application/library/Zend/Db/Statement/Pdo.php
Line: 235
Message: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #72 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'prod_hotels.hc.currency' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by, query was: SELECT `h`.*, `t`.*, `hc`.`currency`, `c`.`cityId`, `c`.`cityName`, `c`.`cityPath` FROM `hotels_hotels` AS `h`
LEFT JOIN `site_translates` AS `t` ON t.translateName = h.hotelDescriptionName
LEFT JOIN `hotels_hotel_currency` AS `hc` ON h.hotelId = hc.hotelId
LEFT JOIN `hotels_cities` AS `c` ON h.cityId = c.cityId WHERE (h.hotelPath = 'comfort') AND (h.isActive = 1) AND (t.translateLang = 'it') AND (c.cityPath = 'minsk') GROUP BY `hotelId`