01-13-2010, 11:29 AM
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
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