Re: [Building Sakai] problem with resources tool after migration

Hi David, 

I haven’t executed migration scripts before.  I am running MySql.

1. I backed up the old database and restored it on a new server using mysql command line
2. Applied the 2.4 to 2.5 conversion script using SQLyog.  Wasn’t able to use command line, I was getting the following error:

C:\wamp\bin\mysql\mysql5.1.33\bin>mysql -u root sakai < "c:\sakai_2_4_0-2_5_0_mysql_conversion.sql"

ERROR 1062 (23000) at line 164: Duplicate entry '0' for key 'PRIMARY'

3. Applied 2.5.0 to 2.5.2 conversion script using command line.
4. Applied 2.5 to 2.6 conversion script using command line.

I am not sure what is going on!

Thanks and regards,

Am Khan

Am,

Have you executed migration scripts before? At sakai_2_4_0-2_5_0_oracle_conversion.sql there are several updates onto resources tables and maybe the problem you are experiencing is that you should run them but you hadn’t.

We have also migrated from 2.4.x. to 2.6.x and haven’t found any issue like this.

David

I have migrated our Sakai 2.4 to Sakai 2.6 and lost the resources.  

In Sakai 2.4

When I click on resources and go to root/simpleAccess/mercury, I see a test.txt file. If I open the file I see “Hello there!”

In 2.6

I see the file but if I open it I don’t see any content.

I am having same problem with all the other documents.

Thanks and regards

Am Khan