I want to upgrade nopcommerce from 1.90 to 2.10 on my server.
I understand that first I will need to upgrade to 2.0 and then 2.10.
However, looking at all the forums thread, I am not able to get the exact procedure how to perform the upgrade.
1) Which file of 2.0 is to be used for upgrade? Is it nopCommerce 2.00 (with source code) (22.50 MB) or nopCommerce 2.00 (no source) (9.60 MB)
2) How do I Install nopCommerce 2.00 to your existing database (1.90). Do I copy the installation files to my wwwroot folder and then run setup using domainname/install/install.aspx.
3) I have tried to copy nopCommerce 2.00 (no source) to my wwwroot and then proceed with setup but it says "Upgrade script from your version is not available". I have copied the sql upgrade script in "install\scripts" folder and named it nopCommerce_upgrade.sql but no luck. If I try to install 2.0 instead of selecting upgrade during installation , it gives error "An error occured: There is already an object named 'Nop_CustomerRole' in the database."
4) If I need to use nopCommerce 2.00 (with source code) for upgrade then please let me know the exact steps as I do not find anything under it and nor am I able to execute installation.
Please let me know what am I missing and the correct steps.
Many thanks in advance.
Upgrade Nopcommerce from 1.90 to 2.10
- 82
- 462
- 5/6/2010
- United States
I'm having the same exact issue. I managed to install the new files but I'm having a very hard time with the upgrade script on the website. I can't seem to run the upgrade script without a bunch of errors. All I'm doing is copying and pasting exactly what is on the sql file into my database query editor.
MVP
Bronze Solution Partner
- 2898
- 23165
- 1/8/2010
- United States
In order to upgrade you will have to replace all the files of 1.9 with 2.0 or higher version.
On your webserver, replace all the files / folders of 1.9 with 2.1.
Source code version is only for development purpose - if you wanna make any change.
If you don't wanna make change, you can use (web version).
For Database upgrade:
Once you're done with the above steps, you will need to run the upgrade script against your 1.9 database. You can use SQL Server Management Studio for that.
I would recommend go 1 by 1 : 1.9 to 2.0 then 2.1
You can download the upgrade script (for 2.0 version) from here: http://nopcommerce.codeplex.com/releases/view/69080#DownloadId=265405
Once you're done with 1.9 to 2.0 - repeat the same process for 2.1 upgrade script.
For 2.1 upgrade script: http://nopcommerce.codeplex.com/releases/view/69081#DownloadId=276392
Source code version is only for development purpose - if you wanna make any change in the code / functionality.
If you don't wanna make change, you can use (web version).
P.S. Always make a back up of complete website (web files and database) before upgrading.
On your webserver, replace all the files / folders of 1.9 with 2.1.
Source code version is only for development purpose - if you wanna make any change.
If you don't wanna make change, you can use (web version).
For Database upgrade:
Once you're done with the above steps, you will need to run the upgrade script against your 1.9 database. You can use SQL Server Management Studio for that.
I would recommend go 1 by 1 : 1.9 to 2.0 then 2.1
You can download the upgrade script (for 2.0 version) from here: http://nopcommerce.codeplex.com/releases/view/69080#DownloadId=265405
Once you're done with 1.9 to 2.0 - repeat the same process for 2.1 upgrade script.
For 2.1 upgrade script: http://nopcommerce.codeplex.com/releases/view/69081#DownloadId=276392
Source code version is only for development purpose - if you wanna make any change in the code / functionality.
If you don't wanna make change, you can use (web version).
P.S. Always make a back up of complete website (web files and database) before upgrading.
- 82
- 462
- 5/6/2010
- United States
abcd_12345 wrote:
I know how to replace the files but the database upgrade script isn't working. I copied and pasted the script exactly from the upgrade.sql file and it has a bunch of errors showing up. For example the messages say things like Customer object doesn't exist
In order to upgrade you will have to replace all the files of 1.9 with 2.0 or higher version.
On your webserver, replace all the files / folders of 1.9 with 2.1.
Source code version is only for development purpose - if you wanna make any change.
If you don't wanna make change, you can use (web version).
For Database upgrade:
Once you're done with the above steps, you will need to run the upgrade script against your 1.9 database. You can use SQL Server Management Studio for that.
I would recommend go 1 by 1 : 1.9 to 2.0 then 2.1
You can download the upgrade script (for 2.0 version) from here: http://nopcommerce.codeplex.com/releases/view/69080#DownloadId=265405
Once you're done with 1.9 to 2.0 - repeat the same process for 2.1 upgrade script.
For 2.1 upgrade script: http://nopcommerce.codeplex.com/releases/view/69081#DownloadId=276392
Source code version is only for development purpose - if you wanna make any change in the code / functionality.
If you don't wanna make change, you can use (web version).
P.S. Always make a back up of complete website (web files and database) before upgrading.
On your webserver, replace all the files / folders of 1.9 with 2.1.
Source code version is only for development purpose - if you wanna make any change.
If you don't wanna make change, you can use (web version).
For Database upgrade:
Once you're done with the above steps, you will need to run the upgrade script against your 1.9 database. You can use SQL Server Management Studio for that.
I would recommend go 1 by 1 : 1.9 to 2.0 then 2.1
You can download the upgrade script (for 2.0 version) from here: http://nopcommerce.codeplex.com/releases/view/69080#DownloadId=265405
Once you're done with 1.9 to 2.0 - repeat the same process for 2.1 upgrade script.
For 2.1 upgrade script: http://nopcommerce.codeplex.com/releases/view/69081#DownloadId=276392
Source code version is only for development purpose - if you wanna make any change in the code / functionality.
If you don't wanna make change, you can use (web version).
P.S. Always make a back up of complete website (web files and database) before upgrading.
I know how to replace the files but the database upgrade script isn't working. I copied and pasted the script exactly from the upgrade.sql file and it has a bunch of errors showing up. For example the messages say things like Customer object doesn't exist
- 25
- 135
- 5/26/2011
- Israel
before I run into these errors as wel and mess up everything
can you publish "how to" article on how to upgrade my 1.9 version to 2.1 ?
btw the main reason I am doing this is because the PCI Compliant scan at hackerguardian.com failed :
Security Hole found on port/service "http (80/tcp)"
Status : Fail (This must be resolved for your device to be compliant).
Plugin : "Comodo SQL injections"
Category : "CGI abuses "
Priority : "Urgent"
Description:
The following CGI script seem to be vulnerable to various SQL injection techniques : /category/51-notebooks.aspx
Unsafe arguments : pageindex
Unsafe URLs : /category/51-notebooks.aspx?pageindex=QUOTETEST%271%221%60& =7 (Internal Server Error)
An attacker may exploit this flaws to bypass authentication or to take the control of the remote database.
Risk factor
High See also : http://www.securiteam.com/securityreviews/5DP0N1P76E.html
Solution
Modify the relevant CGIs so that they properly escape arguments
can you publish "how to" article on how to upgrade my 1.9 version to 2.1 ?
btw the main reason I am doing this is because the PCI Compliant scan at hackerguardian.com failed :
Security Hole found on port/service "http (80/tcp)"
Status : Fail (This must be resolved for your device to be compliant).
Plugin : "Comodo SQL injections"
Category : "CGI abuses "
Priority : "Urgent"
Description:
The following CGI script seem to be vulnerable to various SQL injection techniques : /category/51-notebooks.aspx
Unsafe arguments : pageindex
Unsafe URLs : /category/51-notebooks.aspx?pageindex=QUOTETEST%271%221%60& =7 (Internal Server Error)
An attacker may exploit this flaws to bypass authentication or to take the control of the remote database.
Risk factor
High See also : http://www.securiteam.com/securityreviews/5DP0N1P76E.html
Solution
Modify the relevant CGIs so that they properly escape arguments
- 7
- 55
- 3/15/2012
- United States
Two seconds after my first post, I find the answer in the following thread: https://www.nopcommerce.com/boards/t/13498/upgradesql.aspx