Latest News: (loading..)

Archived

This topic is now archived and is closed to further replies.

ce7

1066 - Not unique table/alias: 'p'

3 posts in this topic

Hi

 

When I do search at the backend, I got the error message. I think maybe I have two products p,

but I dont know which files I should go to check, can anyboy please help?

 

Categories/Products / search

 

 

1066 - Not unique table/alias: 'p'

 

select count(*) as total from products p, products_description pd, products_to_categories p2c , products p LEFT JOIN products_fields_groups_names pfgn on p.products_fields_group_id = pfgn.products_fields_group_id and pfgn.language_id = '1' where p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and pd.products_name like '%072%'

 

thanks

Share this post


Link to post
Share on other sites

Your sql query should look like this:

 

select count(*) as total from (products p LEFT JOIN products_fields_groups_names pfgn on p.products_fields_group_id = pfgn.products_fields_group_id and pfgn.language_id = '1'), products_description pd, products_to_categories p2c where p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and pd.products_name like '%072%'

Share this post


Link to post
Share on other sites

Hi Marek,

 

Thank you for replying my post. Can you please post again as I can not see your code.

 

And which file should I go to modify? admin/categories.php?

Share this post


Link to post
Share on other sites