#303 need error check for adding annotation without reference

closed-fixed
nobody
None
5
2006-07-27
2006-07-26
Tanya Berardini
No

Right now, you can add an annotation into the db via
the web interface without having selected a reference.
This should be reported as an error.

From the table description:
+------------------------+---------------+------+-----+------------+----------------+
| Field | Type | Null | Key |
Default | Extra |
| pub_reference_id | int(12) | YES | MUL |
NULL | |

The default is null. Can we set this to not null to
solve this problem?

Thanks,

Tanya

Discussion

  • Logged In: YES
    user_id=579762

    Shanker altered the pub_termannotation table so that this
    field is not allowed to be null anymore. With this change,
    an error message is triggered when trying to add an
    annotation without a reference. Tested on
    pub_curator_sandbox and tesuque.stanford.edu:9999/sandbox.
    Shanker will propagate this change to pub, pub2 and pubstaging.

     
    • status: open --> pending
     
    • status: pending --> closed-fixed
     
  • Logged In: YES
    user_id=579762

    Confirmed that table has been altered in pub and error is
    reported when attempting to insert an annotation without a
    reference. Closing bug.