Please activate SQL-level debugging:
In $JBOSS/server/default/conf/jboss-log4j.xml add:
<category name="org.nuxeo.ecm.core.storage.sql">
<priority value="TRACE" />
</category>
and bump the levelMin value to TRACE in the CONSOLE appender.
Then have a look at the generated query at the PostgreSQL level that
gives the error.
It would be good if you also found somewhere in the logs the
corresponding NXQL query.
Florent
On Mon, Aug 23, 2010 at 5:02 PM, Raimund Sacherer <[email protected]> wrote:
> Hello,
>
> I managed to integrate fields from a custom document in the advanced search.
> If I search for one field it seems to work quite fine, but if I search for
> two fields I get the above postgreSQL error.
>
> Does anybody have any idea what's wrong?
>
> I attached all the files from my jar which I think correspond to the advanced
> search, I am very new to Nuxeo and hope someone will be able to help me out,
>
> best regards
> Raimund
>
>
>
>
> -
> RunSolutions
> Open Source It Consulting
> -
> Email: [email protected]
>
> Parc Bit - Centro Empresarial Son Espanyol
> Edificio Estel - Local 3D
> 07121 - Palma de Mallorca
> Baleares
>
--
Florent Guillaume, Director of R&D, Nuxeo
Open Source, Java EE based, Enterprise Content Management (ECM)
http://www.nuxeo.com http://www.nuxeo.org +33 1 40 33 79 87
_______________________________________________
ECM mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm
To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm
