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(421) "SELECT `h`.*, `c`.`cityName`, `c`.`cityPath`, `r`.`regionId`, `r`.`regionName`, `g`.* FROM `hotels_hotels` AS `h`
LEFT JOIN `hotels_cities` AS `c` ON h.cityId = c.cityId
LEFT JOIN `hotels_regions` AS `r` ON c.regionId = r.regionId
LEFT JOIN `hotels_gallery_files` AS `g` ON h.galleryId = g.galleryId WHERE (c.cityId = (20)) AND (h.mapLatitudes != '') AND (h.mapLongitudes != '') AND (h.isActive = 1) 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)#54 (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) "c"
[1] => string(8) "cityName"
[2] => NULL
}
[2] => array(3) {
[0] => string(1) "c"
[1] => string(8) "cityPath"
[2] => NULL
}
[3] => array(3) {
[0] => string(1) "r"
[1] => string(8) "regionId"
[2] => NULL
}
[4] => array(3) {
[0] => string(1) "r"
[1] => string(10) "regionName"
[2] => NULL
}
[5] => array(3) {
[0] => string(1) "g"
[1] => string(1) "*"
[2] => NULL
}
}
["union"] => array(0) {
}
["from"] => array(4) {
["h"] => array(4) {
["joinType"] => string(4) "from"
["schema"] => NULL
["tableName"] => string(13) "hotels_hotels"
["joinCondition"] => NULL
}
["c"] => array(4) {
["joinType"] => string(9) "left join"
["schema"] => NULL
["tableName"] => string(13) "hotels_cities"
["joinCondition"] => string(19) "h.cityId = c.cityId"
}
["r"] => array(4) {
["joinType"] => string(9) "left join"
["schema"] => NULL
["tableName"] => string(14) "hotels_regions"
["joinCondition"] => string(23) "c.regionId = r.regionId"
}
["g"] => array(4) {
["joinType"] => string(9) "left join"
["schema"] => NULL
["tableName"] => string(20) "hotels_gallery_files"
["joinCondition"] => string(25) "h.galleryId = g.galleryId"
}
}
["where"] => array(4) {
[0] => string(17) "(c.cityId = (20))"
[1] => string(26) "AND (h.mapLatitudes != '')"
[2] => string(27) "AND (h.mapLongitudes != '')"
[3] => string(20) "AND (h.isActive = 1)"
}
["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(239)
["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(917)
["function"] => string(16) "getHotelsMapCity"
["class"] => string(6) "Hotels"
["type"] => string(2) "->"
["args"] => array(3) {
[0] => string(2) "20"
[1] => int(0)
[2] => array(0) {
}
}
}
[6] => array(6) {
["file"] => string(70) "/sites/belarushotels.by/application/library/Zend/Controller/Action.php"
["line"] => int(516)
["function"] => string(24) "hotelsAllGoogleMapAction"
["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(24) "hotelsAllGoogleMapAction"
}
}
[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(18) "/es/map/city/orsha"
["_baseUrl":protected] => string(0) ""
["_basePath":protected] => NULL
["_pathInfo":protected] => string(18) "/es/map/city/orsha"
["_params":protected] => array(5) {
["lang"] => string(2) "es"
["cityId"] => string(5) "orsha"
["module"] => string(4) "main"
["controller"] => string(5) "index"
["action"] => string(21) "hotels-all-google-map"
}
["_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(21) "hotels-all-google-map"
["_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: /es/map/city/orsha
File: /sites/belarushotels.by/application/library/Zend/Db/Statement/Pdo.php
Line: 235
Message: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #71 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'prod_hotels.g.fileId' 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`.*, `c`.`cityName`, `c`.`cityPath`, `r`.`regionId`, `r`.`regionName`, `g`.* FROM `hotels_hotels` AS `h`
LEFT JOIN `hotels_cities` AS `c` ON h.cityId = c.cityId
LEFT JOIN `hotels_regions` AS `r` ON c.regionId = r.regionId
LEFT JOIN `hotels_gallery_files` AS `g` ON h.galleryId = g.galleryId WHERE (c.cityId = (20)) AND (h.mapLatitudes != '') AND (h.mapLongitudes != '') AND (h.isActive = 1) GROUP BY `hotelId`