Jump to content
Sign in to follow this  
Nev

Featured Products v1.3

Recommended Posts

I have installed this along side FreeCall V4.0 but I'm getting the following error when enabling the Featured Products.

 

1064 - You have an error in your SQL syntax near 'rand() DESC limit 6' at line 1

 

select p.products_id, p.products_image, p.products_tax_class_id, s.status as specstat, s.specials_new_products_price, p.products_price from products p 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 rand() DESC limit 6

 

 

any ideas any one, please.

 

Nev :?

Share this post


Link to post
Share on other sites

I have never touched that select that I know of in my code.

 

I think that would be a Featured Products issue.

Share this post


Link to post
Share on other sites

After doing some testing it looks like the rand() is not support in my versions of mySQL. So will have to upgrade to 3.23.2 or change the statement.

 

Can any one suggest a replaced statement that will provide the same random effect.

 

Nev

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  

×