Dynacase » Platform » Core

Application :

FGSEARCH

Filtre :

(eric);

Erreur :

[Fri Jun 07 10:02:23 2013] [error] [client 10.0.2.2] {DB0005} query prepare error : ERROR:  syntax error at or near "svalues"\nLINE 1: ...S') and ((  (fulltext @@ '''eric'' | '
'eric'''))  svalues ~*...\n                                                             ^\n\nselect docread.id, owner, title, revision, version, initid, fromid, doctype, locked
, allocated, archiveid, icon, lmodify, profid, usefor, cdate, adate, revdate, comment, classname, state, wid, postitid, domainid, lockdomainid, cvid, name, dprofid, atags, prel
id, confidential, ldapdn, values, svalues, attrids  from  docread  where   (docread.archiveid is null) and (docread.doctype != 'Z') and (docread.doctype != 'T') and (docread.lo
cked != -1) and (confidential is null or hasaprivilege('{2,11}', profid,1024)) and (usefor !~ '^S') and ((  (fulltext @@ '''eric'' | ''eric'''))  svalues ~* E'\\\\y;\\\\y') and
 (views && '{2,0,11}') ORDER BY ts_rank(fulltext,to_tsquery('french','((eric|Eric));')) desc, id desc LIMIT 11 OFFSET 0;\n, referer: http://localhost:8081/?sole=A&app=FGSEARCH&
keyword=(eric)%3B

Application :

GENERIC&action=GENERIC_TAB

Filtre :

()

Erreur :

[Fri Jun 07 10:03:42 2013] [error] [client 10.0.2.2] 25099> Dynacase got an uncaught exception 'Dcp\\Db\\Exception' with message '{DB0005} query prepare error : ERROR:  syntax
error in tsquery: "()"\n\nselect doc1064.id, owner, title, revision, version, initid, fromid, doctype, locked, allocated, archiveid, icon, lmodify, profid, usefor, cdate, adate
, revdate, comment, classname, state, wid, postitid, domainid, lockdomainid, cvid, name, dprofid, views, atags, prelid, confidential, ldapdn, a_abstract_my_text, a_abstract_lin
ked_text, values, attrids  from  doc1064  where   (doc1064.archiveid is null) and (doc1064.doctype != 'T') and (doc1064.locked != -1) and (fulltext @@ to_tsquery('french','()')
) and  (doctype != 'Z') and (confidential is null or hasaprivilege('{2,11}', profid,1024)) and (views && '{2,0,11}') ORDER BY revdate desc LIMIT 9 OFFSET 0;\n' in file /var/www
/dynacase/dynacase/WHAT/Class.DbObj.php at line 825:, referer: http://localhost:8081/?sole=Y&&app=GENERIC&action=GENERIC_TAB&onefam=DEMO_REFLECT&famid=1064&catg=0&tab=0&viewfld
=no&refresh=no