Opened 11 years ago

Closed 10 years ago

#535 closed defect (fixed)

maia_users.primary_email_id should be unique - duplicate digests sent

Reported by: mortonda@… Owned by: mortonda@…
Priority: normal Milestone: 1.0.3
Component: SQL scripts Version: 1.0.2
Severity: normal Keywords:
Cc:

Description

A problem arises when maia_users.primary_email_address has duplicate values. This causes a query in send-quarantine-digets.pl to send duplicate digest messages to the same address, but secretly to multiple maia_users.

It is an error to have multiple Maia users share a users row. An unique index needs to be added to the database schema.

When updating the schema, it may fail due to existing problems, how should it be handled?

Change History (1)

comment:1 Changed 10 years ago by mortonda@…

  • Resolution set to fixed
  • Status changed from new to closed

addresses can only have one maia_user_id, so update the incorrect primary_email_id to an existing one.

fixed [1452]

Note: See TracTickets for help on using tickets.