[Building Sakai] Sakai 2.6.x migration issue

[DAVID ROLDAN MARTINEZ]

Dear Am,

Context field is added to SAKAI_EVENT at sakai_2_6_0_oracle_conversion.sql. I attach all the scripts we have used to migrate from 2.4.x to 2.6.x. Review them, because there are some lines commented as they don't apply to our installation (for example, we don't use OSP tools).

Let me know if you need further information or help.

David



De: sakai-dev-bounces at collab.sakaiproject.org [mailto:sakai-dev-bounces at collab.sakaiproject.org] En nombre de Am Khan
Enviado el: viernes, 05 de junio de 2009 19:48
Para: sakai-dev at collab.sakaiproject.org
Asunto: [Building Sakai] Sakai 2.6.x migration issue

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/20090619/429d2561/attachment.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: scripts_migracion.rar
Type: application/octet-stream
Size: 20952 bytes
Desc: scripts_migracion.rar
Url : http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20090619/429d2561/attachment.obj