Zen Cart Logo
Forums / Upgrading to 1.5.x / Database migration trouble moving from 1.3.8a to 1.5.1

Database migration trouble moving from 1.3.8a to 1.5.1

Views: 840

Results 1 to 6 of 6
29 Oct 2014, 7:29 PM
#1
potterpoole avatar

potterpoole

New Zenner

Join Date:
Feb 2009
Posts:
13
Plugin Contributions:
0

Database migration trouble moving from 1.3.8a to 1.5.1

I am upgrading my zen cart from 1.3.8a to 1.5.1, because I was moving from one hosting to another I installed 1.5.1 from scratch and performed the following

during setup I

  1. created a database in 1.5.1

using admin I
2. created categories in 1.5.1
3. created a product listing in 1.5.1

using Godaddy database management tool I
4. downloaded a csv file for the new products database file
5. downloaded a csv file from the old products database file
6. merged the two files making changes to the old data based on the new format
7. uploaded the merged file into the new database
8. edited the products to categories database file to include all my product numbers and the category number.

when I go back to admin panel and go to categories it shows the right amount of products in each
when I go to products admin it only shows the original products I entered none of the products i put in the products database show up.

Anyone have any Idea as to why.

29 Oct 2014, 9:45 PM
#2
lhungil avatar

lhungil

Totally Zenned

Join Date:
Feb 2012
Location:
mostly harmless
Posts:
1,818
Plugin Contributions:
4

Re: Database migration trouble moving from 1.3.8a to 1.5.1

Any reason you are not just using the Zen Cart method for upgrading the database (zc_install)? This process is far easier than trying to "import" / "export" / "update" the database by hand.

29 Oct 2014, 10:07 PM
#3
lat9 avatar

lat9

Administrator

Join Date:
Sep 2009
Location:
Stuart, FL
Posts:
14,089
Plugin Contributions:
56

Re: Database migration trouble moving from 1.3.8a to 1.5.1

lhungil:

Any reason you are not just using the Zen Cart method for upgrading the database (zc_install)? This process is far easier than trying to "import" / "export" / "update" the database by hand.
In addition, with Zen Cart v1.5.3 now available, why are you going through the effort to upgrade to v1.5.1 (a 2-year-old distribution)? You're just doubling your efforts, since v1.5.3 includes the changes necessary for PHP versions 5.4 and later.

29 Oct 2014, 11:52 PM
#4
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,908
Plugin Contributions:
2

Re: Database migration trouble moving from 1.3.8a to 1.5.1

Amen to both.

30 Oct 2014, 3:21 AM
#5
potterpoole avatar

potterpoole

New Zenner

Join Date:
Feb 2009
Posts:
13
Plugin Contributions:
0

Re: Database migration trouble moving from 1.3.8a to 1.5.1

There are reason
godaddy sets up 1.5.1 with its database for free 1.5.4 isn't available yet
the other site was moded and I don't want dual pricing anymore
I could just re inter the products by hand, I only have 44 but
transferring customer accounts worked fine so I thought this would to

30 Oct 2014, 4:57 AM
#6
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,908
Plugin Contributions:
2

Re: Database migration trouble moving from 1.3.8a to 1.5.1

Did you mean that php 5.4 isn't available yet or that Zen Cart 1.5.4 isn't available yet?

And so their "install" it is a full set of the files? No changes, no autoinstaller?