prodigieux Posted May 25, 2013 Share Posted May 25, 2013 (edited) When accessing the Currency screen I now get this error: "Bad SQL query Column 'conversion_rate' in order clause is ambiguous" instead of seeing the currencies listed. (Originally I had CAD and US currencies.) Not sure exactly what I did, but what I remember is having updated successfully the currency rate by clicking on "update currency rates" and after that I tried to change the order of the currencies, and started to received this error. Now I can't see the currencies anymore. Does anybody has an idea about what I could do to fix that ? (I attached a screenshot of the page and of the data contained in the DB for the currency table.) Thank you! Jean-Francois Lessard Edited May 25, 2013 by prodigieux (see edit history) Link to comment Share on other sites More sharing options...
prodigieux Posted May 25, 2013 Author Share Posted May 25, 2013 (edited) Forgot to mention that I'm using PrestaShop™ 1.5.4.1 Edited May 25, 2013 by prodigieux (see edit history) Link to comment Share on other sites More sharing options...
prodigieux Posted May 25, 2013 Author Share Posted May 25, 2013 Found the solution, I had to clear the smarty cache. Not sure why, my guess from my understanding is it was caused by the ordering I changed and added an "order by" statement to the DB, that was cached inside smarty. 1 Link to comment Share on other sites More sharing options...
.png.022b5452a8f28f552bc9430097a16da2.png)
Recommended Posts