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

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

[kcb410]

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

I believe this is the correct table...KCB.sql.zip

[Ajeh]

While it is the right table, I believe you only exported some of it ...

See if you can try again by going to phpMyAdmin so that you see all the table names for your database in the right hand panel of the screen, then click on EXPORT and you should see the selection for:

Export Method:

Quick - display only the minimal options
Custom - display all possible options

Pick Custom and you will see all the tables listed ... just pick the one for products_attributes ...