Hi all,
i have a custom view with this statement:
SELECT Count(tabchiamate.n_chiamata) AS Chiamate, clienti.ragsociale_cliente AS
Cliente
FROM tabchiamate LEFT JOIN
clienti ON tabchiamate.id_cliente = clienti.id_cliente
GROUP BY clienti.ragsociale_cliente
LIMIT 10
When edit the custom view and then execute (F9) the results are correct.
Then i generate all the files.
When, in the website i click on the page customview1 i get this error:
“Failed to execute SQL. Error: Unknown column ‘clienti.ragsociale_cliente’ in ‘group statement’ (1054)”
if i remove the LIMIT statement all run perfectly.
Any help? thanks.