1146 Table error zenconfiguration doesn't exist

[DrByte]

Great.

I should have mentioned part two ... can you look up the same settings from your "old" site? ... and post them.

[gayelston]

You ARE quick!
This is the same section copied & pasted from the live site files:
// define our database connection
define('DB_TYPE', 'mysql');
define('DB_PREFIX', 'zen_');
define('DB_SERVER', '127.0.0.1'); // eg, localhost - should not be empty
define('DB_SERVER_USERNAME', 'kelston');
define('DB_SERVER_PASSWORD', '');
define('DB_DATABASE', 'artyfactsforcrafts_com_-_zencart');
define('USE_PCONNECT', 'false'); // use persistent connections?
define('STORE_SESSIONS', 'db'); // leave empty '' for default handler or set to 'db'
Hope that helps
Regards
######

[DrByte]

Okay.

Did you notice that your DB_PREFIX is "zen" for one site and "zen_" for the other?

So, your imported data will have tables named like "zen_admin", "zen_configuration", etc

But, since your new site is set up for "zen", it's looking for "zenadmin", "zenconfiguration", etc.

Thus, there's a mismatch.

What to do?
a) drop all the tables in your NEW database
b) edit your NEW configure.php files and change DB_PREFIX to "zen_" ... which matches your old site .... because you'll be importing data that has tables matching the names of your old site
c) import your old site data into the new database

Things should be okay now.

[gayelston]

Thank you!
Actually, it didn't work fully at first:
I changed includes/configure.php & that let me see the front end, but not the admin.
So I checked the admin/includes/configure.php & found the same fault.
I changed that & now everything is perfect.
All I have to do now is go through it all again with the new version!
You may see me back on a similar subject soon but, until then, many many thanks.
You really have saved my sanity, because I checked all the lines on this file & could have sworn I'd done it all right!
Thanks again
Regards
######
Artyfactsforcrafts.com