yeah ... you may actually want to back that down. I recall that I tried some 3.1.x drivers about 6 months ago and they caused me some problems so I reverted to the latest 3.0.x drivers.
It's up to you, but I wouldn't want to be deleting things by hand for very long. -- Allen On Sat, 2006-02-04 at 12:28, Matt Raible wrote: > I'm using 3.1.11 - so I'm pretty close to the latest version (3.1.12). > Oh well, I can just manually delete from the database. I've only > recently started seeing this error with Roller 2.x. > > Matt > > On 2/4/06, Allen Gilliland <[EMAIL PROTECTED]> wrote: > > This is the same as the last bunch of errors you reported. Something > > appears to be wacky with your mysql driver ... > > > > Caused by: java.sql.SQLException: Can't open file: 'referer.MYD'. (errno: > > 145) > > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2926) > > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571) > > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666) > > at com.mysql.jdbc.Connection.execSQL(Connection.java:2978) > > at com.mysql.jdbc.Connection.execSQL(Connection.java:2902) > > > > I've never seen that before so I couldn't tell you exactly what the cause > > is, but I would try some different mysql drivers and see if that helps. > > > > -- Allen > > > > > > On Sat, 2006-02-04 at 12:10, Matt Raible wrote: > > > When I try to delete an entry posted with Performancing, I get the > > > following error - any ideas? > > > > > > org.roller.RollerException > > > at > > > org.roller.business.hibernate.HibernateWeblogManagerImpl.removeWeblogEntryContents(HibernateWeblogManagerImpl.java:512) > > > at > > > org.roller.pojos.WeblogEntryData.remove(WeblogEntryData.java:1074) > > > at > > > org.roller.presentation.weblog.actions.WeblogEntryFormAction.remove(WeblogEntryFormAction.java:641) > > > 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.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:276) > > > at > > > org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:196) > > > at > > > org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421) > > > at > > > org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226) > > > at > > > org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164) > > > at > > > org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415) > > > at javax.servlet.http.HttpServlet.service(HttpServlet.java:709) > > > 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 > > > org.roller.presentation.filters.BreadCrumbFilter.doFilter(BreadCrumbFilter.java:77) > > > at > > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) > > > at > > > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) > > > at > > > org.roller.presentation.filters.RequestFilter.doFilter(RequestFilter.java:95) > > > at > > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) > > > at > > > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) > > > at > > > org.roller.presentation.filters.PersistenceSessionFilter.doFilter(PersistenceSessionFilter.java:53) > > > at > > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) > > > at > > > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) > > > at > > > org.roller.presentation.filters.SchemeEnforcementFilter.doFilter(SchemeEnforcementFilter.java:97) > > > at > > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) > > > at > > > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) > > > at > > > org.roller.presentation.filters.CharEncodingFilter.doFilter(CharEncodingFilter.java:94) > > > at > > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) > > > at > > > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) > > > at > > > net.sf.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:292) > > > at > > > net.sf.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:108) > > > at > > > net.sf.acegisecurity.intercept.web.SecurityEnforcementFilter.doFilter(SecurityEnforcementFilter.java:197) > > > at > > > net.sf.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303) > > > at > > > net.sf.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:143) > > > at > > > net.sf.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303) > > > at > > > net.sf.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:50) > > > at > > > net.sf.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303) > > > at > > > net.sf.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:154) > > > at > > > net.sf.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303) > > > at > > > net.sf.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:324) > > > at > > > net.sf.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303) > > > at > > > net.sf.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:220) > > > at > > > net.sf.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303) > > > at > > > net.sf.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:173) > > > at > > > net.sf.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:120) > > > 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.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:199) > > > at > > > org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:282) > > > at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:744) > > > at > > > org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:674) > > > at > > > org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:866) > > > at > > > org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) > > > at java.lang.Thread.run(Thread.java:595) > > > --- ROOT CAUSE --- > > > org.hibernate.exception.GenericJDBCException: could not execute query > > > at > > > org.hibernate.exception.ErrorCodeConverter.handledNonSpecificException(ErrorCodeConverter.java:92) > > > at > > > org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:80) > > > at > > > org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) > > > at org.hibernate.loader.Loader.doList(Loader.java:1596) > > > at org.hibernate.loader.Loader.list(Loader.java:1577) > > > at > > > org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:111) > > > at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1322) > > > at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:300) > > > at > > > org.roller.business.hibernate.HibernateWeblogManagerImpl.removeWeblogEntryContents(HibernateWeblogManagerImpl.java:502) > > > at > > > org.roller.pojos.WeblogEntryData.remove(WeblogEntryData.java:1074) > > > at > > > org.roller.presentation.weblog.actions.WeblogEntryFormAction.remove(WeblogEntryFormAction.java:641) > > > 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.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:276) > > > at > > > org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:196) > > > at > > > org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421) > > > at > > > org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226) > > > at > > > org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164) > > > at > > > org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415) > > > at javax.servlet.http.HttpServlet.service(HttpServlet.java:709) > > > 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 > > > org.roller.presentation.filters.BreadCrumbFilter.doFilter(BreadCrumbFilter.java:77) > > > at > > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) > > > at > > > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) > > > at > > > org.roller.presentation.filters.RequestFilter.doFilter(RequestFilter.java:95) > > > at > > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) > > > at > > > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) > > > at > > > org.roller.presentation.filters.PersistenceSessionFilter.doFilter(PersistenceSessionFilter.java:53) > > > at > > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) > > > at > > > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) > > > at > > > org.roller.presentation.filters.SchemeEnforcementFilter.doFilter(SchemeEnforcementFilter.java:97) > > > at > > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) > > > at > > > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) > > > at > > > org.roller.presentation.filters.CharEncodingFilter.doFilter(CharEncodingFilter.java:94) > > > at > > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) > > > at > > > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) > > > at > > > net.sf.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:292) > > > at > > > net.sf.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:108) > > > at > > > net.sf.acegisecurity.intercept.web.SecurityEnforcementFilter.doFilter(SecurityEnforcementFilter.java:197) > > > at > > > net.sf.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303) > > > at > > > net.sf.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:143) > > > at > > > net.sf.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303) > > > at > > > net.sf.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:50) > > > at > > > net.sf.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303) > > > at > > > net.sf.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:154) > > > at > > > net.sf.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303) > > > at > > > net.sf.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:324) > > > at > > > net.sf.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303) > > > at > > > net.sf.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:220) > > > at > > > net.sf.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303) > > > at > > > net.sf.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:173) > > > at > > > net.sf.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:120) > > > 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.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:199) > > > at > > > org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:282) > > > at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:744) > > > at > > > org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:674) > > > at > > > org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:866) > > > 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: Can't open file: 'referer.MYD'. (errno: > > > 145) > > > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2926) > > > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571) > > > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666) > > > at com.mysql.jdbc.Connection.execSQL(Connection.java:2978) > > > at com.mysql.jdbc.Connection.execSQL(Connection.java:2902) > > > at > > > com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:933) > > > at > > > com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1027) > > > at > > > org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92) > > > at > > > org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:120) > > > at org.hibernate.loader.Loader.getResultSet(Loader.java:1272) > > > at org.hibernate.loader.Loader.doQuery(Loader.java:391) > > > at > > > org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:218) > > > at org.hibernate.loader.Loader.doList(Loader.java:1593) > > > ... 67 more > > > >
