Page 2 of 2 FirstFirst 12
Results 11 to 14 of 14
  1. #11
    Join Date
    Dec 2010
    Posts
    13
    Plugin Contributions
    0

    Default Re: Upgrading database.

    Thanks. This is my includes/configure.php

    <?php
    /**
    * @package Configuration Settings circa 1.3.8
    * @copyright Copyright 2003-2007 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.yourdomain.com
    // HTTPS_SERVER is your Secure webserver: eg, https://www.yourdomain.com
    define('HTTP_SERVER', 'http://mywebsite.co.uk');
    define('HTTPS_SERVER', 'https://mywebsite.co.uk');

    // 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/bswccouk/public_html/mywebsite.co.uk/');

    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', 'bswccouk_zc1');
    define('DB_SERVER_PASSWORD', 'XXXXXXXXXXXX');
    define('DB_DATABASE', 'bswccouk_zc1');
    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/bswccouk/public_html/mywebsite.co.uk/cache');

    // EOF
    I changed the password to XXXXs in this posting but it does actually have a password in there:

    define('DB_SERVER_PASSWORD', 'XXXXXXXXXXXX');

    I have also removed my website domain.



    This is my admin/includes/configure.php

    <?php

    /**

    * dist-configure.php

    *

    * @package Configuration Settings

    * @package Admin

    * @copyright Copyright 2003-2007 Zen Cart Development Team

    * @copyright Portions Copyright 2003 osCommerce

    * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0

    * @version $Id: dist-configure.php 6329 2007-05-16 15:36:56Z drbyte $

    * @private

    */



    // Define the webserver and path parameters

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

    /*

    * URL's 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

    *

    * If you desire your *entire* admin to be SSL-protected, make sure you use a "https:" URL for all 4 of the following:

    */

    define('HTTP_SERVER', 'http://localhost');

    define('HTTPS_SERVER', 'https://localhost');

    define('HTTP_CATALOG_SERVER', 'http://localhost');

    define('HTTPS_CATALOG_SERVER', 'https://localhost');



    // 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', '/admin/');

    define('DIR_FS_CATALOG', '/');



    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', 'root');

    define('DB_SERVER_PASSWORD', '');

    define('DB_DATABASE', '');

    define('USE_PCONNECT', 'false');

    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', 'none');

    define('DIR_FS_SQL_CACHE', '/enter/your/path/to/public_html_or_htdocs/and/zencart/here/zen/cache');



    ?>

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

    Default Re: Upgrading database.

    I meant that you need to compare the entries!!!!

    These are some that do not match but you need to check them all

    Store = black
    admin = green

    Code:
    define('HTTP_SERVER', 'http://scottishphotographs.co.uk');
    define('HTTPS_SERVER', 'https://scottishphotographs.co.uk');
    
    define('HTTP_SERVER', 'http://localhost');
    define('HTTPS_SERVER', 'https://localhost');
    
    define('DIR_FS_CATALOG', '/home/bswccouk/public_html/scottishphotographs.co.uk/');
    define('DIR_FS_CATALOG', '/');
    
    Admin only
    //the following path is a COMPLETE path to your Zen Cart files. eg: /var/www/vhost/accountname/public_html/store/
    
    define('DIR_FS_ADMIN', '/admin/');
    This is not the COMPLETE PATH
    
    
    define('DB_SERVER_USERNAME', 'bswccouk_zc1');
    define('DB_SERVER_USERNAME', 'root');
    
    
    define('DB_DATABASE', 'bswccouk_zc1');
    define('DB_DATABASE', '');
    
    
    define('SQL_CACHE_METHOD', 'database');
    define('SQL_CACHE_METHOD', 'none');
    
    
    define('DIR_FS_SQL_CACHE', '/home/bswccouk/public_html/scottishphotographs.co.uk/cache');
    Missing
    Zen-Venom Get Bitten

  3. #13
    Join Date
    Dec 2010
    Posts
    13
    Plugin Contributions
    0

    Default Re: Upgrading database.

    Right, thanks. Will do!

    Thanks.

  4. #14
    Join Date
    Dec 2010
    Posts
    13
    Plugin Contributions
    0

    Default Re: Upgrading database.

    Quote Originally Posted by kobra View Post
    I meant that you need to compare the entries!!!!
    THANK YOU It works!

    I have a few other things to sort but I am happy to get the shop up and running, and to be able to access the admin section.

    Thank you again

 

 
Page 2 of 2 FirstFirst 12

Similar Threads

  1. v154 Upgrading database
    By kalastaja in forum Upgrading to 1.5.x
    Replies: 17
    Last Post: 29 Jan 2016, 08:34 PM
  2. upgrading database
    By skelly100 in forum Upgrading to 1.5.x
    Replies: 9
    Last Post: 14 Feb 2012, 06:50 AM
  3. upgrading database questions
    By fusionsp in forum Upgrading from 1.3.x to 1.3.9
    Replies: 19
    Last Post: 14 Jun 2010, 06:29 PM
  4. Trouble upgrading database
    By gift-taggs in forum Upgrading from 1.3.x to 1.3.9
    Replies: 1
    Last Post: 20 Apr 2008, 04:11 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