I don't know what this issue was caused by but it went away. Now I'm
trying to upgrade my existing site to 4.0. I believe I'm currently
running an RC of 3.1. Here's the error I'm getting:
INFO 2007-10-09 10:35:08,153 DatabaseProvider:successMessage -
SUCCESS: Got parameters. Using configuration type JNDI_NAME
INFO 2007-10-09 10:35:08,157 DatabaseProvider:successMessage - --
Using JNDI datasource name: java:comp/env/jdbc/rollerdb
INFO 2007-10-09 10:35:08,159 DatabaseProvider:successMessage -
SUCCESS: located JNDI DataSource [java:comp/env/jdbc/rollerdb]
INFO 2007-10-09 10:35:08,571 DatabaseInstaller:upgradeDatabase -
Database is old, beginning upgrade to version 400
ERROR 2007-10-09 10:35:08,599 DatabaseInstaller:errorMessage - Problem
upgrading database to version 320
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column
'parentid' in 'field list'
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2941)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1623)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1715)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3249)
at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1268)
at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1541)
at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1455)
at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1440)
at
org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
at
org.apache.roller.weblogger.business.startup.DatabaseInstaller.upgradeTo400(DatabaseInstaller.java:741)
at
org.apache.roller.weblogger.business.startup.DatabaseInstaller.upgradeDatabase(DatabaseInstaller.java:245)
at
org.apache.roller.weblogger.business.startup.WebloggerStartup.prepare(WebloggerStartup.java:192)
at
org.apache.roller.weblogger.ui.core.RollerContext.contextInitialized(RollerContext.java:138)
at
org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3827)
at
org.apache.catalina.core.StandardContext.start(StandardContext.java:4334)
at
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
at
org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)
at
org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:626)
at
org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:553)
at
org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:488)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)
at
org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
at
org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at
org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at
org.apache.catalina.core.StandardService.start(StandardService.java:516)
at
org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:566)
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:288)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
FATAL 2007-10-09 10:35:08,603 RollerContext:contextInitialized -
Roller Weblogger startup failed during app preparation
org.apache.roller.weblogger.business.startup.StartupException: Problem
upgrading database to version 320
at
org.apache.roller.weblogger.business.startup.DatabaseInstaller.upgradeTo400(DatabaseInstaller.java:764)
at
org.apache.roller.weblogger.business.startup.DatabaseInstaller.upgradeDatabase(DatabaseInstaller.java:245)
at
org.apache.roller.weblogger.business.startup.WebloggerStartup.prepare(WebloggerStartup.java:192)
at
org.apache.roller.weblogger.ui.core.RollerContext.contextInitialized(RollerContext.java:138)
at
org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3827)
at
org.apache.catalina.core.StandardContext.start(StandardContext.java:4334)
at
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
at
org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)
at
org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:626)
at
org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:553)
at
org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:488)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)
at
org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
at
org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at
org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at
org.apache.catalina.core.StandardService.start(StandardService.java:516)
at
org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:566)
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:288)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
--- ROOT CAUSE ---
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column
'parentid' in 'field list'
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2941)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1623)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1715)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3249)
at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1268)
at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1541)
at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1455)
at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1440)
at
org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
at
org.apache.roller.weblogger.business.startup.DatabaseInstaller.upgradeTo400(DatabaseInstaller.java:741)
at
org.apache.roller.weblogger.business.startup.DatabaseInstaller.upgradeDatabase(DatabaseInstaller.java:245)
at
org.apache.roller.weblogger.business.startup.WebloggerStartup.prepare(WebloggerStartup.java:192)
at
org.apache.roller.weblogger.ui.core.RollerContext.contextInitialized(RollerContext.java:138)
at
org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3827)
at
org.apache.catalina.core.StandardContext.start(StandardContext.java:4334)
at
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
at
org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)
at
org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:626)
at
org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:553)
at
org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:488)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)
at
org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
at
org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at
org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at
org.apache.catalina.core.StandardService.start(StandardService.java:516)
at
org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:566)
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:288)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
Any ideas?
Matt
On 10/5/07, Dave <[EMAIL PROTECTED]> wrote:
> On 10/5/07, Matt Raible <[EMAIL PROTECTED]> wrote:
> > My roller-custom.properties (in tomcat6/lib) doesn't seem to be
> > getting picked up. Therefore, my legacy theme doesn't work. Any ideas?
> > Here's the contents:
> >
> > plugins.page=\
> > org.apache.roller.ui.rendering.plugins.ConvertLineBreaksPlugin \
> > ,org.apache.roller.ui.rendering.plugins.TopicTagPlugin \
> > ,org.apache.roller.ui.rendering.plugins.WikipediaLinkPlugin \
> > ,org.apache.roller.ui.rendering.plugins.GoogleLinkPlugin \
> > ,org.apache.roller.ui.rendering.plugins.AcronymsPlugin \
> > ,org.apache.roller.ui.rendering.plugins.BookmarkPlugin \
> > ,org.apache.roller.ui.rendering.plugins.ObfuscateEmailPlugin \
> > ,org.apache.roller.ui.rendering.plugins.SmileysPlugin \
> > ,net.java.dev.roller.plugins.weblogentry.jspwiki.WikiPlugin
>
> Take a look at the roller.properties file at the end of the
> installation guide to get the correct package names for those plugins.
>
> - Dave
>
--
http://raibledesigns.com
