Home› General support

Header error & Cannot connect to database

tessa Member
in General support
Hi,

I get this error message after installing the latest version. I did not have the old version so it was not an upgrade. I'm using MySQLv4.1.21 on MAX OSX10.3.9. Appreciate any advice. I've checked the username & pwd in zp-config and its the same as the sql database. Not sure what to do with .htaccess but I did rename the path to "RewriteBase /familyalbum/zenphoto"

*******error msg begins**********

MySQL Error: Could not connect to the database server.

Warning: Cannot modify header information - headers already sent by (output started at /Library/WebServer/Documents/familyalbum/zenphoto/zen/functions-db.php:19) in /Library/WebServer/Documents/familyalbum/zenphoto/zen/auth_zp.php on line 30

Warning: Cannot modify header information - headers already sent by (output started at /Library/WebServer/Documents/familyalbum/zenphoto/zen/functions-db.php:19) in /Library/WebServer/Documents/familyalbum/zenphoto/zen/auth_zp.php on line 31
zenphoto setup
MySQL Error: Could not connect to the database server.
database not connected

Check the zp-config.php file to make sure you've got the right username, password, host, and database. If you haven't created the database yet, now would be a good time.

Comments

  • carasmo Member
    Does your host create databases with your username and underscore?

    Usually it's

    domainname_databasename

    domainname_username

    So check that it's the full name of the database and user name

    Do you have phpMyAdmin? You can check it there and also check your server error log to get more specific information.

    I wish I could help you further. See what others have to say.
  • trisweb Administrator
    Well it's definitely not .htaccess... it's the database connection for sure with that error.

    One thing I can think of, are you using MySQL 5? Somewhere along the line they changed the way passwords are stored, and there might be an incompatibility with the PHP MySQL library and the MySQL version.

    Other than that, are you sure the DB server is started? Did you create the database? SURE you have the right user/pass? Sure the database is running on the same system as PHP (should be with MAX)? There's a lot that could happen, but it's somewhere in that connection.

    Do you have other apps that use the database on that server? Can you check their configurations and see how they connect successfully (if they do..)?
Sign In or Register to comment.