[Building Sakai] resources still not showing up in Sakai 2.6 after migration!

[Am Khan]

I am trying to migrate from Sakai 2.4 to 2.6. I am not seeing my resources in 2.6 after migration. I see the links to the documents but don't see the actual documents. Also, I don't get any errors. I ran the following scripts:

1. https://source.sakaiproject.org/svn/reference/tags/sakai_2-5-0/docs/conversion/sakai_2_4_0-2_5_0_mysql_conversion.sql
2. https://source.sakaiproject.org/svn/reference/tags/sakai_2-5-1/docs/conversion/sakai_2_5_0-2_5_1_mysql_conversion.sql
3. https://source.sakaiproject.org/svn/reference/tags/sakai_2-5-2/docs/conversion/sakai_2_5_0-2_5_2_mysql_conversion.sql
4. https://source.sakaiproject.org/svn/reference/branches/sakai_2-6-x/docs/conversion/sakai_2_6_0_mysql_conversion.sql
5. http://jira.sakaiproject.org/browse/SAK-15513

I ran into two problems with the database migration scripts:

1. sakai_2_4_0-2_5_0_mysql_conversion.sql

mysql -u sakaiuser -p sakai < /home/acoe/sakai_upgrade_scripts/sakai/sakai_2_4_0-2_5_0_mysql_conversion.sql
ERROR 1005 (HY000) at line 61: Can't create table './sakai/#sql-835_6d.frm' (errno: 150)

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

Works much better if I switch the statements
CREATE INDEX IE_MAILARC_SUBJECT ON MAILARCHIVE_MESSAGE
 (
        SUBJECT                   ASC
 );
 ALTER TABLE MAILARCHIVE_MESSAGE ADD COLUMN (
        SUBJECT           VARCHAR (255) NULL,
        BODY              LONGTEXT NULL
 );

I know I need to run two more scripts but it shouldn't impact content hosting.
assignments: http://jira.sakaiproject.org/browse/SAK-15907
mailarchive: http://jira.sakaiproject.org/browse/SAK-15512



Thanks and regards
Am Khan

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