http://kbpublisher.com/forums/ KBPublisher Forums » Topic: KB 2.1 en Thu, 09 Feb 2012 18:15:33 +0000 http://kbpublisher.com/forums/topic.php?id=159#post-471 Fri, 15 Jan 2010 08:24:49 +0000 onesign 471@http://kbpublisher.com/forums/ <p>Ah, yes. You should add fulltext index on body field. </p> http://kbpublisher.com/forums/topic.php?id=159#post-470 Mon, 11 Jan 2010 12:01:02 +0000 nidave 470@http://kbpublisher.com/forums/ <p>Spoke too soon<br /> I keep getting<br /> Database error!<br /> It is possible server is overloaded. Try again or come back later. </p> http://kbpublisher.com/forums/topic.php?id=159#post-469 Mon, 11 Jan 2010 09:59:28 +0000 nidave 469@http://kbpublisher.com/forums/ <p>thanks very much. :) </p> http://kbpublisher.com/forums/topic.php?id=159#post-468 Mon, 11 Jan 2010 00:40:11 +0000 onesign 468@http://kbpublisher.com/forums/ <p>client/inc/KBClientSearchGenerator.php</p> <p>from<br /> $sql['select'] = "MATCH (e.title, e.body, e.meta_keywords, e.meta_description) AGAINST ('$str') AS score";<br /> $sql['where'] = "MATCH (e.title, e.body, e.meta_keywords, e.meta_description) AGAINST ('$str' IN BOOLEAN MODE)";<p>to<br /> $sql['select'] = "MATCH (e.body) AGAINST ('$str') AS score";<br /> $sql['where'] = "MATCH (e.body) AGAINST ('$str' IN BOOLEAN MODE)";<p>it will search only by body field </p> http://kbpublisher.com/forums/topic.php?id=159#post-464 Thu, 07 Jan 2010 15:44:16 +0000 nidave 464@http://kbpublisher.com/forums/ <p>I am using the free version of the script as an internal knowledge base within the office. (once I get the money I will pay for the latest version) however I want to change the way the searches are done. I want to just search through the meta keywords not the body of the article. I assume I need to change KBClientSearchModel.php and </p> <p>$sql = "<br /> oSELECT<br /> oe.*,<br /> oSUBSTRING_INDEX(e.body,' ',70) AS body, </p> <p>I think the change needs to be<br /> SUBSTRING_INDEX(e.meta_keywords,' ',70) AS meta_keywords,</p> <p>I have no great knowledge with PHP and SQL so am making guesses. </p> <p>I would be very grateful for any help.<br /> Dave </p>