[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