I've found that liquibase 2.0 was not able to upgrade the liquibasechangelog with the new columns. Committed fix in rev:22631.
Please update and see if it has been fixed. Sorry for any trouble it might have caused. --- Regards, Saptarshi PURKAYASTHA My Tech Blog: http://sunnytalkstech.blogspot.com You Live by CHOICE, Not by CHANCE On 17 August 2011 12:30, Saptarshi Purkayastha <[email protected]> wrote: > Hi Darius, > > From the error I understand, one of the columns ORDEREXECUTED has not been > found... In the earlier versions this column did not exist in the > liquibasechangelog table, but exists in 2.0+ > > seems like your got stuck stuck with this... > http://liquibase.jira.com/browse/CORE-980 > I did not find this because I was playing with a new database as well as > old database where it was created fine during the upgrade process but with a > capitalized liquibasechangelog table. This has been outlined here in the > third post: > http://forum.liquibase.org/topic/unknown-column-orderexecuted-during-upgrade > > --- > Regards, > Saptarshi PURKAYASTHA > > My Tech Blog: http://sunnytalkstech.blogspot.com > You Live by CHOICE, Not by CHANCE > > > > On 17 August 2011 09:23, Darius Jazayeri <[email protected]> wrote: > >> Hi Saptarshi, >> >> When I try to run the trunk webapp, I get the exception below. Presumably >> this is due to your upgrading Liquibase. Can you look at this? >> >> -Darius >> >> ERROR - Listener.contextInitialized(154) |2011-08-16 20:49:18,190| Got >> exception while starting up: >> >> java.lang.RuntimeException: Error occurred while trying to get the updates >> needed for the database. Error executing SQL SELECT >> FILENAME,AUTHOR,ID,MD5SUM,DATEEXECUTED,ORDEREXECUTED,TAG,EXECTYPE FROM >> `liquibasechangelog` ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC: Unknown >> column 'ORDEREXECUTED' in 'field list' >> >> at >> org.openmrs.util.DatabaseUpdater.getUnrunDatabaseChanges(DatabaseUpdater.java:605) >> >> at >> org.openmrs.util.DatabaseUpdater.updatesRequired(DatabaseUpdater.java:258) >> >> at org.openmrs.web.Listener.setupNeeded(Listener.java:170) >> >> at org.openmrs.web.Listener.contextInitialized(Listener.java:142) >> >> at >> org.mortbay.jetty.handler.ContextHandler.startContext(ContextHandler.java:540) >> >> at org.mortbay.jetty.servlet.Context.startContext(Context.java:135) >> >> at >> org.mortbay.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1220) >> >> at >> org.mortbay.jetty.handler.ContextHandler.doStart(ContextHandler.java:510) >> >> at org.mortbay.jetty.webapp.WebAppContext.doStart(WebAppContext.java:448) >> >> at >> org.mortbay.jetty.plugin.Jetty6PluginWebAppContext.doStart(Jetty6PluginWebAppContext.java:110) >> >> at >> org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:39) >> >> at >> org.mortbay.jetty.handler.HandlerCollection.doStart(HandlerCollection.java:152) >> >> at >> org.mortbay.jetty.handler.ContextHandlerCollection.doStart(ContextHandlerCollection.java:156) >> >> at >> org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:39) >> >> at >> org.mortbay.jetty.handler.HandlerCollection.doStart(HandlerCollection.java:152) >> >> at >> org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:39) >> >> at >> org.mortbay.jetty.handler.HandlerWrapper.doStart(HandlerWrapper.java:130) >> >> at org.mortbay.jetty.Server.doStart(Server.java:222) >> >> at >> org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:39) >> >> at >> org.mortbay.jetty.plugin.Jetty6PluginServer.start(Jetty6PluginServer.java:132) >> >> at >> org.mortbay.jetty.plugin.AbstractJettyMojo.startJetty(AbstractJettyMojo.java:371) >> >> at >> org.mortbay.jetty.plugin.AbstractJettyMojo.execute(AbstractJettyMojo.java:307) >> >> at >> org.mortbay.jetty.plugin.AbstractJettyRunMojo.execute(AbstractJettyRunMojo.java:203) >> >> at org.mortbay.jetty.plugin.Jetty6RunMojo.execute(Jetty6RunMojo.java:184) >> >> at >> org.apache.maven.plugin.DefaultBuildPluginManager.executeMojo(DefaultBuildPluginManager.java:107) >> >> at >> org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:209) >> >> at >> org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:153) >> >> at >> org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:145) >> >> at >> org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:84) >> >> at >> org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:59) >> >> at >> org.apache.maven.lifecycle.internal.LifecycleStarter.singleThreadedBuild(LifecycleStarter.java:183) >> >> at >> org.apache.maven.lifecycle.internal.LifecycleStarter.execute(LifecycleStarter.java:161) >> >> at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:319) >> >> at org.apache.maven.DefaultMaven.execute(DefaultMaven.java:156) >> >> at org.apache.maven.cli.MavenCli.execute(MavenCli.java:534) >> >> at org.apache.maven.cli.MavenCli.doMain(MavenCli.java:196) >> >> at org.apache.maven.cli.MavenCli.main(MavenCli.java:141) >> >> 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:597) >> >> at >> org.codehaus.plexus.classworlds.launcher.Launcher.launchEnhanced(Launcher.java:290) >> >> at >> org.codehaus.plexus.classworlds.launcher.Launcher.launch(Launcher.java:230) >> >> at >> org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode(Launcher.java:409) >> >> at >> org.codehaus.plexus.classworlds.launcher.Launcher.main(Launcher.java:352) >> >> Caused by: liquibase.exception.DatabaseException: Error executing SQL >> SELECT FILENAME,AUTHOR,ID,MD5SUM,DATEEXECUTED,ORDEREXECUTED,TAG,EXECTYPE >> FROM `liquibasechangelog` ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC: >> Unknown column 'ORDEREXECUTED' in 'field list' >> >> at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62) >> >> at liquibase.executor.jvm.JdbcExecutor.query(JdbcExecutor.java:143) >> >> at liquibase.executor.jvm.JdbcExecutor.query(JdbcExecutor.java:151) >> >> at liquibase.executor.jvm.JdbcExecutor.queryForList(JdbcExecutor.java:203) >> >> at liquibase.executor.jvm.JdbcExecutor.queryForList(JdbcExecutor.java:198) >> >> at >> liquibase.database.AbstractDatabase.getRanChangeSetList(AbstractDatabase.java:853) >> >> at >> liquibase.changelog.DatabaseChangeLog.validate(DatabaseChangeLog.java:129) >> >> at liquibase.Liquibase.listUnrunChangeSets(Liquibase.java:583) >> >> at >> org.openmrs.util.DatabaseUpdater.getUnrunDatabaseChanges(DatabaseUpdater.java:593) >> >> ... 44 more >> >> Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: >> Unknown column 'ORDEREXECUTED' in 'field list' >> >> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) >> >> at >> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) >> >> at >> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) >> >> at java.lang.reflect.Constructor.newInstance(Constructor.java:513) >> >> at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) >> >> at com.mysql.jdbc.Util.getInstance(Util.java:381) >> >> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030) >> >> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) >> >> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3536) >> >> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3468) >> >> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1957) >> >> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2107) >> >> at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2642) >> >> at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2571) >> >> at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1451) >> >> at >> liquibase.executor.jvm.JdbcExecutor$1QueryStatementCallback.doInStatement(JdbcExecutor.java:129) >> >> at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55) >> >> ... 52 more > > > _________________________________________ To unsubscribe from OpenMRS Developers' mailing list, send an e-mail to [email protected] with "SIGNOFF openmrs-devel-l" in the body (not the subject) of your e-mail. [mailto:[email protected]?body=SIGNOFF%20openmrs-devel-l]
