Featured Products Infobox V1.3 Assistance Please

[JMcCutcheon]

Hi,

 

I installed Featured Products Infobox V1.3. I believe it followed the readme.txt, but it doesn't replace the What's New box and also there is an error (see bottom of URL):

 

http://www.briqsholidayspecialties.com/default.php

 

Obviously I'm missing something.

 

Any assistance would be greatly appreciated in getting this to work.

 

Thanks.

 

Jackie

[Guest]

Try to follow through from begining to end just to make sure you didn't leave something out :D

 

I am using the same feature and this is what it should look like

http://www.raveknights.com/catalog/default.php

[JMcCutcheon]

I've gone through the instructions one more time and can't see what I'm missing.

 

Here is what is showing up where the featured products should show up:

 

1064 - You have an error in your SQL syntax near 'rand() DESC limit 3' 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 3



[TEP STOP]

 

Any ideas? Thanks.

 

Jackie

[JMcCutcheon]

Just wanted to add that I noticed the featured_products.php page appears: http://www.briqsholidayspecialties.com/fea...ed_products.php

 

After going through all the code again, I'm still receiving this error on the main page:

 

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



[TEP STOP]

 

I'm willing the pay for assistance. Thanks in advance.

 

Jackie

[JMcCutcheon]

Hi,

 

I'm back to working on this project:

 

http://www.briqsholidayspecialties.com

 

Still receiving the following error:

 

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



[TEP STOP]

 

If anyone would have time to take a look - I've posted a zip file here:

 

http://www.briqsholidayspecialties.com/zip...s/feat_briq.zip

 

Again - willing to pay.

 

Thank You.

 

Jackie McCutcheon

[burt]

What version of MySQL are you running ? If it is an older version then RAND won't work.

[JMcCutcheon]

Gary,

 

I believe it is 3.23.10-alpha. That's what I see when I run phpinfo.

 

Thanks!

 

Jackie