December 12, 2010 in Feedback
There are times when searching a site for things like SQL / URL / SSL / EPS / PDF are part of the lexicon of the members within the forums.
And more times then not they are trying to specifically search for these terms within the content of the site.
However due to the fact SQL imposes limits on terms < 4 characters it makes it impossible to search for such items. In theory an idea:
Admin creates a table of "safe" words that users on the site would most likely search for. (like the example above)
each one of these terms has a unique key associated with it perhaps the ASCII or MD5 equivalent - . and stored with the post or some other table that says "hey this post has the term SQL in it."
SQL in ASCII & #83 ;& #81;& #76; (space added so it displays here)
SQL as MD5 9778840a0100cb30c982876741b0b5a2
When the user does a search for the term the search operation first takes the term "SQL" and converts it to the ID/ASCII or MD5 from that table and then uses THAT as an additional parameter for
searching the the forum.
OR it puts in to a field a tag that wraps the term like sql to be _sql_ so that the value > than the 4 min. that field is also included in the search so that the post is found.
Currently - users needing to search my site (even me searching this site) i have to rely on to google return results on the domain.
Thoughts, recommendations, ideas?
You can try reducing the minimum word size from 4 letters to 3 and see if it works for your site. It depends on the configuration of the SQL server and may or may not work. If you are offering a suggestion for a future version of IPB, then please make it in the feedback forum.
Kessler go ahead move the topic - to the right forum ---
point of contentions is that there are SO many forums here that have the EXACT same Title - IP.Board / IP. Content. creates confusion when posting
after making a search (prob. not in this case ) but in general.
Stephen - why not just install Sphinx as your search engine. It can then search three letter words, or even two letter words. I use it on my site to great effect, much better than using MySQL to search.
This topic is now archived and is closed to further replies.
403 - Forbiddeen
Started 2 hours ago
Started 1 hour ago
Started 26 minutes ago