Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2007
    Location
    Vancouver, Canada
    Posts
    1,547
    Plugin Contributions
    81

    Default Cannot Connect to Database on Fresh 1.5.4 Install

    After debugging, it was found that the newly created database needed to have the collation set to utf8 in order for the database username and password to be accepted. This isn't mentioned in the documentation and doesn't appear to be identified by the installer.

  2. #2
    Join Date
    Jan 2004
    Posts
    66,373
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: Cannot Connect to Database on Fresh 1.5.4 Install

    I can't replicate this problem.

    This is what I tried:
    1. Create a new database with default character set of latin1, and collation latin1_general_ci
    2. Run zc_install and choose Install, provide database name, username, password
    3. Install ran fine.

    Tested against MySQL 5.5.27, PHP 5.6, 5.5, 5.4.

    What did you do differently? What exact steps must I take to recreate your symptoms?


    Quote Originally Posted by numinix View Post
    This isn't mentioned in the documentation and doesn't appear to be identified by the installer.
    That isn't formally a requirement. There's nothing technically in the code that requires UTF-8, although it's highly recommended.
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

 

 

Similar Threads

  1. v138a Cannot connect to database
    By blueroomhermit in forum General Questions
    Replies: 10
    Last Post: 17 Nov 2013, 03:43 AM
  2. Cannot connect to database
    By pontiacg5 in forum Installing on a Linux/Unix Server
    Replies: 5
    Last Post: 12 Jul 2010, 03:00 PM
  3. Cannot connect to database
    By actorxfactor in forum Installing on a Linux/Unix Server
    Replies: 7
    Last Post: 18 Sep 2007, 10:05 PM
  4. Cannot Connect To Database...
    By kbalona in forum General Questions
    Replies: 2
    Last Post: 3 May 2007, 07:41 PM
  5. cannot connect to database
    By east coast in forum General Questions
    Replies: 1
    Last Post: 23 May 2006, 04:42 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