Data Base Issues - not connected - during install

[yellow1912]

Let me know if things go well this time.

[yellow1912]

You can also do this:
Create a file name test.php with the content:

<?php
    $connection = mysql_connect("servername","username","password");

    if (!$connection) 
        echo "Couldn't make a connection!"; 
        else
echo "Connected to database";
?>

Replace the servername, username, password with the info you have.
Then access this file on your browser (yoursite.com/test.php), see how it goes.

[hbtechguy]

yes that test.php works, it connects to my database fine, i think it's ZC not working, maybe i uploaded it wrong, now i'm using cuteftp to up load these files.
what software you use to connect to ftp server?

[yellow1912]

I use cuteftp as well, nice proggie.

[hbtechguy]

yellow1912, one question, could you please post me how u install your ZC,

i uploaded the files again. still i can't connect this database to the host server with all info given by the provider

if this not going to work, i may have to give up...

[Chuckl]

It might be worthwhile asking your provider what permissions/priviledges you have on that supposed MySql 4 database.

Does your control panel have phpMyAdmin available, or some method of viewing the database? If so, use that and see if that can connect.

[hbtechguy]

thanks Chuckl, i do have access to mysql4 , i can log onto phpmyadmin i can manually add the sql database. Seems to be something to do with ZC. i'll downloaded phpbb and install into a different dir, and see if it connects to mysql, and it did, so there has to be a bug in this ZC... must be me.... so sad..

i really want to use this ZC website.... please any other suggestions i can try,

thankyou guys for replying...

is there an older version, and i try upgrading that way..

[DrByte]

0 Install Error: Could not connect to the Database
in:
[DROP TABLE IF EXISTS upgrade_exceptions;]

Are you always getting the *same* error message ?

[Chuckl]

When you connect using phpMyAdmin, is that as the same user and password as used in the ZC install you are attempting?
Likewise the PHPBB install.
If not, try that on the install.

What I'm trying to get clear in my mind is what is causing this pretty fundamental error. There are thousands of Zen Cart sites all over the world connecting to MySQL 4 databases every day. Coupled with the fact that the upgrade_exceptions table DROP TABLE IF EXISTS is the first SQL statement executed by the db installer that attempts to do anthing with the database. (I'm discounting existence checks etc, this is actually altering the database).

That said, I'm left with a probable cause of insufficient priviledges/permissions, or wrong username/password. Another possibility is attempting to access a remote MySQL server without remote access being enabled. I'm not sure that the error message is necessarily accurate beyond 'something went wrong', but it certainly indicates a problem.
Another one thats caught me before is usernames and passwords that contain ones (1) and ells(l), and ohs (O) and zeroes (0). In courier fonts they can be interesting.

My response would be to use MySQL 5, but then I've used nothing else since about version 1.2.7, so I'm probably biased.

[hbtechguy]

Hi Drbyte,

Yes every time i try install ZC database section always same error message.