Press Ctrl / CMD + C to copy this to your clipboard.
This post will be reported to the moderators as potential spam to be looked at
After upgrading from 6 to 7+ all members are locked out because the Is Approved checkbox is not checked. (I understand this is a new property).
Is there some sql that can be executed directly to set IsApproved setting to true for all members?
Thanks for your time with this.
I've not tested this but it might work:
SET userDisabled= '0'
WHERE userDisabled = '1';
Thanks for the reply but the question was about members, cmsMember. I believe it is a property in the propertyData table perhaps?
something like this:
;WITH DataProp as (SELECT pd.*
FROM cmsPropertyData as pd
JOIN cmsPropertyType as pt ON pt.Id = pd.propertytypeid AND pt.Alias = 'umbracoMemberApproved')
UPDATE DataProp SET dataInt = 1
*Make sure to backup your database first before doing such a query!
Thanks for the reply.
I created a view by joining the tables as you have done above and it appears that only 4 members actually have a record for this IsApproved property.
I suppose the other 300 members did not have record created for this property.
I am guessing I would need to also run an INSERT first setting IsApproved to true for each member that does not already have a record for IsApproved,
then run an UPDATE query to change all that are currently false.
Would this be correct or am I missing something?
then the entry in the cmsPropertyData with this property for the other Members are missing.
Don't think it's a good approach for inserting this manually because it contains a verionId of this entry also.
What happens if you re-save one of these members that isn't fetched into the view? Does the property then appear and does your 4 becomes 5 in the view?
Yep. So I choose a member that does not appear in the original 4, check the Is Approved property, hit save and sure enough 5 now appear in the view.
Ok thats good news!
Now you have 2 possibilities to perform this task for all your members:
If you need guidance for the second solution let me know.
No problems, sorry, miss understood your question. :)
is working on a reply...
Write your reply to:
Image will be uploaded when post is submitted