nobynator Posted December 13, 2013 Share Posted December 13, 2013 I have 1.5.5.0, after click Catalog -> product it showes error : Bad SQL queryColumn 'quantity' in order clause is ambiguous Anyone know how to fix this? Link to comment Share on other sites More sharing options...
NemoPS Posted December 14, 2013 Share Posted December 14, 2013 Did you activate the full error reporting? (as my signature says) If so, can you print the full error stack? Link to comment Share on other sites More sharing options...
vekia Posted December 14, 2013 Share Posted December 14, 2013 hello it's because your sql query has got JOINS and two or more tables has got quantity field. you have to use alias.quantity in SELECT / WHERE clause please give us more info about in what query you've got this problem. Link to comment Share on other sites More sharing options...
nobynator Posted December 15, 2013 Author Share Posted December 15, 2013 It seems to have solved by itself after 1 day. Link to comment Share on other sites More sharing options...
FernandoLopez Posted January 10, 2014 Share Posted January 10, 2014 I have the same problem but after clicking customers Link to comment Share on other sites More sharing options...
Frankie84 Posted January 24, 2014 Share Posted January 24, 2014 (edited) I deleted cookies in my browser and it fixed it. I got that error by sorting quantity ascending in the back end and it happens each time. Ver 1.5.4.0 Edited January 24, 2014 by Frankie84 (see edit history) Link to comment Share on other sites More sharing options...
vekia Posted January 24, 2014 Share Posted January 24, 2014 you've got the same error as it is described in first post here? Link to comment Share on other sites More sharing options...
Frankie84 Posted January 24, 2014 Share Posted January 24, 2014 (edited) On 1/24/2014 at 8:29 PM, vekia said: you've got the same error as it is described in first post here? yeah.. exactly the same error. If I repeat the sort ascending on the back office under catalog > product I get the same error. And if I delete the cookies the error goes away. Edited January 24, 2014 by Frankie84 (see edit history) Link to comment Share on other sites More sharing options...
vekia Posted January 24, 2014 Share Posted January 24, 2014 weirdy but ... great it's worth to know that this solution can solve this problem i just want to test it but i have no idea how to reproduce main issue Link to comment Share on other sites More sharing options...
Frankie84 Posted January 24, 2014 Share Posted January 24, 2014 On 1/24/2014 at 10:02 PM, vekia said: weirdy but ... great it's worth to know that this solution can solve this problem i just want to test it but i have no idea how to reproduce main issue Yea, easy fix. These are the steps I took: 1. Log into back end (admin). 2. Click on Catalog > Products Tab. 3. On the product fields under quantities click the sort ascending "^". 4. Change the number of products displaying. 5. Then I get the error. Also, hitting "back" button right away and resetting the filters gets you out of that error. 1 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