Hi All,
I have updated my version to 9.2 and now having some issues. Whenever try to run grid applications with bit more complex SQL query (with multiple joins and sub-selects) it gives an error as per below;
1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘)’ at line 1
ADOConnection._Execute(select count(*), sum(tot1_hrs), sum(tot2_hrs), sum(tot3_hrs), sum(tot1_amnt), sum(tot2_amnt), sum(tot3_amnt), ..., false) % line 1149, file: adodb.inc.php
ADOConnection.Execute(select count(*), sum(tot1_hrs), sum(tot2_hrs), sum(tot3_hrs), sum(tot1_amnt), sum(tot2_amnt), sum(tot3_amnt), ...) % line 70, file: grid_Hrs_Daily_Smry_total.class.php
grid_Hrs_Daily_Smry_total.quebra_geral_sc_free_group_by() % line 800, file: grid_Hrs_Daily_Smry_grid.class.php
grid_Hrs_Daily_Smry_grid.inicializa() % line 160, file: grid_Hrs_Daily_Smry_grid.class.php
grid_Hrs_Daily_Smry_grid.monta_grid(0) % line 2524, file: grid_Hrs_Daily_Smry.php
All the applications were working fine before the upgrade. The Basic grid apps with simple SQL are also working fine in 9.2.
Also when I paste the same SQL statement into ‘Run’ tab section inside SQL builder then it runs fine.
What can cause an issue like this?
Is there any easier way to go back to 9.1?
Thank you for your help and time