Zen Cart Logo
Forums / Setting Up Categories, Products, Attributes / Dynamic drop downs for stock by attributes

Dynamic drop downs for stock by attributes

Views: 2,241

Results 1 to 2 of 2
3 Mar 2009, 1:03 PM
#1
dthomas avatar

dthomas

New Zenner

Join Date:
Feb 2009
Posts:
13
Plugin Contributions:
0

Dynamic drop downs for stock by attributes

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!

9 Mar 2010, 1:46 AM
#2
creinold avatar

creinold

Zen Follower

Join Date:
Sep 2008
Location:
North Highlands, California 95660
Posts:
287
Plugin Contributions:
0

Re: Dynamic drop downs for stock by attributes

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