Jump to content
Sign in to follow this  
joshcamerote

product extra fields search results problem

Recommended Posts

hey i installed product extra fields "j" and works great but when i go to search i get this error

Products meeting the search criteria

 

"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 = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and ((pd.products_name like '%stink%' or p.products_model like '%stink%' or m.manufacturers_name like '%stink%' or p2pef.products_extra_fields_value like '%stink%') )

 

[TEP STOP]"

 

 

anywone know what to look for to fix this?

 

"stink" is my frustrated search word.

Share this post


Link to post
Share on other sites

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 = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and ((pd.products_name like '%stink%' or p.products_model like '%stink%' or m.manufacturers_name like '%stink%' or p2pef.products_extra_fields_value like '%stink%') )

 

products_description pd occurs twice in the sql you show.

 

Check the installation instructions, did you edit this code?

 

If not go back a contribution version and look at the section of code in there


Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

 

Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.

 

For links mentioned in old answers that are no longer here follow this link Useful Threads.

 

If this post was useful, click the Like This button over there ======>>>>>.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×