php Error sucedido
Información técnica | |
Tipo de error | 256 |
Descripción del error | Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'userlitdb.usertbl.fechainicio' 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/Usuarios_Registrados_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 | SELECT YEAR(fechainicio) as `Año`, MONTHname(fechainicio) as `Mes`, COUNT(`usertbl`.`id`) as `Total` FROM `alumnos` RIGHT OUTER JOIN `usertbl` ON `alumnos`.`carnet` = usertbl.alumnoscarnet GROUP BY 'Año',Mes ORDER BY fechainicio LIMIT 20 OFFSET 0 |