message error

[phmoreau]

in the admin part, when I try to preview a product (click on the left end of the line) I got this message :

 

1109 - Table inconnue 'p.products' dans field list

 

select p.products_id, pd.language_id, pd.products_name, pd.products_description, pd.products_url, p.products_quantity, p.products_nombre, p.products.delai, p.products_util1, p.products_util2, p.products_util3, p.products_util4, p.products_model, p.products_image, p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p.manufacturers_id from products p, products_description pd where p.products_id = pd.products_id and p.products_id = '84'

 

[TEP STOP]

 

Does somebody could explain me how to fix it ? In witch file is the mistake ?

 

Thanks

[♥Vger]

If you read here and follow the links provided it should explain the error to you.

 

http://bugs.mysql.com/bug.php?id=1109

 

Vger