how to set customer id to 1,2,and 3 in Customer_CustomerRole_Mapping table

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.
8 Jahre weitere
I am shut out of my admin account and looking at this:

https://www.nopcommerce.com/boards/t/26541/if-my-admn-account-deleted-then-i-have-to-install-nopcommerce-again.aspx

I need to set an existeng customer id to 1,2,and 3 in Customer_CustomerRole_Mapping table but I can't see where to do that
8 Jahre weitere
u need to insert 3 records to customer tole mapping table

if your customerId is 1, it should look like that:


INSERT INTO [dbo].[Customer_CustomerRole_Mapping] ([Customer_Id] ,[CustomerRole_Id])VALUES(1,1)
INSERT INTO [dbo].[Customer_CustomerRole_Mapping] ([Customer_Id] ,[CustomerRole_Id])VALUES(1,2)
INSERT INTO [dbo].[Customer_CustomerRole_Mapping] ([Customer_Id] ,[CustomerRole_Id])VALUES(1,3)
8 Jahre weitere
Thank you for your help I am trying to get up to speed on this but lack experience. Would I right click on dbo.Customer_CustomerRole_Mapping open powershell copy and paste the code snippet and press enter?
8 Jahre weitere
In SSMS, Right-click the Database node, select New Query, paste in the contents, press F5 to execute.
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.