[Building Sakai] SAKAI 2.6 UPGRADE FW: auto.ddl=false - CONTENT_RESOURCE

[Yzelle, Sonette]

This message (and attachments) is subject to restrictions and a disclaimer. Please refer to http://www.unisa.ac.za/disclaimer for full details.
________________________________

Hi,

I am still experiencing the same problem when starting up tomcat.
Upgrading to 2.6
In sakai.properties auto.ddl is set to false.  However when I startup tomcat it tries the following:
Alter table CONTENT_RESOURCE add FILE_SIZE NUMBER(18) default NULL binds.
This alteration was already done when we ran the database update scripts for the upgrade.
Then I get table does not exist.
I even redid the whole setup and checkout.  Same thing happens.  Do you think I must change the database user access to be able to alter that table?   Any other suggestions?

Regards
SOnette

Sonette Yzelle
Analyst Developer
ICT
UNISA
South Africa
email: syzelle at unisa.ac.za<mailto:syzelle at unisa.ac.za>

From: Nuno Fernandes [mailto:nuno at ufp.edu.pt]
Sent: Thursday, April 22, 2010 3:06 PM
To: Yzelle, Sonette
Subject: Re: FW: auto.ddl=false - CONTENT_RESOURCE

I did double check our sakai.properties. The settings that could be related:

# CONTENT MIGRATION
#convertToContextQueryForCollectionSize at org.sakaiproject.content.api.ContentHostingService = true

# Disable FILE_SIZE checks (once the conversion has run successfully)
content.filesizeColumnReady = true

(make sure that, if the first is present, it is also commented)

Hope it helps,
Nuno


On Thu, Apr 22, 2010 at 10:03 AM, Yzelle, Sonette <SYzelle at unisa.ac.za<mailto:SYzelle at unisa.ac.za>> wrote:
This message (and attachments) is subject to restrictions and a disclaimer. Please refer to http://www.unisa.ac.za/disclaimer for full details.
________________________________

Hi Nuno,
Thanks, but that did not help!
Any other suggestions?

Sonette Yzelle
Analyst Developer
ICT
UNISA
South Africa
email: syzelle at unisa.ac.za<mailto:syzelle at unisa.ac.za>

From: Nuno Fernandes [mailto:nuno at ufp.edu.pt<mailto:nuno at ufp.edu.pt>]
Sent: Thursday, April 22, 2010 10:14 AM
To: Yzelle, Sonette
Subject: Re: FW: auto.ddl=false - CONTENT_RESOURCE

Hi Sonette!

Please try adding the following property to sakai.properties file and see if it fixes:

content.filesizeColumnReady = true

Hope it helps,
Nuno

On Wed, Apr 21, 2010 at 12:51 PM, Yzelle, Sonette <SYzelle at unisa.ac.za<mailto:SYzelle at unisa.ac.za>> wrote:
This message (and attachments) is subject to restrictions and a disclaimer. Please refer to http://www.unisa.ac.za/disclaimer for full details.
________________________________

Hi Nuno,

Can I bother you please?
See email below.  I don't think sakai-dev email group mails are going through so I am e-mailing you personally - sorry.

Thanks
Sonette

From: Yzelle, Sonette
Sent: Wednesday, April 21, 2010 11:57 AM
To: sakai-dev at collab.sakaiproject.org<mailto:sakai-dev at collab.sakaiproject.org>
Subject: auto.ddl=false - CONTENT_RESOURCE

Good day,

Upgrading to 2.6
In sakai.properties auto.ddl is set to false.  However when I startup tomcat it tries the following:
Alter table CONTENT_RESOURCE add FILE_SIZE NUMBER(18) default NULL binds.

This alteration was already done when we ran the database update scripts for the upgrade.

Why is it trying to do the alteration even with auto.ddl=false?  What can I do to prevent it from doing that alteration?

Regards
Sonette

Sonette Yzelle
Analyst Developer
ICT
UNISA
South Africa
email: syzelle at unisa.ac.za<mailto:syzelle at unisa.ac.za>




--
Nuno Fernandes  .  { Analyst/Programmer }

|| web  . { http://www.ufp.pt  |  http://tinyurl.com/nfgrilo  |  follow_me @ nfgrilo }
|| work . { Universidade Fernando Pessoa  |  Praça 9 de Abril, 349  |  4249-004 Porto }



--
Nuno Fernandes  .  { Analyst/Programmer }

|| web  . { http://www.ufp.pt  |  http://tinyurl.com/nfgrilo  |  follow_me @ nfgrilo }
|| work . { Universidade Fernando Pessoa  |  Praça 9 de Abril, 349  |  4249-004 Porto }
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20100429/158613d7/attachment.html