adorni
Posts: 120
|
| Posted: 01/04/2012, 12:45 PM |
|
I install today Appserver 2.5.10 and i see in my CCS 4.3 applications this:
"Database Error: Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause "
How i can resolve this?
Thanks
|
 |
 |
mor
Posts: 119
|
| Posted: 01/05/2012, 1:25 AM |
|
Maybe you use incorrect SQL query (multiple COUNT()/MIN or MAX without GROUP BY)?
Please post your query here. :)
_________________
Mor ve Ötesi |
|
|
|
adorni
Posts: 120
|
| Posted: 01/05/2012, 4:06 AM |
|
Yes, but in the previous version (XAMPP 1.7.3) all works fine... is possible?
|
|
|
|
mor
Posts: 119
|
| Posted: 01/05/2012, 4:35 AM |
|
Latest XAMPP and Appserver includes different versions of MySQL (5.0.24a and 5.0.51b). You receive error from database about incorrect SQL. Maybe problem in updated MySQL?
1. You can try latest MySQL Server (5.5.19)
2. Use stable XAMPP
3. check SQL query
_________________
Mor ve Ötesi |
|
|
|
adorni
Posts: 120
|
| Posted: 01/05/2012, 2:55 PM |
|
mor, a add the SQL from CCS Visual query:
SELECT Count(Solicitud) AS Puntos_Count, MesComercialMapemfi
FROM scoringdetallado INNER JOIN puntos ON
scoringdetallado.`Lugar de la operacion` = puntos.ID
WHERE puntos.ID <> {Expr0}
AND scoringdetallado.MesComercialMapemfi = {s_MesComercialMapemfi}
ORDER BY `Punto de Venta`
Thanks
PD: i don`t understand nothing about sql :)
|
|
|
|
cleyan
Posts: 136
|
| Posted: 01/23/2012, 1:23 PM |
|
Te falta el group by
prueba con
SELECT Count(Solicitud) AS Puntos_Count, MesComercialMapemfi
FROM scoringdetallado INNER JOIN puntos ON
scoringdetallado.`Lugar de la operacion` = puntos.ID
WHERE puntos.ID <> {Expr0}
AND scoringdetallado.MesComercialMapemfi = {s_MesComercialMapemfi}
GROUP BY MesComercialMapemfi
ORDER BY `Punto de Venta`
Sin contar que no el la mejor idea usar espacios y mayusculas en los nombres de campos
Saludos
Carlos
_________________
**************************************************
Carlos Leyan B.
Temuco, Chile
www.leytec.net |
|
|
|
