error when moving to a new server

**fright-rags** · 16 Apr 2007, 04:44 AM

I just followed the Wiki instructions on moving my cart installation to a new server but something isn't right. Here's what I did:

- backed up databases and site files
- installed cart on new server (v1.3.5 - which is what I was using on my old site)
- moved over all my site files, but did not overwrite includes/config.php or admin/includes/config.php
- imported database (same name, etc as old one)

All of that worked...until I tried uploading and running the fix_cache_key.php...that didn't work. and now when I got to my domain, here's what I get:

1146 Table 'bscriv77_zc1.configuration' doesn't exist
in:
[select configuration_key as cfgkey, configuration_value as cfgvalue from configuration]

and on my admin page:

1146 Table 'bscriv77_zc1.project_version' doesn't exist
in:
[select * from project_version WHERE project_version_key = 'Zen-Cart Database' ]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Any ideas as to what went wrong??

**kobra** · 16 Apr 2007, 05:39 AM

installed cart on new server (v1.3.5 - which is what I was using on my old site)

When you did this, did you specify the table prefix zc1_ as I would think that either your db backup was a data only back without the recreation of the tables or something along those lines.

You can use phpmyadmin to view your table names to see that they are there and that they all have no prefix or the same prefix

**fright-rags** · 16 Apr 2007, 10:22 AM

Yeah, I need to change the prefix...how do I do that? In the config file?

**kobra** · 16 Apr 2007, 10:34 AM

Yeah, I need to change the prefix...how do I do that? In the config file?

did you check the DB names using phpmyadmin? were they all the same? If not you have to rename them and this can be done in phpmyadmin. Then yes make sure that in the configigure.php files (2 of them) that the DB prefix is set to what ever it actually is.

**fright-rags** · 16 Apr 2007, 11:37 AM

got it straightened out...thanks!

**blind1** · 22 Jun 2007, 07:49 AM

I am having the same problem and i added the prefix but get the error page:

Sorry!
There seems to be a problem connecting to our database. Please give us a few minutes to remedy the problem. Thank you.

with the maitanance picture on it???