Questions! Questions! Please Help Someone.

[weezee]

Questions! Questions! I am trying to keep from losing my site and customers and all the work I did on it this pass year. I looked in tools server/verson to find the version this is what it said. Zen Cart 1.3.7 Database Patch Level: 1.3.7
v1.3.7 [2007-01-30 21:47:04] (Fresh Installation)

would I download the v1.3.7 or v1.3.7.1 - I didn't install the first time my host did it for me that is while I am asking, everytime I send him an e-mail I get this automatic responder that say All customer my be moved by April 1, etc. etc. I don't know which one he installed.

I pointed my website back to the old data base so I could go back and do another backup. after I finish the fresh install do I go to the new data base and select all the tables and do drop, insert and import. or in what order is the steps taken to import my site onto the new server.

[TShooters]

This tutorial should help with moving your site:

https://www.zen-cart.com/tutorials/i...hp?article=100

I think you should get 1.3.7.1, which includes the security patches here:
http://http://sourceforge.net/project/showfiles.php?group_id=83781&package_id=171544&release_id=474574

[weezee]

Thanks a lot, but when I tried to do it there was not drop button, and the browse button wastn't accessible, I called Godaddy and the rep said it wasn't suspose to be a drop button. I told him in the tutorial it said and import. I don't know if we go disconnected or if he hung up on me. I didn't call back.

[TShooters]

What is giving you problems? Are trying to import to your new host? What kind
of control panel do you have? CPanel?

[TShooters]

If you did this in #3 of the tutorial:

3. On your OLD host, Make a COMPLETE backup of your DATABASE and STORE.
a. Use either the "Backup MySQL Database" contribution to do the backup of your database, or use phpMyAdmin to export your entire database ... include the "DROP" tables command, and under Data, choose "Complete Inserts" and "Extended Inserts".
Save the SQL file to your PC for later.
b. Download all your old site's files via FTP (or if you have the option, zip them up on the server and download the zip)

your exported DB backup SQL already has the command to drop the tables.

[weezee]

This is what I did. I installed the fresh insall and went into the data base and imported my old data base into the new data base it said import is complete. then I run the key and I thought my shop was transferred. but when I brought it up there was not products it was still the fresh install.

[DrByte]

You seem to have skipped an instruction ... From FAQ: https://www.zen-cart.com/tutorials/i...hp?article=100

2. Go to your NEW host and upload (FTP) a fresh NEW install using the same version files that you built your other site on.... this will make sure that you get the proper settings in your configure.php files...
While installing, allow it to install the demo products, so that you can test and be sure that it's working nicely.
a. Install (when asked about the database-table-prefix during Database-Setup, use the same prefix that your old store uses)

You probably have a different DB_PREFIX on your new site vs your old one.
Find out your DB_PREFIX from your old site's configure.php files, and change your new site's configure.php file DB_PREFIX settings to match.
Otherwise you'll keep looking at entirely different data.

[weezee]

When I used local host in the setup I got an error it could find it, I call Godaddy and the rep said to click on the pencil and get the information from there which was: host name: p41mysql----- secureserver.net and what ever the number was it would be a different evertime you setup a data base. I don't have a prefix on my other. If you mean like /shop or /catalog or/store. I used the same data base name same password I also set it up in the in public html folder and wouldn't come up it would say page not found. I call Godaddy again the rep said it had to be install in the root. These are my two configure files on the old site. The site was given to me it was originally in another name and the host transferred it over to me using my website name.


<?php
/**
*
* @package Configuration Settings
* @copyright Copyright 2003-2006 Zen Cart Development Team
* @copyright Portions Copyright 2003 osCommerce
* @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
*/


/*************** NOTE: This file is similar, but DIFFERENT from the "admin" version of configure.php. ***********/
/*************** The 2 files should be kept separate and not used to overwrite each other. ***********/

// Define the webserver and path parameters
// HTTP_SERVER is your Main webserver: eg, http://www.bestvarietyshop.com
// HTTPS_SERVER is your Secure webserver: eg, https://www.bestvarietyshop.com
define('HTTP_SERVER', 'http://www.bestvarietyshop.com');
define('HTTPS_SERVER', 'https://www.bestvarietyshop.com');

// Use 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', '/');
define('DIR_WS_HTTPS_CATALOG', '/');

