1146 Table error zenconfiguration doesn't exist

[gayelston]

Hello,
Can anyone help please?
I've been tearing my hair out for the last few days, & that's just my latest batch of attempt to get this sorted!
I am with United Hostings on a Linux server.
I was having the same problems when I tried all of this on my computer using Wamp5;
I load in Zen Cart 1.3.02, because that is what I used when I first created my shop.
I have no problem with this at all.
I check the shop front & the admin & all seems to be working just fine.
Then, as I read in lots of different help files, I drop the tables of the database, import a copy of my current (shop) db then copy over a back-up of my shop files.
I took out the 2 configure.php files first, then put them back after the upload.
I checked the sessions.php file had the changes specified in another help file & I made sure the install file was renamed.

I tried to go to my shop & got this:
1146 Table 'artyfactsforcrafts_com_-_zencartnew.zenconfiguration' doesn't exist
in:
[select configuration_key as cfgkey, configuration_value as cfgvalue from zenconfiguration]

I tried to go to my admin & got this:
1146 Table 'artyfactsforcrafts_com_-_zencartnew.zenconfiguration' doesn't exist
in:
[select configuration_key as cfgkey, configuration_value as cfgvalue from zenconfiguration]
Can anyone help please?
It seems to say that there's a table missing in the db, but shouldn't ther be an underscore as in zen_configuration.

I have checked the admin/includes/configure.php file & all my details have been updated, so the entries that read, for example, define('DIR_WS_ADMIN', '/zen-cart/admin/'); now reads define('DIR_WS_ADMIN', '/zen-cart-new/admin/');
Ths version of Zen Cart is called zec-cart-new, with the db named zencartnew.
Please help, but please keep in mind I have virtually no experience with coding of any kind - took my a whole day to work out how to change my password, or give me a password, using mysql!
Thanks very much, in advance, for any help you can give.
Regards
###### Elston
Artyfactsforcrafts.com

[DrByte]

In your /includes/configure.php file, what are the settings for these:

define('DB_PREFIX', '');
define('DB_SERVER', '');
define('DB_SERVER_USERNAME', '');
define('DB_SERVER_PASSWORD', *********** DONT POST THIS ONE ******
define('DB_DATABASE', '');

[gayelston]

Hi,
Thank very much for you VERY speedy reply!
Thjese are the details copied & pasted straight from the file:
// define our database connection
define('DB_TYPE', 'mysql');
define('DB_PREFIX', 'zen');
define('DB_SERVER', 'localhost'); // eg, localhost - should not be empty
define('DB_SERVER_USERNAME', 'kelston');
define('DB_SERVER_PASSWORD', '');
define('DB_DATABASE', 'artyfactsforcrafts_com_-_zencartnew');
define('USE_PCONNECT', 'false'); // use persistent connections?
define('STORE_SESSIONS', 'db'); // leave empty '' for default handler or set to 'db'
As suggested, I have removed the password.
Thanks again
Regards
######

[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