help sql5

[julinhu00]

Hi, I'm troubled when I search for product in my store.

the search does not find anything, and sometimes the error ..

can someone help me?

 

 

 

054 - Unknown column 'p.products_id' in 'on clause'

 

select count(distinct p.products_id) as total from products p left join manufacturers m using(manufacturers_id), products_description pd left join specials s on p.products_id = s.products_id, categories c, products_to_categories p2c,products_attributes pa where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '4' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and ((pd.products_name like '%cg%' or p.products_model like '%cg%' or m.manufacturers_name like '%cg%') )

 

[TEP STOP]

[♥geoffreywalton]

This is a classic symptom of a template using old code being run on a server that has mysql5 installed on it.

 

Apply the mysql 5 patches that can be found by following the links in my signature block and then look in the contributions for instruction on how the fix the code in any contributions that have been installed that have this problem.