[opencms-dev] where do I post a log file

tony tony at tgds.net
Wed Nov 24 14:54:54 CET 2004


Le mercredi 24 novembre 2004 à 13:40 +0100, Tristan Tarrant a écrit :
> On Wed, 2004-11-24 at 12:46 +0100, tony wrote:
> > com.opencms.core.CmsException: 4 Sql exception. Detailed error:
> > [com.opencms.file.genericSql.CmsDbAccess]ERROR:  Function concat
> > (character varying, "unknown") does not exist
> >         Unable to identify a function that satisfies the given
> > argument types
> >         You may need to add explicit typecasts
> > . 
> > root cause was java.sql.SQLException: ERROR:  Function concat
> > (character varying, "unknown") does not exist
> >         Unable to identify a function that satisfies the given
> > argument types
> >         You may need to add explicit typecasts
> 
> This is the error. My guess is that the generic sql scripts use the
> concat function, but your DB (PostgreSQL I guess) doesn't support it.

Postgres has strict data typing. The fuvtion is OK but the data types
must be specified

> FYI: A friend of mine is currently adding specific PostgreSQL support
> to the CVS version of OpenCMS 6.x. As soon as we've done enough
> testing we will give it to Alkacon for inclusion.

I would like to play with it. If he doesn't mind letting me see it.

Cheers

Tony Grant




More information about the opencms-dev mailing list