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
Line 3: Line 3:
 
Access the Supportworks Server
 
Access the Supportworks Server
  
−
# Stop the following services via the services console: services.msc
+
# 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):
 
# Edit the following file (where <installPath:> = drive and path of the Supportworks server installation):
 
#:<installPath>Core Services\SwSQLServer\Bin\SwSQL.ini  
 
#:<installPath>Core Services\SwSQLServer\Bin\SwSQL.ini  
Line 11: Line 20:
 
# Run the SupportWorks Interactive SQL Program (Start->Programs->Hornbill Core Services->Interactive SQL)
 
# Run the SupportWorks Interactive SQL Program (Start->Programs->Hornbill Core Services->Interactive SQL)
 
# Enter the following SQL
 
# Enter the following SQL
−
#:<pre>Use sw_knowledgebase;Alter Table KbDocuments Drop Index Title;ALTER TABLE kbdocuments ADD FULLTEXT (Title,Keywords,Problem,Solution,CallProbCode);
+
#:<pre>Use sw_knowledgebase;</pre>
−
# Thereafter restart the SwSql server service and all remaining services.
+
#:<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

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=686’