Page 1 of 2 12 LastLast
Results 1 to 10 of 18
  1. #1
    Join Date
    Aug 2005
    Posts
    140
    Plugin Contributions
    0

    Default error when moving to a new server

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

  2. #2
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,761
    Plugin Contributions
    9

    Default Re: error when moving to a new server

    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
    Zen-Venom Get Bitten

  3. #3
    Join Date
    Aug 2005
    Posts
    140
    Plugin Contributions
    0

    Default Re: error when moving to a new server

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

  4. #4
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,761
    Plugin Contributions
    9

    Default Re: error when moving to a new server

    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.
    Zen-Venom Get Bitten

  5. #5
    Join Date
    Aug 2005
    Posts
    140
    Plugin Contributions
    0

    Default Re: error when moving to a new server

    got it straightened out...thanks!

  6. #6
    Join Date
    Dec 2006
    Location
    Victoria, Australia
    Posts
    360
    Plugin Contributions
    0

    Default Re: error when moving to a new server

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

  7. #7
    Join Date
    Apr 2004
    Location
    UK
    Posts
    5,821
    Plugin Contributions
    2

    Default Re: error when moving to a new server

    Quote Originally Posted by blind1 View Post
    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???
    This means zencart cannot connect to zencart database.
    Make sure you have correctly entered details of database
    in both config files..

  8. #8
    Join Date
    Dec 2006
    Location
    Victoria, Australia
    Posts
    360
    Plugin Contributions
    0

    Default Re: error when moving to a new server

    I have tried with and without prefix and combinations of the database name etc but no luck. Can anyone record here an example of what is entered when you create a database and how it should appear in the config files please

    say for example if i called the database: boxes, username: user, password: MyPassword and didnt set a prefix --- what would it look like in the coding?

    Because mine looks like ones I have done before except they have a prefix (which I tried adding but no good either)
    I did notice that it didnt encrype the password like my other site though?

    I used to create the live. I am having trouble now because i am uploading and trying to install the databasr.

  9. #9
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,761
    Plugin Contributions
    9

    Default Re: error when moving to a new server

    Blind,

    Check in you hosting account manager what the DB name is....many times it will be
    usr-name_DB-Name
    If you have phpmyadmin you can also use this to see the DB name and the table names & if they have a prefix or not....

    Collect the information - edit the configure.php to match the data and you should connect
    Zen-Venom Get Bitten

  10. #10
    Join Date
    Dec 2006
    Location
    Victoria, Australia
    Posts
    360
    Plugin Contributions
    0

    Default Re: error when moving to a new server

    Me again
    I have added another user name and password and tried different combinations in the config files but still a dead end.
    As an example In the code below where would you place what if the details in phpmyadmin where: User : model_Username , Database model_boxes , P/w: MyPassword


    // define our database connection
    define('DB_TYPE', 'mysql');
    define('DB_PREFIX', 'model_');
    define('DB_SERVER', 'localhost');
    define('DB_SERVER_USERNAME', 'model_Username);
    define('DB_SERVER_PASSWORD', 'MyPassword');
    define('DB_DATABASE', 'boxes');
    define('USE_PCONNECT', 'false'); // use persistent connections?
    define('STORE_SESSIONS', 'db'); // use 'db' for best support, or '' for file-based storage

    This is how it is set now but I must have something in the wrong place?

 

 
Page 1 of 2 12 LastLast

Similar Threads

  1. v154 Error 1044 when moving database to new server
    By Annie_zaz in forum Installing on a Linux/Unix Server
    Replies: 18
    Last Post: 19 Jan 2016, 03:04 PM
  2. cart not working when moving to a new server
    By webdev316 in forum General Questions
    Replies: 4
    Last Post: 30 Oct 2008, 03:35 AM
  3. Problems when moving to a new server
    By Moncia in forum General Questions
    Replies: 3
    Last Post: 15 Sep 2007, 04:20 AM
  4. ERROR after moving Zen to new Server
    By directdesign in forum Installing on a Linux/Unix Server
    Replies: 2
    Last Post: 8 Sep 2007, 08:08 PM

Bookmarks

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
Zen-Cart, Internet Selling Services, Klamath Falls, OR