Admin search problem

[directpc]

We have a nasty problem with the admin search, its not working, we did a clean install of zen and then had a programmer do other bits, he insist's he did not touch anything near that section so it could not be anything he has done, we are not sure if it was working before he started the work.

We search for an item in the admin side of the site, and it always comes back with no results, even though the product we are searching for is found with the search function on the main pages on the site, its just the admin side.

Please somebody help, we really need this search function, any ideas of what the problem could be, or the location of the file we need to find, to see if there is any difference between the file on our server and the main zen cart files,

Thanks for any help anybody can provide us

[darkswan]

What version of Zencart? Where are you using the search at? In products or in the customers area? Is it an add-on module?

[bernie.oz]

HI,

I am using 1.3.9c and have the same problem.

Can anybody help me?

Cheers

[milobloom]

Fresh Install for me...

Same problem

[bminister]

I'm using the same version - 1.3.9c but the admin and the customer search feature work fine.
Do you try to search in the admin area -> categories/products ? What do you enter for keyword - the product name or a description word?

[ttfan]

I've got the same problem, with 1.3.9e fresh install. Search works fine on the main page, but searhc in admin only seems to find categories not products...

[ttfan]

Here's a clue that might be the issue for mine:

My database was imported from OScommerce.

When I create new items, it seems to be able to find them in admin search, but for the items imported, it does not find them...

Is there a way of re-indexing the database perhaps?

[Ajeh]

If you go to phpMyAdmin and look at the structure of the products_description table ...

What is the Collation on the products_name, products_description and products_url ...

If you look at the structure of the categories_description table ...

What is the Collation on the categories_name and categories_description ...

[ttfan]

Looking in phpmyadmin, and selecting the table, all entries seem to have latin1_general_ci as their collation.

I can't specifically see the names "products_name" or "products_url" though, only the following ones in the main list:

products
products_attributes
products_attributes_download
products_description
products_discount_quantity
products_notifications
products_options
products_options_types
products_options_values
products_options_values_to_products_options
products_to_categories
products_with_attributes_stock
product_music_extra
product_types
product_types_to_category
product_type_layout

categories
categories_description

[Ajeh]

Can you check that all of your Products in the products table have master_categories_id set and products_type set and products_price_sorter ...