New Installation of 3.5

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.
10 Jahre weitere
This is a clean install from nopcommerce site. I'm getting  the following:

Invalid column name 'CompanyName'.
Invalid column name 'CompanyAddress'.
Invalid column name 'CompanyPhoneNumber'.
Invalid column name 'CompanyVat'.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Invalid column name 'CompanyName'.
Invalid column name 'CompanyAddress'.
Invalid column name 'CompanyPhoneNumber'.
Invalid column name 'CompanyVat'.

This works on my local development machine but not on my production server. I simply deploy the code from the working environment to my server and this appears.

Any thoughts.

Thanks Dean
10 Jahre weitere
Hi Dean,

It does not look like a clean installation. Looks like you upgraded your solution but did not run the upgrade script. These columns were added in version 3.50 but your database does not them.

Please have a look at Upgrading nopCommerce
10 Jahre weitere
I went to nopcommerce downloaded the 3.5 source installer,
unzipped it on my development machine,
Built it and launched it in vs and let it create the database during the install,
Setup some basic theme stuff,
cleaned the build, rebuilt the build,
deployed the build locally,
ftp the built code onto my server,
moved the database from my local SQL Server
to my SQL server on my server.
Pulled the site up from my production server on the web and that is the error I received.

I did not upgrade from a previous version, this was a complete clean install of 3.5.

I even have donotsupportpreviousversions set off in the web.config.

Strange as it appears to not know those fields in the repository as it is failing doing the initial GetAllStores call.

I'm sure it must be something stupid so I'm just going to rebuild and redeploy again and see what happens.

There are other installations running on this server with different versions. I have 3.4 and 3.5 sites running on this server so you never know.
9 Jahre weitere
Hello there,

I also just moved my 3.6 NopCommerce website from Arvixe to SmarterASP.net and get exactly the same error.

Have there been any solutions? I tried running the 3.60 upgrade script over the database but to no avail.

Any help is greatly appreciated.
9 Jahre weitere
Andrei was correct it was a bad install.

One thing I found is you really need to run Streams.exe on all your source files before doing anything on a new download of files.

https://technet.microsoft.com/en-us/sysinternals/streams.aspx

Using Streams

Usage: streams [-s] [-d] <file or directory>
-s  Recurse subdirectories.
-d  Delete streams.
Streams takes wildcards e.g. 'streams *.txt'.
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.