Page 1 of 2 12 LastLast
Results 1 to 10 of 11
  1. #1
    Join Date
    Jan 2006
    Location
    Hooterville, Connecticut
    Posts
    10
    Plugin Contributions
    0

    Default Moved Zencart Not Working

    Hi,

    I moved my zencart from one server to another. I did a fresh install of zencart on the new server. All went well... let all my files with the exception of the admin/includes/config and includes/config overwrite the files on the server.. everything at that point was still ok..
    Went in and droped all the tables in the new database.. then imported my database into it.. All the info is showing up in the database.. but when I try to log-in to the admin .. I am getting basically a blank page.. with this error..

    1146 Table 'kreative_zc1.configuration' doesn't exist

    HELP!! I have been reading through the posts.. but haven't found anything like this.
    I wasn't sure where to post this question, hope I have the right place.

    Karyn

  2. #2
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: Moved Zencart Not Working

    If your Catalog works but your Admin does not ...

    Check the /includes/configure.php and look down at the bottom for the database settings ...

    Then check the /admin/includes/configure.php and look down at the bottom for the database settings ...

    Are both using the same database?

    Look at the top of the two files ...

    Are both using the same URLs and path settings?
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

  3. #3
    Join Date
    Jan 2006
    Location
    Hooterville, Connecticut
    Posts
    10
    Plugin Contributions
    0

    Default Re: Moved Zencart Not Working

    Since I imported the database, neither the catalog or the admin works.. I am getting the same error.. when trying to log in to the admin.. or view the catalog. Both were working before I imported the database.

    Karyn

    yes, they are both using the same database
    Last edited by karyn; 13 May 2006 at 05:25 PM.

  4. #4
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: Moved Zencart Not Working

    So you loaded a clean v1.3.0.1 on your new site and created a new database ... and all was good ...

    Then ... you overwrote all of the v1.3.0.1 code with your v1.2.7 code and dropped the database tables in your v1.3.0.1 database and loaded your v1.2.7 database and structure ... and all is broken ...

    Is this correct?
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

  5. #5
    Join Date
    Jan 2006
    Location
    Hooterville, Connecticut
    Posts
    10
    Plugin Contributions
    0

    Default Re: Moved Zencart Not Working

    No.. I loaded a fresh 1.26 version ( which is the same version that I had) and then overwrote the files ( that were the same version) on the new server. I figured I would upgrade AFTER i had everything moved and working.

    Everything was working in the store and admin.. until I imported the database. But zencart was the same version that I had.

  6. #6
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: Moved Zencart Not Working

    Did your old site use database prefixes and your new site not use them?

    Look in the configure.php files to see if you have a prefix set ... then look via phpMyAdmin at your database tables and see if it is or isn't using those based on what is set in the configure.php files ...
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

  7. #7
    Join Date
    Jan 2006
    Location
    Hooterville, Connecticut
    Posts
    10
    Plugin Contributions
    0

    Default Re: Moved Zencart Not Working

    No, they both use them.

    This is the error

    1146 Table 'kreative_zc1.kreative_project_version' doesn't exist

    that table is not in my database, could be why it can't find it! LOL
    But I can't find that reference to that table in any of the config files.. I am totally lost.

  8. #8
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: Moved Zencart Not Working

    You said you had the error referencing:
    1146 Table 'kreative_zc1.configuration' doesn't exist
    But now you have an error referencing:
    1146 Table 'kreative_zc1.kreative_project_version' doesn't exist
    That would mean half your code is calling the database tables with the prefix:
    kreative_

    And half the code is calling the database tables with no prefix ...

    This makes no sense ...

    Your old site works correct?

    Do both sites have different user names?

    Are they with different hosts? Or just different domain names?

    Could you post the /includes/configure.php from the server for your old site ... without your username and password ...

    Then, could you post the /includes/configure.php from the server for your new site ... without your username and password ...
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

  9. #9
    Join Date
    Jan 2006
    Location
    Hooterville, Connecticut
    Posts
    10
    Plugin Contributions
    0

    Default Re: Moved Zencart Not Working

    The top error is what I am getting when trying to access the admin..

    the second error is what I am getting when trying to access the store.

    The domain name is the same.. the hosts are different. User names are different.

    The old site ( on my old host) is not up anymore.. But yes, it was working perfect.

    After 4 days of trying to get this to work.. I am at my wits end.. I wiped out what I had.. and started over.. I can now get into the admin, and the catalog.. but I have not imported my database yet. I am thinking of starting over from scratch. I can always add my customer base back in manually.. . And my products again also.. The database is what is messing things up.


    This is the file from my old server: ( was the one that worked)

    // Define the webserver and path parameters
    // Main webserver: eg, http://localhost - should not be empty for productive servers
    define('HTTP_SERVER', 'http://karyntaglia.com');
    // Secure webserver: eg, https://localhost - should not be empty for productive servers
    define('HTTPS_SERVER', 'https://karyntaglia.com');
    // secure webserver for checkout procedure?
    define('ENABLE_SSL', 'false');

    // NOTE: be sure to leave the trailing '/' at the end of these lines if you make changes!
    // * DIR_WS_* = Webserver directories (virtual/URL)
    // these paths are relative to top of your webspace ... (ie: under the public_html or httpdocs folder)
    define('DIR_WS_CATALOG', '/zencart1/');
    define('DIR_WS_HTTPS_CATALOG', '/zencart1/');

    define('DIR_WS_IMAGES', 'images/');
    define('DIR_WS_INCLUDES', 'includes/');
    define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/');
    define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/');
    define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/');
    define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/');
    define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/');
    define('DIR_WS_DOWNLOAD_PUBLIC', DIR_WS_CATALOG . 'pub/');
    define('DIR_WS_BLOCKS', DIR_WS_INCLUDES . 'blocks/');
    define('DIR_WS_TEMPLATES', DIR_WS_INCLUDES . 'templates/');

    define('DIR_WS_PHPBB', '/');

    // * DIR_FS_* = Filesystem directories (local/physical)
    //the following path is a COMPLETE path to your Zen Cart files. eg: /var/www/vhost/accountname/public_html/store/
    define('DIR_FS_CATALOG', '/home/karynta/public_html/zencart1/');

    define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/');
    define('DIR_FS_DOWNLOAD_PUBLIC', DIR_FS_CATALOG . 'pub/');
    define('DIR_WS_UPLOADS', DIR_WS_IMAGES . 'uploads/');
    define('DIR_FS_UPLOADS', DIR_FS_CATALOG . DIR_WS_UPLOADS);
    define('DIR_FS_EMAIL_TEMPLATES', DIR_FS_CATALOG . 'email/');

    // define our database connection
    define('DB_TYPE', 'mysql');
    define('DB_PREFIX', 'zen_');
    define('DB_SERVER', 'localhost'); // eg, localhost - should not be empty
    define('DB_SERVER_USERNAME', '******');
    define('DB_SERVER_PASSWORD', '*******');
    define('DB_DATABASE', 'karynta_zc1');
    define('USE_PCONNECT', 'false'); // use persistent connections?
    define('STORE_SESSIONS', 'db'); // leave empty '' for default handler or set to 'db'

    // The next 2 "defines" are for SQL cache support.
    // For SQL_CACHE_METHOD, you can select from: none, database, or file
    // If you choose "file", then you need to set the DIR_FS_SQL_CACHE to a directory where your apache
    // or webserver user has write privileges (chmod 666 or 777). We recommend using the "cache" folder inside the Zen Cart folder
    // ie: /path/to/your/webspace/public_html/zen/cache -- leave no trailing slash
    define('SQL_CACHE_METHOD', 'database');
    define('DIR_FS_SQL_CACHE', '/home/karynta/public_html/zencart1/cache');

    ?>


    Will post the other file in a minute.

  10. #10
    Join Date
    Jan 2006
    Location
    Hooterville, Connecticut
    Posts
    10
    Plugin Contributions
    0

    Default Re: Moved Zencart Not Working

    I think I found the problem.. I named the new database with a prefix.. so it would be the same as the database I had, that is what is showing up in when I look in the hosting control panel.. BUT the actual database name on the new server is a different name, withouth a prefix, I didn't catch that before.

    Now the question is.. how to fix that or can't I? I really would just love to get my address book and customers back in. Is there a way to do that?

    Thank you for your help.

 

 
Page 1 of 2 12 LastLast

Similar Threads

  1. Moved Site, address not working
    By micro007 in forum Basic Configuration
    Replies: 7
    Last Post: 26 Feb 2015, 11:50 PM
  2. Moved To Another Server but Not Working
    By webhtmauicom in forum General Questions
    Replies: 4
    Last Post: 21 Jul 2010, 10:18 PM
  3. 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
  4. Moved server fix_cache_key.php not working
    By supersnow in forum Installing on a Linux/Unix Server
    Replies: 5
    Last Post: 2 Jan 2008, 01:18 AM

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