I can't reproduce this one. Filter works fine for me with MySQL 5 and Derby.
What database are you using? - Dave On Nov 5, 2007 5:47 PM, Steve <[EMAIL PROTECTED]> wrote: > The filter function returns a Status Code of 500 when the filter button is > pressed. > > It makes no difference on which radio buttons are selected. > > This is Roller 4.0 RC9 > Unexpected Exception Status Code 500 Message Parameter index out of range > (4 > number of parameters, which is 3). Type Exception Roller has > encountered and logged an unexpected exception. > > ERROR 2007-11-05 22:41:10,175 StandardWrapperValve:invoke - Servlet.service() > for servlet default threw exception > <0.9.7-incubating nonfatal general error> > org.apache.openjpa.persistence.PersistenceException: Parameter index out of > range (4 > number of parameters, which is 3). > at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException( > DBDictionary.java:3784) > at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java > :97) > at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java > :83) > at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java > :59) > at > org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.handleCheckedException > (SelectResultObjectProvider.java:155) > at org.apache.openjpa.lib.rop.EagerResultList.<init>(EagerResultList.java > :40) > at org.apache.openjpa.kernel.QueryImpl.toResult(QueryImpl.java:1219) > at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:987) > at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:796) > at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:766) > at org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java > :533) > at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:227) > at org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java > :269) > at > org.apache.roller.weblogger.business.jpa.JPAWeblogManagerImpl.getWeblogEntries > (JPAWeblogManagerImpl.java:645) > at org.apache.roller.weblogger.ui.struts2.editor.Entries.execute( > Entries.java:88) > 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 com.opensymphony.xwork2.DefaultActionInvocation.invokeAction( > DefaultActionInvocation.java:404) > at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly( > DefaultActionInvocation.java:267) > at com.opensymphony.xwork2.DefaultActionInvocation.invoke( > DefaultActionInvocation.java:229) > at > com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept( > DefaultWorkflowInterceptor.java:221) > at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept( > MethodFilterInterceptor.java:86) > at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling( > DefaultActionInvocation.java:224) > at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling( > DefaultActionInvocation.java:223) > at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile( > UtilTimerStack.java:455) > at com.opensymphony.xwork2.DefaultActionInvocation.invoke( > DefaultActionInvocation.java:221) > at com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept( > ValidationInterceptor.java:150) > at > org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept > (AnnotationValidationInterceptor.java:48) > at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept( > MethodFilterInterceptor.java:86) > at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling( > DefaultActionInvocation.java:224) > at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling( > DefaultActionInvocation.java:223) > at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile( > UtilTimerStack.java:455) > at com.opensymphony.xwork2.DefaultActionInvocation.invoke( > DefaultActionInvocation.java:221) > at > org.apache.roller.weblogger.ui.struts2.util.UIActionPrepareInterceptor.intercept > (UIActionPrepareInterceptor.java:52) > at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling( > DefaultActionInvocation.java:224) > at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling( > DefaultActionInvocation.java:223) > at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile( > UtilTimerStack.java:455) > at com.opensymphony.xwork2.DefaultActionInvocation.invoke( > DefaultActionInvocation.java:221) > at > org.apache.roller.weblogger.ui.struts2.util.UISecurityInterceptor.intercept( > UISecurityInterceptor.java:93) > at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling( > DefaultActionInvocation.java:224) > at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling( > DefaultActionInvocation.java:223) > at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile( > UtilTimerStack.java:455) > at com.opensymphony.xwork2.DefaultActionInvocation.invoke( > DefaultActionInvocation.java:221) > at > org.apache.roller.weblogger.ui.struts2.util.UIActionInterceptor.intercept( > UIActionInterceptor.java:82) > at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling( > DefaultActionInvocation.java:224) > at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling( > DefaultActionInvocation.java:223) > at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile( > UtilTimerStack.java:455) > at com.opensymphony.xwork2.DefaultActionInvocation.invoke( > DefaultActionInvocation.java:221) > at com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept > (ConversionErrorInterceptor.java:123) > at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling( > DefaultActionInvocation.java:224) > at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling( > DefaultActionInvocation.java:223) > at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile( > UtilTimerStack.java:455) > at com.opensymphony.xwork2.DefaultActionInvocation.invoke( > DefaultActionInvocation.java:221) > at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept( > ParametersInterceptor.java:167) > at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept( > MethodFilterInterceptor.java:86) > at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling( > DefaultActionInvocation.java:224) > at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling( > DefaultActionInvocation.java:223) > at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile( > UtilTimerStack.java:455) > at com.opensymphony.xwork2.DefaultActionInvocation.invoke( > DefaultActionInvocation.java:221) > at > com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept( > StaticParametersInterceptor.java:105) > at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling( > DefaultActionInvocation.java:224) > at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling( > DefaultActionInvocation.java:223) > at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile( > UtilTimerStack.java:455) > at com.opensymphony.xwork2.DefaultActionInvocation.invoke( > DefaultActionInvocation.java:221) > at org.apache.struts2.interceptor.CheckboxInterceptor.intercept( > CheckboxInterceptor.java:83) > at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling( > DefaultActionInvocation.java:224) > at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling( > DefaultActionInvocation.java:223) > at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile( > UtilTimerStack.java:455) > at com.opensymphony.xwork2.DefaultActionInvocation.invoke( > DefaultActionInvocation.java:221) > at org.apache.struts2.interceptor.FileUploadInterceptor.intercept( > FileUploadInterceptor.java:207) > at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling( > DefaultActionInvocation.java:224) > at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling( > DefaultActionInvocation.java:223) > at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile( > UtilTimerStack.java:455) > at com.opensymphony.xwork2.DefaultActionInvocation.invoke( > DefaultActionInvocation.java:221) > at com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept( > ModelDrivenInterceptor.java:74) > at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling( > DefaultActionInvocation.java:224) > at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling( > DefaultActionInvocation.java:223) > at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile( > UtilTimerStack.java:455) > at com.opensymphony.xwork2.DefaultActionInvocation.invoke( > DefaultActionInvocation.java:221) > at > com.opensymphony.xwork2.interceptor.ScopedModelDrivenInterceptor.intercept( > ScopedModelDrivenInterceptor.java:127) > at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling( > DefaultActionInvocation.java:224) > at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling( > DefaultActionInvocation.java:223) > at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile( > UtilTimerStack.java:455) > at com.opensymphony.xwork2.DefaultActionInvocation.invoke( > DefaultActionInvocation.java:221) > at org.apache.struts2.interceptor.ProfilingActivationInterceptor.intercept( > ProfilingActivationInterceptor.java:107) > at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling( > DefaultActionInvocation.java:224) > at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling( > DefaultActionInvocation.java:223) > at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile( > UtilTimerStack.java:455) > at com.opensymphony.xwork2.DefaultActionInvocation.invoke( > DefaultActionInvocation.java:221) > at org.apache.struts2.interceptor.debugging.DebuggingInterceptor.intercept( > DebuggingInterceptor.java:206) > at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling( > DefaultActionInvocation.java:224) > at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling( > DefaultActionInvocation.java:223) > at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile( > UtilTimerStack.java:455) > at com.opensymphony.xwork2.DefaultActionInvocation.invoke( > DefaultActionInvocation.java:221) > at com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept( > ChainingInterceptor.java:115) > at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling( > DefaultActionInvocation.java:224) > at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling( > DefaultActionInvocation.java:223) > at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile( > UtilTimerStack.java:455) > at com.opensymphony.xwork2.DefaultActionInvocation.invoke( > DefaultActionInvocation.java:221) > at com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept( > I18nInterceptor.java:143) > at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling( > DefaultActionInvocation.java:224) > at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling( > DefaultActionInvocation.java:223) > at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile( > UtilTimerStack.java:455) > at com.opensymphony.xwork2.DefaultActionInvocation.invoke( > DefaultActionInvocation.java:221) > at com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept( > PrepareInterceptor.java:121) > at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept( > MethodFilterInterceptor.java:86) > at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling( > DefaultActionInvocation.java:224) > at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling( > DefaultActionInvocation.java:223) > at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile( > UtilTimerStack.java:455) > at com.opensymphony.xwork2.DefaultActionInvocation.invoke( > DefaultActionInvocation.java:221) > at org.apache.struts2.interceptor.ServletConfigInterceptor.intercept( > ServletConfigInterceptor.java:170) > at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling( > DefaultActionInvocation.java:224) > at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling( > DefaultActionInvocation.java:223) > at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile( > UtilTimerStack.java:455) > at com.opensymphony.xwork2.DefaultActionInvocation.invoke( > DefaultActionInvocation.java:221) > at com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept( > AliasInterceptor.java:123) > at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling( > DefaultActionInvocation.java:224) > at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling( > DefaultActionInvocation.java:223) > at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile( > UtilTimerStack.java:455) > at com.opensymphony.xwork2.DefaultActionInvocation.invoke( > DefaultActionInvocation.java:221) > at > com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept( > ExceptionMappingInterceptor.java:176) > at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling( > DefaultActionInvocation.java:224) > at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling( > DefaultActionInvocation.java:223) > at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile( > UtilTimerStack.java:455) > at com.opensymphony.xwork2.DefaultActionInvocation.invoke( > DefaultActionInvocation.java:221) > at org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java > :50) > at org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java > :504) > at org.apache.struts2.dispatcher.FilterDispatcher.doFilter( > FilterDispatcher.java:419) > at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter( > ApplicationFilterChain.java:202) > at org.apache.catalina.core.ApplicationFilterChain.doFilter( > ApplicationFilterChain.java:173) > at org.apache.struts2.dispatcher.ActionContextCleanUp.doFilter( > ActionContextCleanUp.java:99) > at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter( > ApplicationFilterChain.java:202) > at org.apache.catalina.core.ApplicationFilterChain.doFilter( > ApplicationFilterChain.java:173) > at > org.apache.roller.weblogger.ui.rendering.filters.RequestMappingFilter.doFilter > (RequestMappingFilter.java:140) > at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter( > ApplicationFilterChain.java:202) > at org.apache.catalina.core.ApplicationFilterChain.doFilter( > ApplicationFilterChain.java:173) > at org.apache.roller.weblogger.ui.core.filters.InitFilter.doFilter( > InitFilter.java:71) > at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter( > ApplicationFilterChain.java:202) > at org.apache.catalina.core.ApplicationFilterChain.doFilter( > ApplicationFilterChain.java:173) > at > org.apache.roller.weblogger.ui.core.filters.PersistenceSessionFilter.doFilter > (PersistenceSessionFilter.java:60) > at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter( > ApplicationFilterChain.java:202) > at org.apache.catalina.core.ApplicationFilterChain.doFilter( > ApplicationFilterChain.java:173) > at org.apache.roller.weblogger.ui.core.filters.BootstrapFilter.doFilter( > BootstrapFilter.java:65) > at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter( > ApplicationFilterChain.java:202) > at org.apache.catalina.core.ApplicationFilterChain.doFilter( > ApplicationFilterChain.java:173) > at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter( > FilterChainProxy.java:264) > at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke( > FilterSecurityInterceptor.java:107) > at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter( > FilterSecurityInterceptor.java:72) > at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter( > FilterChainProxy.java:274) > at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter( > ExceptionTranslationFilter.java:110) > at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter( > FilterChainProxy.java:274) > at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter > (AnonymousProcessingFilter.java:125) > at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter( > FilterChainProxy.java:274) > at > org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter( > SecurityContextHolderAwareRequestFilter.java:81) > at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter( > FilterChainProxy.java:274) > at org.acegisecurity.securechannel.ChannelProcessingFilter.doFilter( > ChannelProcessingFilter.java:138) > at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter( > FilterChainProxy.java:274) > at org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter( > RememberMeProcessingFilter.java:142) > at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter( > FilterChainProxy.java:274) > at org.acegisecurity.ui.AbstractProcessingFilter.doFilter( > AbstractProcessingFilter.java:217) > at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter( > FilterChainProxy.java:274) > at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter( > HttpSessionContextIntegrationFilter.java:229) > at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter( > FilterChainProxy.java:274) > at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java > :148) > at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java > :98) > at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter( > ApplicationFilterChain.java:202) > at org.apache.catalina.core.ApplicationFilterChain.doFilter( > ApplicationFilterChain.java:173) > at > org.apache.roller.weblogger.ui.core.filters.SchemeEnforcementFilter.doFilter > (SchemeEnforcementFilter.java:121) > at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter( > ApplicationFilterChain.java:202) > at org.apache.catalina.core.ApplicationFilterChain.doFilter( > ApplicationFilterChain.java:173) > at org.apache.roller.weblogger.ui.core.filters.CharEncodingFilter.doFilter( > CharEncodingFilter.java:77) > 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.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(Thread.java:595) > Caused by: java.sql.SQLException: Parameter index out of range (4 > number > of parameters, which is 3). > at com.mysql.jdbc.PreparedStatement.setInternal(PreparedStatement.java > :2250) > at com.mysql.jdbc.PreparedStatement.setString(PreparedStatement.java:2949) > at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.setString( > DelegatingPreparedStatement.java:131) > at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.setString( > DelegatingPreparedStatement.java:309) > at > org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.setString > (LoggingConnectionDecorator.java:981) > at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.setString( > DelegatingPreparedStatement.java:309) > at org.apache.openjpa.jdbc.sql.DBDictionary.setString(DBDictionary.java > :1021) > at org.apache.openjpa.jdbc.sql.DBDictionary.setUnknown(DBDictionary.java > :1225) > at org.apache.openjpa.jdbc.sql.SQLBuffer.setParameters(SQLBuffer.java:567) > at org.apache.openjpa.jdbc.sql.SQLBuffer.prepareStatement(SQLBuffer.java > :478) > at org.apache.openjpa.jdbc.sql.SQLBuffer.prepareStatement(SQLBuffer.java > :454) > at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:344) > at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:308) > at org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.open( > SelectResultObjectProvider.java:94) > at org.apache.openjpa.lib.rop.EagerResultList.<init>(EagerResultList.java > :34) > > > > > > -- > Steve >
