| Author |
 Topic  |
|
Maarten
Starting Member
Netherlands
22 Posts |
 Posted - 16 August 2002 : 13:28:07
|
It might be an idea to disable (block) common words (the and an etc) in the searchengine query's. Also i am able to search for '%' (everything in SQL). A couple of these requests can kill your hosts cpu time or even stop answering requests.
I don't really know if this is fixed in a later version or versions that are in development at this moment but it might be better to block those things.
I'm using version 3.3.05 myself and i am able to search for '%'.
Is this a known issue? |
A bartender is just a pharmacist with a limited inventory. |
|
|
Nathan
Help Moderator
USA
7664 Posts |
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 16 August 2002 : 14:13:22
|
We would just need a list of all characters that would need to be filtered out.
I'd also like to set a minimum # of characters for the search words, maybe at least 5? |
 |
|
|
davemaxwell
Access 2000 Support Moderator
USA
3020 Posts |
Posted - 16 August 2002 : 14:22:06
|
| If it's five, you couldn't search for things like XML, .NET, CSS, v3.4, etc... |
Dave Maxwell
Barbershop Harmony Freak |
|
|
|
Maarten
Starting Member
Netherlands
22 Posts |
Posted - 16 August 2002 : 14:27:09
|
| If things are really bad you might even fill in sql queries that you really don't want a user to do. But i guess that is being checked already? |
A bartender is just a pharmacist with a limited inventory. |
|
|
|
Nathan
Help Moderator
USA
7664 Posts |
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 16 August 2002 : 14:46:39
|
this is all that is being checked for:
fString = Replace(fString, "'", "''")
fString = replace(fString, ">", ">")
fString = replace(fString, "<", "<")
|
|
|
|
Aaron S.
Average Member
USA
985 Posts |
Posted - 16 August 2002 : 14:54:18
|
A minimum of 3 characters should suffice. That is what I use on my other sites for search.
--Aaron
|
DOWNLOAD GREAT NEW MODS HERE |
|
|
|
davemaxwell
Access 2000 Support Moderator
USA
3020 Posts |
Posted - 16 August 2002 : 15:08:00
|
quote:
Originally posted by Aaron S.
A minimum of 3 characters should suffice. That is what I use on my other sites for search.
--Aaron
As long as you ignore words like the, why, etc. |
Dave Maxwell
Barbershop Harmony Freak |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
|
|
davemaxwell
Access 2000 Support Moderator
USA
3020 Posts |
Posted - 16 August 2002 : 15:08:47
|
quote:
Originally posted by HuwR
not sure it would help, and it would certainly irritate me if I could no longer search for
a e i o u 
And sometimes y?  |
Dave Maxwell
Barbershop Harmony Freak |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
|
|
Aaron S.
Average Member
USA
985 Posts |
Posted - 16 August 2002 : 15:17:03
|
Of course why not just have it be an admin function:
1. Minimum length (if any)
2. Excluded words
Should be an easy MOD if it is not something we want in the core code.
--Aaron
|
DOWNLOAD GREAT NEW MODS HERE |
|
|
|
Nathan
Help Moderator
USA
7664 Posts |
Posted - 16 August 2002 : 15:55:17
|
quote:
Originally posted by davemaxwell
quote:
Originally posted by HuwR
not sure it would help, and it would certainly irritate me if I could no longer search for
a e i o u
And sometimes y?
And on very rare occations, w  |
 Nathan Bales
CoreBoard | Active Users Download |
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 16 August 2002 : 16:55:39
|
You can look in \winnt\system32 on a computer with SQL Server installed and find files that the server uses to identify "noise" words.
The file(s) are named "noise.zzz" where the zzz is by language.
I think there are more noise word files in the free text search folder in the mssql program files, too.
|
======
Doug G
======
Computer history and help at www.dougscode.com |
|
|
|
Deleted
deleted
4116 Posts |
Posted - 16 August 2002 : 17:48:04
|
| Doug, thank you for the info... I think $ is used for end of file, with the ones below that are readied for cut-paste. It was interesting to see that English file is 1kb and German one is 147 kb... |
 Stop the WAR! |
|
|
|
Topic |
|
Topic Locked
