Ticket #535 (closed defect: fixed)

Opened 11 months ago

Last modified 7 months ago

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

Changed 7 months ago by mortonda@…

  • status changed from new to closed
  • resolution set to fixed

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.