2 replies to this topic

[ce7]

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

[marrrecki]

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%'

[ce7]

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?