2 replies [Last post]
pebosi@drupal.org's picture
Offline
Uber DonorBug Finder
Joined: 09/05/2007
Juice: 47
Was this information Helpful?

Go this Error:

user warning: Unknown column 'p.sell_price' in 'order clause' query: SELECT DISTINCT(n.nid), n.sticky, n.title, n.created FROM node n INNER JOIN term_node tn ON n.nid = tn.nid WHERE tn.tid = 10 AND n.status = 1 AND n.type IN ("product") ORDER BY p.sell_price ASC LIMIT 0, 20 in C:\xampplite\htdocs\drupal5\includes\database.mysql.inc on line 172.

While sorting for "price" - column.

regards

aswalla's picture
Offline
Getting busy with the Ubercode.Spreading the word - Ubercart for president.
Joined: 08/17/2007
Juice: 105
Re: Error when sorting on price in catalog

pebosi - I was getting this error when running PHP4 and upgraded to PHP5.x and now the error is gone so my best guess is some sort of conflict with PHP4.x is causing this error. Are you able to upgrade?

Lyle's picture
Offline
AdministratoreLiTe!
Joined: 08/07/2007
Juice: 6854
Re: Re: Error when sorting on price in catalog

Actually, it's an error in alpha7b. Upgrade to the bazaar version to get fix it.