[Phpgroupware-cvs] CVS: phpbrain/doc INSTALL,NONE,1.1 README,NONE,1.1

[Dave Hall <address@hidden>]

Update of /cvsroot/phpgroupware/phpbrain/doc
In directory subversions:/tmp/cvs-serv29642/doc

Added Files:
        INSTALL README 
Log Message:
added some docs

--- NEW FILE ---
KnowledgeBase Install

KnowledgeBase is a phpGroupWare application designed to run on all versions 
from 0.9.14 to 0.9.16.  Please grab phpGroupWare from http://phpgroupware.org

The application uses the normal phpgw setup3 install process.

KnowledgeBase will run any version of PHP from 4.1.0 and up.

KnowledgeBase has been tested on both pgsql and mysql.

KnowledgeBase is register_globals = off and error_reporting = E_ALL compliant.

Post Install Instructions for mySQL users:
Please run the follow command from with in mySQL:
ALTER TABLE phpgw_kb_faq ADD FULLTEXT(text,keywords,title);

--- NEW FILE ---
KnowledgeBase
Written by Dave Hall - skwashd at phpgroupware.org
Sponsored by Reiner Jung - r.jung at creativix.net

KnowldgeBase is based on phpBrain by address@hidden - http://vrotvrot.com/
Most of the code is original work, but was inspired by phpBrain, which is used 
for the BlenderBase - http://vrotvrot.com/support


KNOWN ISSUES
----
SQL error when searching using mySQL:
Symptom: 
Database error: Invalid SQL: SELECT *, MATCH text,keywords,title 
AGAINST('something') AS score FROM phpgw_kb_faq WHERE published = 1 ORDER BY 
score DESC
MySQL Error: 1191 (Can't find FULLTEXT index matching the column list)
File: /path/to/phpgroupware/phpbrain/inc/class.sokb.inc.php

Cause:
The FULLTEXT index has not be created on the phpgw_kb_faq table.  This is a 
limitation of the phpgw db setup tools.  You must create the index manually.

Fix:
Run this in mySQL
ALTER TABLE phpgw_kb_faq ADD FULLTEXT(text,keywords,title);
----