PDA

View Full Version : Database problem with EE 1.5 beta 4 (full install)


jose_bonifacio
27th of November 2003 (Thu), 23:31
Hi, I am having some problems installing EE 1.5 beta (Full Install). After modifying the Preferences.php file to specify my database server stuff which I specify 'photogallery' as my database name, i get the an error after running the install.php. The error I got was,

'Unable to connect to the photo database at this time
PLEASE PRESS REFRESH ON YOUR BROWSER TO TRY AGAIN.

Why do you get this error? Maybe because:

The database does not exist
The database name you try to use is wrong
The database permissions for this user have been set wrong

If you get this error, a good troubleshooting action is to install phpMyAdmin at http://phpwizard.net/projects/phpMyAdmin/ (install it by editing your username and pass to config.inc.php) and when you run it you can see if there are any databases installed and what their names are. If there are no database(s) to select from, you'll need to contact the system administrator to create one for you.

(Info by Exhibit Engine)'

But the weird thing was, I tried adding a database named 'GALLERY' in MYSQL modified the Preferences.php file and run the install.php and its happy.

Does this mean that I can only specify the database name 'GALLERY' and nothing else.

Anyone has an answer to this problem?

Please advise.

Thank you.

JB..

Pekka
28th of November 2003 (Fri), 07:49
EE database connection info is in file

/ee/add/connect.php

It has lines

$servername = "localhost";
$databasename = "your_ee_database_name";
$username = "your_username";
$password = "your_password";

which you edit to suit your database info, e.g.

$servername = "localhost";
$databasename = "jose_database";
$username = "jose";
$password = "josepass";

That is EE database setup. Installer uses that info.

EE Backup uses its own configuration file /ee/input/backup/ee_backup_prefs/preferences.php where you set one or more databases

connect_menu ("localhost", "databasename", "username", "password", "100" );

filled with above dummy data it would be

connect_menu ("localhost", "jose_database", "jose", "josepass", "100" );

jose_bonifacio
28th of November 2003 (Fri), 23:48
Hi Pekka. Thank for the quick response to my post. My bad. I was changing the Preference.php file for the name of the database but not the Connect.php.

Its installed now.

Thanks a lot.

JB..