Cannot login with superuser


I have just installed DNN 8.0 and have run the TurboScripts as per the instructions. However I cannot login as the superuser now.

It seems to be linked to GetUserByEmail which is returning -1 for the email address of the superuser account.

The UserID for my superuser is 1 in the DB.

There is no PortalID associated with the superuser and I am now unsure of what to do.


leupold wrote Jan 3 at 2:49 PM

in the stored procedure, please try replacing the two lines
WHERE (U.PortalId = {databaseOwner}{objectQualifier}MasterPortalId(@PortalID) OR IsNull(@PortalID, -1) = -1)
WHERE (U.PortalId = {databaseOwner}{objectQualifier}MasterPortalId(@PortalID) OR U.PortalID = -1 OR IsNull(@PortalID, -1) = -1)
Restart DNN and please report back your results.

naineshmehta wrote Jan 4 at 10:21 AM

Hi Seb, sorry I wrote up the wrong SP, the SP that is the problem is GetSingleUserByEmail (the SP used by the login functionality)

leupold wrote Jan 7 at 6:24 PM

Hi, would you mind to check, whether there is a record for this user and Portal in Userportals table, thank you.

naineshmehta wrote Jan 8 at 3:32 PM

I can confirm the user DOES NOT exist in the UserPortals table.