[325] in Project_DB
Re: Update Failed
daemon@ATHENA.MIT.EDU (Larry Stone)
Thu Apr 9 19:36:09 1998
Date: Thu, 9 Apr 98 19:36:03 EDT
From: Larry Stone <lcs@MIT.EDU>
To: dbaron@MIT.EDU (Dennis Baron)
Cc: miki@MIT.EDU, project-db@MIT.EDU
In-Reply-To: Your message of Thu, 09 Apr 1998 14:23:11 EDT
> Thanks - this fixed the second problem that I reported. It is strange
> that it sorted the comments into non-chronological order:
Miki is the one who fixed it (for now), by adding you to the directors
list. She is in the process of correcting several kinds of anomalies
she found in the database.
We'll look into the comment problem, not sure when.
I think Miki is looking into the problem with project 921 below, too.
How are you identified at the top of the page, as "dbaron" or "dennis"?
If you use the certificate for "dennis", permission shouldn't be a
problem, since that is now listed as the creator of the project.
> >Comments get placed as a bulleted list below the description on the project information page.
> >
> > dennis (15-MAY-1997 07:45): Funding of approx. $150K allocated from Service budget for FY97 DELETE
> > dennis (27-JUN-1997 12:03): Completion date dependent on receiving permits from Cambridge in July. DELETE
> > dennis (05-AUG-1997 12:54): On hold pending premission from the City of Cambridge. DELETE
> > dennis (09-APR-1998 13:13): Scheduled to be completed 6/30/98. DELETE
> > dennis (22-DEC-1997 13:24): Permit from City of Cambridge received. DELETE
>
> See:
>
> https://arachne.mit.edu/fcgi-bin/brlfcgi/brlpdb/projmod.html?projid=121
>
> It almost looks like it is sorting them by time-of-day and not date?
> The project page doesn't display the dates so it's a little confusing
> to have them show up out of order.
>
> I'm still having the first problem I reported. When I try to update on:
>
> https://arachne.mit.edu/fcgi-bin/brlfcgi/brlpdb/projmod.html?projid=921
>
> I get:
>
> Scheme Error
>
> The object (error "ORA-02290: check constraint
> (PDB.SYS_C00435) violated\n (update pdb.my_project_data\n set
> current_q_ach='NONE.', commitment='()'\n where project_id =
> 921)\n"), passed as the first argument to integer-zero?, is
> not the correct type.
>
> Dennis
