[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