Post by noonoo » Thu Sep 03, 2009 4:42 am

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.

Newbie

Posts

Joined
Thu Jul 16, 2009 4:34 pm

Post by noonoo » Thu Sep 10, 2009 8:01 pm

Could i just replace the backup.php with the one from v1.3.2 or another version to fix the problem? Are there any database changes from v1.3.1 to v1.3.2?

Thanks

Newbie

Posts

Joined
Thu Jul 16, 2009 4:34 pm

Post by kdmp » Thu Sep 10, 2009 10:36 pm

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.

Kevin Davidson
Purolator Shipping Module
Canpar Shipping Module
VQMod - Paypal Transaction ID to Payment Details


Active Member

Posts

Joined
Thu Jun 04, 2009 10:40 am
Location - Ontario, Canada

Post by noonoo » Thu Sep 10, 2009 11:31 pm

Hi thanks for the reply,

Im not sure what you mean by:
the changes that were completed with the sql files provided by Qphoria
Thanks

Newbie

Posts

Joined
Thu Jul 16, 2009 4:34 pm

Post by kdmp » Thu Sep 10, 2009 11:44 pm

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


Active Member

Posts

Joined
Thu Jun 04, 2009 10:40 am
Location - Ontario, Canada

Post by noonoo » Fri Sep 11, 2009 12:35 am

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

Newbie

Posts

Joined
Thu Jul 16, 2009 4:34 pm

Post by kdmp » Fri Sep 11, 2009 5:16 am

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 :P

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


Active Member

Posts

Joined
Thu Jun 04, 2009 10:40 am
Location - Ontario, Canada

Post by noonoo » Fri Sep 11, 2009 8:50 am

Hi thanks for the reply,
kdmp wrote:Overwriting the new installation of 1.3.2 with files from an older version of OpenCart would defeat the purpose of upgrading :P
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?

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

Newbie

Posts

Joined
Thu Jul 16, 2009 4:34 pm

Post by kdmp » Fri Sep 11, 2009 9:52 am

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.

Kevin Davidson
Purolator Shipping Module
Canpar Shipping Module
VQMod - Paypal Transaction ID to Payment Details


Active Member

Posts

Joined
Thu Jun 04, 2009 10:40 am
Location - Ontario, Canada

Post by noonoo » Sat Sep 12, 2009 12:25 am

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

Newbie

Posts

Joined
Thu Jul 16, 2009 4:34 pm

Post by kdmp » Sat Sep 12, 2009 4:36 am

Hi Noonoo,

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


Active Member

Posts

Joined
Thu Jun 04, 2009 10:40 am
Location - Ontario, Canada
Who is online

Users browsing this forum: No registered users and 5 guests