Home » Forums » Ubercart » Bug Reports

Error when sorting on price in catalog

Submitted by pebosi@drupal.org on Wed, 09/05/2007 - 05:57
pebosi@drupal.org
Posts: 20
 Joined: 09/05/2007
Uber DonorBug Finder

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
permalink #1 Wed, 09/05/2007 - 14:50
aswalla

Posts: 50
 Joined: 08/17/2007
Getting busy with the Ubercode.Spreading the word - Ubercart for president.

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?

permalink #2 Wed, 09/05/2007 - 15:38
Lyle

Posts: 2267
 Joined: 08/07/2007
AdministratoreLiTe!

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