[Building Sakai] Melete 2.6 upgrade ddl?

[Holladay, Bryan Andrew]

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




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