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

**Ajeh** · 3 Feb 2015, 07:10 PM

And if you do a search for:
products_id 1032

now what comes up?

**kcb410** · 3 Feb 2015, 07:15 PM

Originally Posted by Ajeh

And if you do a search for:
products_id 1032

now what comes up?

This (unless I'm not searching correctly):

Click image for larger version.

Name: Product-1032.jpg
Views: 41
Size: 48.2 KB
ID: 14943

If I sort by product ID it stops at 179

Click image for larger version.

Name: Product-Attributes.jpg
Views: 32
Size: 77.4 KB
ID: 14944

**Ajeh** · 3 Feb 2015, 07:30 PM

This is kind of what I am getting at ...

Your database is not matching up to your website ...

If you peek at the products table in phpMyAdmin, and sort by products_id, what is the low value products_id and the high value products_id?

**kcb410** · 3 Feb 2015, 07:45 PM

Originally Posted by Ajeh

This is kind of what I am getting at ...

Your database is not matching up to your website ...

If you peek at the products table in phpMyAdmin, and sort by products_id, what is the low value products_id and the high value products_id?

I'm just speaking with the hosting company now...

**Ajeh** · 3 Feb 2015, 07:46 PM

And you are sure those configure.php files are from your server ... correct?

So far I am a bit baffled here ...

**kcb410** · 3 Feb 2015, 08:15 PM

Originally Posted by Ajeh

And you are sure those configure.php files are from your server ... correct?

So far I am a bit baffled here ...

Wow do I feel stupid!

I have two databases within the live database, one with a prefix and one without. This apparently happened when I did the 1.5.1 upgrade last January and installed the demo data and didn't remove it before importing my data. I'm sorry for wasting your time on this issue!

The original DELETE from products_attributes WHERE options_id=XX and options_values_id=0; works perfectly when you add the database prefix that matches your live database.

Thank you for your help on this Ajeh...I appreciate it!

**Ajeh** · 3 Feb 2015, 08:18 PM

That is unfortunately a typical *thud* that many have run into in the past ... doesn't it feel great to finally realize that you are not stupid but are merely blind?

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

Thread Tools

Search Thread

Display

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

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

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

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

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

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

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

Similar Threads

v150 Is this a bug in v1.50? orders_total doesn't output "text" but "value"

HELP - ALL Attributes are showing up as "Text" for option value!

How to remove ellipses ("...") after "All Products" and "New Products" on home page?

Ability to get a list of "option value" by "customer"?

Inside the "Categories" box it says "New Products" and "All Products"...

Bookmarks

Bookmarks

Posting Permissions