[opencms-dev] OpenCms 7.0.5 Explorer has no LeftClick Manus and no types in new window

Sun Oct 5 12:11:39 CEST 2008

Here is what I found in logs

05 Oct 2008 14:49:43,308 ERROR [explorer.CmsExplorerTypeAccess: 235] Error reading groups of user Admin
org.opencms.db.CmsDbSqlException: Error reading all roles for user "Admin" over resource "/".
    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.CmsNewResource.getListItems(CmsNewResource.java:973)
    at org.opencms.workplace.list.A_CmsListDialog.fillList(A_CmsListDialog.java:883)
    at org.opencms.workplace.list.A_CmsListDialog.refreshList(A_CmsListDialog.java:628)
    at org.opencms.workplace.list.A_CmsListDialog.actionDialog(A_CmsListDialog.java:364)
    at org.opencms.workplace.list.A_CmsListResourceTypeDialog.actionDialog(A_CmsListResourceTypeDialog.java:216)
    at org.opencms.workplace.explorer.CmsNewResource.actionDialog(CmsNewResource.java:414)
    at org.opencms.workplace.list.A_CmsListDialog.displayDialog(A_CmsListDialog.java:411)
    at org.opencms.workplace.list.A_CmsListDialog.displayDialog(A_CmsListDialog.java:396)
    at org.apache.jsp.WEB_002dINF.jsp.offline.system.workplace.commons.newresource_jsp._jspService(newresource_jsp.java:167)
    at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
    at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331)
    at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
    at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
    at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:679)
    at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:584)
    at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:497)
    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 javax.servlet.http.HttpServlet.service(HttpServlet.java:627)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
    at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:835)
    at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:640)
    at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1286)
    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 2153fe. 
    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)
    ... 47 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)
    ... 51 more

Will try also with JPA.
Will try to correct...
Regards
Vahe Momjyan

----- Original Message ----
From: Georgi Naplatanov <gosho at oles.biz>
To: The OpenCms mailing list <opencms-dev at opencms.org>
Sent: Sunday, October 5, 2008 2:56:21 PM
Subject: Re: [opencms-dev] OpenCms 7.0.5 Explorer has no LeftClick Manus and no types in new window

Hello, Vahe.

I'm not sure, but one of possible reasons is error of some SQL queries
for MS SQL server.

Just check log files and fix queries if applicable.

Best regards
Georgi

Vahe Momjian wrote:
> I have installed OpenCms 7.0.5 on Tomcat 5.5.27 + MSSQL Server 2000 SP4 + Windows Server 2003 SP1 + JDK 6
> OpenCms 7.0.5 Explorer has no LeftClick Manus and no types in new window, (all modules installed by default). But the same OpenCms Tomcat 5.5.27 + Oracle 10g + Windows Server 2000 SP4+ JDK 6 works fine. 
> 
> How can I fix this?
> 
> 
> 
>      
> 
> 
> ------------------------------------------------------------------------
> 
> 
> _______________________________________________
> This mail is sent to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please visit
> http://lists.opencms.org/mailman/listinfo/opencms-dev

_______________________________________________
This mail is sent to you from the opencms-dev mailing list
To change your list options, or to unsubscribe from the list, please visit
http://lists.opencms.org/mailman/listinfo/opencms-dev

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20081005/283e213a/attachment.htm>