FRESH INSTALL: Search facility is not working properly?

[willem_j]

I get the same SQL error when I set 'Display Product Image' to 0, setting it back to 1 makes the search function work again.

Willem

[DrByte]

aha ! a key !

Okay -- I can duplicate that on v1.3.0.1, but not in the next version being developed.

Gonna have to hunt to see what fixed it.

[DrByte]

Moved this post to the Bug Reports area.

[DrByte]

I think I have a solution:

includes/modules/pages/advanced_search_result/header.php
starting at line 176:

// always add quantity regardless of whether or not it is in the listing for add to cart buttons
if (PRODUCT_LIST_QUANTITY < 1) {
  $select_column_list .= ', p.products_quantity ';
} 

replace with:

// always add quantity regardless of whether or not it is in the listing for add to cart buttons
if (PRODUCT_LIST_QUANTITY < 1) {
  if (empty($select_column_list)) {
    $select_column_list .= ' p.products_quantity ';
  } else  {
    $select_column_list .= ', p.products_quantity ';
  }
}