Ticket #495 (testing defect: fixed)

Opened 6 years ago

Last modified 6 years ago

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

Changed 6 years ago by mortonda@…

  • owner changed from dmorton to mortonda@…
  • status changed from new to accepted

[1322] and [1323] implement this fix

Changed 6 years ago by mortonda@…

  • status changed from accepted to testing
  • resolution set to fixed
Note: See TracTickets for help on using tickets.