Upgrade Nopcommerce 2.65 to 3.0

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.
10 years ago
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.
9 years ago
Any joy on this I am getting the same on 3.20?
9 years ago
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
9 years ago
My problem turned out to be a problem with the database update. I initially ran the database upgrade scripts on my local development machine and uploaded the updated database incorrectly to the database server. when I re-uploaded correctly everything was ok. The details are here:- https://www.nopcommerce.com/boards/t/32247/everything-redirects-to-login-page.aspx?p=2
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.