[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[phpGroupWare-users] Knowledge base search

From: Mark Benson
Subject: [phpGroupWare-users] Knowledge base search
Date: Fri, 15 Jun 2007 00:26:31 -0700 (MST)

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/
Line: 342

Session halted. Sent from the phpGroupWare forums @

reply via email to

[Prev in Thread] Current Thread [Next in Thread]