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

    help question changing servers!! and its not working Please help!!

    I am moving servers and this is what I have done so far.

    1. Uploaded and installed the same verson of zencart on the new server.
    2. copied the old site to the new server saving the config files from the new install.
    3. did a back up of the old data base
    4. imported the old data base into the new data base on the new server.

    Now here are the problem I am getting:
    in the data base inport it says "Import has been successfully finished, 0 queries executed."

    When I go to the site this is what it says:
    1054 Unknown column 'c.parent_id' in 'on clause'
    in:
    [SELECT c.categories_id as id, c.parent_id, cd.categories_name as cName, cd2.categories_name as pName FROM categories c, categories_description cd LEFT JOIN categories_description cd2 ON c.parent_id=cd2.categories_id AND cd2.language_id='1' WHERE c.categories_id=cd.categories_id AND cd.language_id='1']



    Can some one please help me with this I have been working on it for 3 days and can make it work?

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

    Default Re: changing servers!! and its not working Please help!!

    Did'nt you select a host that can/will assist??

    With "0" queries completed I would doubt that your DB has been imported successfully...

    Check your old host php and mysql ver and compare to your current versions

    What Ver of Zen Cart is this?
    What mods and versions?
    Zen-Venom Get Bitten

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

    Default Re: changing servers!! and its not working Please help!!

    I am using zencart 1.3.7.1
    this is what the old server says MySQL 4.1.14-standard
    and this is what it says for the new server MySQL client version: 4.0.21

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

    Default Re: changing servers!! and its not working Please help!!

    And php versions?
    Zen-Venom Get Bitten

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

    Default Re: changing servers!! and its not working Please help!!

    ok I got the data base to import but now when I go to the site this is what it says "Sorry!
    There seems to be a problem connecting to our database. Please give us a few minutes to remedy the problem. Thank you."


    and when I go to the admin area this is what it says"0 DB_ERROR_NOT_CONNECTED
    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??

  6. #6
    Join Date
    Feb 2005
    Location
    Lansing, Michigan USA
    Posts
    20,024
    Plugin Contributions
    3

    Default Re: changing servers!! and its not working Please help!!

    Probably the database user name and password entries in includes/admin/configure.php and includes/configure.php

 

 

Similar Threads

  1. redirect not working and host says its not their problem
    By MHulak in forum Setting Up Categories, Products, Attributes
    Replies: 40
    Last Post: 15 May 2012, 03:26 AM
  2. useing my template and its not working as planned
    By Eric24v in forum Templates, Stylesheets, Page Layout
    Replies: 1
    Last Post: 29 Jul 2010, 10:55 AM
  3. Error page after changing servers!! please help me :(
    By endi in forum General Questions
    Replies: 3
    Last Post: 9 Feb 2009, 01:06 AM
  4. Moved Servers and site not working
    By ztotheetothen in forum Installing on a Linux/Unix Server
    Replies: 1
    Last Post: 19 Nov 2008, 01:27 AM
  5. It was working and now its not!
    By roachie in forum Basic Configuration
    Replies: 1
    Last Post: 5 Dec 2006, 12:38 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