Rebuilding store w/existing DB

[Brian1234]

Hi, I'm having trouble rebuilding a Zen-Cart store. The previous and current store both are the current version.

I backed up my original DB, created a new DB and installed ZC into the new DB fine. Everything is working good.

I thought I would be able to drop the tables there and import the tables from my old DB but when I try to view the site I get an error:
1146 Table 'MyNewDatabaseName.configuration' doesn't exist
in:
[select configuration_key as cfgkey, configuration_value as cfgvalue from configuration]

So, it appears that somewhere in the database it has stored the name of the old one? Or am I having some other issue? I can clear the DB out and import the blank-store.sql that I created after the new ZC install process and everything works again, so I know my DB settings in the configure.php's is fine.

Oh, I also have a directory on the server I haven't seen before: '-newname' ... what is that about?

Hints or tips appreciated, thanks!

[Muzz]

HI There,

After you have installed the DB etc.. you replaced the new zen cart files with your previous ones?

Check your DB paths, names and passwords:

includes/configure.php

admin/includes/configure.php

[Brian1234]

It's a clean / new ZC install, the only files I uploaded besides the stock ZC ones are my custom template.

Since it is operational with the post-install data in the DB I believe the names, PWs and paths are all correct.

Now I'm not completely sure the old store was the current version. It was the version current as of Jan 20 2008 when I set it up.

[Muzz]

I suggest that you login to your MYPHP admin.

Ensure the database name is correct.

Then compare your OLD website files:

includes/configure.php

admin/includes/configure.php

to the NEW one.

Are they EXACTLY the same ?

You comparing this area:

define('DB_TYPE', 'mysql');
define('DB_PREFIX', '');
define('DB_SERVER', 'localhost');
define('DB_SERVER_USERNAME', 'YOURdatabaseUSERNAME');
define('DB_SERVER_PASSWORD', 'yourPASSWORD');
define('DB_DATABASE', 'YOURshopNAME');
define('USE_PCONNECT', 'false');
define('STORE_SESSIONS', 'db');
// for STORE_SESSIONS, use 'db' for best support, or '' for file-based storage

[Brian1234]

[The site] is operational with the post-install data in the DB

ZC is not having a problem connecting to the DB. It appears to be having trouble finding a table or table data once connected.

Oh, and since the current release of ZC was in 2007, I'm 99 & 44/100ths sure the store I setup in 2008 was using it. Since it's been so long though, I'm starting to wonder if ZC development has stopped.

[Brian1234]

AHA! Got it!

The old DB had a table prefix I hadn't noticed. Once I edited the config files for that, all is well.

Thanks for the replies Muzz.

[Muzz]

Np. Glad it's all working.

[DrByte]

Since it's been so long though, I'm starting to wonder if ZC development has stopped.

Not at all. Check the Announcements area regarding v2.0