[MOBY-dev] critical update required for those with a local MOBY Central installation

[Mark Wilkinson]

Hi all, 

Rebecca noticed a bug this AM that results in incorrect writing of
records to the database for services with collections of inputs and
outputs.  I have fixed the code, and you can get it from a CVS update. 
I have also fixed the public registry; however anyone who is running a
local copy of the MOBY Central registry will have to "patch" their
database with the following two SQL commands:

use mobycentral;

update simple_input set service_instance_id=NULL where
collection_input_id IS NOT NULL and service_instance_id IS NOT NULL;

update simple_output set service_instance_id=NULL where
collection_output_id IS NOT NULL and service_instance_id IS NOT NULL



(don't forget to make a dump of the mobycentral table first, just to be
safe!!!)

Sorry about that!  Contact me if you have any questions.

Mark


-- 
Mark Wilkinson
Assistant Professor (Bioinformatics)
Dept. Medical Genetics, UBC, Canada