Sophie

Sophie

distrib > Mandriva > 10.0-com > i586 > by-pkgid > 9331a96c41b6b23ff233bf4b8bb14b39 > files > 3

egroupware-phpbrain-1.0-0.RC3.1mdk.noarch.rpm

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

KnowldgeBase is based on phpBrain by B@rt - 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);
----