Hi, when i try to backup v1.3.1 from the open cart admin panel i download the backup.sql but its blank. I want to upgrade to v1.3.2 but need the backup so im stuck as to how to go about it.
I hope this hasnt been asked before i did a search but didnt find anything.
Thanks in advance.
I hope this hasnt been asked before i did a search but didnt find anything.
Thanks in advance.
Hi Noonoo,
The files are one thing - don't worry about them unless you have some custom files in the base installation of OpenCart.
Focus on your database. Follow the instructions here using the Easier steps:
http://wiki.opencart.com/index.php?titl ... _Procedure
Your data is the most important thing to make sure it will work with 1.3.1 and up. Once done the steps provided, back up your database using phpmyadmin or what ever database editor you are using. Do a clean installation of 1.3.2 and with the changes that were completed with the sql files provided by Qphoria you would then just drop your 1.3.2 database created by the clean installation and replace it with the backup you made with the needed changes.
Kevin.
The files are one thing - don't worry about them unless you have some custom files in the base installation of OpenCart.
Focus on your database. Follow the instructions here using the Easier steps:
http://wiki.opencart.com/index.php?titl ... _Procedure
Your data is the most important thing to make sure it will work with 1.3.1 and up. Once done the steps provided, back up your database using phpmyadmin or what ever database editor you are using. Do a clean installation of 1.3.2 and with the changes that were completed with the sql files provided by Qphoria you would then just drop your 1.3.2 database created by the clean installation and replace it with the backup you made with the needed changes.
Kevin.
Kevin Davidson
Purolator Shipping Module
Canpar Shipping Module
VQMod - Paypal Transaction ID to Payment Details
The reference to the wiki have links that come back to the forum. These entries in the forum were provided by Qphoria. The files that are attached in the forum are mysql queries to be applied to the database. Once you have completed those queries to your current working database (making sure to backup your current database before you do them of course), your database will be ready for 1.3.2.
Kevin Davidson
Purolator Shipping Module
Canpar Shipping Module
VQMod - Paypal Transaction ID to Payment Details
Hi, i thought thats what you might of meant but i didnt see an option for v1.3.1 to v1.3.2. Would the upgrade from v1.3.0 to v1.3.2 posted by Qphoria work ok as im running v1.3.1?
Also the wiki it says there are no database changes between v1.3.1 and v1.3.2, if this is the case could i upload all the files appart from the install folder and the configs to upgrade to v1.3.2 leaving the database alone?
Sorry to ask so many questions, i couldnt find a changelog to see what exactly has been changed between versions.
Thanks
Also the wiki it says there are no database changes between v1.3.1 and v1.3.2, if this is the case could i upload all the files appart from the install folder and the configs to upgrade to v1.3.2 leaving the database alone?
Sorry to ask so many questions, i couldnt find a changelog to see what exactly has been changed between versions.
Thanks
No problem Noonoo.
That's right, there are no database changes for those versions.
Overwriting the new installation of 1.3.2 with files from an older version of OpenCart would defeat the purpose of upgrading
I would only restore the image directory and your custom theme into the new version of OpenCart. If you have any modules that you have added on, please download the correct version of those modules that work with 1.3.2. If you have made changes to the base files of OpenCart to do something custom, you may have to make changes to that code to make it work.
That's right, there are no database changes for those versions.
Overwriting the new installation of 1.3.2 with files from an older version of OpenCart would defeat the purpose of upgrading

I would only restore the image directory and your custom theme into the new version of OpenCart. If you have any modules that you have added on, please download the correct version of those modules that work with 1.3.2. If you have made changes to the base files of OpenCart to do something custom, you may have to make changes to that code to make it work.
Kevin Davidson
Purolator Shipping Module
Canpar Shipping Module
VQMod - Paypal Transaction ID to Payment Details
Hi thanks for the reply,
Qphoria posted the easy upgrade from v1.3.0 to v1.3.2 but i dont know if it will work as im using v1.3.1 and any backups i make in the open cart admin panel come out blank so i cant upgrade the regular way.
Thanks in advance for any help
Sorry i meant overwriting my existing v1.3.1 files with the new v1.3.2 files and leaving the database alone as it seemed there were no changes to the database anyway, but looking into it further there are some changes so i have to upgrade my database from v1.3.1 to v1.3.2 but how?kdmp wrote:Overwriting the new installation of 1.3.2 with files from an older version of OpenCart would defeat the purpose of upgrading
Qphoria posted the easy upgrade from v1.3.0 to v1.3.2 but i dont know if it will work as im using v1.3.1 and any backups i make in the open cart admin panel come out blank so i cant upgrade the regular way.
Thanks in advance for any help
Hey Noonoo,
There are no database updates from 1.3.1 to 1.3.2. The only changes between 1.3.1 and 1.3.2 is just the files for OpenCart.
Kevin.
There are no database updates from 1.3.1 to 1.3.2. The only changes between 1.3.1 and 1.3.2 is just the files for OpenCart.
Kevin.
Kevin Davidson
Purolator Shipping Module
Canpar Shipping Module
VQMod - Paypal Transaction ID to Payment Details
Hi, v1.3.1 drops the table 'myprefix_product_special' but v1.3.2 brings it back again.
I couldnt use the easy upgrade v1.3.0 to v1.3.2 by Qphoria as this didnt readd the table 'myprefix_product_special' as v1.3.0 already has it as it was dropped in v1.3.1. And i couldnt do a fresh install and restore through the carts admin panel because of the bug in the backup method giving a blank backup.sql.
What i did was overwrite my existing v1.3.1 files with the files from v.1.3.2 appart from the two config files, then via phpmyadmin readded the 'myprefix_product_special' table along with its data from the v1.3.2 sql file.
Everything seems to be working ok hopefully there were no other changes i needed to make.
Thanks for taking the time to help Kevin
I couldnt use the easy upgrade v1.3.0 to v1.3.2 by Qphoria as this didnt readd the table 'myprefix_product_special' as v1.3.0 already has it as it was dropped in v1.3.1. And i couldnt do a fresh install and restore through the carts admin panel because of the bug in the backup method giving a blank backup.sql.
What i did was overwrite my existing v1.3.1 files with the files from v.1.3.2 appart from the two config files, then via phpmyadmin readded the 'myprefix_product_special' table along with its data from the v1.3.2 sql file.
Everything seems to be working ok hopefully there were no other changes i needed to make.
Thanks for taking the time to help Kevin
Hi Noonoo,
I think you should be fine. If you do run into problems, post back!
Kevin
I think you should be fine. If you do run into problems, post back!
Kevin
Kevin Davidson
Purolator Shipping Module
Canpar Shipping Module
VQMod - Paypal Transaction ID to Payment Details
Who is online
Users browsing this forum: No registered users and 2 guests