Upgrading several BASE versions in one go is not really something that is supported. Usually we only test the update script between one version and the next. The 119->120 change belongs to BASE 3.5 and it seems like it fails due to changes that was made in BASE 3.7.
The BASE versions 3.5, 3.6 and 3.7 all contain several database changes so I would recommend that at least those upgrades are made one step at a time. The 3.8 and 3.9 versions are not making any major changes to the database so I think it should be possible to go directly from 3.7 to 3.9. /Nicklas On 2016-08-05 15:28, Bob MacCallum wrote: > Dear BASE guys, > > I got the error below with updatedb.sh > > I've had a look at Update.java and I'm afraid the hibernate stuff is > outside my comfort zone... > > Please could you let me any further information you need to diagnose? > cheers, > Bob > > > [72%] --Creating platforms... > [73%] --Creating news... > [75%] Database initialised successfully. > [75%] Updating database... > [75%] --Updating schema version: 118 -> 119... > [77%] --Updating schema version: 119 -> 120...14:06:22,779 ERROR > Update:1313 - updateToSchemaVersion120: FAILED > org.hibernate.exception.SQLGrammarException: could not execute statement > at > org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:63) > at > org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42) > at > org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109) > at > org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:95) > at > org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:207) > at > org.hibernate.engine.query.spi.NativeSQLQueryPlan.performExecuteUpdate(NativeSQLQueryPlan.java:194) > at > org.hibernate.internal.SessionImpl.executeNativeUpdate(SessionImpl.java:1373) > at > org.hibernate.internal.SQLQueryImpl.executeUpdate(SQLQueryImpl.java:373) > at net.sf.basedb.core.Update.updateToSchemaVersion120(Update.java:1280) > at net.sf.basedb.core.Update.updateDatabase(Update.java:465) > at net.sf.basedb.install.InitDB.main(InitDB.java:86) > Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: > Unknown column 'removed' in 'field list' > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) > at > sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) > > > > ------------------------------------------------------------------------------ > > > > _______________________________________________ > The BASE general discussion mailing list > basedb-users@lists.sourceforge.net > unsubscribe: send a mail with subject "unsubscribe" to > basedb-users-requ...@lists.sourceforge.net > ------------------------------------------------------------------------------ _______________________________________________ The BASE general discussion mailing list basedb-users@lists.sourceforge.net unsubscribe: send a mail with subject "unsubscribe" to basedb-users-requ...@lists.sourceforge.net