[Building Sakai] Sakai 2.6.x migration issue

[David Horwitz]

Hi Am,

Your missing the 2.5 to 2.6 conversion:

https://source.sakaiproject.org/svn/reference/branches/sakai_2-6-x/docs/conversion/sakai_2_6_0_mysql_conversion.sql

David

Am Khan wrote:
> 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
>
>
>   
> ------------------------------------------------------------------------
>
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
> TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20090605/de4665c0/attachment.html