Hi Everyone I'm sitting on this database error at host registration: Caused by: org.opencastproject.serviceregistry.api.ServiceRegistryException: javax.persistence.RollbackException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.0.2.v20100323-r6872): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLException: Field 'ID' doesn't have a default value Error Code: 1364 Call: INSERT INTO HOST_REGISTRATION (HOST, MAINTENANCE, MAX_JOBS, ONLINE) VALUES (?, ?, ?, ?) bind => [http://srvslsopc003.uct.ac.za, false, 4, true] Query: InsertObjectQuery(http://gsadcbjdhbv.uct.ac.za) at org.opencastproject.serviceregistry.impl.ServiceRegistryJpaImpl.registerHost(ServiceRegistryJpaImpl.java:468) at org.opencastproject.serviceregistry.impl.ServiceRegistryJpaImpl.activate(ServiceRegistryJpaImpl.java:161)
This happens on a clean install of Matterhorn and MySql (v5.5.9-1) after manually running the ddl sql scripts. The Matterhorn startup fails after this. Looks like the HOST_REGISTRATION table is missing a default value. If this is a bug on the 1.1.x branch I'll file a jira. Thanks -- Lovemore Nalube OLE Developer (Vula) University of Cape Town http://www.cet.uct.ac.za/LovemoreN ### UNIVERSITY OF CAPE TOWN This e-mail is subject to the UCT ICT policies and e-mail disclaimer published on our website at http://www.uct.ac.za/about/policies/emaildisclaimer/ or obtainable from +27 21 650 9111. This e-mail is intended only for the person(s) to whom it is addressed. If the e-mail has reached you in error, please notify the author. If you are not the intended recipient of the e-mail you may not use, disclose, copy, redirect or print the content. If this e-mail is not related to the business of UCT it is sent by the sender in the sender's individual capacity. ###
_______________________________________________ Matterhorn mailing list [email protected] http://lists.opencastproject.org/mailman/listinfo/matterhorn To unsubscribe please email [email protected] _______________________________________________
