[Babase] Now I'm stuck in mtd_cycles

Karl O. Pinc kop at meme.com
Wed Jan 23 13:39:37 EST 2008


On 01/23/2008 10:50:47 AM, kfenn wrote:
> Hi Karl,
> 
> I'm now stuck trying to use UPLOAD to get the mtd_cycles in.  I'm  
> getting the following error:
> 
> ERROR: insert or update on table "cycpoints" violates foreign key  
> constraint "Cid on CYCLES" DETAIL: Key (cid)=(26762) is not present  
> in table "cycles".
> 
> I started with a whole group of cycles for Omos group but now now am  
> just trying single cycles.  Each time I try again, the cid number  
> changes so this error doesn't seem linked to a specific  
> individual...it's like it can't parse the info back into the tables  
> correctly from the view, but I really don't want to have to upload  
> into the tables themselves.  That was the whole point of having the  
> views.
> I've re-read your email advice from before (below) and read the  
> documentations on the mtd_cycles view but I can't figure this out and  
> I'm all out of chickens.

This was a bug in the mtd_cycles view.  I expect that it's now fixed.

(Note that in babase test I accidently put in your omo2 file

sname	mdate	tdate	ddate
ORI		2007-01-01	2007-01-16

and then had to manually remove it.  Babase_test _should_ be
like it was before I started....)


Karl <kop at meme.com>
Free Software:  "You don't pay back, you pay forward."
                  -- Robert A. Heinlein



More information about the Babase mailing list