+- Community Support for OpenDocMan (Deprecated) (https://forum.opendocman.com)
+-- Forum: OpenDocMan Community Discussion (https://forum.opendocman.com/forum-5.html)
+--- Forum: OpenDocMan Support - Community Based (https://forum.opendocman.com/forum-6.html)
+--- Thread: Problem with Search (/thread-76.html)
Problem with Search - Stephen - 01-13-2010
artmach2
2004-10-26 03:36:22 PDT
I'm a user of OpenDocMan v1.2p1, I install it few days ago.
There is a problem with Search. If I put the word and
mark "case sensitivy" I get an error:
Error in query: SELECT data.id FROM data, user, department,
category WHERE data.owner = user.id AND
data.department=department.id AND data.category = category.id
AND (category.name REGEXP BINARY 'instrukcja' OR
user.first_name REGEXP BINARY 'instrukcja' OR user.last_name
REGEXP BINARY 'instrukcja' OR department.name REGEXP
BINARY 'instrukcja' OR data.description REGEXP
BINARY 'instrukcja' OR data.realname REGEXP BINARY 'instrukcja'
OR data.comment REGEXP BINARY 'instrukcja') ORDER BY data.id
ASCYou have an error in your SQL syntax
near 'BINARY 'instrukcja' OR user.first_name REGEXP
BINARY 'instrukcja' OR user.last_n' at line 1
On any other combinations I have answer "No files found"
Thanks for any solutions.
Artur
logart
2004-10-28 14:21:11 PDT
I will have to do some more testing on this. Seems there are some issues but I was unable to get the error message you got.
steve