Jump to content
Sign in to follow this  
espacio

Featured Products Error

Recommended Posts

I?ve installed the Featured Products Contrib. Now, I get this Error :(

 

Does anybody know, what i got to do now?

 

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 'select p.products_id, p.products_name, p.products_image, p.prod

 

select count(select p.products_id, p.products_name, p.products_image, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_date_added, m.manufacturers_name from products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join products_description pd on p.products_id = pd.products_id and pd.language_id = \'2\' left join specials s on p.products_id = s.products_id left join featured f on p.products_id = f.products_id where p.products_status = \'1\' and f.status = \'1\' order by p.products_date_added DESC, pd.products_name) as total

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  

×