Edit History

5 hours ago, D. Tengler said:

It is necessary to correct the sql query in the module.
GROUP BY ... ASC will not work.
Need to change to ORDER BY ... ASC.

Or put ORDER BY ... ASC before GROUP BY ...

 

thanks for your reply,will try that, however if i remove "ASC" from the query. it still working, just want to know if removing ASC will affect anything?

just for information , the issue is with  mySQL version 8.0 only , on mySQL version 5.0 it does not give any error. 

thanks again

5 hours ago, D. Tengler said:

It is necessary to correct the sql query in the module.
GROUP BY ... ASC will not work.
Need to change to ORDER BY ... ASC.

Or put ORDER BY ... ASC before GROUP BY ...

 

thanks for your reply,will try that, however if i remove "ASC" from the query. it still working, just want to know if removing ASC will affect anything?

thanks again