Dave - I doubt I'll be bitten by this since I'm running a 3.x version of MySQL. However, it seems like a good reason to repackage and re-release.
Matt On 3/4/06, Vincent <[EMAIL PROTECTED]> wrote: > Figured it out, long story short : don't use quotes when defining a > default value for a Mysql BIT field (in version 5.0.18 anyway). > > I put a corrected script on my wiki: > > http://www.ghettojava.com/JSPWiki/Wiki.jsp?page=MysqlUpgradeScript > > Matt Raible wrote: > > On 3/4/06, Vincent <[EMAIL PROTECTED]> wrote: > >> Just wanted to give you guys some feedback. > >> Tomcat 5.5.9 (Sun) jdk 1.5 on redhat linux. > >> I moved from 2.01 to 2.1. > >> First the install script had problems: > >> > >> > >> > >> mysql> source 200-to-210-migration.sql > >> > >> ERROR 1067 (42000): Invalid default value for 'approved' > >> ERROR 1067 (42000): Invalid default value for 'pending' > >> ERROR 1054 (42S22): Unknown column 'approved' in 'field list' > >> ERROR 1067 (42000): Invalid default value for 'commentmod' > >> ERROR 1067 (42000): Invalid default value for 'defaultallowcomments' > >> Query OK, 2 rows affected (0.01 sec) > >> Records: 2 Duplicates: 0 Warnings: 0 > >> > >> Query OK, 2 rows affected (0.01 sec) > >> Records: 2 Duplicates: 0 Warnings: 0 > >> > >> ERROR 1054 (42S22): Unknown column 'commentmod' in 'field list' > >> ERROR 1061 (42000): Duplicate key name 'we_status_idx' > >> Query OK, 2 rows affected (0.00 sec) > >> Records: 2 Duplicates: 0 Warnings: 0 > >> > >> mysql> quit > >> > >> > >> > >> > >> > >> > >> this are some tomcat logs with traces I got starting up roller before I > >> fell asleep > >> last night: > >> > >> > >> > >> INFO 2006-03-04 10:10:38,559 IndexManagerImpl:<init> - search enabled: > >> true > >> INFO 2006-03-04 10:10:38,560 IndexManagerImpl:<init> - index dir: > >> /web/java/roller_data/search-index > >> > >> ==> /usr/local/tomcat/logs/catalina.2006-03-04.log <== > >> Mar 4, 2006 10:10:39 AM org.apache.catalina.core.StandardContext > >> filterStart > >> SEVERE: Exception starting filter securityFilter > >> java.lang.IllegalStateException: No WebApplicationContext found: no > >> ContextLoaderListener registered? > > > > This seems to imply that Spring's ContextLoaderListener is not loading > > - probably because of all the other database issues. > > > > Matt > > > >> at > >> org.springframework.web.context.support.WebApplicationContextUtils.getRequiredWebApplicationContext(WebApplicationContextUtils.java:84) > >> at > >> org.acegisecurity.util.FilterToBeanProxy.getContext(FilterToBeanProxy.java:144) > >> at > >> org.acegisecurity.util.FilterToBeanProxy.doInit(FilterToBeanProxy.java:165) > >> at > >> org.acegisecurity.util.FilterToBeanProxy.init(FilterToBeanProxy.java:132) > >> at > >> org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:225) > >> at > >> org.apache.catalina.core.ApplicationFilterConfig.setFilterDef(ApplicationFilterConfig.java:308) > >> at > >> org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:79) > >> at > >> org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:3540) > >> at > >> org.apache.catalina.core.StandardContext.start(StandardContext.java:4110) > >> at > >> org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759) > >> at > >> org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739) > >> at > >> org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524) > >> at > >> org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:589) > >> at > >> org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:536) > >> at > >> org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:471) > >> at > >> org.apache.catalina.startup.HostConfig.start(HostConfig.java:1102) > >> at > >> org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311) > >> at > >> org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119) > >> at > >> org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1020) > >> at > >> org.apache.catalina.core.StandardHost.start(StandardHost.java:718) > >> at > >> org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1012) > >> at > >> org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442) > >> at > >> org.apache.catalina.core.StandardService.start(StandardService.java:450) > >> at > >> org.apache.catalina.core.StandardServer.start(StandardServer.java:683) > >> at org.apache.catalina.startup.Catalina.start(Catalina.java:537) > >> 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.catalina.startup.Bootstrap.start(Bootstrap.java:271) > >> at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:409) > >> Mar 4, 2006 10:10:39 AM org.apache.catalina.core.StandardContext start > >> SEVERE: Error filterStart > >> Mar 4, 2006 10:10:39 AM org.apache.catalina.core.StandardContext start > >> SEVERE: Context [/roller] startup failed due to previous errors > >> Mar 4, 2006 10:10:39 AM org.apache.catalina.startup.HostConfig deployWAR > >> INFO: Deploying web application archive ROOT.war > >> > >> ==> /usr/local/tomcat/logs/roller.log <== > >> INFO 2006-03-04 10:10:38,680 IndexManagerImpl:<init> - Index was > >> inconsistent. Rebuilding index in the background... > >> INFO 2006-03-04 10:10:38,746 WriteToIndexOperation:run - Starting > >> search index operation > >> WARN 2006-03-04 10:10:38,894 JDBCExceptionReporter:logExceptions - SQL > >> Error: 1054, SQLState: 42S22 > >> ERROR 2006-03-04 10:10:38,896 JDBCExceptionReporter:logExceptions - > >> Unknown column 'websitedat2_.defaultallowcomments' in 'field list' > >> FATAL 2006-03-04 10:10:38,910 RollerContext:contextInitialized - > >> RollerContext initialization failed > >> org.roller.RollerException > >> at > >> org.roller.business.hibernate.HibernatePingTargetManagerImpl.getCommonPingTargets(HibernatePingTargetManagerImpl.java:50) > >> at > >> org.roller.config.PingConfig.initializeCommonTargets(PingConfig.java:175) > >> at > >> org.roller.presentation.RollerContext.initializePingFeatures(RollerContext.java:228) > >> at > >> org.roller.presentation.RollerContext.contextInitialized(RollerContext.java:159) > >> at > >> org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3669) > >> at > >> org.apache.catalina.core.StandardContext.start(StandardContext.java:4104) > >> at > >> org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759) > >> at > >> org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739) > >> at > >> org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524) > >> at > >> org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:589) > >> at > >> org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:536) > >> at > >> org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:471) > >> at > >> org.apache.catalina.startup.HostConfig.start(HostConfig.java:1102) > >> at > >> org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311) > >> at > >> org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119) > >> at > >> org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1020) > >> at > >> org.apache.catalina.core.StandardHost.start(StandardHost.java:718) > >> at > >> org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1012) > >> at > >> org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442) > >> at > >> org.apache.catalina.core.StandardService.start(StandardService.java:450) > >> at > >> org.apache.catalina.core.StandardServer.start(StandardServer.java:683) > >> at org.apache.catalina.startup.Catalina.start(Catalina.java:537) > >> 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.catalina.startup.Bootstrap.start(Bootstrap.java:271) > >> at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:409) > >> --- ROOT CAUSE --- > >> org.hibernate.exception.SQLGrammarException: could not execute query > >> at > >> org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:70) > >> 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.HibernatePingTargetManagerImpl.getCommonPingTargets(HibernatePingTargetManagerImpl.java:46) > >> at > >> org.roller.config.PingConfig.initializeCommonTargets(PingConfig.java:175) > >> at > >> org.roller.presentation.RollerContext.initializePingFeatures(RollerContext.java:228) > >> at > >> org.roller.presentation.RollerContext.contextInitialized(RollerContext.java:159) > >> at > >> org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3669) > >> at > >> org.apache.catalina.core.StandardContext.start(StandardContext.java:4104) > >> at > >> org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759) > >> at > >> org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739) > >> at > >> org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524) > >> at > >> org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:589) > >> at > >> org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:536) > >> at > >> org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:471) > >> at > >> org.apache.catalina.startup.HostConfig.start(HostConfig.java:1102) > >> at > >> org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311) > >> at > >> org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119) > >> at > >> org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1020) > >> at > >> org.apache.catalina.core.StandardHost.start(StandardHost.java:718) > >> at > >> org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1012) > >> at > >> org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442) > >> at > >> org.apache.catalina.core.StandardService.start(StandardService.java:450) > >> at > >> org.apache.catalina.core.StandardServer.start(StandardServer.java:683) > >> at org.apache.catalina.startup.Catalina.start(Catalina.java:537) > >> 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.catalina.startup.Bootstrap.start(Bootstrap.java:271) > >> at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:409) > >> Caused by: java.sql.SQLException: Unknown column > >> 'websitedat2_.defaultallowcomments' in 'field list' > >> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928) > >> 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:2994) > >> at > >> com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:936) > >> at > >> com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1030) > >> 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) > >> ... 32 more > >> WARN 2006-03-04 10:10:39,020 JDBCExceptionReporter:logExceptions - SQL > >> Error: 1054, SQLState: 42S22 > >> ERROR 2006-03-04 10:10:39,021 JDBCExceptionReporter:logExceptions - > >> Unknown column 'websitedat4_.defaultallowcomments' in 'field list' > >> ERROR 2006-03-04 10:10:39,022 > >> HibernateWeblogManagerImpl:getWeblogEntries - > >> org.hibernate.exception.SQLGrammarException: could not execute query > >> ERROR 2006-03-04 10:10:39,023 RebuildWebsiteIndexOperation:doRun - ERROR > >> adding doc to index > >> org.roller.RollerException > >> at > >> org.roller.business.hibernate.HibernateWeblogManagerImpl.getWeblogEntries(HibernateWeblogManagerImpl.java:253) > >> at > >> org.roller.business.WeblogManagerImpl.getWeblogEntries(WeblogManagerImpl.java:301) > >> at > >> org.roller.business.search.operations.RebuildWebsiteIndexOperation.doRun(RebuildWebsiteIndexOperation.java:112) > >> at > >> org.roller.business.search.operations.WriteToIndexOperation.run(WriteToIndexOperation.java:41) > >> at > >> EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(Unknown Source) > >> at java.lang.Thread.run(Thread.java:595) > >> --- ROOT CAUSE --- > >> org.hibernate.exception.SQLGrammarException: could not execute query > >> at > >> org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:70) > >> 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.getWeblogEntries(HibernateWeblogManagerImpl.java:248) > >> at > >> org.roller.business.WeblogManagerImpl.getWeblogEntries(WeblogManagerImpl.java:301) > >> at > >> org.roller.business.search.operations.RebuildWebsiteIndexOperation.doRun(RebuildWebsiteIndexOperation.java:112) > >> at > >> org.roller.business.search.operations.WriteToIndexOperation.run(WriteToIndexOperation.java:41) > >> at > >> EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(Unknown Source) > >> at java.lang.Thread.run(Thread.java:595) > >> Caused by: java.sql.SQLException: Unknown column > >> 'websitedat4_.defaultallowcomments' in 'field list' > >> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928) > >> 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:2994) > >> at > >> com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:936) > >> at > >> com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1030) > >> 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) > >> ... 10 more > >> INFO 2006-03-04 10:10:39,055 BreadCrumbFilter:init - set breadcrumb > >> stack size to 3 > >> INFO 2006-03-04 10:10:39,079 FeedCacheFilter:init - Initializing feed > >> cache > >> INFO 2006-03-04 10:10:39,081 FeedCacheFilter:init - {timeout=3600, > >> size=200} > >> INFO 2006-03-04 10:10:39,090 RebuildWebsiteIndexOperation:doRun - > >> Completed rebuilding index for all users in '0.343' secs > >> INFO 2006-03-04 10:10:39,091 WriteToIndexOperation:run - Search index > >> operation complete > >> INFO 2006-03-04 10:10:39,095 CacheManager:<clinit> - Cache Manager > >> Initialized. > >> INFO 2006-03-04 10:10:39,096 CacheManager:<clinit> - Default cache > >> factory = org.roller.presentation.cache.ExpiringLRUCacheFactoryImpl > >> INFO 2006-03-04 10:10:39,112 MainPageCacheFilter:init - Initializing > >> main page cache > >> INFO 2006-03-04 10:10:39,114 MainPageCacheFilter:init - {timeout=1800, > >> excludeOwnerEditPages=false, size=10} > >> INFO 2006-03-04 10:10:39,118 IfPlanetModifiedFilter:init - Initializing > >> if-modified planet filter > >> INFO 2006-03-04 10:10:39,124 RefererFilter:init - Referrer processing > >> enabled = true > >> INFO 2006-03-04 10:10:39,129 WeblogPageCacheFilter:init - Initializing > >> weblog page cache > >> INFO 2006-03-04 10:10:39,131 WeblogPageCacheFilter:init - > >> {timeout=3600, excludeOwnerEditPages=false, size=400} > >> INFO 2006-03-04 10:10:39,136 IfModifiedWeblogPageCacheFilter:init - > >> Initializing if-modified cache > >> INFO 2006-03-04 10:10:39,137 IfModifiedWeblogPageCacheFilter:init - > >> {timeout=14400, size=1000} > >> INFO 2006-03-04 10:10:39,144 IfModifiedFeedCacheFilter:init - > >> Initializing if-modified feed cache > >> INFO 2006-03-04 10:10:39,146 IfModifiedFeedCacheFilter:init - > >> {timeout=14400, size=200} > >> INFO 2006-03-04 10:10:39,150 PlanetCacheFilter:init - Initializing > >> planet cache > >> INFO 2006-03-04 10:10:39,152 PlanetCacheFilter:init - {timeout=1800, > >> excludeOwnerEditPages=false, size=10} > >> INFO 2006-03-04 10:10:39,176 ReferrerQueueManagerImpl:<init> - > >> Initializing Referrer Queue Manager > >> INFO 2006-03-04 10:10:39,177 ReferrerQueueManagerImpl:<init> - > >> Asynchronous referrer processing = false > >> WARN 2006-03-04 10:10:39,178 RollerImpl:shutdown - > >> java.lang.NullPointerException > >> INFO 2006-03-04 10:10:39,180 SessionFactoryImpl:close - closing > >> > >> > >> > >> > >> -- > >> Kings are Earth's Gods: in vice their laws their will > >> And if Jove stray, who dares say Jove doth ill? -Shakespeare > >> > > > -- > Kings are Earth's Gods: in vice their laws their will > And if Jove stray, who dares say Jove doth ill? -Shakespeare >
