Newsletter Manager 1054 - Unknown column 'p.products_id' in 'on clause'

[Stin_]

Hello,

 

I get this error when I want to preview the newsletter, pls some one .... what I have to do? :unsure:

 

 

"Newsletter Manager

 

1054 - Unknown column 'p.products_id' in 'on clause'

 

select p.products_id, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id, if(s.status, s.specials_new_products_price, NULL) as specials_price from products p, products_description pd left join specials s on p.products_id = s.products_id where pd.products_id = p.products_id and p.products_id in(1638) and pd.language_id=4

 

[TEP STOP]"

 

 

 

Best Regards

 

Stin_

[Jan Zonjee]

what I have to do?

Change the query a bit. For example to:

 

select p.products_id, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id, if(s.status, s.specials_new_products_price, NULL) as specials_price from products p left join products_description pd on pd.products_id = p.products_id left join specials s on p.products_id = s.products_id where p.products_id in(3,5,6,16) and pd.language_id=4

[Stin_]

Hi,

 

pleas be patient end let me know where I find the file end what I have to change becosue I'm not so expert .... sorry

 

 

thank You! for the answer, end apologize for my English

 

 

Cristian