PDMP Webmaster Posted December 10, 2010 Share Posted December 10, 2010 Hi all, Please see my customer's store here. He recently started adding products and was testing the search function when he noticed some funny things, so he asked me to look into it. It seems the search function has trouble with non-alphanumeric characters, which isn't such a big deal. I've seen previous threads where words with a character length less than 4 gave errors, but that seems to be corrected (I'm running v4.4.2) for the most part, though I'll return to that in a bit. I've also seen threads regarding a MySQL error, which I haven't had come up. What I find really bizarre is that the search string 'plate 23 audubon' returns a hit, but 'audubon plate 23' does not. This is quite an issue, since as a store selling antique prints, it would be very conceivable for someone to come in and search 'audubon' to find prints by that artist. Eventually there'll be a few hundred Audubon's in there, so it'd be reasonable if say a collector comes by, to narrow the search by expanding it to 'audubon plate 23'. If nothing comes up, the customer will conclude we don't have it and move on, probably not thinking to try 'plate 23' or 'plate 23 audubon' instead. Any ideas why this may be happening, and any potential solutions? Here's another weird thing: I search for 'birds of america', and I get hits. I expand to 'birds of america royal', and I get hits. 'birds of america royal octavo', still fine. 'birds of america royal octavo edition', no problem. 'birds of america royal octavo edition audubon', still ok. ' birds of america royal octavo edition audubon artist', and suddenly I get no hits. I tried removing 'of', so I search for 'birds america royal octavo edition audubon artist', and that works, so I'm thinking either it's a wordcount threshold or an error with a two character word. To test the former, I search 'birds america royal octavo edition audubon artist buzzard', and that works, so it doesn't seem to be a maximum wordcount issue. Why would a two letter word cause a problem there, but not by itself or earlier? I really don't get it. I have a good idea of which fields are indexed upon entering products, so my understanding of a database is that typically all words (minus certain exclusions, such as special characters, 'a', 'the', etc.) within those fields would be added to an index, or dictionary, and that when a search string is entered it queries that file. What could be causing the above errors? We're hoping not to have to put some sort of message in bold on the homepage letting customers know the search function has a mind of its own and to try a myriad of search string combinations before concluding we don't carry something. Anyway, if you have any suggestions I'm all ears. Hopefully the above doesn't sound like some tirade, I'm calm and collected, just rather confused. -Josh Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.