The help desk software we got conceptionally works well, and I know as soon as I get a few of these little bugs worked out it will be great addition to our system. I am how ever having a problem with the search functionality.
When I do a search on the knowlege base after creating a new problem and adding it to the knowlede base, via the "Enter in Knowledge Base" check mark and than hiting submit Problem. It returns no results, either with % or with a word from the title, subject, etc. There is no error message, just simply stats
"No results found"
Can someone tell me what I am doing wrong?
Thanks
Mike
General Parts LLC
I actually was able to read on the old forum a note about it only seaching closed Tickets. I closed one of the tickets I had in the system and it worked.
i encountered also same problem... i modify the default.asp in kb folder.
i modified the sql command freetext() function was change to like
can you show precisely what satement you changed with exactly what...some of us are not sql gurus.
thx
Here's the section below, do you mean to say you've changed as shown in bold? your response is appreciated.
If Cfg(cnnDB, "KBFreeText") = 1 Then If Request.Form("title") = "on" Or blAllOff Then If Len(strWhere2) < 1 Then strWhere2 = " AND (FREETEXT LIKE (title, '" & keywords & "')" Else strWhere2 = strWhere2 & " OR FREETEXT LIKE (title, '" & keywords & "')" End If End If If Request.Form("description") = "on" Or blAllOff Then If Len(strWhere2) < 1 Then strWhere2 = " AND (FREETEXT LIKE (description, '" & keywords & "')" Else strWhere2 = strWhere2 & " OR FREETEXT LIKE (description, '" & keywords & "')" End If End If If Request.Form("solution") = "on" Or blAllOff Then If Len(strWhere2) < 1 Then strWhere2 = " AND (FREETEXT LIKE (solution, '" & keywords & "')" Else strWhere2 = strWhere2 & " OR FREETEXT LIKE(solution, '" & keywords & "')" End If End If