I tried dropping the database altogether and starting with a clean
database. This gives me the following error. Maybe I need to read the
install guide? ;-)
INFO 2007-09-17 14:43:09,659 WebloggerImpl:initialize - Initializing
Roller Weblogger business tier
FATAL 2007-09-17 14:43:11,546 JPAPropertiesManagerImpl:initialize -
Failed to initialize runtime configuration properties.Please check
that the database has been upgraded!
<0.9.7-incubating nonfatal general error>
org.apache.openjpa.persistence.PersistenceException: Table
'roller.roller_properties' doesn't exist {prepstmnt 906478 SELECT
t0.name, t0.value FROM roller_properties t0} [code=1146, state=42S02]
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.QueryImpl.execute(QueryImpl.java:762)
at
org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:517)
at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:230)
at
org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:269)
at
org.apache.roller.weblogger.business.jpa.JPAPropertiesManagerImpl.getProperties(JPAPropertiesManagerImpl.java:117)
at
org.apache.roller.weblogger.business.jpa.JPAPropertiesManagerImpl.initialize(JPAPropertiesManagerImpl.java:77)
at
org.apache.roller.weblogger.business.WebloggerImpl.initialize(WebloggerImpl.java:301)
at
org.apache.roller.weblogger.ui.core.RollerContext.contextInitialized(RollerContext.java:159)
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.deployDirectory(HostConfig.java:920)
at
org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:883)
at
org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492)
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)
Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Table
'roller.roller_properties' doesn't exist {prepstmnt 906478 SELECT
t0.name, t0.value FROM roller_properties t0} [code=1146, state=42S02]
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:191)
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$800(LoggingConnectionDecorator.java:56)
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeQuery(LoggingConnectionDecorator.java:843)
at
org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:262)
at
org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeQuery(JDBCStoreManager.java:1372)
at
org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:252)
at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:359)
at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:317)
at
org.apache.openjpa.jdbc.sql.LogicalUnion$UnionSelect.execute(LogicalUnion.java:407)
at
org.apache.openjpa.jdbc.sql.LogicalUnion.execute(LogicalUnion.java:218)
at
org.apache.openjpa.jdbc.sql.LogicalUnion.execute(LogicalUnion.java:208)
at
org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.open(SelectResultObjectProvider.java:94)
at
org.apache.openjpa.lib.rop.EagerResultList.<init>(EagerResultList.java:34)
... 36 more
NestedThrowables:
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table
'roller.roller_properties' doesn't exist
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3124)
at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1149)
at
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1262)
at
org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
Matt
On 9/17/07, Matt Raible <[EMAIL PROTECTED]> wrote:
> First thing I noticed is the META-INF/context.xml-example. I like it!
>
> The rumor is I can install the exploded WAR and install Tomcat and get
> prompted to create everything. I'll try that first...
>
> Nope, no dice. I get a 500 error - in Spanish no less:
>
> Excepción inesperada
> Status Code 500
> Message An exception occurred processing JSP page /index.jsp at line
> 31 28: } else { 29: // dispatch to setup page 30: RequestDispatcher
> setuppage = request.getRequestDispatcher("/roller-ui/setup.rol"); 31:
> setuppage.forward(request, response); 32: } 33: 34: %> Stacktrace:
> Type
> Exception Roller ha encontrado y registrado una excepción inesperada.
>
> From the logs:
>
> 2007-09-17 14:32:46,804 PreviewServlet:init - Initializing PreviewServlet
> WARN 2007-09-17 14:32:57,092 WebloggerRuntimeConfig:getProperty -
> Trouble accessing property: site.frontpage.weblog.handle
> java.lang.IllegalStateException: Roller Weblogger has not been bootstrapped
> yet
> at
> org.apache.roller.weblogger.business.WebloggerFactory.getWeblogger(WebloggerFactory.java:60)
> at
> org.apache.roller.weblogger.config.WebloggerRuntimeConfig.getProperty(WebloggerRuntimeConfig.java:66)
> at org.apache.jsp.index_jsp._jspService(index_jsp.java:55)
>
> Oh well, I'll go ahead and create a new database from scratch and
> setup context.xml myself.
>
> Hmmm, no WEB-INF/dbscripts. I guess I'll just setup context.xml.
>
> I'll be daring and point it at my same database and drop my custom
> theme into the themes directory. Cross your fingers!
>
> Similar error:
>
> Status Code 500
> Message javax.servlet.ServletException:
> java.lang.IllegalStateException: Roller Weblogger has not been
> bootstrapped yet
> Type
> Exception Roller ha encontrado y registrado una excepción inesperada.
>
> Maybe I'll try removing my 3.1.1 install at ROOT and moving 4.0 from
> roller to ROOT. That didn't work, but tailing my logs, the following
> error is in there:
>
> INFO 2007-09-17 14:39:06,100 DatabaseInstaller:upgradeDatabase -
> Database is old, beginning upgrade to version 400
> ERROR 2007-09-17 14:39:06,159 DatabaseInstaller:errorMessage - Problem
> upgrading database to version 320
> com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column
> 'parentid' in 'field list'
>
> Is there an upgrade script I should try running to get my (seemingly
> working) database from 3.1.x to 4.x?
>
> Thanks,
>
> Matt
>
>
> On 9/17/07, Dave <[EMAIL PROTECTED]> wrote:
> > Thanks for everybody's help in finding and fixing 4.0 bugs. I just
> > updated my site to use the latest build and uploaded RC2 for testing.
> > Unless we find some critical issue(s), I'm going to call for a release
> > vote on Wednesday. So please take the new release for a spin.
> >
> > Release files:
> >
> > Can be found here: http://people.apache.org/~snoopdave/apache-roller-4.0
> >
> > Fixes since RC1:
> >
> > * Deleted entries still visible
> > http://opensource.atlassian.com/projects/roller/browse/ROL-1540
> >
> > * Errors in PostgreSQL migration script
> > http://opensource.atlassian.com/projects/roller/browse/ROL-1563
> >
> > * Roller Admin Protocol broken
> > http://opensource.atlassian.com/projects/roller/browse/ROL-1560
> >
> > * Wrong path resource with I18N name or path
> > http://opensource.atlassian.com/projects/roller/browse/ROL-1542
> >
> > * Theme preview bug
> > http://opensource.atlassian.com/projects/roller/browse/ROL-1561
> >
> > * Resources.jsp bug
> > http://opensource.atlassian.com/projects/roller/browse/ROL-1562
> >
> > * Atom protocol fixes
> > http://opensource.atlassian.com/projects/roller/browse/ROL-1533
> >
> > * Multiple problems with database auto-upgrade
> > http://opensource.atlassian.com/projects/roller/browse/ROL-1548
> >
>
>
> --
> http://raibledesigns.com
>
--
http://raibledesigns.com
