Product Search works in Store NOT in Admin

If I try to search for --SOME-- products in the Admin section, it comes up with nothing. From what I can tell it only happens with products in ONE particular category and all sub categories.

That category has a large number of items in it, over 8000 with a lot of sub categories.

If I use the same search words or product model in the STORE it works fine.

Any suggestions on how to fix that or what the cause might be?

Sorry using v1.39h

I have the same problem. About 25,000 products using version 1.5.4. Any ideas?

keith z:

I have the same problem. About 25,000 products using version 1.5.4. Any ideas?
Is it with everything, or just one specific product?
And where exactly are you doing this search?
And are you searching from within a certain category already, or from the top level?

Is it with everything, or just one specific product? It is with recently added products. About 2500 in number.
And where exactly are you doing this search? I start at categories/products top then work my way down ending up in the category the items are located. The search cannot find the item in any category level.
And are you searching from within a certain category already, or from the top level? In one example I start from top then a category called repair parts, then a category by manufacturer name. The item is not found in any category searches.

Does the storefront search work fine for those affected products?

I think you are asking about the product search that a customer would use on the website. Yes, it finds the product just fine.

And I am assuming that both your files:
/includes/configure.php
/your_secret_admin/includes/configure.php

are using the same DB_xxxxxx database settings? :lookaroun

Also, can you check the table:
products

(with something like phpMyadmin) and make sure you have the master_categories_id set on the products you cannot find?

Also how were the ~1400 items added to the store?

Ajeh:

And I am assuming that both your files:
/includes/configure.php
/your_secret_admin/includes/configure.php

are using the same DB_xxxxxx database settings? :lookaroun

/includes/configure.php is 0444
/your_secret_admin/includes/configure.php is 0644

keith z:

/includes/configure.php is 0444
/your_secret_admin/includes/configure.php is 0644
The question was in reference to content inside each of those files. There is a "section" related to the database. That section has defines with constants that begin with DB_ such as DB_PREFIX. The question is for all DB_XXX related fields when comparing the two files, are they the same?

Ajeh:

Also, can you check the table:
products

(with something like phpMyadmin) and make sure you have the master_categories_id set on the products you cannot find?

I downloaded my products table and the missing items are in the table.

mc12345678:

Also how were the ~1400 items added to the store?

with Easy Populate 4.0.28 - Beta 01-03-2015

keith z:

I downloaded my products table and the missing items are in the table.
Good that the products are there, so now that you see the products, please look through the fields until you see master_categories_id then for each of the problem product what is the value for master_categories_id for those product. Still important to review the data inside the configure files.