The "site unavailable" error occurs when PhpGedView can't access the database. The database connection parameters configured into PGV are wrong.
There are two ways to proceed:
1. Edit the existing "config.php" file that's in the server directory where PhpGedView is installed. You would download that file using your favourite FTP client, edit the file on your local PC using any suitable text editor such as Notepad, and then upload the modified file back to the server. Be sure to save that file as an ASCII text file. UTF-8 coding is NOT acceptable.
2. Replace the existing "config.php" file with a fresh copy from the set of files that you used to originally install PGV. Be sure to set the permissions on that file to 777 so that you can set up the PGV configuration properly once you launch PGV.
Approach (1) should get you going right away.
Approach (2), which is the preferred method, will launch the Setup wizard when you next launch PGV. Just go through the configuration steps, remembering to click the "Next" button at each stage, so that your configuration will be saved properly. When you're asked to log in, just use the previously defined admin userid.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
This is quite old, but I find I have the same error "Site is currently unavailable", but the two proposals do not correct my issue.
I looked at the config.php, jumped over to phpMyAdmin and entered the same credentials from config.php. phpMyAdmin logged me in and the database and details were visible.
I put a "clean" config.php in place (from config.dist). I was greeted with the installation wizard and Step 1 - Check Environment passed. Step 2 was a bit different result after entering credentials -
Your current database configuration is bad. Please check your database connection parameters and configure again.
SQLSTATE[HY000][2002] No such file or directory
I cannot find this text in the php source (or I didn't find the right file to open). I see that the SQLSTATE message comes from mysql.
What changed since it last worked?
I did update my php install to 7.3 from 7.0. I reverted to 7.0 and it works.
v7.2 generates:
Fatal error: Uncaught PDOException: No Connection Established in /volume1/web/gen/includes/classes/class_pgv_db.php:717 Stack trace:
'#0 /volume1/web/gen/includes/functions/functions_db.php(2632): PGV_DB::prepare('SELECT setting_...')
'#1 /volume1/web/gen/includes/session.php(545): get_user_setting('1', 'language')
'#2 /volume1/web/gen/config.php(89): require_once('/volume1/web/ge...')
'#3 /volume1/web/gen/index.php(35): require('/volume1/web/ge...')
'#4 {main} thrown in /volume1/web/gen/includes/classes/class_pgv_db.php on line 717
v7.3 reverses the stack dump but ends in the same line - PGV_DB::prepare
function get_user_setting($user_id, $setting_name) {
global $TBLPREFIX;
returnPGV_DB::prepare("SELECT setting_value FROM {$TBLPREFIX}user_setting WHERE user_id=? AND setting_name=?")->execute(array($user_id, $setting_name))->fetchOne();
}
I have backed down to 7.0, but as I recall there are features/security updates in 7.3 that are compelling.
Last edit: David Smart 2020-02-26
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
It looks as if you have a configuration problem with your PHP 7.3 installation.
The error, detected on line 716 of install.php, suggests a PDO problem.
Unfortunately, anything having to do with installing PHP on a server is Greek to me. I suggest you compare your PHP 7.0 and PHP 7.3 configurations. Perhaps PDO support is not set up properly?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
My pgv website now shows the pgv login page but with the message "Site is currently unavailable"
The server is working fine, I can access all the files and examine the database through phpmyadmin.
1) Is there a way to fix this problem?
or
2) Can a gedcom file be generated without having access to the pgv pages?
The "site unavailable" error occurs when PhpGedView can't access the database. The database connection parameters configured into PGV are wrong.
There are two ways to proceed:
1. Edit the existing "config.php" file that's in the server directory where PhpGedView is installed. You would download that file using your favourite FTP client, edit the file on your local PC using any suitable text editor such as Notepad, and then upload the modified file back to the server. Be sure to save that file as an ASCII text file. UTF-8 coding is NOT acceptable.
2. Replace the existing "config.php" file with a fresh copy from the set of files that you used to originally install PGV. Be sure to set the permissions on that file to 777 so that you can set up the PGV configuration properly once you launch PGV.
Approach (1) should get you going right away.
Approach (2), which is the preferred method, will launch the Setup wizard when you next launch PGV. Just go through the configuration steps, remembering to click the "Next" button at each stage, so that your configuration will be saved properly. When you're asked to log in, just use the previously defined admin userid.
Gerry,
Thanks very much!
I now have access to my pgv
Bill
Yes. Thank you. Approach 1 fixed my situation too. I had to update the mySQL password.
This is quite old, but I find I have the same error "Site is currently unavailable", but the two proposals do not correct my issue.
I looked at the config.php, jumped over to phpMyAdmin and entered the same credentials from config.php. phpMyAdmin logged me in and the database and details were visible.
I put a "clean" config.php in place (from config.dist). I was greeted with the installation wizard and Step 1 - Check Environment passed. Step 2 was a bit different result after entering credentials -
Your current database configuration is bad. Please check your database connection parameters and configure again.
SQLSTATE[HY000] [2002] No such file or directory
I cannot find this text in the php source (or I didn't find the right file to open). I see that the SQLSTATE message comes from mysql.
What changed since it last worked?
I did update my php install to 7.3 from 7.0. I reverted to 7.0 and it works.
v7.2 generates:
Fatal error: Uncaught PDOException: No Connection Established in /volume1/web/gen/includes/classes/class_pgv_db.php:717 Stack trace:
'#0 /volume1/web/gen/includes/functions/functions_db.php(2632): PGV_DB::prepare('SELECT setting_...')
'#1 /volume1/web/gen/includes/session.php(545): get_user_setting('1', 'language')
'#2 /volume1/web/gen/config.php(89): require_once('/volume1/web/ge...')
'#3 /volume1/web/gen/index.php(35): require('/volume1/web/ge...')
'#4 {main} thrown in /volume1/web/gen/includes/classes/class_pgv_db.php on line 717
v7.3 reverses the stack dump but ends in the same line - PGV_DB::prepare
function get_user_setting($user_id, $setting_name) {
global $TBLPREFIX;
}
I have backed down to 7.0, but as I recall there are features/security updates in 7.3 that are compelling.
Last edit: David Smart 2020-02-26
It looks as if you have a configuration problem with your PHP 7.3 installation.
The error, detected on line 716 of install.php, suggests a PDO problem.
Unfortunately, anything having to do with installing PHP on a server is Greek to me. I suggest you compare your PHP 7.0 and PHP 7.3 configurations. Perhaps PDO support is not set up properly?