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

[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.

[Ajeh]

Browse the table products_attributes and sort on the field options_id then scroll to where you find the records for options_id = 10 ...

How many records do you see there with options_id is 10?

[kcb410]

Browse the table products_attributes and sort on the field options_id then scroll to where you find the records for options_id = 10 ...

How many records do you see there with options_id is 10?

I don't see any...it goes from option id 9 then jumps to 11.

[Ajeh]

Are you able to Export the table products_attributes from your database and Zip it then attach it to your post?