php Error sucedido

Información técnica
Tipo de error256
Descripción del errorExpression #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
URLbiblioacceso.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 errores611
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

More info