Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Sproc GetDuplicateEmailCount errors out, if there are more than one duplicate emails

Description

Stored procedure returns an error, if there are more than one duplicate emails in users table.
Error message: subquery returns more than one record

Steps to reproduce:

  • enter site settings on a website like dnnsoftware.com

  • set to use email address as login (require unique email addresses)

  • click save

  • will return error message above

  • expected: no error message, but number of items

Besides, the procedure misses to check superusers, who need to be included in the unique check

QA Test Plan

None

Activity

Show:

Sebastian Leupold January 11, 2016 at 11:18 AM

improved upgrade check included

Francesco Rivola November 25, 2015 at 10:35 AM

Descoped from 8.0.0 release based on 's comment.

Sebastian Leupold November 22, 2015 at 11:28 PM

@Antonio: sorry, I can't waste additional time with your tooling atm and pulled the request.
FIx is included in TurboDNN for my clients and users.
I'll try to re-submit next year, may be I'll have more luck to get it accepted.

Antonio D. González November 20, 2015 at 9:56 AM

Hi , as we commented in the existing pull request, we would need a valid pull request against the development branch before we can merge this. Thanks.

Sebastian Leupold November 17, 2015 at 1:40 PM

Note:
There are two use cases for this stored procedure:

  • when a website user is created and added to a site (PortalID >= 0)

  • when a superuser is added to the system (PortalID = -1 or is Null), who needs to be unique across all sites

Details

Assignee

Reporter

Story Size

Unknown

Severity

Major

Triage

Triaged

Reported in Build #

Includes Code Fix

No

Components

Affects versions

Priority

Created September 5, 2015 at 12:10 PM
Updated January 25, 2017 at 1:13 AM