Umbraco 4.6.1 - Unable to login - queries cmsMember table instead of umbracoUser Table
I've been given an Umbraco install which is v4.6.1, I've downloaded fresh Umbraco binaries and the login problem persists. Using a SQL Profiling tool I can see whenever I try to login the following query executes:
exec sp_executesql N'select nodeID from cmsMember where LoginName = @loginName and Password = @password',N'@loginName nvarchar(5),@password nvarchar(28)',@loginName=N'admin',@password=N'd9xnUXsUah9gycu7D0TpRYcx19c='
So, I can't login because for some reason it is querying the cmsMembers table instead of the cmsUsers table.
I know v4.6.1 had a short life but was this an issue or is there something a bit funky with this install that I've not yet uncovered?
Just a guess, maybe check umbracoSettings.config and see if you have a DefaultBackofficeProvider configured? Maybe somehow it's set to the wrong connection provider? If not I'd probably start checking your web.config for issues, specifically around <membership>.
Spot on - well done and thanks. Every day's a school day! In the 7+ years I've been working with Umbraco never once have I used or come across an install that used that setting. This particular install had it set to UmbracoMembershipProvider.
Umbraco 4.6.1 - Unable to login - queries cmsMember table instead of umbracoUser Table
I've been given an Umbraco install which is v4.6.1, I've downloaded fresh Umbraco binaries and the login problem persists. Using a SQL Profiling tool I can see whenever I try to login the following query executes:
So, I can't login because for some reason it is querying the cmsMembers table instead of the cmsUsers table.
I know v4.6.1 had a short life but was this an issue or is there something a bit funky with this install that I've not yet uncovered?
Cheers, Simon
Hey Simon,
Just a guess, maybe check
umbracoSettings.configand see if you have aDefaultBackofficeProviderconfigured? Maybe somehow it's set to the wrong connection provider? If not I'd probably start checking your web.config for issues, specifically around<membership>.-Tom
Spot on - well done and thanks. Every day's a school day! In the 7+ years I've been working with Umbraco never once have I used or come across an install that used that setting. This particular install had it set to
UmbracoMembershipProvider.Cheers Tom!
is working on a reply...
This forum is in read-only mode while we transition to the new forum.
You can continue this topic on the new forum by tapping the "Continue discussion" link below.