Hi all, I'm excited about the discovery of nopCommerce and am looking forward to learning more about it. I'm an asp.net developer working on my own solutions, but the fact that nopCommerce is not only a store but offers blog, forums and news as well is very exciting!
I wanted to pass along my installation experience while it's fresh in my mind, and it may be specific to this particular version / database that I'm running (info below). I downloaded 4.80.9 and found that I needed to thread the needle in a very specific way before the installation went through successfully.
Conditions for success:
- The database shouldn't already exist
- Manually enter your connection string (no option for port)
Steps for success
1. Extract latest nopcommerce into correct folder that visual studio will work from
2. Run Nop.Web
3. When prompted, enter admin email and pass and choose postgresql
4. In pgAdmin, create the database username and password that will own the database (but don't create the database)
5. Choose to manually enter your connection string. It will look something like this on postgresql
1. Note: the port controls which version of postgresql server will be used if you have more than one installed on your system (1st / default = 5432, 2nd defaults to 5433, etc.)
2. Host=localhost;Port=5435;Database=store;Username=store;Password=password;
6. Done
Some holes I fell into:
1. If you create the database first, before running the solution and set up procedure, you'll end up in the trap where citext isn't installed (and won't be by the installation code, it's either failing or a failure before that step is short-circuiting what it's supposed to be doing). Manually running the below works to get past this step, but gets you to the #2 error below:
CREATE EXTENSION IF NOT EXISTS citext WITH SCHEMA public;
Note: If you don't run that first, you get this error:
System.Exception: 'An error occurred executing the following sql:
ALTER TABLE "public"."MigrationVersionInfo" ADD "Description" citext NULL;
The error was 42704: type "citext" does not exist
2. After correcting the above (which seemed to require me to both delete the database as well as reset all of the src files for some reason), you get this while trying to run:
System.Exception: 'No store could be loaded'
To circumvent both of these, I found that if I checked the box to let setup to create the database and manually entered my own connection string (above), I avoided both of these issues and install was successful. I concluded that the setup process expects this, so wandering off the path means the install will fail.
I'm past these issues so I don't need any direct help, I just wanted to post this here in case it helps anyone else (and let you know to take a look at the set up procedure)
What I'm working with (all on windows localhost):
- asp.net 9
- fresh postgresql database (16.10)
- unaltered nopCommerce 4.80.9
- Visual studio 2022 (17.14.16)
- just using the native VS IIS Express to run the app if that matters
Thanks!