Thank you Nicklas, that works in four steps no problems at all. On Mon, Aug 8, 2016 at 8:42 AM, Nicklas Nordborg <nicklas.nordb...@med.lu.se > wrote:
> > 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 >
------------------------------------------------------------------------------
_______________________________________________ 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
