Search broken?

[benn600]

In my new camera store, I can view a product called the Casio Exilim. If I search for exilim, copied from the title of the product, nothing shows up! Any idea why search seems broken to me? It works for some things but not others.

[yellow1912]

Version of ZC?
Have you installed any new mod recently?
A link to your site would help.

[benn600]

I'm somewhat hesitant to post a link but I guess it's hard to help without one.

http:// thriftyphotography DOT
com/index.php?main_page=product_info&products_id=3651

There you will see the Casio Exilim and searching won't find it. I have not added anything to Zencart at all other than making my own template.

[yellow1912]

You can still edit your post now (within 7 mins), break down the links like this so SEngine wont pick it up:

thrifty photo graphy dot com

[yellow1912]

Which category does this product belong to?

[benn600]

I am lost. I can't figure out if it is or isn't in a category. It appears that it isn't! Can items not in categories be found? I imported all the data from another database so the items were not entered by hand.

So I wonder how many products I have entered that are not in any categories? Is there a way to check this out?

[yellow1912]

That may be the problem why it is not found using search.

You can use phpmyadmin, visit table products in your database and check the master_category_id of each product to see if there is anything weird.

[benn600]

Good time for a question. Master categories id is completely and fully blank for what looks like all records.

I put products in categories with the products_to_categories table.

Remember I copied this from another different ecommerce system database so this was all done by hand. What should be done? Should they match? products_to_categories allows multiple categories. So is the master one supposed to be the primary category?

This could definitely be the problem! What do you think?

[yellow1912]

first, back up your database. back it up first!!!
Then lets try to do something here:

You can use the search function in PhpMyadmin, and search for products with blank master_categories_id, then set the ids to the id of the category it should belong to. This works if you dont have too many products like that.

Let me know if you found too many products like that, we may try another way.

[benn600]

Can you help me figure the steps out a bit? I don't need to back the database up because this is all being pulled from another source. We're taking an existing Miva Merchant store and creating a new Zen Cart one. At some point we're gonna clear the database and start over with fresh data because the data I put in is several months old.

But what are the steps in more detail please? Do I need to run some SQL? I am moderately good at it but am not sure because there are multiple categories for several products so which one gets picked? I wouldn't mind if it was just random.