Zen Cart Logo
Forums / Upgrading from 1.3.x to 1.3.9 / Database changes 1.3.7 -> 1.3.8

Database changes 1.3.7 -> 1.3.8

Locked

Views: 2,201

Results 1 to 7 of 7
This thread is locked. New replies are disabled.
29 Jul 2009, 4:51 AM
#1
todoonada avatar

todoonada

Zen Follower

Join Date:
Nov 2006
Posts:
127
Plugin Contributions:
0

Database changes 1.3.7 -> 1.3.8

Does anybody know which changes have been made to the database between versions 1.3.7 and 1.3.8?
I see there are two new tables, but would like to know if fields in other tables hve been added or touched.
It also would be great if the changes in the db would be added in the changelog files.

29 Jul 2009, 5:07 AM
#2
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: Database changes 1.3.7 -> 1.3.8

I'm compelled to ask "why" you're asking those questions.

Usually when I hear someone asking such questions it becomes obvious that they're trying to hack in database changes when they should really use the built-in database-upgrade script supplied with the new version. Most of the time when people try to hack in the changes manually they end up breaking things and creating an emergency that then creates demand for support that's harder to make available.

So ... what's the "why" behind your questions?

29 Jul 2009, 5:30 AM
#3
todoonada avatar

todoonada

Zen Follower

Join Date:
Nov 2006
Posts:
127
Plugin Contributions:
0

Re: Database changes 1.3.7 -> 1.3.8

Because I got the old and new version running parallel. I modified a lot of files and it takes quite some time to compare old and new versions and write my changes into the new files. I don't want a long downtime of the shop.
New shop is all set and now the changes in db (new customers, etc) have to be written into the shop.

29 Jul 2009, 2:32 PM
#4
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: Database changes 1.3.7 -> 1.3.8

In that case I usually take a copy of the live database, import it into the new version's database, and run zc_install to take care of the database upgrade which takes only a couple minutes. Then I have all my customer and order history up to date. Then I apply any unique admin config changes that I've made notes about needing to do, and take the new version live.

2 Aug 2009, 7:38 AM
#5
todoonada avatar

todoonada

Zen Follower

Join Date:
Nov 2006
Posts:
127
Plugin Contributions:
0

Re: Database changes 1.3.7 -> 1.3.8

OK, thank you. I will try that.

10 Sep 2009, 9:22 PM
#6
sellgourmet avatar

sellgourmet

New Zenner

Join Date:
May 2008
Location:
Houston
Posts:
9
Plugin Contributions:
0

Re: Database changes 1.3.7 -> 1.3.8

I just built a demo version of my site in a folder on the server to upgrade from 1.3.7 to 1.3.8 due to using PayPal in my cart. Very first time ever doing anything like this so please understand I have read and re-read many comments and instructions but can't figure out how to get the info from the database on the old file to the new database file.

DrByte says to "take a copy of the live database, import it into the new version's database, and run zc_install" but how exactly is this done? How and where do I import a database into another database...on the cpanel phpadmin?

Thanks for any support you guys can offer!

11 Sep 2009, 2:13 AM
#7
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: Database changes 1.3.7 -> 1.3.8

sellgourmet:

DrByte says to "take a copy of the live database, import it into the new version's database, and run zc_install" but how exactly is this done? How and where do I import a database into another database...on the cpanel phpadmin?
Yes!! in cPanel > phpmyadmin > select the DB > select "import" >
"browse" to where the back up is

How to create a DB backup
https://www.zen-cart.com/tutorials/index.php?article=103

https://www.zen-cart.com/tutorials/index.php?article=98