Jump to content
Sign in to follow this  
donslund

mySQL error when sending from Newsletter products

Recommended Posts

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

Share this post


Link to post
Share on other sites

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 ?

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×