What's your database collation set to for your products_description table, particularly the products_description column *in* the products_description table? I suspect it's set to something that's not _ci (case-insensitive).
Thread: Search box does not work
Results 1 to 10 of 12
Hybrid View
-
22 Jun 2011, 07:09 PM #1
Sensei
- Join Date
- Jan 2004
- Posts
- 66,446
- Plugin Contributions
- 81
Re: Search box does not work
.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole
Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.
-
23 Jun 2011, 03:59 AM #2
Zen Follower
- Join Date
- Sep 2006
- Posts
- 449
- Plugin Contributions
- 0
Re: Search box does not work
where would I find that information?
-
23 Jun 2011, 04:07 AM #3
Sensei
- Join Date
- Jan 2004
- Posts
- 66,446
- Plugin Contributions
- 81
Re: Search box does not work
phpMyAdmin
.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole
Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.
-
23 Jun 2011, 04:29 AM #4
Zen Follower
- Join Date
- Sep 2006
- Posts
- 449
- Plugin Contributions
- 0
Re: Search box does not work
ok, this is way out of my zone, but I went into phpmyadmi and clicked on products_description. Then I went to the products_description column. All of them say [BLOB and the size of the files ].
does that make sense?
-
23 Jun 2011, 05:05 AM #5
Sensei
- Join Date
- Jan 2004
- Posts
- 66,446
- Plugin Contributions
- 81
Re: Search box does not work
Hmmm ... no, I would have expected them to be TEXT, not BLOB.
See this image:[scr]http://www.zen-cart.com/forum/attachment.php?attachmentid=9399&stc=1&d=1308801903[/scr].
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole
Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.
-
23 Jun 2011, 05:17 AM #6
Zen Follower
- Join Date
- Sep 2006
- Posts
- 449
- Plugin Contributions
- 0
Re: Search box does not work
ok, yeah, i see where you are and it does say text. I tried to attach a print screen so you can see what I have, I hope it works.
-
23 Jun 2011, 05:19 AM #7
Zen Follower
- Join Date
- Sep 2006
- Posts
- 449
- Plugin Contributions
- 0
Re: Search box does not work
here is the second half. I notice there is a difference in the collation. So would I need to edit that?
Reply With QuoteSimilar Threads
-
v151 Add Items does not work after a Search
By katrobb in forum Managing Customers and OrdersReplies: 2Last Post: 15 Sep 2014, 06:35 PM -
Search Feature on Home Page Does Not Work
By Jay Racing in forum General QuestionsReplies: 2Last Post: 30 Jun 2010, 01:04 PM -
Developers Tool Kit search does not work..
By yuppicide in forum Templates, Stylesheets, Page LayoutReplies: 5Last Post: 10 Mar 2010, 11:23 PM -
My search function does not work properly
By idtags in forum General QuestionsReplies: 2Last Post: 1 Nov 2007, 05:40 PM
