Bug reports Found a bug? Post it here please.
Version 5.x > Bug reports > Cannot login after 5.0 ->5.5 View modes: 
User avatar
Member
Member
zhaowy-5ipatent - 7/21/2010 2:50:44 AM
   
Cannot login after 5.0 ->5.5
I just upgraded to 5.5 yesterday execute the following steps in the same order as 'Kentico CMS – Upgrade from v5.0 to v5.5'. But I get some error and can't login again.

Server Error in '/' Application.
[DataConnection.ExecuteQuery]: Query: UPDATE CMS_User SET [UserName] = @UserName, [FirstName] = @FirstName, [MiddleName] = @MiddleName, [LastName] = @LastName, [FullName] = @FullName, [Email] = @Email, [UserPassword] = @UserPassword, [PreferredCultureCode] = @PreferredCultureCode, [PreferredUICultureCode] = @PreferredUICultureCode, [UserEnabled] = @UserEnabled, [UserIsEditor] = @UserIsEditor, [UserIsGlobalAdministrator] = @UserIsGlobalAdministrator, [UserIsExternal] = @UserIsExternal, [UserPasswordFormat] = @UserPasswordFormat, [UserCreated] = @UserCreated, [LastLogon] = @LastLogon, [UserStartingAliasPath] = @UserStartingAliasPath, [UserGUID] = @UserGUID, [UserLastModified] = @UserLastModified, [UserLastLogonInfo] = @UserLastLogonInfo, [UserIsHidden] = @UserIsHidden, [UserVisibility] = @UserVisibility, [UserIsDomain] = @UserIsDomain, [UserHasAllowedCultures] = @UserHasAllowedCultures, [UserSiteManagerDisabled] = @UserSiteManagerDisabled WHERE [UserID] = @UserID: caused exception: Must declare the scalar variable "@UserSiteManagerDisabled".
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Exception: [DataConnection.ExecuteQuery]: Query: UPDATE CMS_User SET [UserName] = @UserName, [FirstName] = @FirstName, [MiddleName] = @MiddleName, [LastName] = @LastName, [FullName] = @FullName, [Email] = @Email, [UserPassword] = @UserPassword, [PreferredCultureCode] = @PreferredCultureCode, [PreferredUICultureCode] = @PreferredUICultureCode, [UserEnabled] = @UserEnabled, [UserIsEditor] = @UserIsEditor, [UserIsGlobalAdministrator] = @UserIsGlobalAdministrator, [UserIsExternal] = @UserIsExternal, [UserPasswordFormat] = @UserPasswordFormat, [UserCreated] = @UserCreated, [LastLogon] = @LastLogon, [UserStartingAliasPath] = @UserStartingAliasPath, [UserGUID] = @UserGUID, [UserLastModified] = @UserLastModified, [UserLastLogonInfo] = @UserLastLogonInfo, [UserIsHidden] = @UserIsHidden, [UserVisibility] = @UserVisibility, [UserIsDomain] = @UserIsDomain, [UserHasAllowedCultures] = @UserHasAllowedCultures, [UserSiteManagerDisabled] = @UserSiteManagerDisabled WHERE [UserID] = @UserID: caused exception: Must declare the scalar variable "@UserSiteManagerDisabled".

Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.


Stack Trace:

[Exception: [DataConnection.ExecuteQuery]: Query: UPDATE CMS_User SET [UserName] = @UserName, [FirstName] = @FirstName, [MiddleName] = @MiddleName, [LastName] = @LastName, [FullName] = @FullName, [Email] = @Email, [UserPassword] = @UserPassword, [PreferredCultureCode] = @PreferredCultureCode, [PreferredUICultureCode] = @PreferredUICultureCode, [UserEnabled] = @UserEnabled, [UserIsEditor] = @UserIsEditor, [UserIsGlobalAdministrator] = @UserIsGlobalAdministrator, [UserIsExternal] = @UserIsExternal, [UserPasswordFormat] = @UserPasswordFormat, [UserCreated] = @UserCreated, [LastLogon] = @LastLogon, [UserStartingAliasPath] = @UserStartingAliasPath, [UserGUID] = @UserGUID, [UserLastModified] = @UserLastModified, [UserLastLogonInfo] = @UserLastLogonInfo, [UserIsHidden] = @UserIsHidden, [UserVisibility] = @UserVisibility, [UserIsDomain] = @UserIsDomain, [UserHasAllowedCultures] = @UserHasAllowedCultures, [UserSiteManagerDisabled] = @UserSiteManagerDisabled WHERE [UserID] = @UserID: caused exception: Must declare the scalar variable "@UserSiteManagerDisabled".]
CMS.DataProviderSQL.DataConnection.ExecuteQuery(String queryText, Object[,] queryParams, QueryTypeEnum queryType) +491
CMS.DataEngine.GeneralConnection.RunQuery(QueryParameters query) +400
CMS.DataEngine.GeneralConnection.ExecuteQuery(QueryParameters query) +495
CMS.DataEngine.GeneralConnection.ExecuteQuery(String queryName, Object[,] parameters) +42
CMS.DataEngine.SimpleDataClass.Update() +172
CMS.DataEngine.AbstractInfo.Update() +576
CMS.Staging.SynchronizedInfo.Update() +49
CMS.SiteProvider.UserInfoProvider.SetUserInfoInternal(UserInfo user, GeneralConnection conn) +241
CMS.SiteProvider.UserInfoProvider.AuthenticateUser(String userName, String password, String siteName, Boolean login) +1080
CMS.MembershipProvider.CMSMembershipProvider.ValidateUser(String username, String password) +36
System.Web.UI.WebControls.Login.AuthenticateUsingMembershipProvider(AuthenticateEventArgs e) +75
System.Web.UI.WebControls.Login.AttemptLogin() +152
System.Web.UI.WebControls.Login.OnBubbleEvent(Object source, EventArgs e) +124
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +70
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +29
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2981

User avatar
Kentico Support
Kentico Support
kentico_jurajo - 7/21/2010 3:45:03 AM
   
RE:Cannot login after 5.0 ->5.5
Hi,

Could you please check out this blog post and use the package mentioned in it? The reason and fix for this issue should be the same.

Best regards,
Juraj Ondrus

User avatar
Member
Member
zhaowy-5ipatent - 7/21/2010 4:20:46 AM
   
RE:Cannot login after 5.0 ->5.5

Thanks jurajo,It's ok now!