[opencms-dev] Unable to edit or create new resources using 7.0.5

[Padilla, Patricia]

Hello everyone,

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.



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?

Our set-up is below:
Tomcat Version: Apache Tomcat/5.5.12
JVM Version: 1.5.0_05-b05
JVM Vendor: Sun Microsystems Inc.
OS Name: Windows 2003
OS Version: 5.2
Database: MSSQL 2000

Error:



11 Aug 2008 13:12:55,570 ERROR [explorer.CmsExplorerTypeAccess: 235] Error reading groups of user Admin
org.opencms.db.CmsDbSqlException: Error reading all roles for user "Admin" over resource "/release/".
 at org.opencms.db.CmsDbSqlException.createException(CmsDbSqlException.java:116)
 at org.opencms.db.CmsDbContext.throwException(CmsDbContext.java:238)
 at org.opencms.db.CmsDbContext.report(CmsDbContext.java:212)
 at org.opencms.db.CmsSecurityManager.getRolesForResource(CmsSecurityManager.java:2257)
 at org.opencms.security.CmsRoleManager.getRolesForResource(CmsRoleManager.java:260)
 at org.opencms.workplace.explorer.CmsExplorerTypeAccess.getPermissions(CmsExplorerTypeAccess.java:232)
 at org.opencms.workplace.explorer.CmsExplorerTypeSettings.isEditable(CmsExplorerTypeSettings.java:458)
 at org.opencms.workplace.explorer.CmsExplorerContextMenuBuilder.contextMenu(CmsExplorerContextMenuBuilder.java:139)
 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)
 at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
 at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
 at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
 at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
 at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:672)
 at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:574)
 at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:499)
 at org.opencms.flex.CmsFlexRequestDispatcher.includeExternal(CmsFlexRequestDispatcher.java:194)
 at org.opencms.flex.CmsFlexRequestDispatcher.include(CmsFlexRequestDispatcher.java:169)
 at org.opencms.loader.CmsJspLoader.service(CmsJspLoader.java:1193)
 at org.opencms.flex.CmsFlexRequestDispatcher.includeInternalWithCache(CmsFlexRequestDispatcher.java:423)
 at org.opencms.flex.CmsFlexRequestDispatcher.include(CmsFlexRequestDispatcher.java:173)
 at org.opencms.loader.CmsJspLoader.dispatchJsp(CmsJspLoader.java:1227)
 at org.opencms.loader.CmsJspLoader.load(CmsJspLoader.java:1171)
 at org.opencms.loader.CmsResourceManager.loadResource(CmsResourceManager.java:964)
 at org.opencms.main.OpenCmsCore.showResource(OpenCmsCore.java:1498)
 at org.opencms.main.OpenCmsServlet.doGet(OpenCmsServlet.java:152)
 at org.opencms.main.OpenCmsServlet.doPost(OpenCmsServlet.java:164)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
 at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541)
 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
 at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:868)
 at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:663)
 at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
 at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
 at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
 at java.lang.Thread.run(Unknown Source)
Caused by: org.opencms.db.CmsDbSqlException: An SQL error occurred when executing the following query: net.sourceforge.jtds.jdbc.JtdsPreparedStatement at e8dd96<mailto:net.sourceforge.jtds.jdbc.JtdsPreparedStatement at e8dd96>.
 at org.opencms.db.generic.CmsVfsDriver.getResourceOus(CmsVfsDriver.java:1892)
 at org.opencms.db.generic.CmsVfsDriver.readRelations(CmsVfsDriver.java:1775)
 at org.opencms.db.CmsDriverManager.getResourceOrgUnits(CmsDriverManager.java:4100)
 at org.opencms.db.CmsDriverManager.getRolesForResource(CmsDriverManager.java:4200)
 at org.opencms.db.CmsSecurityManager.getRolesForResource(CmsSecurityManager.java:2255)
 ... 44 more
Caused by: java.sql.SQLException: 'CONCAT' is not a recognized function name.
 at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
 at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
 at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
 at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
 at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:418)
 at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:693)
 at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
 at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
 at org.opencms.db.generic.CmsVfsDriver.getResourceOus(CmsVfsDriver.java:1877)
 ... 48 more




Patricia Padilla
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20080813/c04ef88e/attachment.htm>