ce7 Posted August 10, 2012 Share Posted August 10, 2012 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 Link to comment Share on other sites More sharing options...
Guest Posted August 10, 2012 Share Posted August 10, 2012 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%' Link to comment Share on other sites More sharing options...
ce7 Posted August 26, 2012 Author Share Posted August 26, 2012 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? Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.