[Building Sakai] problem with resources tool after migration

[Am Khan]

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'

 1.  Applied 2.5.0 to 2.5.2 conversion script using command line.
 2.  Applied 2.5 to 2.6 conversion script using command line.
I am not sure what is going on!

Thanks and regards,
Am Khan

________________________________
From: DAVID ROLDAN MARTINEZ [mailto:darolmar at upvnet.upv.es]
Sent: Friday, June 19, 2009 2:31 AM
To: Am Khan; sakai-dev at collab.sakaiproject.org
Subject: RE: 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

De: sakai-dev-bounces at collab.sakaiproject.org [mailto:sakai-dev-bounces at collab.sakaiproject.org] En nombre de Am Khan
Enviado el: martes, 16 de junio de 2009 23:01
Para: sakai-dev at collab.sakaiproject.org
Asunto: [Building Sakai] problem with resources tool after migration


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

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