[phpGroupWare-users] Knowledge base search

[Mark Benson]

I have just notice that when you search for more than on term in the Knowledge 
base it throws an error.

Database error: Invalid SQL: SELECT * FROM phpgw_kb_faq WHERE published = 1 
AND(title LIKE '%username%' (title LIKE '%password%' ) OR(keywords LIKE 
'%username%' (keywords LIKE '%password%' ) OR(text LIKE '%username%' (text LIKE 
'%password%' )

MySQL Error: 1064 (You have an error in your SQL syntax; check the manual that 
corresponds to your MySQL server version for the right syntax to use near 
'(title LIKE '%password%' ) OR(keywords LIKE '%username%' (keywords LIKE 
'%passwo' at line 1)

File: /var/www/phpbrain/inc/class.sokb.inc.php
Line: 342

Session halted. Sent from the phpGroupWare forums @ 
http://forums.phpGroupWare.org