Guest Posted March 26, 2007 Share Posted March 26, 2007 i installed product extra field v2.0j and get error when search with advanced_search_result.php 1066 - Not unique table/alias: 'pd' select count(distinct p.products_id) as total from (products p left join products_to_products_extra_fields p2pef on p.products_id=p2pef.products_id) left join manufacturers m on m.manufacturers_id=p.manufacturers_id, products_description pd left join specials s on p.products_id = s.products_id, categories c, products_to_categories p2c, products_description pd, categories c, products_to_categories p2c 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 '%o%' or p.products_model like '%o%' or m.manufacturers_name like '%o%' or p2pef.products_extra_fields_value like '%o%') and (pd.products_name like '%cam%' or p.products_model like '%cam%' or m.manufacturers_name like '%cam%' or p2pef.products_extra_fields_value like '%cam%') ) [TEP STOP] i tried Product extra fields - Advaced_search_result.php by marthynes 3 Oct 2006 but problem with another error can someone help? thanks Quote Link to comment Share on other sites More sharing options...
Guest Posted March 27, 2007 Share Posted March 27, 2007 someone plz help me! Quote Link to comment Share on other sites More sharing options...
Guest Posted March 28, 2007 Share Posted March 28, 2007 anyone who has tried this contribution.can you help me? urgent problem thanks :(( Quote Link to comment Share on other sites More sharing options...
Guest Posted March 28, 2007 Share Posted March 28, 2007 please help ! Quote Link to comment Share on other sites More sharing options...
Guest Posted April 2, 2007 Share Posted April 2, 2007 please help me everyone Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.