<html dir="ltr"><head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style title="owaParaStyle">P {
MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px
}
</style>
</head>
<body ocsi="x">
<p>Hello everyone,<br>
<br>
We are in the process of creating a new install of OpenCms 7.0.5. Everything appears to install correctly. However, once we attempt to edit any page, folder, etc we are unable to do so. No menu appears when you click on the page icons. The direct edit buttons
work on the pages included with Template Two module. When I attempt to create a new page, no resources are available. We created a site using OpenCms 7.0.4 and the application worked correctly.</p>
<p><font face="times new roman"></font> </p>
<p>Based on the error message in the log, it appears that there is a problem with the SQL syntax for MS SQL. 'CONCAT ' does not work in MSSQL. Is anyone else experiencing these problems?
</p>
<p><br>
<strong>Our set-up is below:</strong><br>
Tomcat Version: Apache Tomcat/5.5.12<br>
JVM Version: 1.5.0_05-b05<br>
JVM Vendor: Sun Microsystems Inc.<br>
OS Name: Windows 2003<br>
OS Version: 5.2<br>
Database: MSSQL 2000<br>
<br>
<font face="times new roman">Error:</font></p>
<p><font face="times new roman"></font> </p>
<p>11 Aug 2008 13:12:55,570 ERROR [explorer.CmsExplorerTypeAccess: 235] Error reading groups of user Admin<br>
org.opencms.db.CmsDbSqlException: Error reading all roles for user "Admin" over resource "/release/".<br>
at org.opencms.db.CmsDbSqlException.createException(CmsDbSqlException.java:116)<br>
at org.opencms.db.CmsDbContext.throwException(CmsDbContext.java:238)<br>
at org.opencms.db.CmsDbContext.report(CmsDbContext.java:212)<br>
at org.opencms.db.CmsSecurityManager.getRolesForResource(CmsSecurityManager.java:2257)<br>
at org.opencms.security.CmsRoleManager.getRolesForResource(CmsRoleManager.java:260)<br>
at org.opencms.workplace.explorer.CmsExplorerTypeAccess.getPermissions(CmsExplorerTypeAccess.java:232)<br>
at org.opencms.workplace.explorer.CmsExplorerTypeSettings.isEditable(CmsExplorerTypeSettings.java:458)<br>
at org.opencms.workplace.explorer.CmsExplorerContextMenuBuilder.contextMenu(CmsExplorerContextMenuBuilder.java:139)<br>
at org.apache.jsp.WEB_002dINF.jsp.online.system.workplace.views.explorer.contextmenu_jsp._jspService(org.apache.jsp.WEB_002dINF.jsp.online.system.workplace.views.explorer.contextmenu_jsp:42)<br>
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)<br>
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)<br>
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)<br>
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)<br>
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)<br>
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)<br>
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)<br>
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)<br>
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:672)<br>
at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:574)<br>
at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:499)<br>
at org.opencms.flex.CmsFlexRequestDispatcher.includeExternal(CmsFlexRequestDispatcher.java:194)<br>
at org.opencms.flex.CmsFlexRequestDispatcher.include(CmsFlexRequestDispatcher.java:169)<br>
at org.opencms.loader.CmsJspLoader.service(CmsJspLoader.java:1193)<br>
at org.opencms.flex.CmsFlexRequestDispatcher.includeInternalWithCache(CmsFlexRequestDispatcher.java:423)<br>
at org.opencms.flex.CmsFlexRequestDispatcher.include(CmsFlexRequestDispatcher.java:173)<br>
at org.opencms.loader.CmsJspLoader.dispatchJsp(CmsJspLoader.java:1227)<br>
at org.opencms.loader.CmsJspLoader.load(CmsJspLoader.java:1171)<br>
at org.opencms.loader.CmsResourceManager.loadResource(CmsResourceManager.java:964)<br>
at org.opencms.main.OpenCmsCore.showResource(OpenCmsCore.java:1498)<br>
at org.opencms.main.OpenCmsServlet.doGet(OpenCmsServlet.java:152)<br>
at org.opencms.main.OpenCmsServlet.doPost(OpenCmsServlet.java:164)<br>
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)<br>
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)<br>
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)<br>
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)<br>
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)<br>
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)<br>
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)<br>
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)<br>
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541)<br>
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)<br>
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)<br>
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:868)<br>
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:663)<br>
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)<br>
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)<br>
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)<br>
at java.lang.Thread.run(Unknown Source)<br>
Caused by: org.opencms.db.CmsDbSqlException: An SQL error occurred when executing the following query:
<a href="mailto:net.sourceforge.jtds.jdbc.JtdsPreparedStatement@e8dd96">net.sourceforge.jtds.jdbc.JtdsPreparedStatement@e8dd96</a>.
<br>
at org.opencms.db.generic.CmsVfsDriver.getResourceOus(CmsVfsDriver.java:1892)<br>
at org.opencms.db.generic.CmsVfsDriver.readRelations(CmsVfsDriver.java:1775)<br>
at org.opencms.db.CmsDriverManager.getResourceOrgUnits(CmsDriverManager.java:4100)<br>
at org.opencms.db.CmsDriverManager.getRolesForResource(CmsDriverManager.java:4200)<br>
at org.opencms.db.CmsSecurityManager.getRolesForResource(CmsSecurityManager.java:2255)<br>
... 44 more<br>
Caused by: java.sql.SQLException: 'CONCAT' is not a recognized function name.<br>
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)<br>
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)<br>
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)<br>
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)<br>
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:418)<br>
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:693)<br>
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)<br>
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)<br>
at org.opencms.db.generic.CmsVfsDriver.getResourceOus(CmsVfsDriver.java:1877)<br>
... 48 more</p>
<p><br>
<br>
<br>
<br>
Patricia Padilla</p>
</body>
</html>