Home› General support

MySQL Setup Issues

Sixth.Gear Member
in General support
I'm currently working on switching hosts, and transferring everything between the two servers. I was able to get zenphoto transferred over, but run into a small snag.

I ran the install script to make sure that database could be connected to, and also upgraded to 1.2.1. Setup was able to connect to the database fine, read all the tables, added the new ones for 1.2.1 etc etc. I'm able to navigate to the admin page, and view all the gallery and sub-galleries, modify titles etc.

The problem comes when I try to load the actual gallery. I get the

"
Zenphoto Error
MySQL Error: Zenphoto could not connect to the database server.Check your zp-config.php file for the correct host, user name, and password.Note that you may need to change the host from localhost if your web server uses a separate MySQL server, which is common in large shared hosting environments like Dreamhost and GoDaddy.Also make sure the server is running, if you control it.
"
What could be the problem since setup is able to connect to the database?

Comments

  • darrellm Member
    It looks like you don't have the correct path. Check your zp-config.php and make sure you have the correct path. Make sure you have the correct username and password to MySQL when you created it.
  • Sixth.Gear Member
    The problem is that setup can initialize the tables, which means that it is reading the right mySQL username and database. For some reason the core of the website can't connect to the database.

    What path would be wrong? There are several different paths that can be set within the zp-config.php.

    Edit: Seems like it some something with the old version of the database having some sort of configuration issue with it from the old server. Just did a new install, but have to re-set all of my settings :(
Sign In or Register to comment.