According to the signature of the call in DotNetNuke.Security.Membership.Data.SqlDataProvider.UpdateUser of stored procedure UpdateUser as updated in 07.01.00.sqldataprovider, there is a parameter mismatch, caused by an additional "vanityName" in the stored procedure.
it looks like you are still using an old version of dotNetNuke.dll, is this possible? please check version and date

---

Cheers from Germany,
Sebastian Leupold

   

Speed up your DNN Websites with TurboDNN

As Sebastian says it looks like you have a mismatch between the DB and the code.

The safest way to fix this is always to recover a matched set of Database and site files and have another go.

---

Best wishes,
- Richard
Agile Development Consultant, Practitioner, and Trainer
www.dynamisys.co.uk

I'm continuing to dig and here is what I'm finding:
The login is successful. In the eventLog table, it logs a LOGIN_SUCCESS event. The very next event is a PAGE_LOAD_EXCEPTION and that is what is throwing the error.

Here is the raw XML from the LogProperties field:
AssemblyVersion7.1.0PortalID0PortalNameGunNoobUserID-1UserNameActiveTabID55ActiveTabNameHomeRawURL/login.aspx?ReturnUrl=/&popUp=trueAbsoluteURL/Default.aspxAbsoluteURLReferrerhttp://www.gunnoob.com/login.aspx?ReturnUrl=/&popUp=trueUserAgentMozilla/5.0 (Macintosh; Intel Mac OS X 10_8_4) AppleWebKit/536.30.1 (KHTML, like Gecko) Version/6.0.5 Safari/536.30.1DefaultDataProviderDotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProviderExceptionGUID66869f06-8af7-4400-8295-6fc720f212c9InnerExceptionParameter count does not match Parameter Value count.FileNameFileLineNumber0FileColumnNumber0MethodMicrosoft.ApplicationBlocks.Data.SqlHelper.AssignParameterValuesStackTraceMessageDotNetNuke.Services.Exceptions.PageLoadException: Parameter count does not match Parameter Value count. ---> System.ArgumentException: Parameter count does not match Parameter Value count.
at Microsoft.ApplicationBlocks.Data.SqlHelper.AssignParameterValues(SqlParameter[] commandParameters, Object[] parameterValues)
at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, String spName, Object[] parameterValues)
at DotNetNuke.Security.Membership.Data.SqlDataProvider.UpdateUser(Int32 userId, Int32 portalID, String firstName, String lastName, Boolean isSuperUser, String email, String displayName, Boolean updatePassword, Boolean isApproved, Boolean refreshRoles, String lastIpAddress, Boolean isDeleted, Int32 lastModifiedByUserID)
at DotNetNuke.Security.Membership.AspNetMembershipProvider.UpdateUser(UserInfo user)
at DotNetNuke.Entities.Users.UserController.UpdateUser(Int32 portalId, UserInfo user, Boolean loggedAction, Boolean clearCache)
at DotNetNuke.Entities.Users.UserController.UserLogin(Int32 portalId, UserInfo user, String portalName, String ip, Boolean createPersistentCookie)
at DotNetNuke.Modules.Admin.Authentication.Login.ValidateUser(UserInfo objUser, Boolean ignoreExpiring)
at DotNetNuke.Modules.Admin.Authentication.Login.UserAuthenticated(Object sender, UserAuthenticatedEventArgs e)
at DotNetNuke.Modules.Admin.Authentication.Login.OnLoginClick(Object sender, EventArgs e)
at System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
--- End of inner exception stack trace ---Source