Search error in search box

I am getting this message when typing in a key word:

Advanced Search
1064 You have an error in your SQL syntax near ' p.products_quantity , m.manufacturers_id, p.products_id, pd.products_name, p.p' at line 1
in:
[SELECT DISTINCT , p.products_quantity , m.manufacturers_id, p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_price_sorter FROM products p LEFT JOIN manufacturers m USING(manufacturers_id), products_description pd, categories c, products_to_categories p2c LEFT JOIN meta_tags_products_description mtpd ON mtpd.products_id= p2c.products_id AND mtpd.language_id = 1 WHERE p.products_status = 1 AND p.products_id = pd.products_id AND pd.language_id = 1 AND p.products_id = p2c.products_id AND p2c.categories_id = c.categories_id AND ((pd.products_name LIKE '%lawyer%' OR p.products_model LIKE '%lawyer%' OR m.manufacturers_name LIKE '%lawyer%' OR (mtpd.metatags_keywords LIKE '%lawyer%' AND mtpd.metatags_keywords !='') OR (mtpd.metatags_description LIKE '%lawyer%' AND mtpd.metatags_description !='') OR pd.products_description LIKE '%lawyer%') ) order by pd.products_name limit 0, 10]

The version of zen cart is the most recent and current, it is a Unix server and the URL is http://alltalktease.com/catalog/

What specific version of Zen Cart are you running?

The version is 1.3.0.2

Sounds like you missed a file ...

What version Zen Cart were you?

How did you upgrade?

Do you see around line 170 - 174 in /includes/modules/pages/index/main_template_vars.php on the server ...

  // 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, ';
  }

What settings do you have for the Configuration ... Product Listing ...

sparktronic:

I am getting this message when typing in a key word:

Advanced Search
1064 You have an error in your SQL syntax near ' p.products_quantity , m.manufacturers_id, p.products_id, pd.products_name, p.p' at line 1
in:
[SELECT DISTINCT , p.products_quantity , m.manufacturers_id, p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_price_sorter FROM products p LEFT JOIN manufacturers m USING(manufacturers_id), products_description pd, categories c, products_to_categories p2c LEFT JOIN meta_tags_products_description mtpd ON mtpd.products_id= p2c.products_id AND mtpd.language_id = 1 WHERE p.products_status = 1 AND p.products_id = pd.products_id AND pd.language_id = 1 AND p.products_id = p2c.products_id AND p2c.categories_id = c.categories_id AND ((pd.products_name LIKE '%lawyer%' OR p.products_model LIKE '%lawyer%' OR m.manufacturers_name LIKE '%lawyer%' OR (mtpd.metatags_keywords LIKE '%lawyer%' AND mtpd.metatags_keywords !='') OR (mtpd.metatags_description LIKE '%lawyer%' AND mtpd.metatags_description !='') OR pd.products_description LIKE '%lawyer%') ) order by pd.products_name limit 0, 10]

The version of zen cart is the most recent and current, it is a Unix server and the URL is http://alltalktease.com/catalog/

Can you paste the corresponding file here?

Also in the /includes/modules/pages/advanced_search_results/header_php.php around line 185 - 192 do you see:

// 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 ';
  }
}

I took the two files you suggested off another catalog that the search was working and now the search works fine. Thanks for your help and speed in getting back to me.

Thanks for the update that you just had some files out of date ... :smile: