Difference between revisions of "Knowledgebase Search: 3 letter term in search, no results are being returned"

From support-works
Jump to navigation Jump to search
 
(2 intermediate revisions by the same user not shown)
Line 3: Line 3:
 
Access the Supportworks Server
 
Access the Supportworks Server
  
−
1..Stop All Services from the services console: services.msc
+
# Stop the following services via the services console(services.msc):
−
 
+
#:SwMailSchedule
−
2..Edit the following file C:\Program Files\Hornbill\Core Services\SwSQLServer\Bin\SwSQL.ini (where C: = drive you have installed supportworks server on)
+
#:SwMailService
−
 
+
#:SwServerService
−
3..Add the following parameter and Save the changes
+
#:SwSchedulerService
−
 
+
#:SwMessengerService
−
set-variable = ft_min_word_len=3
+
#:SwIndexserver
−
 
+
#:SwFileService
−
4..Restart Only the SwSQLServer
+
#:SwCalendarService
−
 
+
#:SwSqlServer
−
5..Run the SupportWorks Interactive SQL Program (Start->Programs->Hornbill Core Services->Interactive SQL)
+
# Edit the following file (where <installPath:> = drive and path of the Supportworks server installation):
−
 
+
#:<installPath>\Core Services\SwSQLServer\Bin\SwSQL.ini  
−
6..Enter the following SQL
+
# Add the following parameter and Save the changes
−
 
+
#:<pre>set-variable = ft_min_word_len=3</pre>
−
Use sw_knowledgebase;
+
# Restart Only the SwSQLServer
−
Alter Table KbDocuments Drop Index Title;
+
# Run the SupportWorks Interactive SQL Program (Start->Programs->Hornbill Core Services->Interactive SQL)
−
ALTER TABLE kbdocuments ADD FULLTEXT (Title,Keywords,Problem,Solution,CallProbCode);
+
# 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>
−
7..Thereafter restart the SwSql server service and all remaining services.
+
# 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

  1. Stop the following services via the services console(services.msc):
    SwMailSchedule
    SwMailService
    SwServerService
    SwSchedulerService
    SwMessengerService
    SwIndexserver
    SwFileService
    SwCalendarService
    SwSqlServer
  2. Edit the following file (where <installPath:> = drive and path of the Supportworks server installation):
    <installPath>\Core Services\SwSQLServer\Bin\SwSQL.ini
  3. Add the following parameter and Save the changes 
    set-variable = ft_min_word_len=3
  4. Restart Only the SwSQLServer
  5. Run the SupportWorks Interactive SQL Program (Start->Programs->Hornbill Core Services->Interactive SQL)
  6. Enter the following SQL 
    Use sw_knowledgebase;
    Alter Table KbDocuments Drop Index Title;ALTER TABLE kbdocuments ADD FULLTEXT(Title,Keywords,Problem,Solution,CallProbCode);
  7. Restart the following services:
    SwSqlServer
    SwCalendarService
    SwFileService
    SwIndexserver
    SwMessengerService
    SwSchedulerService
    SwServerService
    SwMailService
    SwMailSchedule
Retrieved from ‘https://wiki.support-works.com/index.php?title=Knowledgebase_Search:_3_letter_term_in_search,_no_results_are_being_returned&oldid=687’