| Author |
 Topic  |
|
-gary
Development Team Member
406 Posts |
 Posted - 18 August 2004 : 13:10:15
|
Updated the link in the original message to download version B. Only the search_mssqlft.asp file has changed.
Changes:
- Script checks that there are search terms remaining after removing noise words
- If no terms remain and user is not specified, then graceful error
- If no terms remain and user is specified, then continue search without terms
If you still receive an error about only ignored words, make sure the strNoiseWords string contains all of your servers ignored words. |
KawiForums.com
 |
 |
|
|
Jeepaholic
Average Member
USA
697 Posts |
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 25 August 2004 : 18:31:17
|
quote:
Originally posted by HuwR
well, actually the mod works with all databases from what I can tell, but if you are using Access it just uses the existing search code.
I am going to install the code here later today so everyone can see the improvement.
The code has been running here for about a week, I have not implemented "full text" but you can still see a massive improvement in the search times. (for those that bother to use it  ) |
|
|
|
nickw
Junior Member
Ireland
193 Posts |
Posted - 26 August 2004 : 15:22:49
|
So... how do I add "Noise words"? Please ;)
I assume edit the search_mysqlft.asp and....? |
Nick |
|
|
|
-gary
Development Team Member
406 Posts |
Posted - 26 August 2004 : 15:33:46
|
| Edit the search.asp file, line 49. |
KawiForums.com
|
|
|
|
nickw
Junior Member
Ireland
193 Posts |
Posted - 26 August 2004 : 16:07:42
|
Also.. if I may... I cannot seem to index any of the tables in SQL. Something about Keys :) Appreciate anyones help.
Thanks,
|
Nick |
|
|
|
nickw
Junior Member
Ireland
193 Posts |
Posted - 26 August 2004 : 16:18:28
|
quote:
Originally posted by -gary
Edit the search.asp file, line 49.
Sorry, that was totally obvious :)
Anyone on the full text issue... I have looked at the page mentioned on creating Full Text indexes, but I get an error on the tables when I try to add them. That error is:
The selected table has no
unique single column index on a column that does not allow NULLS.
Database: ForumDB
Table: [dbo].[FORUM_TOPICS]
|
Nick |
|
|
|
-gary
Development Team Member
406 Posts |
Posted - 27 August 2004 : 10:46:14
|
- Go to the SQL Enterprise manager and right-click on forum_topics.
- Select "Design Table".
- Click the "Manage Indexes/Keys" button or right-click in the open space to the right of the columns and select "Indexes/Keys".
- Click "New".
- Under "Column name", select TOPIC_ID.
- Check the "Create UNIQUE" box.
- Check the "Index" radio.
- Click "Close".
- Do the same for the FORUM_REPLY table on the REPLY_ID column
Or run the commands in the CreateIndexs.sql file I've added to the Version C link in the original topic above. |
KawiForums.com
|
|
|
|
nickw
Junior Member
Ireland
193 Posts |
Posted - 27 August 2004 : 13:44:08
|
| Thank you! Worked like a charm. WOW, it is fast :) |
Nick |
|
|
|
nickw
Junior Member
Ireland
193 Posts |
Posted - 27 August 2004 : 13:53:59
|
One last recommendation.
The Forum_A_Topics and Forum_A_Replies need the same done.
Thanks,
|
Nick |
|
|
|
therookery
Starting Member
29 Posts |
Posted - 29 August 2004 : 12:40:53
|
| Would love to have this mod but the zip file in the first post is empty. Can someone point me to the correct zip file? |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
nickw
Junior Member
Ireland
193 Posts |
Posted - 29 August 2004 : 17:20:47
|
| Also, try save to disk as opposed to open. Winzip sometimes gives the effect of no data. |
Nick |
|
|
|
nickw
Junior Member
Ireland
193 Posts |
Posted - 30 August 2004 : 14:36:19
|
Just had a report from a forum user that the following happens on search:
Type in the name of a forum member and nothing else. Click search.
You will see 10 or 20 pages of results, but, when you go to page 2 or 3 it gives the "use must enter keywords" message.
|
Nick |
|
|
|
-gary
Development Team Member
406 Posts |
Posted - 30 August 2004 : 19:01:01
|
Posted version E. This should take care of all variables between using the member drop-down and typed in members that created the paging error. Also cleaned up the display of the search paramaters a bit.
Replaced: search.asp, search_mssql.asp, search_mssqlft.asp |
KawiForums.com
|
|
|
|
Topic |
|
Topic Locked
