<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
<META NAME="GENERATOR" CONTENT="GtkHTML/3.5.0">
</HEAD>
<BODY>
On Wed, 2004-11-24 at 12:46 +0100, tony wrote:<BR>
<BLOCKQUOTE TYPE=CITE>
<TT><FONT COLOR="#000000">com.opencms.core.CmsException: 4 Sql exception. Detailed error: [com.opencms.file.genericSql.CmsDbAccess]ERROR: Function concat(character varying, "unknown") does not exist</FONT></TT><BR>
<TT><FONT COLOR="#000000"> Unable to identify a function that satisfies the given argument types</FONT></TT><BR>
<TT><FONT COLOR="#000000"> You may need to add explicit typecasts</FONT></TT><BR>
<TT><FONT COLOR="#000000">. </FONT></TT><BR>
<TT><FONT COLOR="#000000">root cause was java.sql.SQLException: ERROR: Function concat(character varying, "unknown") does not exist</FONT></TT><BR>
<TT><FONT COLOR="#000000"> Unable to identify a function that satisfies the given argument types</FONT></TT><BR>
<TT><FONT COLOR="#000000"> You may need to add explicit typecasts</FONT></TT><BR>
</BLOCKQUOTE>
<BR>
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.<BR>
<BR>
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.<BR>
<BR>
<BR>
Tristan<BR>
<BR>
</BODY>
</HTML>