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]
