Lot's of issues with this module

I tried using this module a year ago and couldn't get it working and gave up. I have a need for it now and thought I'd try it again....I still can't get it to work and thought I'd try to get help this time...

I CAN create product variations OK. Here's where my issues lie tho:
- I create a tangible sub-product fine (the base product) but when I go to generate subproducts, I AM able to choose my variations I want but when I click the "review options" button, I get this error (this is BEFORE clicking on the 'Generate' button on the next page) :

user warning: Duplicate entry 'subproducts_ec_live_subproducts_tangible_default' for key 1 query: INSERT INTO variable (name, value) VALUES ('subproducts_ec_live_subproducts_tangible_defaults', 'a:2:{i:2;a:2:{i:6;a:1:{s:5:\"stock\";s:1:\"0\";}i:5;a:1:{s:5:\"stock\";s:1:\"0\";}}i:1;a:4:{i:1;a:2:{s:3:\"use\";s:1:\"1\";s:5:\"stock\";s:1:\"0\";}i:2;a:2:{s:3:\"use\";s:1:\"1\";s:5:\"stock\";s:1:\"0\";}i:3;a:2:{s:3:\"use\";s:1:\"1\";s:5:\"stock\";s:1:\"0\";}i:4;a:2:{s:3:\"use\";s:1:\"1\";s:5:\"stock\";s:1:\"0\";}}}') in /var/www/vhosts/viparagliding.com/httpdocs/includes/database.mysql.inc on line 172.

I don't know what that tells me so maybe it is the root of all my issues....

Here is how things behave after this error...
- it does create the sub-products (a separate node for each sub-product variation)
- when I view the base product node, it DOES show a drop down menu to choose from the sub-variations but when I choose any of the variations and click add to cart, it adds the same variation all the time (it was the last and heaviest weighted variation I created)

I have a View that shows the products' - and all variations are listed (I don't like that) - I have to remove the separate variations' taxonomy term to get them removed from that View.

I have the 'Add to cart' button shown on that view and if I have the option to show that button in the base product but have inventory management disabled, it shows "out of stock" for all variations. So I removed the 'show add to cart link' to get around that. This is a viable solution as it forces users to go to the main product node to choose the proper variation...but as per above, it's adding the same variation regardless of what the user chooses.

Even if I show the sub-products in the Views table AND enable inventory management AND set the in stock levels high (even tho I don't want to keep track of inventory) just to get the 'add to cart' link on the views table, clicking on that button adds that same variation as above. Going to the variation's node page and clicking on the 'add to cart' button gives the same result.

It seems to take a lot to set up this module...and then in the end it doesn't work....I REALLY hope that that error above points to the root of my issues.

In an ideal world, what I would like to see is it NOT create separate nodes for each variation so they all aren't added to my views. Instead, I'd suggest that you are allowed to include a drop down selection list in the Views table of the variations so a visitor could:
- only see the main product in the table
- select the desired variation
- NOT manage inventory but still get an 'add to cart' link in the view
- and of course have the link add the proper item to the cart.

Many thanks - I know it's a big read above but I hope I can get some help.