Warning (512): SQL Error: 1140: Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause [CORE/cake/libs/model/datasources/dbo_source.php, line 681]
$this = dbomysql
dbomysql::$connected = true
dbomysql::$fullDebug = true
dbomysql::$error = "1140: Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause"
dbomysql::$affected = NULL
dbomysql::$numRows = NULL
dbomysql::$took = 1
dbomysql::$startQuote = "`"
dbomysql::$endQuote = "`"
dbomysql::$_result = false
dbomysql::$_queriesCnt = 9
dbomysql::$_queriesTime = 14
dbomysql::$_queriesLog = array
dbomysql::$_queriesLogMax = 200
dbomysql::$_queryCache = array
dbomysql::$_baseConfig = array
dbomysql::$__descriptions = array
dbomysql::$_sources = array
dbomysql::$connection = resource
dbomysql::$config = array
dbomysql::$configKeyName = "default"
dbomysql::$_transactionStarted = false
dbomysql::$cacheSources = true
dbomysql::$description = "MySQL DBO Driver"
dbomysql::$index = array
dbomysql::$alias = "AS "
dbomysql::$methodCache = array
dbomysql::$cacheMethods = true
dbomysql::$__bypass = true
dbomysql::$__sqlOps = array
dbomysql::$_commands = array
dbomysql::$virtualFieldSeparator = "__"
dbomysql::$tableParameters = array
dbomysql::$fieldParameters = array
dbomysql::$_useAlias = true
dbomysql::$columns = array
dbomysql::$results = false
dbomysql::$map = array
dbomysql::$__booleans = array
$sql = "SELECT Seccione.nombre,Seccione.id,Count(`Seccione`.`id`) as NoEmpresas FROM `empresas_secciones` AS `EmpresasSeccione` LEFT JOIN `empresas` AS `Empresa` ON (`EmpresasSeccione`.`empresa_id` = `Empresa`.`id`) LEFT JOIN `secciones` AS `Seccione` ON (`EmpresasSeccione`.`seccione_id` = `Seccione`.`id`) WHERE (`Empresa`.`departamento_id` = 10) and (`Empresa`.`aprobado` <> 0 ) ORDER BY `Seccione`.`nombre` asc LIMIT 10"
$error = "1140: Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause"
$out = null
dbomysql::showquery() - CORE/cake/libs/model/datasources/dbo_source.php, line 681
dbomysql::execute() - CORE/cake/libs/model/datasources/dbo_source.php, line 266
dbomysql::fetchall() - CORE/cake/libs/model/datasources/dbo_source.php, line 410
dbomysql::read() - CORE/cake/libs/model/datasources/dbo_source.php, line 820
empresasseccione::find() - CORE/cake/libs/model/model.php, line 2093
seccionescontroller::paginate() - CORE/cake/libs/controller/controller.php, line 1228
seccionescontroller::departamental() - APP/controllers/secciones_controller.php, line 40
dispatcher::_invoke() - CORE/cake/dispatcher.php, line 204
dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
[main] - APP/webroot/index.php, line 83
Query: SELECT Seccione.nombre,Seccione.id,Count(`Seccione`.`id`) as NoEmpresas FROM `empresas_secciones` AS `EmpresasSeccione` LEFT JOIN `empresas` AS `Empresa` ON (`EmpresasSeccione`.`empresa_id` = `Empresa`.`id`) LEFT JOIN `secciones` AS `Seccione` ON (`EmpresasSeccione`.`seccione_id` = `Seccione`.`id`) WHERE (`Empresa`.`departamento_id` = 10) and (`Empresa`.`aprobado` <> 0 ) ORDER BY `Seccione`.`nombre` asc LIMIT 10
Secciones - GuiaXW.com por XelaWeb, la guia de empresas de Guatemala
unknown - [internal], line ??
include - APP/views/secciones/departamental.ctp, line 18
view::_render() - CORE/cake/libs/view/view.php, line 723
view::render() - CORE/cake/libs/view/view.php, line 419
seccionescontroller::render() - CORE/cake/libs/controller/controller.php, line 913
dispatcher::_invoke() - CORE/cake/dispatcher.php, line 207
dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
[main] - APP/webroot/index.php, line 83
<< Atras | Adelante >>
(default) 9 queries took 14 ms
Nr
Query
Error
Affected
Num. rows
Took (ms)
1
DESCRIBE `secciones`
4
4
1
2
DESCRIBE `empresas`
16
16
2
3
DESCRIBE `usuarios`
16
16
3
4
DESCRIBE `departamentos`
4
4
1
5
DESCRIBE `municipios`
5
5
1
6
DESCRIBE `empresas_secciones`
3
3
1
7
SELECT `Departamento`.`id`, `Departamento`.`departamento`, `Departamento`.`created`, `Departamento`.`modified` FROM `departamentos` AS `Departamento` WHERE `Departamento`.`id` = 10 LIMIT 1
1
1
1
8
SELECT COUNT(*) AS `count` FROM `empresas_secciones` AS `EmpresasSeccione` LEFT JOIN `empresas` AS `Empresa` ON (`EmpresasSeccione`.`empresa_id` = `Empresa`.`id`) LEFT JOIN `secciones` AS `Seccione` ON (`EmpresasSeccione`.`seccione_id` = `Seccione`.`id`) WHERE (`Empresa`.`departamento_id` = 10) and (`Empresa`.`aprobado` <> 0 ) ORDER BY `Seccione`.`nombre` asc
1
1
3
9
SELECT Seccione.nombre,Seccione.id,Count(`Seccione`.`id`) as NoEmpresas FROM `empresas_secciones` AS `EmpresasSeccione` LEFT JOIN `empresas` AS `Empresa` ON (`EmpresasSeccione`.`empresa_id` = `Empresa`.`id`) LEFT JOIN `secciones` AS `Seccione` ON (`EmpresasSeccione`.`seccione_id` = `Seccione`.`id`) WHERE (`Empresa`.`departamento_id` = 10) and (`Empresa`.`aprobado` <> 0 ) ORDER BY `Seccione`.`nombre` asc LIMIT 10
1140: Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause