[SOLVED] Column 'quantity' in order clause is ambiguous

[Comshop]

Hello

 

After the sort the product list in the BO now I get the following error message: (Column 'quantity' in order clause is ambiguous)

 

What can I do?

 

Thanks

[PrestaHeroes USA]

see this post:

http://board.phpbuilder.com/showthread.php?10322384-RESOLVED-Column-in-where-clause-in-ambiguous

[Comshop]

<SOLVED>

 

MySQL > Check All > Repair Table > Go

 

www.comshop.com.pt

[AlexFL]

An easier way is to just log off and log on again from back office.

[vekia]

i think that it's not enough to just log in log out from back office, it looks like problem with queries, not with cookies etc

[frankit]

i think that it's not enough to just log in log out from back office, it looks like problem with queries, not with cookies etc

Log in and out just flush the sorting preferences (from the cookies i suppose) and let you see again your products in the product page, so it can be considered a "solution" for those that just wants back their product page. but of course doesn't solve the problem so if you try to sort the quantity column and than view more than 50 product per page, the error will pops out again, at least on my outdated ps1.5.6.