Mian Waqas Posted June 6, 2020 Share Posted June 6, 2020 Hi everyone, i am facing issue when i try to open configurations of a module while in debug mode, you can see the sql error in below screenshot. how ever without the debug mode the module will open but wont show the saved line (in database it exist) and i tried to install the module on fresh prestashop same version where it is working fine. dont know why i am getting this issue, tried everything. uninstalled, cleared caches done everything. thanks in advance Link to comment Share on other sites More sharing options...
JBW Posted June 7, 2020 Share Posted June 7, 2020 There is definitly something wrong with the module as the SQL syntax is invalid. Contaxt tte module developer to fix it. In the meantime you can try to remove the part of the ASC statement from the module file 1 Link to comment Share on other sites More sharing options...
Guest Posted June 8, 2020 Share Posted June 8, 2020 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 ... Link to comment Share on other sites More sharing options...
Mian Waqas Posted June 8, 2020 Author Share Posted June 8, 2020 (edited) 5 hours ago, Guest 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 Edited June 8, 2020 by SMTmardan (see edit history) Link to comment Share on other sites More sharing options...
Mian Waqas Posted June 8, 2020 Author Share Posted June 8, 2020 (edited) 18 hours ago, JBW said: There is definitly something wrong with the module as the SQL syntax is invalid. Contaxt tte module developer to fix it. In the meantime you can try to remove the part of the ASC statement from the module file Just saw your message , yes you are rite if i remove the ASC (not all statement but just the Word ASC ) it will work fine. what will affect if ASC is removed? Thank you Edited June 8, 2020 by SMTmardan (see edit history) Link to comment Share on other sites More sharing options...
Guest Posted June 8, 2020 Share Posted June 8, 2020 In order to solve your problem, I would need to have a module available and check sql queries. Link to comment Share on other sites More sharing options...
Guest Posted June 8, 2020 Share Posted June 8, 2020 ASC = sort A - Z or 1 ..... 10 DESC = sort Z - A or 10 .... 1 Link to comment Share on other sites More sharing options...
Mian Waqas Posted June 8, 2020 Author Share Posted June 8, 2020 57 minutes ago, Guest said: In order to solve your problem, I would need to have a module available and check sql queries. i will sent you the files with queries in private message Link to comment Share on other sites More sharing options...
Guest Posted June 8, 2020 Share Posted June 8, 2020 One moment please, I'll see in an hour. Link to comment Share on other sites More sharing options...
Guest Posted June 8, 2020 Share Posted June 8, 2020 I sent you a fixed module. Link to comment Share on other sites More sharing options...
Mian Waqas Posted June 9, 2020 Author Share Posted June 9, 2020 18 hours ago, Guest said: I sent you a fixed module. Thanks once again, its working good now Link to comment Share on other sites More sharing options...
Guest Posted June 9, 2020 Share Posted June 9, 2020 I gladly helped 😉 Link to comment Share on other sites More sharing options...
.png.022b5452a8f28f552bc9430097a16da2.png)
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now