search not working

[geel]

Thanks Tick. I want to follow your advice but since its a lot of work to change all those, is there a way I can use the site without bringing the changes you mentioned?
I have checked a little, I mean, a member logged in and he tried everything by himself and found no problem so far in searching any products that it listed. I havent configured a lot of things like, languages, shipping, store name, locations and especially the "online payment" part yet and therefore one cant test the site for the full functionality yet. I hope everything will be fine. Lets hope for the best. If you know or think of any apparent issues invloved in if I didnt bring those changes you said, please tell me. I dont want to touch anything that is not needed. Your help will be much appreciated.
Thanks.

[Tick]

You can certainly give it a try. However, it may be worth it to put in the time up front rather than chase problems around later.

At a minimum, do the customers table (if you haven't already). Otherwise, people's email addresses will be case sensitive when they try to log in.

I can't speak to the payment modules. I can't think of a reason off the top of my head why they wouldn't work, however we only use two of them.

[rubbercarp]

Tick -

Thank you for this information.
I was having search problems as well and this fixed my problem.

My hosting providing (Bluehost) also had these tables set to "utf8_bin" and I adjusted them to "utf8_general_ci" and it fixed my search problem.

Aside from the products_name, products_description, and customer tables are there any other tables that you would recommend adjusting?


Thanks again!
This post was a big help.

[Tick]

Tick -

Aside from the products_name, products_description, and customer tables are there any other tables that you would recommend adjusting?


Thanks again!
This post was a big help.

You're most welcome! I'm glad you found the post helpful. Honestly, I would recommend changing all of the tables. I know it's a lot of work, but I think it will come back to bite you if you don't. You never know when a modification to the cart or an add on will assume that database searches are case-insensitive (which is the default behavior for databases) and exhibit weird behavior. If you're anything like me, you'll spend hours troubleshooting it before you remember the collation setting.

If your store is brand new, you could also consider starting from scratch and manually installing. I'm not sure which would be more work.

You may also want to put in a support ticket with BlueHost support and ask them to modify their installer. When we were with them, I always found them very responsive and helpful. If they fix the installer fast enough, you could delete and re-install to get properly set up tables. (Again, assuming you're willing to start over.)

Good luck!

[sw09]

I am having problem with my search and was following this thread. Thanks so much for solving my problem, Tick . I am a newbie and not familiar with much programming but I was able to follow step by step. Now my search engine works. But there are sometimes that if I search or I use the search item starts with, the advance search will sometimes show no result.

My site- http://www.bruneipartyshop.com

I install my zen cart using simple script and is the latest 1.3.8 sp1 version. I did not touch the search file. Is it something that I still have to set?

[Tick]

Now my search engine works. But there are sometimes that if I search or I use the search item starts with, the advance search will sometimes show no result.

I'm not sure what you mean by "search item starts with." What exactly are you doing? Can you provide an example?

When you say that it shows no result, does it return that no items matched or do you get a blank page?

Looks like your site is coming together nicely! If I can make a suggestion: after you get the search issue resolved, you may want to install Image Handler 2. It will greatly speed up your image load times.

[atl2rva]

Thank you for this thread, I have been struggling with this for days! I also am using bluehost as a provider. Note to others I had to change a different file to fix my search. under zen_products i had to make this change to products_model. this is what I was storing my item numbers under when I would add new products.