Re: OpenCart v1.3.2
Posted: Fri Aug 14, 2009 7:32 pm
I think the user name needs to be yourname@gmail.com
OpenCart Community Forum - Discuss shopping cart and e-commerce solutions.
https://forum.opencart.com/
Thank you very much; worked a treat.hcamelion wrote:Ok here are my steps for a smooth upgrade from 1.3.0 to 1.3.2 with an attached sql file to run....
(Im not sure if this will work from 1.3.1 to 1.3.2 you will have to do a diff on the three schemas)
Note: this assumes you do not have a database prefix. If you do you will have to add the prefix to the sql commands in the sql file.1.3.0 > 1.3.2
To Upgrade:
1. First off backup your site.
2. Goto your opencart's store admin and download a backup of your database.
3. Delete the files in your hosting directory. **SEE NOTE AFTER LAST STEP**
4. Upload the files from the download.
5. Go through the install as normal but use a new database while keeping the old intact.
6. Once the install is done run the attached file db_changes.sql in your database administrator on the old database.
7. Goto the image directory from the backup and copy all the image and upload to the image directory on your hosting.
8. Goto the download directory from the backup and copy all the downloads and upload to the download directory on your hosting.
9. Go to the administration and give Top Administrator access to customer groups and modify abilities.
10. Change to the old database in both the admin and catalog config files.
11. Load the site and test everything.
**If you have tons of large images and downloads you may choose not to delete the downloads and images folders**
Let me know how it works for everyone.
PS: Yes the new version did fix the pagination issue.
Code: Select all
Notice: Undefined index: password in /home3/interos7/public_html/sianshop_com/catalog/controller/account/password.php on line 73Notice: Undefined index: confirm in /home3/interos7/public_html/sianshop_com/catalog/controller/account/password.php on line 79
jamieleshaw wrote:Are there instructions available for upgrading from 1.3?
Thanks the upgrade went perfectly!hcamelion wrote:Ok here are my steps for a smooth upgrade from 1.3.0 to 1.3.2 with an attached sql file to run....
(Im not sure if this will work from 1.3.1 to 1.3.2 you will have to do a diff on the three schemas)
Note: this assumes you do not have a database prefix. If you do you will have to add the prefix to the sql commands in the sql file.1.3.0 > 1.3.2
To Upgrade:
1. First off backup your site.
2. Goto your opencart's store admin and download a backup of your database.
3. Delete the files in your hosting directory. **SEE NOTE AFTER LAST STEP**
4. Upload the files from the download.
5. Go through the install as normal but use a new database while keeping the old intact.
6. Once the install is done run the attached file db_changes.sql in your database administrator on the old database.
7. Goto the image directory from the backup and copy all the image and upload to the image directory on your hosting.
8. Goto the download directory from the backup and copy all the downloads and upload to the download directory on your hosting.
9. Go to the administration and give Top Administrator access to customer groups and modify abilities.
10. Change to the old database in both the admin and catalog config files.
11. Load the site and test everything.
**If you have tons of large images and downloads you may choose not to delete the downloads and images folders**
Let me know how it works for everyone.
PS: Yes the new version did fix the pagination issue.
Could someone please explain step 6 to me. I can't seem to find that file anywhere. Even in phpMyAdminjamieleshaw wrote:Thanks the upgrade went perfectly!hcamelion wrote:Ok here are my steps for a smooth upgrade from 1.3.0 to 1.3.2 with an attached sql file to run....
(Im not sure if this will work from 1.3.1 to 1.3.2 you will have to do a diff on the three schemas)
Note: this assumes you do not have a database prefix. If you do you will have to add the prefix to the sql commands in the sql file.1.3.0 > 1.3.2
To Upgrade:
1. First off backup your site.
2. Goto your opencart's store admin and download a backup of your database.
3. Delete the files in your hosting directory. **SEE NOTE AFTER LAST STEP**
4. Upload the files from the download.
5. Go through the install as normal but use a new database while keeping the old intact.
6. Once the install is done run the attached file db_changes.sql in your database administrator on the old database.
7. Goto the image directory from the backup and copy all the image and upload to the image directory on your hosting.
8. Goto the download directory from the backup and copy all the downloads and upload to the download directory on your hosting.
9. Go to the administration and give Top Administrator access to customer groups and modify abilities.
10. Change to the old database in both the admin and catalog config files.
11. Load the site and test everything.
**If you have tons of large images and downloads you may choose not to delete the downloads and images folders**
Let me know how it works for everyone.
PS: Yes the new version did fix the pagination issue.
Thanks.hcamelion wrote:You have to go to the original post on page 1 of this thread. What you are seeing are quotes of that original post and the OP has the attachment that contains the db_changes.sql file.