Error after upgrade - Administration and Configuration

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

Home All Forums

7/20/2016 8:09 AM

James Kaschak

Joined: 6/29/2005

Posts: 48

Error after upgrade

Hi Everyone, I just updated from 7 to DNN 8.0.3 and everything went smoothly as far as i know. I received no errors. The problem is I am going top make some changes to the admin/Site Setting/ User Account Settings

I am trying to set make email username option ansd I get this:

Error: Site Settings is currently unavailable. DotNetNuke.Services.Exceptions.ModuleLoadException: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. ---> System.Data.SqlClient.SqlException: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows) at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more) at System.Data.SqlClient.SqlDataReader.Read() at System.Data.SqlClient.SqlCommand.CompleteExecuteScalar(SqlDataReader ds, Boolean returnSqlValue) at System.Data.SqlClient.SqlCommand.ExecuteScalar() at PetaPoco.Database.ExecuteScalar[T](String sql, Object[] args) at DotNetNuke.Data.PetaPoco.PetaPocoHelper.ExecuteScalar[T](String connectionString, CommandType type, Int32 timeout, String sql, Object[] args) at DotNetNuke.Data.SqlDataProvider.ExecuteScalar[T](String procedureName, Object[] commandParameters) at DotNetNuke.Data.DataProvider.GetDuplicateEmailCount(Int32 portalId) at DotNetNuke.Entities.Users.UserController.GetDuplicateEmailCount() at DesktopModules.Admin.Portals.SiteSettings.UpdatePortal(Object sender, EventArgs e) --- End of inner exception stack trace ---

Also I no longer have ability to change these options and I am a super user???

Requires Unique Email:

False

Password Format:

Encrypted

Password Retrieval Enabled:

True

Password Reset Enabled:

True

Min Password Length:

Min Non Alphanumeric Characters:

Requires Question and Answer:

False

Password Strength Regular Expression:

Max Invalid Password Attempts:

Password Attempt Window:

JamesThanks in advance !!

7/20/2016 8:11 AM

James Kaschak

Joined: 6/29/2005

Posts: 48

Re: Error after upgrade

Info from Log:

ModuleId:362

ModuleDefId:14

FriendlyName:Site Settings

ModuleControlSource:DesktopModules/Admin/Portals/SiteSettings.ascx

AbsoluteURL:/Default.aspx

DefaultDataProvider:DotNetNuke.Data.SqlDataProvider, DotNetNuke

ExceptionGUID:00137592-bb66-4670-9547-7634695334c2

AssemblyVersion:8.0.3

PortalId:0

UserId:1

TabId:44johnn

RawUrl:/Admin/SiteSettings.aspx

Referrer:http://website.com/Admin/SiteSettings.aspx

UserAgent:Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/51.0.2704.103 Safari/537.36

ExceptionHash:zr1q0Wg4K0uZ2+K9zgKyrA==

Message:Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

StackTrace:

InnerMessage:Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

InnerStackTrace:

   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows)
   at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)
   at System.Data.SqlClient.SqlDataReader.Read()
   at System.Data.SqlClient.SqlCommand.CompleteExecuteScalar(SqlDataReader ds, Boolean returnSqlValue)
   at System.Data.SqlClient.SqlCommand.ExecuteScalar()
   at PetaPoco.Database.ExecuteScalar[T](String sql, Object[] args)
   at DotNetNuke.Data.PetaPoco.PetaPocoHelper.ExecuteScalar[T](String connectionString, CommandType type, Int32 timeout, String sql, Object[] args)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScalar[T](String procedureName, Object[] commandParameters)
   at DotNetNuke.Data.DataProvider.GetDuplicateEmailCount(Int32 portalId)
   at DotNetNuke.Entities.Users.UserController.GetDuplicateEmailCount()
   at DesktopModules.Admin.Portals.SiteSettings.UpdatePortal(Object sender, EventArgs e)

Source:

FileName:

FileLineNumber:0

FileColumnNumber:0

Method:

Server Name: web34

7/20/2016 8:29 PM

Sebastian Leupold

www.dnnwerk.de
Joined: 3/8/2004

Posts: 46212

Re: Error after upgrade

there seem to be still duplicate email addresses in your user base (and the query to check it is not written properly)

Cheers from Germany,
Sebastian Leupold

Speed up your DNN Websites with TurboDNN

7/22/2016 8:05 AM

James Kaschak

Joined: 6/29/2005

Posts: 48

Re: Error after upgrade

Any idea on going about fixing this?

7/26/2016 12:04 PM

Sebastian Leupold

www.dnnwerk.de
Joined: 3/8/2004

Posts: 46212

Re: Error after upgrade

Execute the following statement in Host > SQL and it will return all users with duplicate email addresses:

SELECT email, count(1) N from {databaseOwner}[{objectQualifier}Users] GROUP BY email;

Cheers from Germany,
Sebastian Leupold

Speed up your DNN Websites with TurboDNN

Page 1 of 1

These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
No Flaming or Trolling.
No Profanity, Racism, or Prejudice.
Site Moderators have the final word on approving / removing a thread or post or comment.
English language posting only, please.

Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

DNN Corp. (DotNetNuke)