1054 - Unknown column - Help, please !

Hello !
I replace 'manufacturers' by 'editeurs';

When I click on a product at the default page, I receive the following error:

1054 - Unknown column 'p.EDITEURS_id' in 'where clause'

select distinct m.EDITEURS_id as id, m.EDITEURS_name as name from products p, products_to_categories p2c, EDITEURS m where p.products_status = '1' and p.EDITEURS_id = m.EDITEURS_id and p.products_id = p2c.products_id and p2c.categories_id = '45' order by m.EDITEURS_name.

Is someone face this precedently ?

Need some help.

Tanks

[michael_s]

When you change the field used in the code, you also need to change the database. It would be better to just change the displayed text rather than the field name.

This is located in the english.php. I had a problem figuring out where it was located.