mySQL error when sending from Newsletter products

[donslund]

I use the contribution, Nesletter Products

 

 

I can make my newsletter and I can see it, but when I try to send it I get this error:

 

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') and pd.language_id=4' at line 1

 

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() and pd.language_id=4

 

[TEP STOP]

 

I guess it is because in() is empty. But how can that be, Whenm I preview my newsletter everyting is fine.

 

Please, some one help me.

 

Kind regards

Jeppe Donslund

[kornel76]

I use the contribution, Nesletter Products

 

 

I can make my newsletter and I can see it, but when I try to send it I get this error:

 

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') and pd.language_id=4' at line 1

 

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() and pd.language_id=4

 

[TEP STOP]

 

I guess it is because in() is empty. But how can that be, Whenm I preview my newsletter everyting is fine.

 

Please, some one help me.

 

Kind regards

Jeppe Donslund

 

I think the problem is this "pd.language_id=4" do you have installed a language id = 4 ?