How to remove / delete Dynamic drop downs for stock by attributes mods?

[Park]

Just remove the files that I uploaded?

Thank U in advance

[Park]

I've removed the files that I uploaded.

But, Drop-down is NOT working..... as well as The Product Info page is NOT showing.... T T

What is the problem.....?

Plz, help me....

[stevesh]

No idea. Are there any error log files in your /logs folder ?

[Park]

I don't think there is any problem in logs folder...

What the Product Info page is NOT showing happens when I put the Dropdown menu on the product.

It's making me crazy.........

[stevesh]

Blank pages usually mean PHP errors and will generate an error file in the /logs folder. Take a look.

[Park]

Ah.. you're right....

But, I don't know what it means.....;;
Maybe it's Database problem, I guess.. am I right?

"PHP Fatal error: 1060: Duplicate column name 'products_options_track_stock' :: ALTER TABLE products_options ADD products_options_track_stock tinyint(4) default '1' not null AFTER products_options_name; in /home/content/a/l/y/alykhan/html/includes/classes/db/mysql/query_factory.php on line 120"

[Park]

# Add new column to products_options to indicate if stock should be tracked
# for an option

ALTER TABLE products_options
ADD products_options_track_stock tinyint(4) default '1' not null
AFTER products_options_name;


It's the SQL query that used for installation.

[Park]

I think I should delete 'products_options_track_stock ' column.
But, I can't do it yet... Because it's not exactly....

........Delete...? or No?

[mc12345678]

Just remove the files that I uploaded?

Thank U in advance

Not sure all that was installed, but short answer is no, not really/always. Must know what file(s) were uploaded and whether they are core files (overwrote existing files) or if they are potentially/possibly template or override files. Better yet, to uninstall, should restore back to the backup made before attempting the install.

As for specifically removing a portion of what was installed say for Stock By Attributes, essentially need to figure out what code either generates or displays the dropdown and then can in some way work backwards to remove unnecessary portions of the code and "restore" routine functionality back as needed. Not sure why you want to do this though...

[mc12345678]

I think I should delete 'products_options_track_stock ' column.
But, I can't do it yet... Because it's not exactly....

........Delete...? or No?

The error message is occurring because the SQL command that you are trying to run is trying to add the column again (which it can't) if you are able to run all of the SQL by omitting that one statement then you should be good to go unless following statements also cause an error. At that point offending statements should not be run, or the mods done to the database should be undone