<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:times new roman, new york, times, serif;font-size:12pt"><div>Here is what I found in logs<br><br>05 Oct 2008 14:49:43,308 ERROR [explorer.CmsExplorerTypeAccess: 235] Error reading groups of user Admin<br>org.opencms.db.CmsDbSqlException: Error reading all roles for user "Admin" over resource "/".<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.CmsNewResource.getListItems(CmsNewResource.java:973)<br> at org.opencms.workplace.list.A_CmsListDialog.fillList(A_CmsListDialog.java:883)<br> at org.opencms.workplace.list.A_CmsListDialog.refreshList(A_CmsListDialog.java:628)<br> at org.opencms.workplace.list.A_CmsListDialog.actionDialog(A_CmsListDialog.java:364)<br> at org.opencms.workplace.list.A_CmsListResourceTypeDialog.actionDialog(A_CmsListResourceTypeDialog.java:216)<br> at org.opencms.workplace.explorer.CmsNewResource.actionDialog(CmsNewResource.java:414)<br> at
org.opencms.workplace.list.A_CmsListDialog.displayDialog(A_CmsListDialog.java:411)<br> at org.opencms.workplace.list.A_CmsListDialog.displayDialog(A_CmsListDialog.java:396)<br> at org.apache.jsp.WEB_002dINF.jsp.offline.system.workplace.commons.newresource_jsp._jspService(newresource_jsp.java:167)<br> at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)<br> at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)<br> at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331)<br> at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)<br> at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)<br> at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)<br> at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)<br> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)<br> at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:679)<br> at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:584)<br> at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:497)<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 javax.servlet.http.HttpServlet.service(HttpServlet.java:627)<br> at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)<br> at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)<br> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)<br> at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)<br> at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)<br> at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)<br> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)<br> at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)<br> at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)<br> at
org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:835)<br> at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:640)<br> at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1286)<br> at java.lang.Thread.run(Unknown Source)<br>Caused by: org.opencms.db.CmsDbSqlException: An SQL error occurred when executing the following query: net.sourceforge.jtds.jdbc.JtdsPreparedStatement@2153fe. <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> ... 47 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> ... 51 more<br><br>Will try also with JPA.<br>Will try to correct...<br>Regards<br>Vahe Momjyan<br></div><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;"><br><div style="font-family: arial,helvetica,sans-serif; font-size: 13px;">----- Original Message ----<br>From: Georgi Naplatanov <gosho@oles.biz><br>To: The OpenCms mailing list <opencms-dev@opencms.org><br>Sent: Sunday, October 5, 2008 2:56:21 PM<br>Subject: Re: [opencms-dev] OpenCms 7.0.5 Explorer has no LeftClick Manus and no types in new window<br><br>
Hello, Vahe.<br><br>I'm not sure, but one of possible reasons is error of some SQL queries<br>for MS SQL server.<br><br>Just check log files and fix queries if applicable.<br><br>Best regards<br>Georgi<br><br>Vahe Momjian wrote:<br>> I have installed OpenCms 7.0.5 on Tomcat 5.5.27 + MSSQL Server 2000 SP4 + Windows Server 2003 SP1 + JDK 6<br>> 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. <br>> <br>> How can I fix this?<br>> <br>> <br>> <br>> <br>> <br>> <br>> ------------------------------------------------------------------------<br>> <br>> <br>> _______________________________________________<br>> This mail is sent to you from the opencms-dev mailing list<br>> To change your list options, or to unsubscribe from the list, please
visit<br>> <a href="http://lists.opencms.org/mailman/listinfo/opencms-dev" target="_blank">http://lists.opencms.org/mailman/listinfo/opencms-dev</a><br><br><br>_______________________________________________<br>This mail is sent to you from the opencms-dev mailing list<br>To change your list options, or to unsubscribe from the list, please visit<br><a href="http://lists.opencms.org/mailman/listinfo/opencms-dev" target="_blank">http://lists.opencms.org/mailman/listinfo/opencms-dev</a><br></div></div></div><br>
</body></html>