Details
-
Bug
-
Resolution: Fixed
-
Medium
-
2.5.7
-
MySQL 5, SJSWS 7.1, war
Description
Steps to reproduce:
- Log in as a site admin
- Go to Administration view >> Manage Referrers
- Add a referrer
- click on "Purge" or "Purge all" link
Result:
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: java.sql.SQLException: Column 'count' not found.
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at com.mysql.jdbc.ResultSet.findColumn(ResultSet.java:987)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at com.mysql.jdbc.ResultSet.getInt(ResultSet.java:2749)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at com.mchange.v2.c3p0.impl.NewProxyResultSet.getInt(NewProxyResultSet.java:2677)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at com.atlassian.confluence.links.DefaultReferralManager.deleteReferrersWithPrefix(DefaultReferralManager.java:196)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at java.lang.reflect.Method.invoke(Method.java:597)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:284)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:155)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:122)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at com.atlassian.spring.interceptors.SpringProfilingInterceptor.invoke(SpringProfilingInterceptor.java:20)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:56)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:174)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at $Proxy35.deleteReferrersWithPrefix(Unknown Source)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at com.atlassian.confluence.admin.actions.PurgeReferrersAction.doPurgeSingleReferrer(PurgeReferrersAction.java:37)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at java.lang.reflect.Method.invoke(Method.java:597)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at com.opensymphony.xwork.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:302)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at com.opensymphony.xwork.interceptor.DefaultWorkflowInterceptor.intercept(DefaultWorkflowInterceptor.java:55)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at com.atlassian.confluence.core.ConfluenceWorkflowInterceptor.intercept(ConfluenceWorkflowInterceptor.java:39)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at com.atlassian.confluence.core.ConfluenceValidationInterceptor.intercept(ConfluenceValidationInterceptor.java:16)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at com.atlassian.confluence.util.LoggingContextInterceptor.intercept(LoggingContextInterceptor.java:48)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at com.atlassian.confluence.security.actions.PermissionCheckInterceptor.intercept(PermissionCheckInterceptor.java:47)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at com.atlassian.confluence.pages.actions.PageAwareInterceptor.intercept(PageAwareInterceptor.java:114)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at com.atlassian.confluence.spaces.actions.SpaceAwareInterceptor.intercept(SpaceAwareInterceptor.java:67)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at com.atlassian.confluence.core.actions.LastModifiedInterceptor.intercept(LastModifiedInterceptor.java:39)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at com.atlassian.confluence.core.ConfluenceAutowireInterceptor.intercept(ConfluenceAutowireInterceptor.java:25)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at com.atlassian.xwork.interceptors.XWorkTransactionInterceptor.intercept(XWorkTransactionInterceptor.java:98)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java:115)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at com.opensymphony.webwork.dispatcher.ServletDispatcher.serviceAction(ServletDispatcher.java:229)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at com.opensymphony.webwork.dispatcher.ServletDispatcher.service(ServletDispatcher.java:199)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at javax.servlet.http.HttpServlet.service(HttpServlet.java:917)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at org.apache.catalina.core.ApplicationFilterChain.servletService(ApplicationFilterChain.java:398)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:304)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:185)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:117)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at com.atlassian.confluence.util.profiling.ProfilingPageFilter.parsePage(ProfilingPageFilter.java:137)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:51)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:217)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:185)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at com.atlassian.core.filters.ServletContextThreadLocalFilter.doFilter(ServletContextThreadLocalFilter.java:21)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:217)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:185)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at com.atlassian.confluence.util.LoggingContextFilter.doFilter(LoggingContextFilter.java:46)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:217)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:185)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at com.atlassian.confluence.util.UserThreadLocalFilter.doFilter(UserThreadLocalFilter.java:44)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:217)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:185)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:182)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:217)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:185)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at com.atlassian.seraph.filter.LoginFilter.doFilter(LoginFilter.java:159)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:217)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:185)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at com.atlassian.confluence.util.ClusterHeaderFilter.doFilter(ClusterHeaderFilter.java:35)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:217)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:185)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at com.atlassian.johnson.filters.JohnsonFilter.doFilter(JohnsonFilter.java:96)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:217)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:185)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at org.springframework.orm.hibernate.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:172)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at com.atlassian.spring.filter.FlushingSpringSessionInViewFilter.doFilterInternal(FlushingSpringSessionInViewFilter.java:29)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:217)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:185)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:140)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at com.atlassian.core.filters.ProfilingAndErrorFilter.doFilter(ProfilingAndErrorFilter.java:27)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:217)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:185)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at com.atlassian.confluence.util.RequestCacheThreadLocalFilter.doFilter(RequestCacheThreadLocalFilter.java:25)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:217)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:185)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at com.atlassian.core.filters.gzip.GzipFilter.doFilter(GzipFilter.java:61)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:217)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:185)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:37)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:217)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:185)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at com.sun.dse.wikis.auth.SsoFilter.doFilter(SsoFilter.java:145)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:217)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:185)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:255)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:188)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:586)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:556)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:187)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:586)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:556)
[08/Oct/2007:08:50:17] warning ( 7311): CORE3283: stderr: at com.sun.webserver.connector.nsapi.NSAPIProcessor.service(NSAPIProcessor.java:160)