Opened 13 years ago
Last modified 12 years ago
#495 testing defect (fixed)
add_domain() does not check for duplicates
Reported by: | rjl | Owned by: | mortonda@… |
---|---|---|---|
Priority: | normal | Milestone: | 1.0.3 |
Component: | PHP scripts | Version: | 1.0.2 |
Severity: | normal | Keywords: | add_domain domain maia_db.php duplicate |
Cc: |
Description
The add_domain() subroutine in maia_db.php does not check that the supplied domain name exists in the maia_domains table, and blindly INSERTs new rows. If a user tries to add a domain name more than once, repeated entries in the maia_domains and policy tables get created, and only the most recent version gets linked to the users table, orphaning the earlier versions. The maia_domains.domain column and the policy.policy_name table do not have any UNIQUE constraints, so no error is returned from the database driver.
Change History (2)
comment:1 Changed 12 years ago by mortonda@…
- Owner changed from dmorton to mortonda@…
- Status changed from new to accepted
comment:2 Changed 12 years ago by mortonda@…
- Resolution set to fixed
- Status changed from accepted to testing
Note: See
TracTickets for help on using
tickets.
[1322] and [1323] implement this fix