Dynamic drop downs for stock by attributes

[dthomas]

I have been messing around with this Dynamic Drop Downs for Stock by Attributes but have come to a dead end.

I first had installed Stock by Attributes v.4.7multiadd and it was working fine. I then tried to install the Dynamic Drop Downs but immediately ran into problems.

First time it gave some error message directly on my website (product attributes area) and I was too busy to try and figure out why. So I reverted to my backup db and files.

2nd attempt at install and I get the following message when entering the new_install.sql:

1060 Duplicate column name 'products_options_track_stock'
in:
[ALTER TABLE zen_products_options ADD products_options_track_stock tinyint(4) default '1' not null AFTER products_options_name;]


And when entering the config.sql is get this message:


1062 Duplicate entry '888001' for key 1
in:
[INSERT INTO zen_configuration_group (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible) VALUES (888001, 'Dynamic Drop Downs', 'Dynamic Drop Downs configuration options', 8, 1);]

On the actual website, nothing has changed and the normal Stock by Attributes is working fine.

I believe these errors are saying my db was never really restored to original state, but where does that leave me? I don't have any other db to restore than what was already put back.

Suggestions?

Many thanks!

[creinold]

Not sure if you fixed it yet or not, but all you got to do is use MYSQL to delete the duplicate entries and then rerun the sql patch