[Building Sakai] Sakai 2.6.x migration issue

Am Khan akhan at acoe.org
Fri Jun 5 10:47:34 PDT 2009


Hi,

I am migrating our Sakai 2.4 to Sakai 2.6.x.  I applied the following upgrade scripts for mysql

https://source.sakaiproject.org/svn/reference/tags/sakai_2-5-0/docs/conversion/sakai_2_4_0-2_5_0_mysql_conversion.sql
https://source.sakaiproject.org/svn/reference/tags/sakai_2-5-1/docs/conversion/sakai_2_5_0-2_5_1_mysql_conversion.sql

However, I am running into the following problem:

2009-06-04 23:14:52,303  WARN org.sakaiproject.event.impl.ClusterEventTracking$$EnhancerByCGLIB$$267445f1 org.sakaiproject.db.impl.BasicSqlService - Sql.dbRead: sql: select EVENT_ID,EVENT_DATE,EVENT,REF,SAKAI_EVENT.SESSION_ID,EVENT_CODE,CONTEXT,SESSION_SERVER from   SAKAI_EVENT,SAKAI_SESSION where (SAKAI_EVENT.SESSION_ID = SAKAI_SESSION.SESSION_ID) and (EVENT_ID > ?) 1607336
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'CONTEXT' in 'field list'
            at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
            at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
            at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
            at com.mysql.jdbc.Connection.execSQL(Connection.java:3283)
            at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332)
            at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1467)
            at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
            at org.sakaiproject.db.impl.BasicSqlService.dbRead(BasicSqlService.java:545)
            at org.sakaiproject.db.impl.BasicSqlService.dbRead(BasicSqlService.java:464)
            at org.sakaiproject.event.impl.ClusterEventTracking.run(ClusterEventTracking.java:510)
            at java.lang.Thread.run(Unknown Source)



Also, the link to summary page for Wiki 2-6-x branch is broken so I am not sure if there is sql script that will fix the problem.

Thanks and regards
Am Khan

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20090605/9811a2d2/attachment.html 


More information about the sakai-dev mailing list