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


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

[1322] and [1323] implement this fix

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.