Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Search function
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Search function

 Post Reply Post Reply
Author
wyntuition View Drop Down
Newbie
Newbie


Joined: 19 May 2003
Status: Offline
Points: 6
Post Options Post Options   Thanks (0) Thanks(0)   Quote wyntuition Quote  Post ReplyReply Direct Link To This Post Topic: Search function
    Posted: 19 May 2003 at 8:54am

I am having strange results with the search function.  We have a forum topic called "passwords".  When searching the forum topics for 'password' it does not find any matches.  The word 'passwords?' is also in the body of a reply in that topic, and searching bodies for "password" does not find anything. 

The search function will find other words, just not password.  Any ideas?

Wyn

Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 19 May 2003 at 9:15am

You didn't say which version you are using, but I have just tested this with the latest version with a topic called 'passwords' containing the text 'passwords' and no matter if I searched on topic subject or within the message itself, by putting in either 'passwords' or 'password' returned the topic in the results.

I also did a search on this forum for 'passwords' and this topic was sucessfully found in the search.

Back to Top
wyntuition View Drop Down
Newbie
Newbie


Joined: 19 May 2003
Status: Offline
Points: 6
Post Options Post Options   Thanks (0) Thanks(0)   Quote wyntuition Quote  Post ReplyReply Direct Link To This Post Posted: 19 May 2003 at 9:35am

I can't find the version number, but we downloaded it about a month ago and it's using the access 2000 database. 

Is it possible for some variable named password in the code messing it up?  Rather strange...

Thanks very much,

Wyn

Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 19 May 2003 at 9:41am
The version number is displayed at the bottom of every page in the forum next to the link back to web wiz guide.
Back to Top
rpex View Drop Down
Newbie
Newbie


Joined: 19 September 2003
Location: Sweden
Status: Offline
Points: 1
Post Options Post Options   Thanks (0) Thanks(0)   Quote rpex Quote  Post ReplyReply Direct Link To This Post Posted: 19 September 2003 at 3:51am

Hello

there is a problem in the search engine. Some words are translated between user-input and storage in the database. look at the code below:

'Get rid of malicous code in the message
strInputEntry = Replace(strInputEntry, "script", "script", 1, -1, 0)
strInputEntry = Replace(strInputEntry, "SCRIPT", "SCRIPT", 1, -1, 0)
strInputEntry = Replace(strInputEntry, "Script", "Script", 1, -1, 0)
strInputEntry = Replace(strInputEntry, "script", "Script", 1, -1, 1)
strInputEntry = Replace(strInputEntry, "object", "object", 1, -1, 0)
strInputEntry = Replace(strInputEntry, "OBJECT", "OBJECT", 1, -1, 0)

... an so on

deleteing this code will be a solution but is also a security problem.

Example: The Word 'Script" will be translated to 'Script' and saved into the database. the search engine does not take note of this modification, so the word will be not found.

Solution: Translate the serach-string before searching the database.

 

Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 19 September 2003 at 4:12am

If you look closly at the search file it also uses the same filters so that the data stored in the database and the search keywords enterd both match as both are filtered and encoded in the same way.

Changing what you have done above can cousre the search function not to run correctly.

Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.