Forums / General Questions / Setting up on a new Server and I have a problem

Setting up on a new Server and I have a problem

Locked

Views: 1,409

Results 1 to 10 of 10
This thread is locked. New replies are disabled.
3 Oct 2007, 5:25 PM
#1
touchclothing avatar

touchclothing

Totally Zenned

Join Date:
Jul 2005
Location:
Brooklyn NY
Posts:
498
Plugin Contributions:
0

Setting up on a new Server and I have a problem

I set up an already built zencart site on my server we are going to redesin the site but did not want to do it on the live site so I took the site and put it on my server. I set up a data base for it and I change the configure.php to match but now I am getting this error message:
1146 Table 'digitalm_vvip.configuration' doesn't exist
in:
[select configuration_key as cfgkey, configuration_value as cfgvalue from configuration]

3 Oct 2007, 7:21 PM
#2
drbyte avatar

drbyte

Sensei

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

Re: Setting up on a new Server and I have a problem

It cannot find your database tables.
Did you import them properly?
Do you have the correct DB_PREFIX setting on your new server as you did on your old server? If not, Zen Cart cannot find the tables it's looking for.

FAQ: https://www.zen-cart.com/tutorials/index.php?article=99

.
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.

3 Oct 2007, 7:30 PM
#3
touchclothing avatar

touchclothing

Totally Zenned

Join Date:
Jul 2005
Location:
Brooklyn NY
Posts:
498
Plugin Contributions:
0

Re: Setting up on a new Server and I have a problem

No I did not import the data base I just started a new one?

3 Oct 2007, 7:34 PM
#4
touchclothing avatar

touchclothing

Totally Zenned

Join Date:
Jul 2005
Location:
Brooklyn NY
Posts:
498
Plugin Contributions:
0

Re: Setting up on a new Server and I have a problem

I read over the thread so what I need to do is a fresh install on the new server with a new data base and then take a back of the other data base and do a recover install on the new data base. But what if the new data base has a differnt name?

3 Oct 2007, 7:38 PM
#5
drbyte avatar

drbyte

Sensei

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

Re: Setting up on a new Server and I have a problem

touchclothing:

But what if the new data base has a differnt name?
... then you use that new name in your configure.php files.

To keep it as simple as possible, just be sure to use the same "Table Prefix" in your new database when doing the zc_install step, as you had in your old database.

Then all you need to do is import the database content from old to new.
(as well as copying all the files over via FTP)

.
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.

3 Oct 2007, 7:52 PM
#6
touchclothing avatar

touchclothing

Totally Zenned

Join Date:
Jul 2005
Location:
Brooklyn NY
Posts:
498
Plugin Contributions:
0

Re: Setting up on a new Server and I have a problem

I have one other question Do I need to do the install or could I just load the site up and then change the configure.php to the new data base name and then do a restore for the data base? Or do I need to do a fresh install?

3 Oct 2007, 8:48 PM
#7
touchclothing avatar

touchclothing

Totally Zenned

Join Date:
Jul 2005
Location:
Brooklyn NY
Posts:
498
Plugin Contributions:
0

Re: Setting up on a new Server and I have a problem

ok one last question what if I have more then one data base and I only want to restore one of them how do I do that?

3 Oct 2007, 8:55 PM
#8
touchclothing avatar

touchclothing

Totally Zenned

Join Date:
Jul 2005
Location:
Brooklyn NY
Posts:
498
Plugin Contributions:
0

Re: Setting up on a new Server and I have a problem

Ok I did a back up of the old data base not how do I put it into the new data base? on a different server with a different data base name?

3 Oct 2007, 9:00 PM
#9
touchclothing avatar

touchclothing

Totally Zenned

Join Date:
Jul 2005
Location:
Brooklyn NY
Posts:
498
Plugin Contributions:
0

Re: Setting up on a new Server and I have a problem

I guess this is that part that I can't get to work????

6- Using phpMyAdmin, restore your old site's database into the new database you created in step 4.

3 Oct 2007, 9:44 PM
#10
drbyte avatar

drbyte

Sensei

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

Re: Setting up on a new Server and I have a problem

touchclothing:

I guess this is that part that I can't get to work????

6- Using phpMyAdmin, restore your old site's database into the new database you created in step 4.

This FAQ may help: https://www.zen-cart.com/tutorials/index.php?article=103

.
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.