| Información técnica |
Tipo de error | 256 |
Descripción del error | Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'userlitdb.registro.fecha' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by |
URL | biblioacceso.unan.edu.ni/estadisticas/Cantidad_de_Consultas_a_bases_de_datos__por_Mes_y_A_o_report.php? |
Archivo de errores | /var/www/html/estadisticas/connections/Connection.php |
Margen de errores | 611 |
Lenguaje de estructural de comunicación | /* anterior select MONTHname(registro.fecha) AS Mes, YEAR(registro.fecha) as `Año`, bdsuscritas.descripcion as bases, count(bdsuscritasid) as Total from registro inner join bdsuscritas on registro.bdsuscritasid = bdsuscritas.id GROUP BY Mes,`Año`,bdsuscritasid order by registro.fecha,bdsuscritasid */ select
MONTHname(registro.fecha) as `Mes`, YEAR(registro.fecha) as `Año`, COUNT(`registro`.`bdsuscritasid`) as `Total`
FROM `registro`
INNER JOIN `usertbl` ON `registro`.`usertblid` = usertbl.id
INNER JOIN `alumnos` ON `usertbl`.`alumnoscarnet` = alumnos.carnet
INNER JOIN `tipo_usuario` ON `alumnos`.`tipousuarioid` = tipo_usuario.id
INNER JOIN `bdsuscritas` ON `registro`.`bdsuscritasid` = bdsuscritas.id GROUP BY `Año`,mes ORDER BY registro.fecha LIMIT 20 OFFSET 0 |
#0. |
connections/Connection.php:611 |
trigger_error |
1. Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'userlitdb.registro.fecha' which is not functionally dependent on columns in GROUP BY clause; this is incom...; 2. 256; |
#1. |
connections/Connection.php:611 |
Connection->triggerError |
1. Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'userlitdb.registro.fecha' which is not functionally dependent on columns in GROUP BY clause; this is incom...; |
#2. |
connections/MySQLiConnection.php:142 |
MySQLiConnection->query |
1. /* anterior select MONTHname(registro.fecha) AS Mes, YEAR(registro.fecha) as `Año`, bdsuscritas.descripcion as bases, count(bdsuscritasid) as Total from registro inner join bdsuscritas on registro...; |
#3. |
classes/reportlib.php:2272 |
ReportLogic->getReport |
1. 0; |
#4. |
classes/reportpage.php:656 |
ReportPage->setStandartData |
1. Array
(
[tName] => Cantidad de Consultas a bases de datos por Mes y Año
[shortTName] => Cantidad_de_Consultas_a_bases_de_datos__por_Mes_y_A_o
[sessionPrefix] => Cantidad de Consultas a b...; |
#5. |
classes/reportpage.php:302 |
ReportPage->setReportData |
1. Array
(
[tName] => Cantidad de Consultas a bases de datos por Mes y Año
[shortTName] => Cantidad_de_Consultas_a_bases_de_datos__por_Mes_y_A_o
[sessionPrefix] => Cantidad de Consultas a b...; |
#6. |
classes/reportpage.php:156 |
ReportPage->process |
N/A |
#7. |
Cantidad_de_Consultas_a_bases_de_datos__por_Mes_y_A_o_report.php:68 |
Global scope |
N/A |