Page 2 of 3 FirstFirst 123 LastLast
Results 11 to 20 of 30
  1. #11
    Join Date
    Oct 2008
    Location
    Croatia
    Posts
    1,724
    Plugin Contributions
    21

    Default Re: upgrading from 1.5.5e to 2.10

    You say that you used the database mysql wizard. Did it assign a privileged user to your database? Go to cPanel -> Manage My Databases and see if there's a user assigned to your new database. If not, assign it and give it all privileges.

    Only the frontend configure.php file is relevant for the upgrade, but it's a good idea to keep them in sync.

    Check your includes/configure.php and make sure your database user and password are valid and allowed to access the database to which you imported the old one. So, you had to create the new database, then create a user, then assign the user to that database and set its privileges. That user and that password must be in your includes/configure.php file. If not, you don't get the upgrade button and will be prompted to enter database user/password for a fresh install.

  2. #12
    Join Date
    Apr 2025
    Location
    NC
    Posts
    29
    Plugin Contributions
    0

    Default Re: upgrading from 1.5.5e to 2.10

    Quote Originally Posted by balihr View Post
    You say that you used the database mysql wizard. Did it assign a privileged user to your database? Go to cPanel -> Manage My Databases and see if there's a user assigned to your new database. If not, assign it and give it all privileges.

    Only the frontend configure.php file is relevant for the upgrade, but it's a good idea to keep them in sync.

    Check your includes/configure.php and make sure your database user and password are valid and allowed to access the database to which you imported the old one. So, you had to create the new database, then create a user, then assign the user to that database and set its privileges. That user and that password must be in your includes/configure.php file. If not, you don't get the upgrade button and will be prompted to enter database user/password for a fresh install.
    Yes the Database user set up user with full privileges. The user, database, and password are in both configure.php files.

    When I go to install it the page comes up with a clean install only. And says..............
    An existing configure.php file was found, indicating a pre-existing installation. You may upgrade using the button below (if there is no Upgrade button, perhaps your DB_PREFIX does not match the database?

    The DB_PREFIX is blank but I have tried to put my account name 'mydomain_' as the prefix. That did not work. The old ZC files (1.5.5e) were blank and worked for years that way.

    'mydomain_DB'
    'mydomain_UserName'
    'PW'
    Is all like it is suppose to be. The user has been created with full privileges assigned to the database.

  3. #13
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    10,476
    Plugin Contributions
    126

    Default Re: upgrading from 1.5.5e to 2.10

    Post the 155e includes/configure.php file but blank out DB_PASSWORD.
    That Software Guy. My Store: Zen Cart Support
    Available for hire - See my ad in Services
    Plugin Moderator, Documentation Curator, Chief Cook and Bottle-Washer.
    Do you benefit from Zen Cart? Then please support the project.

  4. #14
    Join Date
    Nov 2005
    Location
    los angeles
    Posts
    2,894
    Plugin Contributions
    13

    Default Re: upgrading from 1.5.5e to 2.10

    Quote Originally Posted by Dan4store View Post
    Yes the Database user set up user with full privileges. The user, database, and password are in both configure.php files.

    When I go to install it the page comes up with a clean install only. And says..............
    An existing configure.php file was found, indicating a pre-existing installation. You may upgrade using the button below (if there is no Upgrade button, perhaps your DB_PREFIX does not match the database?

    The DB_PREFIX is blank but I have tried to put my account name 'mydomain_' as the prefix. That did not work. The old ZC files (1.5.5e) were blank and worked for years that way.

    'mydomain_DB'
    'mydomain_UserName'
    'PW'
    Is all like it is suppose to be. The user has been created with full privileges assigned to the database.
    if the existing configure has a blank prefix and that works, then it should remain as a blank prefix.

    do you have a file here:

    includes/local/configure.php;

    if so, that could be your problem.

    i would also examine your configure file. check that it has:

    PHP Code:
    define('SESSION_STORAGE''temporary value added by zc_install'); 
    somewhere inside of it. if that is not there, that could also be the cause of your distress...

    best.
    author of square Webpay.
    mxWorks now has Apple Pay and Google Pay. donations: venmo or paypal accepted.
    premium consistent excellent support. available for hire.

  5. #15
    Join Date
    Apr 2025
    Location
    NC
    Posts
    29
    Plugin Contributions
    0

    Default Re: upgrading from 1.5.5e to 2.10

    Quote Originally Posted by swguy View Post
    Post the 155e includes/configure.php file but blank out DB_PASSWORD.
    <?php
    /**
    * @copyright Copyright 2003-2024 Zen Cart Development Team
    * @copyright Portions Copyright 2003 osCommerce
    * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
    * File Built by Zen Cart Installer on Sun Feb 15 2026 21:27:39
    */


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

    /**
    * Enter the domain for your Admin URL. If you have SSL, enter the correct https address in the HTTP_SERVER setting, instead of just an http address.
    */
    define('HTTP_SERVER', 'https://led4rv.com');
    /**
    * Note about HTTPS_SERVER:
    * There is no longer an HTTPS_SERVER setting for the Admin. Instead, put your SSL URL in the HTTP_SERVER setting above.
    */

    /**
    * Note about DIR_WS_ADMIN
    * The DIR_WS_ADMIN value is now auto-detected.
    * In the rare case where it cannot be detected properly, you can add your own DIR_WS_ADMIN definition below.
    */

    /**
    * Enter the domain for your storefront URL.
    * Enter a separate SSL URL in HTTPS_CATALOG_SERVER if your store supports SSL.
    */
    define('HTTP_CATALOG_SERVER', 'https://led4rv.com');
    define('HTTPS_CATALOG_SERVER', 'https://led4rv.com');

    /**
    * Do you use SSL for your customers login/checkout on the storefront? If so, enter 'true'. Else 'false'.
    */
    define('ENABLE_SSL_CATALOG', 'true');

    /**
    * These DIR_WS_xxxx values refer to the name of any subdirectory in which your store is located.
    * These values get added to the HTTP_CATALOG_SERVER and HTTPS_CATALOG_SERVER values to form the complete URLs to your storefront.
    * They should always start and end with a slash ... ie: '/' or '/foldername/'
    */
    define('DIR_WS_CATALOG', '/catalog2/');
    define('DIR_WS_HTTPS_CATALOG', '/catalog2/');

    /**
    * This is the complete physical path to your store's files. eg: /var/www/vhost/accountname/public_html/store/
    * Should have a closing / on it.
    */
    define('DIR_FS_CATALOG', '/home3/ledfourv/public_html/catalog2/');

    /**
    * NOTE about DIR_FS_ADMIN
    * The value for DIR_FS_ADMIN is now auto-detected.
    * In the very rare case where there is a need to override the autodetection, simply add your own definition for it below.
    */

    /**
    * The following settings define your database connection.
    * These must be the SAME as you're using in your non-admin copy of configure.php
    */
    define('DB_TYPE', 'mysql'); // always 'mysql'
    define('DB_PREFIX', ' '); // prefix for database table names -- preferred to be left empty
    define('DB_CHARSET', 'utf8mb4'); // 'utf8mb4' required. If using older 'utf8' or 'latin1', convert your database to utf8mb4. See conversion util in docs site.
    define('DB_SERVER', 'localhost'); // address of your db server
    define('DB_SERVER_USERNAME', 'ledfourv_flow5');
    define('DB_SERVER_PASSWORD', 'PWXXXXX');
    define('DB_DATABASE', 'ledfourv_z2105');

    /**
    * This is an advanced setting to determine whether you want to cache SQL queries.
    * Options are 'none' (which is the default) and 'file' and 'database'.
    */
    define('SQL_CACHE_METHOD', 'none');

    /**
    * Reserved for future use
    */
    define('SESSION_STORAGE', 'reserved for future use');

    /**
    * Advanced use only:
    * The following are OPTIONAL, and should NOT be set unless you intend to change their normal use. Most sites will leave these untouched.
    * To use them, uncomment AND add a proper defined value to them.
    */
    // define('DIR_FS_SQL_CACHE' ...
    // define('DIR_FS_DOWNLOAD' ...
    // define('DIR_FS_LOGS' ...

    // End Of File

  6. #16
    Join Date
    Apr 2025
    Location
    NC
    Posts
    29
    Plugin Contributions
    0

    Default Re: upgrading from 1.5.5e to 2.10

    Quote Originally Posted by carlwhat View Post
    if the existing configure has a blank prefix and that works, then it should remain as a blank prefix.

    do you have a file here:

    includes/local/configure.php;

    if so, that could be your problem.

    i would also examine your configure file. check that it has:

    PHP Code:
    define('SESSION_STORAGE''temporary value added by zc_install'); 
    somewhere inside of it. if that is not there, that could also be the cause of your distress...

    best.
    There is no local dir under includes but there is one in the admin under includes. All that is in there is a file "skip_version_check.ini"

    It says define('SESSION_STORAGE', 'reserved for future use'); in both of the configure files

  7. #17
    Join Date
    Oct 2008
    Location
    Croatia
    Posts
    1,724
    Plugin Contributions
    21

    Default Re: upgrading from 1.5.5e to 2.10

    Quote Originally Posted by Dan4store View Post
    define('DB_PREFIX', ' '); // prefix for database table names -- preferred to be left empty
    DB_PREFIX is a space?! Would that really create tables with a space prefix? For example ' address_book'?

  8. #18
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    10,476
    Plugin Contributions
    126

    Default Re: upgrading from 1.5.5e to 2.10

    Agreed - this looks odd. Please change to

    define('DB_PREFIX', '');

    No space - just one quote and then the next quote.
    That Software Guy. My Store: Zen Cart Support
    Available for hire - See my ad in Services
    Plugin Moderator, Documentation Curator, Chief Cook and Bottle-Washer.
    Do you benefit from Zen Cart? Then please support the project.

  9. #19
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    10,476
    Plugin Contributions
    126

    Default Re: upgrading from 1.5.5e to 2.10

    If you open ledfourv_flow5 in phpMyAdmin, do you see "address_book" as the first table?
    That Software Guy. My Store: Zen Cart Support
    Available for hire - See my ad in Services
    Plugin Moderator, Documentation Curator, Chief Cook and Bottle-Washer.
    Do you benefit from Zen Cart? Then please support the project.

  10. #20
    Join Date
    Apr 2025
    Location
    NC
    Posts
    29
    Plugin Contributions
    0

    Default Re: upgrading from 1.5.5e to 2.10

    Quote Originally Posted by swguy View Post
    Agreed - this looks odd. Please change to

    define('DB_PREFIX', '');

    No space - just one quote and then the next quote.
    I did it in both, still not upgrade button

 

 
Page 2 of 3 FirstFirst 123 LastLast

Similar Threads

  1. v154 Chinese Language from Database Garbled after upgrading from v137
    By haostaff in forum Upgrading to 1.5.x
    Replies: 2
    Last Post: 21 May 2015, 04:01 AM
  2. Replies: 7
    Last Post: 26 Feb 2013, 09:53 PM
  3. error when trying to email gv from admin, after upgrading from 1.3.7
    By redheads in forum Discounts/Coupons, Gift Certificates, Newsletters, Ads
    Replies: 2
    Last Post: 14 Oct 2009, 06:23 AM
  4. Replies: 3
    Last Post: 19 Jun 2008, 12:44 AM

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