[Building Sakai] problem with resources tool after migration

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

Am,

Can you check that there is not error at sakai_2_4_0-2_5_0_mysql_conversion.sql? What happens at line 164? There is (at least) an entry not present in your database, as the insert has failed. I were you, I would restore the old database and execute scripts once again. Remember that sakai_2_4_0-2_5_0_mysql_conversion.sql has sentences affecting resource tables. Maybe this is the problem.

Let me know.

David

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