Forums / Upgrading from 1.3.x to 1.3.9 / None of DB visible after upgrade from 1.3.0.2 to 1.3.7

None of DB visible after upgrade from 1.3.0.2 to 1.3.7

Locked

Started by bhuntsman on 9 Feb 2007, 2:29 AM · Views: 1,673

Results 1 to 8 of 8
This thread is locked. New replies are disabled.
9 Feb 2007, 2:29 AM
#1
bhuntsman avatar

bhuntsman

New Zenner

Join Date:
Mar 2005
Location:
Miami, FL
Posts:
29
Plugin Contributions:
0

None of DB visible after upgrade from 1.3.0.2 to 1.3.7

Help please. Last time I upgraded, while it took a couple of days, it did not entail near the frustration that I'm having upgrading from 1.3.0.2 to 1.3.7. I thought the upgrading process was supposed to be improved and easier with the newer releases...apparently not.

I followed the installation/upgrade instructions exactly and when I try to find my categories, products, customers, order history or anything else that's in the DB from my present site, it's no where to be found...e.g. in admin, I click on Catalog>Categories/Products and none of my old categories or products are there...same with manufacturers, customers, etc. After loading my old DB, I performed the DB upgrade using zc_install, but to no avail. I've already completely deleted and re-installed twice and I'm ready to pull my hair out. An upgrade is useless to me if I have to go back and hand enter hundreds of customers and 1500+ products.

Why is the DB transition so difficult with this upgrade? Any help would be greatly appreciated.

Brian Huntsman
www.LearningByDVD.com
Your Internet Source for How-To & Educational DVDs & CDs
[email protected]

9 Feb 2007, 4:32 AM
#2
afo avatar

afo

Totally Zenned

Join Date:
Aug 2004
Location:
New York City
Posts:
6,800
Plugin Contributions:
0

Re: None of DB visible after upgrade from 1.3.0.2 to 1.3.7

If the cart and db are both on 1.3.7, you should be able to import the backup of your db from phpMyAdmin. After that you should be good to go.

Mary Ellen
I came; I saw; I Zenned
Taking over the world... one website at a time
Make sure brain is engaged before putting mouth in gear... or fingers to keyboard.

Holzheimer
Fan Odyssey

9 Feb 2007, 4:47 AM
#3
bhuntsman avatar

bhuntsman

New Zenner

Join Date:
Mar 2005
Location:
Miami, FL
Posts:
29
Plugin Contributions:
0

Re: None of DB visible after upgrade from 1.3.0.2 to 1.3.7

Mary Ellen...I had already done what you suggested and it did not work...I guess I'll just have to stick with 1.3.0.2...I spent alot of time customizing my present site and this upgrade seems to be turning into a nightmare...and I consider myself to be an intermediate-level "zenner".

Brian Huntsman
www.LearningByDVD.com
Your Internet Source for How-To & Educational DVDs & CDs
[email protected]

9 Feb 2007, 4:59 AM
#4
afo avatar

afo

Totally Zenned

Join Date:
Aug 2004
Location:
New York City
Posts:
6,800
Plugin Contributions:
0

Re: None of DB visible after upgrade from 1.3.0.2 to 1.3.7

I don't know what to say. I upgraded a cart from 1.2.7 to 1.3.7 using a testbed to setup the 1.3.7 cart. I exported the live 1.2.7 db and imported it into the 1.3.7 test db so I had data and images to test with. I don't see any reason to import your data and then run zc_install again. The import from phpMyAdmin should populate the db correctly. If you run zc_install and don't select "upgrade DB only" (or whatever it says) you're erasing the contents of the db. The db upgrade should detect the version of the db and preselect the required upgrade. From what you've said, you already installed 1.3.7, so the db upgrade shouldn't do anything.

Mary Ellen
I came; I saw; I Zenned
Taking over the world... one website at a time
Make sure brain is engaged before putting mouth in gear... or fingers to keyboard.

Holzheimer
Fan Odyssey

9 Feb 2007, 5:22 AM
#5
bhuntsman avatar

bhuntsman

New Zenner

Join Date:
Mar 2005
Location:
Miami, FL
Posts:
29
Plugin Contributions:
0

Re: None of DB visible after upgrade from 1.3.0.2 to 1.3.7

I installed 1.3.7 into its own directory and with its own new db...I then imported the old db into the new db...after importing my old data, at the top of the admin page for the 1.3.7 I saw the message that the db needed to be upgraded to a higher level, so I ran the db upgrade portion of zc_install to upgrade only the db...at this point I would expect my data to be available, but it's not...and none of it's available...not products, not customers, not manufacturers, not sales reports/history...

Brian Huntsman
www.LearningByDVD.com
Your Internet Source for How-To & Educational DVDs & CDs
[email protected]

9 Feb 2007, 5:31 AM
#6
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: None of DB visible after upgrade from 1.3.0.2 to 1.3.7

Check your files for:
/includes/configure.php
/admin/includes/configure.php

Did you remember to update the database name, username and password?

Did you update all paths to the new temp directory?

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

9 Feb 2007, 5:47 AM
#7
bhuntsman avatar

bhuntsman

New Zenner

Join Date:
Mar 2005
Location:
Miami, FL
Posts:
29
Plugin Contributions:
0

Re: None of DB visible after upgrade from 1.3.0.2 to 1.3.7

Yes, both configure files are correct as well as all paths.

Brian Huntsman
www.LearningByDVD.com
Your Internet Source for How-To & Educational DVDs & CDs
[email protected]

9 Feb 2007, 2:20 PM
#8
afo avatar

afo

Totally Zenned

Join Date:
Aug 2004
Location:
New York City
Posts:
6,800
Plugin Contributions:
0

Re: None of DB visible after upgrade from 1.3.0.2 to 1.3.7

I'm assuming you've got this installed in a test directory. Can you post a url (or send it to me via PM)? Maybe I can see something we're missing.

Mary Ellen
I came; I saw; I Zenned
Taking over the world... one website at a time
Make sure brain is engaged before putting mouth in gear... or fingers to keyboard.

Holzheimer
Fan Odyssey