Deleting an Option with a "TEXT" or "FILE" value for ALL products

[kcb410]

Hello All,

I'm attempting to delete a "TEXT" type option name that exists with all products on our web site. I would normally use "Delete ALL Option Values to ALL products for Option Name" but option names that are the text or file type don't appear in the list. Is there another way to delete this type of option name for all products?

Any help would be appreciated. Thanks.

[kcb410]

I've attempted to use the method found in this thread which seems to match my issue exactly.

The query SELECT from products_attributes WHERE options_id= XX and options_values_id =0; with my option_id generates an error #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from products_attributes WHERE options_id= 10 and options_values_id =0 LIMIT 0,' at line 1

The query DELETE from products_attributes WHERE options_id= XX and options_values_id =0; deletes 4 items but seems to do nothing to the actual option name when you're in the Zen admin.

We're currently using Zen 154, PHP 5.3.28 and MySQL 5.5.40 and the thread noted above is from 2010 so I'm assuming it's possible the solution isn't valid in 2015. Should these queries be functioning properly for me in 2015? or am I missing some required data?

Any help would really be appreciated. Thanks!

[mc12345678]

What is meant by: it doesn't do anything with the actual option name in the admin?

What and where are you still seeing information that I sno longer desired?

[kcb410]

What is meant by: it doesn't do anything with the actual option name in the admin?

What and where are you still seeing information that I sno longer desired?

Thank you for the reply.

The option name still exists in the Zen Admin Catalog -> Option Name Manager and the attribute still exists with every product.

[Ajeh]

Your SELECT will not work as there is nothing set for selection ... try using:

SELECT * from products_attributes WHERE options_id= XX and options_values_id =0;

On the DELETE, this will delete the records in the products_attributes but it will not delete the Option Name ...

Have you an URL to a Product that has TEXT attributes that you are trying to delete that we could perhaps look at?

What is the DELETE that you are using that you say is failing?

[kcb410]

Your SELECT will not work as there is nothing set for selection ... try using:

SELECT * from products_attributes WHERE options_id= XX and options_values_id =0;

That works thanks. When I run that query it only shows 4 product IDs (34, 46, 131 and 134) , however all products have this option_id.

Have you an URL to a Product that has TEXT attributes that you are trying to delete that we could perhaps look at?

The "Upload your Artwork" option id exists with every product, but you can use this link for reference, http://www.kcbgraphics.com/index.php...oducts_id=1032

What is the DELETE that you are using that you say is failing?

I'm using DELETE from products_attributes WHERE options_id= XX and options_values_id =0; and I stand corrected... it's actually working but it only deletes the option name for the 4 product ids noted above which is really confusing me...

[Ajeh]

Are you using:

DELETE from products_attributes WHERE options_id=10 and options_values_id=0;

[kcb410]

Are you using:

DELETE from products_attributes WHERE options_id=10 and options_values_id=0;

Yes that's correct and I get this result "4 rows deleted. (Query took 0.0013 sec)"

[Ajeh]

Could you check the two files on the server for:
/includes/configure.php
/your_secret_admin/includes/configure.php

are they both using the same database name?

Where are you when you run the:

DELETE from products_attributes WHERE options_id=10 and options_values_id=0;

In the Tools ... Install SQL Patches ... or in phpMyAdmin?

[kcb410]

Could you check the two files on the server for:
/includes/configure.php
/your_secret_admin/includes/configure.php

are they both using the same database name?

Where are you when you run the:

DELETE from products_attributes WHERE options_id=10 and options_values_id=0;

In the Tools ... Install SQL Patches ... or in phpMyAdmin?

Both configure files are using the same database. I'm using phpMyAdmin to run the DELETE SQL query.