Difference between revisions of "Knowledgebase Search: 3 letter term in search, no results are being returned"
Jump to navigation
Jump to search
(Created page with "In order to allow three character searches in the knowledgebase please carry out the following: Access the Supportworks Server 1..Stop All Services from the services console...") |
|||
(3 intermediate revisions by 2 users not shown) | |||
Line 3: | Line 3: | ||
Access the Supportworks Server | Access the Supportworks Server | ||
− | + | # Stop the following services via the services console(services.msc): | |
− | + | #:SwMailSchedule | |
− | + | #:SwMailService | |
− | + | #:SwServerService | |
− | + | #:SwSchedulerService | |
− | + | #:SwMessengerService | |
− | + | #:SwIndexserver | |
− | + | #:SwFileService | |
− | + | #:SwCalendarService | |
− | + | #:SwSqlServer | |
− | + | # Edit the following file (where <installPath:> = drive and path of the Supportworks server installation): | |
− | + | #:<installPath>\Core Services\SwSQLServer\Bin\SwSQL.ini | |
− | + | # Add the following parameter and Save the changes | |
− | + | #:<pre>set-variable = ft_min_word_len=3</pre> | |
− | + | # Restart Only the SwSQLServer | |
− | + | # Run the SupportWorks Interactive SQL Program (Start->Programs->Hornbill Core Services->Interactive SQL) | |
− | + | # Enter the following SQL | |
− | + | #:<pre>Use sw_knowledgebase;</pre> | |
+ | #:<pre>Alter Table KbDocuments Drop Index Title;ALTER TABLE kbdocuments ADD FULLTEXT(Title,Keywords,Problem,Solution,CallProbCode);</pre> | ||
+ | # Restart the following services: | ||
+ | #:SwSqlServer | ||
+ | #:SwCalendarService | ||
+ | #:SwFileService | ||
+ | #:SwIndexserver | ||
+ | #:SwMessengerService | ||
+ | #:SwSchedulerService | ||
+ | #:SwServerService | ||
+ | #:SwMailService | ||
+ | #:SwMailSchedule |
Latest revision as of 16:07, 20 July 2015
In order to allow three character searches in the knowledgebase please carry out the following:
Access the Supportworks Server
- Stop the following services via the services console(services.msc):
- SwMailSchedule
- SwMailService
- SwServerService
- SwSchedulerService
- SwMessengerService
- SwIndexserver
- SwFileService
- SwCalendarService
- SwSqlServer
- Edit the following file (where <installPath:> = drive and path of the Supportworks server installation):
- <installPath>\Core Services\SwSQLServer\Bin\SwSQL.ini
- Add the following parameter and Save the changes
set-variable = ft_min_word_len=3
- Restart Only the SwSQLServer
- Run the SupportWorks Interactive SQL Program (Start->Programs->Hornbill Core Services->Interactive SQL)
- Enter the following SQL
Use sw_knowledgebase;
Alter Table KbDocuments Drop Index Title;ALTER TABLE kbdocuments ADD FULLTEXT(Title,Keywords,Problem,Solution,CallProbCode);
- Restart the following services:
- SwSqlServer
- SwCalendarService
- SwFileService
- SwIndexserver
- SwMessengerService
- SwSchedulerService
- SwServerService
- SwMailService
- SwMailSchedule