define('DIR_WS_IMAGES', 'images/');
define('DIR_WS_INCLUDES', 'includes/');
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_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/lakecoun/public_html/');

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');
define('DB_SERVER_USERNAME', '');
define('DB_SERVER_PASSWORD', '');
define('DB_DATABASE', 'lakecoun_zc2');
define('USE_PCONNECT', 'false'); // use persistent connections?
define('STORE_SESSIONS', 'db'); // use 'db' for best support, or '' for file-based storage

// 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/lakecoun/public_html/cache');

?>


<?php
//
/**
*
* @package Configuration Settings
* @copyright Copyright 2003-2006 Zen Cart Development Team
* @copyright Portions Copyright 2003 osCommerce
* @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
*/


/*************** NOTE: This file is similar, but DIFFERENT from the "store" version of configure.php. ***********/
/*************** The 2 files should be kept separate and not used to overwrite each other. ***********/

// Define the webserver and path parameters
// Main webserver: eg, http://localhost - should not be empty for productive servers
// HTTP_SERVER is your Main webserver: eg, http://www.yourdomain.com
// HTTPS_SERVER is your Secure webserver: eg, https://www.yourdomain.com
// HTTP_CATALOG_SERVER is your Main webserver: eg, http://www.yourdomain.com
// HTTPS_CATALOG_SERVER is your Secure webserver: eg, https://www.yourdomain.com
/*
* URLs for your site will be built via:
* HTTP_SERVER plus DIR_WS_ADMIN or
* HTTPS_SERVER plus DIR_WS_HTTPS_ADMIN or
* HTTP_SERVER plus DIR_WS_CATALOG or
* HTTPS_SERVER plus DIR_WS_HTTPS_CATALOG
* ...depending on your system configuration settings
*/
define('HTTP_SERVER', 'http://www.bestvarietyshop.com');
define('HTTPS_SERVER', 'https://www.bestvarietyshop.com');
define('HTTP_CATALOG_SERVER', 'http://www.bestvarietyshop.com');
define('HTTPS_CATALOG_SERVER', 'https://www.bestvarietyshop.com');

// Use secure webserver for catalog module and/or admin areas?
define('ENABLE_SSL_CATALOG', 'false');
define('ENABLE_SSL_ADMIN', '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_ADMIN', '/admin/');
define('DIR_WS_CATALOG', '/');
define('DIR_WS_HTTPS_ADMIN', '/admin/');
define('DIR_WS_HTTPS_CATALOG', '/');

define('DIR_WS_IMAGES', 'images/');
define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/');
define('DIR_WS_CATALOG_IMAGES', HTTP_CATALOG_SERVER . DIR_WS_CATALOG . 'images/');
define('DIR_WS_CATALOG_TEMPLATE', HTTP_CATALOG_SERVER . DIR_WS_CATALOG . 'includes/templates/');
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_CATALOG_LANGUAGES', HTTP_CATALOG_SERVER . DIR_WS_CATALOG . 'includes/languages/');

// * 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_ADMIN', '/home/lakecoun/public_html/admin/');
define('DIR_FS_CATALOG', '/home/lakecoun/public_html/');

define('DIR_FS_CATALOG_LANGUAGES', DIR_FS_CATALOG . 'includes/languages/');
define('DIR_FS_CATALOG_IMAGES', DIR_FS_CATALOG . 'images/');
define('DIR_FS_CATALOG_MODULES', DIR_FS_CATALOG . 'includes/modules/');
define('DIR_FS_CATALOG_TEMPLATES', DIR_FS_CATALOG . 'includes/templates/');
define('DIR_FS_BACKUP', DIR_FS_ADMIN . 'backups/');
define('DIR_FS_EMAIL_TEMPLATES', DIR_FS_CATALOG . 'email/');
define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/');

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

// 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/lakecoun/public_html/cache');

?>

[TShooters]

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

In red, this is the datebase-table-prefix that DrByte mentions. If you didn't specify this in your new install, you have duplicate tables in your datebase...one with the prefix, and one without...therefore your new install is not pointing to imported data.

[weezee]

I clear out every thing and reinstall it before I read this last post.

this time when I run the key I got this message.


1146 Table 'lakecoun_zc2.configuration' doesn't exist
in:
[select configuration_key as cfgkey, configuration_value as cfgvalue from configuration]

what do this mean.