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 years ago
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 years ago
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 years ago
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 years ago
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.