TrushnaDevise wrote:Hi,
I have updated Nopcommerce 2.65 database to 3.0. I have executed below upgrading scrips.
nopCommerce_2.70_UpgradeScripts
nopCommerce_2.80_UpgradeScripts
nopCommerce_3.00_UpgradeScripts
All upgrade scripts executed successfully. After upgrading i have modified Setting.txt file(of new developed site in nopcommerce 3.0) to point to upgraded database. I am able to run site, it displays login page. In fact clicking any link will redirect to login page. I am not able to figure out what is wrong i have done. Please help me to resolve this issue.
Hi,
Looks like there is role based issue.
Goto https://<yourwebsiteurl>/Admin/Security/Permissions and check if Guest role has following rights ticked,
Public store. Allow navigation
Public store. Display Prices
Public store. Enable shopping cart
If you can not login to admin, then go to DB and Run,
Select * from PermissionRecord_Role_Mapping where CustomerRole_Id = 4 and PermissionRecord_Id in (Select id from PermissionRecord where Name in ('Public store. Allow navigation','Public store. Display Prices','Public store. Enable shopping cart'))
See if there is any record. If not, insert those roles. Run following queries. you will understand the relationship.
Select * from CustomerRole
Select * from PermissionRecord
Select * from PermissionRecord_Role_Mapping