Restored Data in New Database but not showing

19 Aug 2010, 10:02 AM

#1

New Zenner

Join Date:: Jun 2008
Location:: Brighton, Britain
Posts:: 46
Plugin Contributions:: 0

Restored Data in New Database but not showing

Hi there

As part of upgrading I've:
a) created a new (blank) database;
b) restored the backup of my old database into it;
c) uploaded 1.3.9;
d) installed 1.3.9.

The problem is the data in the database is not showing up in Zen. If I use phpAdmin I can see that the data is there by the number of records.

Can anyone help me by explaining where I have gone wrong and how to fix this?

cheers and thanks for your help
Guy

Here's my shop: https://www.wargamesheaven.co.uk

19 Aug 2010, 10:12 AM

#2

drbyte

Sensei

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

Re: Restored Data in New Database but not showing

You've likely got the wrong table-prefixes set in your configure.php file, so it's looking in the wrong set of tables.
Look at the DB_PREFIX from your live site's configure.php files, and put that same value into your new/test site's configure.php files.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

19 Aug 2010, 10:13 AM

#3

kobra

Black Belt

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

Re: Restored Data in New Database but not showing

As part of upgrading I've:
a) created a new (blank) database;
b) restored the backup of my old database into it;
c) uploaded 1.3.9;
d) installed 1.3.9.
If this is the order you completed steps in then that is the incorrect order - -
You shouls install 1.3.9 firstas step "b"
Then after installed restore your current DB to it
Then re-run zc_install to upgrade the DB Only

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

Zen-Venom Get Bitten

19 Aug 2010, 10:28 AM

#4

guyhancock

New Zenner