Data Base Issues - not connected - during install

[hbtechguy]

Thanks Chuckl,

yes i've copy and paste the User name and passwords, so i dont think it's cap issues with numbers and letters... i just dont understand why the phpbb is easy to install than ZC, phpbb connects to the db quite with ease, but ZC hesitate to connect to the db...

thanks guys for trying to help me, i hope we will get to the bottom of this..

[DrByte]

What's most odd is that Zen Cart *does* connect to the database to verify username/password/database long before it starts running SQL commands on it. It seems that its second attempt to open the database is failing fatally for unexplained reasons.

[DrByte]

Okay ... there's one spot in the installer where it checks to be sure that the requested database name actually exists ... and after it's done checking, doesn't close the database connection.

Thus, since your hosting account strictly enforces a single connection, it's denying you access.

If you're going to have multiple customers hitting your site, you're going to need to be able to connect to the database multiple times simultaneously. You'll need to get your hosting company to relax your restrictions.


The one-line fix to deal with the error message from the first post is this:
/zc_install/includes/classes/installer.php
Add the close() on line 182:

    function dbExists($zp_create, $zp_type, $zp_host, $zp_username, $zp_pass, $zp_name, $zp_error_text, $zp_error_code) {
      //    echo $zp_create;
      if ($zp_create != 'true' && $this->error == false) {
        if ($zp_type == 'mysql') {
          @mysql_connect($zp_host, $zp_username, $zp_pass);
          if (@mysql_select_db($zp_name) == false) {
            $this->setError($zp_error_text.'<br />'.@mysql_error(), $zp_error_code, true);
          }
          @mysql_close();
        }
      }
    }

[DrByte]

You're also getting an error in your footer like this:

0 Error - Could not connect to Database
in:
[select count(*) as total from sessions where sesskey ='...blahblah.......']

This is caused by the same kind of problem. There are 3 workarounds:
a) increase database connection count
b) use 'file' for the session storage instead of database (choice during installation)
c) use an older version of PHP (due to a PHP5.2 quirk), or rewrite the session handler code

The first is easiest.

[hbtechguy]

Thank you soo much DrByte,.. you are a true Zen Cart Sensei Master...

wow...also thankyou everybody who tried to help...

now i can try to get my store up and running....

just that simple diagnosed by DrByte make wonders!

[puggy]

1062 Duplicate entry '' for key 2
in:
[insert into phpbb_users (user_id, username, user_password, user_email, user_regdate) values ('84', 'PoserUnd', 'f7370f89b8fa54a405a6ebd63b477eaf', '[email protected]', '1190907431')]

This is what I get when a new customer signs up.