Uploaded image for project: 'Confluence Server'
  1. Confluence Server
  2. CONFSERVER-7168

Labels does not work in Turkish locale

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: High
    • Resolution: Duplicate
    • Affects Version/s: 2.2.9
    • Fix Version/s: None
    • Component/s: None
    • Labels:
    • Environment:

      Standalone, Windows, tomcat, JDK 1.5.06 Locale : TR

      Description

      Confluence gives an error and exception stack trace when we try to go to Labels tab in preferences page, Here is the exception log:

      Cause:
      org.springframework.orm.hibernate.HibernateQueryException: undefined alias: DISTINCT [SELECT DISTINCT l FROM com.atlassian.confluence.labels.Label AS l WHERE l.namespace = :namespace AND l.owner = :owner order by l.name]; nested exception is net.sf.hibernate.QueryException: undefined alias: DISTINCT [SELECT DISTINCT l FROM com.atlassian.confluence.labels.Label AS l WHERE l.namespace = :namespace AND l.owner = :owner order by l.name]
      at org.springframework.orm.hibernate.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:463)
      caused by: net.sf.hibernate.QueryException: undefined alias: DISTINCT [SELECT DISTINCT l FROM com.atlassian.confluence.labels.Label AS l WHERE l.namespace = :namespace AND l.owner = :owner order by l.name]
      at net.sf.hibernate.hql.PathExpressionParser.token(PathExpressionParser.java:103)

      Stack Trace: [hide]

      org.springframework.orm.hibernate.HibernateQueryException: undefined alias: DISTINCT [SELECT DISTINCT l FROM com.atlassian.confluence.labels.Label AS l WHERE l.namespace = :namespace AND l.owner = :owner order by l.name]; nested exception is net.sf.hibernate.QueryException: undefined alias: DISTINCT [SELECT DISTINCT l FROM com.atlassian.confluence.labels.Label AS l WHERE l.namespace = :namespace AND l.owner = :owner order by l.name]
      net.sf.hibernate.QueryException: undefined alias: DISTINCT [SELECT DISTINCT l FROM com.atlassian.confluence.labels.Label AS l WHERE l.namespace = :namespace AND l.owner = :owner order by l.name]
      at net.sf.hibernate.hql.PathExpressionParser.token(PathExpressionParser.java:103)
      at net.sf.hibernate.hql.ParserHelper.parse(ParserHelper.java:29)
      at net.sf.hibernate.hql.SelectParser.token(SelectParser.java:170)
      at net.sf.hibernate.hql.ClauseParser.token(ClauseParser.java:87)
      at net.sf.hibernate.hql.ClauseParser.end(ClauseParser.java:114)
      at net.sf.hibernate.hql.PreprocessingParser.end(PreprocessingParser.java:143)
      at net.sf.hibernate.hql.ParserHelper.parse(ParserHelper.java:30)
      at net.sf.hibernate.hql.QueryTranslator.compile(QueryTranslator.java:149)
      at net.sf.hibernate.hql.QueryTranslator.compile(QueryTranslator.java:138)
      at net.sf.hibernate.impl.SessionFactoryImpl.getQuery(SessionFactoryImpl.java:295)
      at net.sf.hibernate.impl.SessionImpl.getQueries(SessionImpl.java:1572)
      at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1543)
      at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:49)
      at com.atlassian.confluence.labels.persistence.dao.hibernate.HibernateLabelDao$2.doInHibernate(HibernateLabelDao.java:182)
      at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:200)
      at com.atlassian.confluence.labels.persistence.dao.hibernate.HibernateLabelDao.findByDetailsInSpace(HibernateLabelDao.java:158)
      at com.atlassian.confluence.labels.persistence.dao.hibernate.HibernateLabelDao.findByDetails(HibernateLabelDao.java:124)
      at com.atlassian.confluence.labels.DefaultLabelManager.getUsersLabels(DefaultLabelManager.java:289)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:585)
      at org.springframework.aop.framework.AopProxyUtils.invokeJoinpointUsingReflection(AopProxyUtils.java:61)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:149)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:116)
      at com.atlassian.confluence.util.profiling.SpringProfilingInterceptor.invoke(SpringProfilingInterceptor.java:18)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:138)
      at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:56)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:138)
      at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:152)
      at $Proxy7.getUsersLabels(Unknown Source)
      at com.atlassian.confluence.user.actions.ViewMyLabelsAction.execute(ViewMyLabelsAction.java:103)
      at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:168)
      at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35)
      at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
      at com.opensymphony.xwork.interceptor.DefaultWorkflowInterceptor.intercept(DefaultWorkflowInterceptor.java:55)
      at com.atlassian.confluence.core.ConfluenceWorkflowInterceptor.intercept(ConfluenceWorkflowInterceptor.java:39)
      at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
      at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35)
      at com.atlassian.confluence.core.ConfluenceValidationInterceptor.intercept(ConfluenceValidationInterceptor.java:16)
      at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
      at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35)
      at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
      at com.atlassian.confluence.security.actions.PermissionCheckInterceptor.intercept(PermissionCheckInterceptor.java:39)
      at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
      at com.atlassian.confluence.pages.actions.PageAwareInterceptor.intercept(PageAwareInterceptor.java:114)
      at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
      at com.atlassian.confluence.spaces.actions.SpaceAwareInterceptor.intercept(SpaceAwareInterceptor.java:82)
      at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
      at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35)
      at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
      at com.atlassian.confluence.core.actions.LastModifiedInterceptor.intercept(LastModifiedInterceptor.java:39)
      at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
      at com.atlassian.confluence.core.ConfluenceAutowireInterceptor.intercept(ConfluenceAutowireInterceptor.java:25)
      at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
      at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35)
      at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
      at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35)
      at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
      at com.atlassian.confluence.util.XWorkTransactionInterceptor.intercept(XWorkTransactionInterceptor.java:133)
      at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
      at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35)
      at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
      at com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java:115)
      at com.opensymphony.webwork.dispatcher.ServletDispatcher.serviceAction(ServletDispatcher.java:229)
      at com.opensymphony.webwork.dispatcher.ServletDispatcher.service(ServletDispatcher.java:199)
      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 com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:117)
      at com.atlassian.confluence.util.profiling.ProfilingPageFilter.parsePage(ProfilingPageFilter.java:143)
      at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:51)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      at com.atlassian.confluence.util.ServletContextThreadLocalFilter.doFilter(ServletContextThreadLocalFilter.java:30)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      at com.atlassian.confluence.util.UserThreadLocalFilter.doFilter(UserThreadLocalFilter.java:45)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:182)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      at com.atlassian.seraph.filter.LoginFilter.doFilter(LoginFilter.java:181)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      at com.atlassian.johnson.filters.JohnsonFilter.doFilter(JohnsonFilter.java:96)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      at org.springframework.orm.hibernate.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:170)
      at bucket.custom.FlushingSpringSessionInViewFilter.doFilterInternal(FlushingSpringSessionInViewFilter.java:31)
      at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:73)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:122)
      at com.atlassian.confluence.util.error.ProfilingAndErrorFilter.doFilter(ProfilingAndErrorFilter.java:27)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      at com.atlassian.core.filters.gzip.GzipFilter.doFilter(GzipFilter.java:61)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:37)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      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.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:869)
      at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:667)
      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(Thread.java:595)

      Referer URL: http://localhost:8080/users/editmyprofile.action

      Build Information:
      Confluence Home: C:\tmp\data
      Uptime: 35 minutes, 13 seconds
      Version: 2.2.9
      Build Number: 527

      Server Information:
      Application Server: Apache Tomcat/5.5.15
      Servlet Version: 2.4
      Database Dialect: net.sf.hibernate.dialect.HSQLDialect
      Database Driver Name: org.hsqldb.jdbcDriver
      Database Driver Version: 1.8

      Memory Information:
      Total Memory: 127 MB
      Free Memory: 76 MB
      Used Memory: 51 MB

      System Information:
      System Date: Sal?, 17 Eki 2006
      System Time: 11:23:32
      System Favourite Colour: Taupe
      Java Version: 1.5.0_06
      Java Vendor: Sun Microsystems Inc.
      JVM Version: 1.0
      JVM Vendor: Sun Microsystems Inc.
      JVM Implementation Version: 1.5.0_06-b05
      Java Runtime: Java(TM) 2 Runtime Environment, Standard Edition
      Java VM: Java HotSpot(TM) Client VM
      User Name: dundara
      User Timezone: Europe/Athens
      Operating System: Windows 2000 5.0
      OS Architecture: x86
      Filesystem Encoding: Cp1254

      Enabled Plugins:
      Basic Macros (confluence.macros.basic, Version: 1.3)
      Core Listeners (confluence.listeners.core, Version: 1.3)
      Dashboard Macros (confluence.macros.dashboard, Version: 1.3)
      User Listener (confluence.extra.userlister, Version: 1.2)
      Chart Plugin (confluence.extra.chart, Version: 1.5)
      Live Search Macros (confluence.extra.livesearch, Version: 1.4)
      Information Macros (confluence.extra.information, Version: 0.1)
      Global Labels Sections (confluence.sections.labels, Version: 1.0)
      JIRA Macros (confluence.extra.jira, Version: 1.4)
      Layout Macros (confluence.extra.layout, Version: 0.1)
      Profile Tabs (confluence.sections.profile, Version: 1.0)
      Confluence Remote API (confluence.extra.confluencerpc, Version: 1.4)
      Admin Sections (confluence.sections.admin, Version: 1.0)
      Tabular Metadata (confluence.extra.masterdetail, Version: 1.0)
      Space Admin Sections (confluence.sections.space.admin, Version: 1.0)
      Space Pages Sections (confluence.sections.space.pages, Version: 1.0)
      Advanced Macros (confluence.macros.advanced, Version: 1.3)
      Space Advanced Sections (confluence.sections.space.advanced, Version: 1.0)
      IM Presence Macros (confluence.extra.impresence, Version: 0.1)
      Attachments Macros (confluence.extra.attachments, Version: 1.3)
      Edit Profile Sections (confluence.sections.profile.edit, Version: 1.0)
      Space Actions Sections (confluence.sections.space.actions, Version: 1.0)
      Task List Macros (confluence.extra.tasklist, Version: 1.3)
      Space Labels Sections (confluence.sections.space.labels, Version: 1.0)
      Attachment Extractors (confluence.extractors.attachments, Version: 1.4)
      Left Navigation Theme (com.atlassian.confluence.themes.leftnavigation, Version: 1.0)
      Dynamic Task List Macros (confluence.extra.dynamictasklist, Version: 1.3)
      Core Extractors (confluence.extractors.core, Version: 1.4)
      Compatibility Macros (confluence.macros.compatibility, Version: 1.3)
      Code Macro (confluence.macros.code, Version: 1.4)
      Request

      Information:
      URL: http://localhost:8080/500page.jsp

      • Scheme: http
      • Server: localhost
      • Port: 8080
      • URI: /500page.jsp
      • - Context Path:
      • - Servlet Path: /500page.jsp
      • - Path Info: null
      • - Query String: null

      Attributes:

      • javax.servlet.forward.request_uri : /users/viewmylabels.action
      • javax.servlet.forward.context_path :
      • javax.servlet.forward.servlet_path : /users/viewmylabels.action
      • javax.servlet.forward.path_info : /500page.jsp
      • javax.servlet.error.message :
      • javax.servlet.error.exception : org.springframework.orm.hibernate.HibernateQueryException: undefined alias: DISTINCT [SELECT DISTINCT l FROM com.atlassian.confluence.labels.Label AS l WHERE l.namespace = :namespace AND l.owner = :owner order by l.name]; nested exception is net.sf.hibernate.QueryException: undefined alias: DISTINCT [SELECT DISTINCT l FROM com.atlassian.confluence.labels.Label AS l WHERE l.namespace = :namespace AND l.owner = :owner order by l.name]
      • os_securityfilter_already_filtered : true
      • _sitemesh_using_stream : false
      • com.atlassian.johnson.filters.JohnsonFilter_already_filtered : true
      • javax.servlet.error.request_uri : /users/viewmylabels.action
      • javax.servlet.error.status_code : 500
      • _sitemesh_filterapplied : true
      • javax.servlet.error.servlet_name : action
      • webwork.valueStack : com.opensymphony.xwork.util.OgnlValueStack@32d521
      • atlassian.core.seraph.original.url : /users/viewmylabels.action
      • loginfilter.already.filtered : true
      • javax.servlet.jsp.jspException : org.springframework.orm.hibernate.HibernateQueryException: undefined alias: DISTINCT [SELECT DISTINCT l FROM com.atlassian.confluence.labels.Label AS l WHERE l.namespace = :namespace AND l.owner = :owner order by l.name]; nested exception is net.sf.hibernate.QueryException: undefined alias: DISTINCT [SELECT DISTINCT l FROM com.atlassian.confluence.labels.Label AS l WHERE l.namespace = :namespace AND l.owner = :owner order by l.name]
      • sessioninview.FILTERED : true
      • com.atlassian.core.filters.gzip.GzipFilter_already_filtered : true

      and also when we try to add a label to a page it says " [41a] Error connecting to the server. The labels have not been updated."

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Last commented:
                  12 years, 7 weeks, 5 days ago