SECv2_2MS2GV 1064 mySQL errors

This message was sent from: Contributions
http://forums.oscommerce.com/viewtopic.php?p=227886#227886
----------------------------------------------------------------

Hi all.
First, let me say that while osCommerce is a wonderful product, Linda's contribution makes it a more complete solution package.  That said, I must be missing (messing??) something.  I did a new install of SECv2_2MS2GV (twice actually, since I encountered errors) and I can't seem to figure out what I'm doing wrong.

I followed the install instructions to the letter.  I had encountered a mySQL error when loading the database in the admin_groups area, so to work around that I set the admin_groups_name to NOT NULL because phpadmin said it couldn't be UNIQUE and NULL.  Everything else loaded fine.  I didn't worry about this too much because the admin didn't seem to have any problems when I went there.

Then I go to the catalog and in the "featured products" area at the bottom of the page I'm receiving an error that says: 

INDEX
[quote]1064 - You have an error in your SQL syntax near 'rand(1912235632) 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(1912235632) DESC limit 6

[TEP STOP][/quote]


Additionally, when I click on "view all products" in the categories menu I'm receiving the following:

PRODUCTS ALL
[quote]1064 - You have an error in your SQL syntax near 'distinct p.products_id) as total from products p left join manufacturers m usin' at line 1

select count(distinct p.products_id) as total from products p left join manufacturers m using(manufacturers_id), products_description pd left join specials s on p.products_id = s.products_id, categories c, products_to_categories p2c where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id 

[TEP STOP][/quote]

I'm still a beginner in php, so if someone could please guide me in the right direction of what I need to do to correct these errors?  I've looked at /includes/modules/featured.php as well as products_all.php, but I'm not sure what I should be looking for.  

I'd appreciate any and all help you all could give me.  

Thanks!