Page 2 of 4 FirstFirst 1234 LastLast
Results 11 to 20 of 36
  1. #11
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    12,492
    Plugin Contributions
    88

    Default Re: Cannot Connect Database When Upgrading from v1.5.0 to v1.5.5

    Quote Originally Posted by Allaction View Post
    PHP version 5.5.38 (Zend: 2.5.0)

    line 64: $this->link = mysqli_connect[$zf_host, $zf_user, $zf_password, $zf_database, (defined('DB_PORT') ? DB_PORT : NULL], (defined('DB_SOCKET') ? DB_SOCKET : NULL));

    Zencart v1.5.5e, does that tell you which one? I had no idea there were so many
    That line is (somehow) different than the as-shipped version; it should read:
    Code:
    $this->link = mysqli_connect[$zf_host, $zf_user, $zf_password, $zf_database, (defined('DB_PORT') ? DB_PORT : NULL), (defined('DB_SOCKET') ? DB_SOCKET : NULL));
    That change should correct your issue, although I'm pondering how the character was changed in the first place!

  2. #12
    Join Date
    Jun 2012
    Location
    Oklahoma
    Posts
    39
    Plugin Contributions
    0

    Default Re: Cannot Connect Database When Upgrading from v1.5.0 to v1.5.5

    I was able to get "Sorry! There seems to be a problem connecting to our database. Please give us a few minutes to remedy the problem. Thank you." screen instead of a blank screen when I changed the top of my configure.php files from this:

    /**
    * @package Configuration Settings
    * @copyright Copyright 2003-2016 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: Author: DrByte Thu Dec 17 11:49:31 2015 -0500 Modified in v1.5.5 $
    * @private
    */

    to this:

    /**
    * @package Configuration Settings circa 1.5.5
    * @copyright Copyright 2003-2016 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 zc_install on 2012-08-15 02:47:22
    */

    The HTTP 500 error remains for the admin page. There is something I missed somewhere and my database isn't connected. Where is the 'Apache error log?'

  3. #13
    Join Date
    Jun 2012
    Location
    Oklahoma
    Posts
    39
    Plugin Contributions
    0

    Default Re: Cannot Connect Database When Upgrading from v1.5.0 to v1.5.5

    Thank you, I corrected line 64. Now what?

  4. #14
    Join Date
    Jul 2012
    Posts
    16,734
    Plugin Contributions
    17

    Default Re: Cannot Connect Database When Upgrading from v1.5.0 to v1.5.5

    Quote Originally Posted by Allaction View Post
    Thank you, I corrected line 64. Now what?
    Check your logs directory (different than and not your apache logs) and see what the latest (most recent) myDebug file is and it's contents.

    Also, from where did you get your updated fileset? Was it a fresh install as downloaded from this website or was it some sort of auto-installer?
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...

  5. #15
    Join Date
    Jul 2012
    Posts
    16,734
    Plugin Contributions
    17

    Default Re: Cannot Connect Database When Upgrading from v1.5.0 to v1.5.5

    Quote Originally Posted by Allaction View Post
    I was able to get "Sorry! There seems to be a problem connecting to our database. Please give us a few minutes to remedy the problem. Thank you." screen instead of a blank screen when I changed the top of my configure.php files from this:

    Code:
    /**
     * @package Configuration Settings
     * @copyright Copyright 2003-2016 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: Author: DrByte  Thu Dec 17 11:49:31 2015 -0500 Modified in v1.5.5 $
     * @private
     */
    to this:

    Code:
    /**
     * @package Configuration Settings circa 1.5.5
     * @copyright Copyright 2003-2016 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 zc_install on 2012-08-15 02:47:22
     */
    The HTTP 500 error remains for the admin page. There is something I missed somewhere and my database isn't connected. Where is the 'Apache error log?'
    Sorry to say, but the change in the above comments has no effect on operation, so wouldn't have really solved anything.

    Content placed between /* and */ while within code is basically ignored by the program. It helps those individuals that read it, but it doesn't alter basic operation.
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...

  6. #16
    Join Date
    Jun 2012
    Location
    Oklahoma
    Posts
    39
    Plugin Contributions
    0

    Default Re: Cannot Connect Database When Upgrading from v1.5.0 to v1.5.5

    I downloaded the 1.5.5 from the zencart website and uploaded to the subfolder on my site. My database is a backup of my existing database that I copied and uploaded as a new database via phpMy Admin. Now there's a problem on line 62. How to I figure out what it's supposed to read? When I looked at the original download on my PC, it's the same as the error line so I don't know what to change it too.

  7. #17
    Join Date
    Jul 2012
    Posts
    16,734
    Plugin Contributions
    17

    Default Re: Cannot Connect Database When Upgrading from v1.5.0 to v1.5.5

    Quote Originally Posted by Allaction View Post
    I downloaded the 1.5.5 from the zencart website and uploaded to the subfolder on my site. My database is a backup of my existing database that I copied and uploaded as a new database via phpMy Admin. Now there's a problem on line 62. How to I figure out what it's supposed to read? When I looked at the original download on my PC, it's the same as the error line so I don't know what to change it too.
    Try checking against the github version of 1.5.5.e: https://github.com/zencart/zencart/tree/v1.5.5e
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...

  8. #18
    Join Date
    Jul 2012
    Posts
    16,734
    Plugin Contributions
    17

    Default Re: Cannot Connect Database When Upgrading from v1.5.0 to v1.5.5

    Also when was the download performed (if download itself came with bad information that data point would help the core group possibly track down an issue). Please include some correlation of timezone and time if able (should show the download time as the date the file was saved to your computer and you know what timezone you are in and can maybe base it off of GMT if so desired.)
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...

  9. #19
    Join Date
    Jun 2012
    Location
    Oklahoma
    Posts
    39
    Plugin Contributions
    0

    Default Re: Cannot Connect Database When Upgrading from v1.5.0 to v1.5.5

    Thank you, that was helpful, but the line is still the same so I don't see an error. I still have the database connection problem. Where else can I check for errors?

  10. #20
    Join Date
    Jun 2012
    Location
    Oklahoma
    Posts
    39
    Plugin Contributions
    0

    Default Re: Cannot Connect Database When Upgrading from v1.5.0 to v1.5.5

    zen-cart-v1.5.5e-03082017

    created: ‎Thursday, ‎April ‎13, ‎2017, ‏‎3:06:56 PM CST

 

 
Page 2 of 4 FirstFirst 1234 LastLast

Similar Threads

  1. v153 Database errors when upgrading from 1.5.3 to the latest 1.5.5a
    By icecold in forum Upgrading to 1.5.x
    Replies: 3
    Last Post: 14 Oct 2016, 04:13 PM
  2. v138a Cannot connect to database
    By blueroomhermit in forum General Questions
    Replies: 10
    Last Post: 17 Nov 2013, 03:43 AM
  3. blank page when upgrading the database from 1.3.8a to 1.3.8h
    By dragosionel in forum Upgrading from 1.3.x to 1.3.9
    Replies: 1
    Last Post: 20 Oct 2011, 05:36 PM
  4. 1064 SQL Syntax error when upgrading database from 1.3.8 to 1.3.9
    By pioupioun in forum Upgrading from 1.3.x to 1.3.9
    Replies: 5
    Last Post: 23 Aug 2010, 06:26 AM
  5. Cannot Connect To Database...
    By kbalona in forum General Questions
    Replies: 2
    Last Post: 3 May 2007, 07:41 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