Results 1 to 10 of 10
  1. #1
    Join Date
    Jul 2005
    Location
    Brooklyn NY
    Posts
    507
    Plugin Contributions
    0

    Default 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]

  2. #2
    Join Date
    Jan 2004
    Posts
    66,443
    Plugin Contributions
    279

    Default 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. #3
    Join Date
    Jul 2005
    Location
    Brooklyn NY
    Posts
    507
    Plugin Contributions
    0

    Default 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?

  4. #4
    Join Date
    Jul 2005
    Location
    Brooklyn NY
    Posts
    507
    Plugin Contributions
    0

    Default 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?

  5. #5
    Join Date
    Jan 2004
    Posts
    66,443
    Plugin Contributions
    279

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

    Quote Originally Posted by touchclothing View Post
    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.

  6. #6
    Join Date
    Jul 2005
    Location
    Brooklyn NY
    Posts
    507
    Plugin Contributions
    0

    Default 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?

  7. #7
    Join Date
    Jul 2005
    Location
    Brooklyn NY
    Posts
    507
    Plugin Contributions
    0

    Default 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?

  8. #8
    Join Date
    Jul 2005
    Location
    Brooklyn NY
    Posts
    507
    Plugin Contributions
    0

    Default 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?

  9. #9
    Join Date
    Jul 2005
    Location
    Brooklyn NY
    Posts
    507
    Plugin Contributions
    0

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

  10. #10
    Join Date
    Jan 2004
    Posts
    66,443
    Plugin Contributions
    279

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

    Quote Originally Posted by touchclothing View Post
    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/i...hp?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.

 

 

Similar Threads

  1. Problem sending emails and setting up the mail server
    By vvomble in forum Installing on a Windows Server
    Replies: 8
    Last Post: 18 Feb 2013, 10:29 PM
  2. server migration - can't access admin on new server (APC problem)
    By nathanscrivener in forum General Questions
    Replies: 8
    Last Post: 16 Nov 2010, 07:09 AM
  3. Replies: 1
    Last Post: 24 Apr 2010, 04:04 PM
  4. I have installed a new template and now all of my sub catagories have disappeared
    By Daisy in forum Templates, Stylesheets, Page Layout
    Replies: 0
    Last Post: 15 Sep 2009, 07:53 PM
  5. Server move - Problem with url and Server/Version Info - please help!
    By bethalicea in forum Installing on a Linux/Unix Server
    Replies: 0
    Last Post: 7 Jun 2009, 10:07 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg