[Building Sakai] Melete 2.6 upgrade ddl?

[Rashmi Maheshwari]

Hi Bryan,
Which sakai version are you using? Can you pl try adding a resource item 
through Resources tool.

thanks,
Rashmi
Melete Team

Holladay, Bryan Andrew wrote:
> That fixed the missing table issue I was having but it exposed another 
> issue:
>
> 2009-04-20 16:06:23,232 WARN http-8080-Processor22 
> org.sakaiproject.db.impl.BasicSqlService - Sql.dbWrite(): error code: 
> 17041 sql: insert into CONTENT_RESOURCE 
> (RESOURCE_ID,IN_COLLECTION,CONTEXT,FILE_SIZE,RESOURCE_TYPE_ID,FILE_PATH,BINARY_ENTITY, 
> XML) values ( ?, ?, ?, ?, ?, ?, ? , NULL ) binds: 
> /private/meleteDocs/50abc348-2b34-44ae-00f5-c07e7e95e7ca/module_22183936/Section_22282242.html 
> /private/meleteDocs/50abc348-2b34-44ae-00f5-c07e7e95e7ca/module_22183936/ 
> /b01/2009/110/20/0b360f0e-1531-4e39-a803-27c2234193a1 [B at f61a49
> java.sql.SQLException: Missing IN or OUT parameter at index:: 5
>
> I looked at the code and it is being thrown at
>
> resource = getContentservice().addResource(name, addCollId, 
> MAXIMUM_ATTEMPTS_FOR_UNIQUENESS, res_mime_type, secContentData, res, 0);
> In MeleteCHServiceImpl.java
>
> Does that look familiar?
>
> I’ve already added a 2.6 upgrade patch to my melete build.
>
> Thanks,
> Bryan
>
>
> On 4/20/09 3:40 PM, "Bryan Holladay" <bahollad at indiana.edu> wrote:
>
>     Ok thanks Rashmi and Matthew!
>
>
>     On 4/20/09 3:37 PM, "rashmi Maheshwari" <rashmi at etudes.org> wrote:
>
>         Yes, there is an upgrade sql. Look under
>         melete-2.6/components/src/sql/mysql or oracle whichever
>         database you are
>         using and then for melete26_upgrade.sql file.
>
>         You mentioned that you don't have the table
>         MeleteSitePreference, It
>         seems that you are upgrading from a fairly old version.
>         MeleteSitePreference table was added in Melete-2.5.
>         If you are upgrading from a very old version then you need to
>         run all
>         upgrade scripts in between.
>
>         thanks,
>         Rashmi
>
>
>
>         Holladay, Bryan Andrew wrote:
>         > Is there new ddl that needs to be run for the 2.6 melete
>         update? I am
>         > seeing an error when the code tries to run a query against
>         > MeleteSitePreference table, which doesn’t exist in my build.
>         >
>         > Thanks,
>         > Bryan
>         > ------------------------------------------------------------------------
>         >
>         > _______________________________________________
>         > sakai-dev mailing list
>         > sakai-dev at collab.sakaiproject.org
>         > http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>         >
>         > TO UNSUBSCRIBE: send email to
>         sakai-dev-unsubscribe at collab.sakaiproject.org with a subject
>         of "unsubscribe"
>
>
>         --
>         PK
>
>
>
>


-- 
Rashmi Maheshwari
Learning Systems Developer
Etudes Inc
http://etudes.org