Hi,
I have a problem with displaying the blocks on the main page and on mygedview portal. Sometimes, everything loads as it should (very rare) but more often it loads two or three blocks, the others are displayed as „site is currently unavailable, „instalation wizard” or login site (look at the attached screenshots). I don't know what's the problem, first I thought that this was PHP execution time, but the site generates in less than 10 seconds and the max execution time is set to 30 seconds. What else should I check?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Anonymous
-
2010-01-28
I agree there is something very strange about your site. What version of PGV is it?
Is it a new install, and how long has it had this problem?
It is possible that your GEDCOM data is corrupt. Try running "Check" against it (from GEDCPM Configuration page). Leep it set to "Critical" errors only, and see if that reports any issues.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
It's PGV 4.2.3, problem exists since the installation, it is new installation not an upgrade. I am a newbie with PGV :-)
And no there is no critical errors, there are only "errors" with gedcom tags "ADDR", "CEME".
oh well, i will try to reinstall PGV, maybe it helps :-)
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Anonymous
-
2010-01-28
I wouldn't rush into re-installing. Now that we have eliminated GEDCOM errors, it is more likely to be a server of configuration problem. Can you answer a few more questions:
1 - What are the details of your set up (PHP, MYSQL, version numbers etc. )?
2 - What are you memory settings, time-out limits etc?
2 - What are you config settings (you can post the relevant parts of config.php here - but blank out user names, passwords etc first).
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Anonymous
-
2010-01-28
I just had nother look at your site, and tried to go to the Individual Lists. It threw this error, whcich gives a big clue to the likely problem:
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE: Syntax error or access violation: 1253 COLLATION 'utf8_unicode_ci' is not valid for CHARACTER SET 'latin1''
It looks like you have inconsistent collations on your database, . You might even have set "Use the database to provide UTF-8 collation" in Database set up AFTER you had created the tables. (The help screen there specifically says don't do that.
To correct it go to this patch, and follow the instructions VERY CAREFULLY, after taking backups of everything first:
PHP ver 5.2.12 but i also tried on ver 5.3.1
MYSQL Server version: 5.0.88-log, Protocol version: 10, MySQL charset: UTF-8 Unicode (utf8) , MySQL connection collation: utf8_unicode_ci
memory limit: local value 32M, master value 64M
mysql.connect_timeout: local and master 60
max_execution_time:local and master 30
max_file_uploads: local and master 20
max_input_nesting_level: local and master 64
max_input_time: local and master -1
post_max_size:local and master 32M
realpath_cache_size: local and master 16K
realpath_cache_ttl: local and master 120
config.php:
if (preg_match('/\Wconfig.php/', $_SERVER)>0) {
print 'Got your hand caught in the cookie jar.';
exit;
}
wait, cause when i was checking the settings of the MySQL i saw that "collation thing" (i am unfamiliar with PHP and MySQL, but i'm working on it :-) ) and i've changed the settings in PGV - old settings was $DB_UTF8_COLLATION=false now i changed to true.
so now i've messed up, upps ok i will try to repair this tommorow
thanks
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
ok i've set $DB_UTF8_COLLATION back to "false" and there is no error about the collation, all the genealogical data seams to be ok, but the blocks still displays wrong, any suggestions about the config.php or server settings?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Anonymous
-
2010-01-30
Does you index folder have the right permissions? They must be full read/write (777) on the folder, files and all sub-folders? I'm wondering if caching cannot happen because permissions are wrong?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
permisions are as they should. i don't think that the problem is with the caching, cause blocks are loading incorrect randomly (sometimes "login" and "random media" loads other times it is GEDCOM Welcome and statistics, etc.) IMO it's something wrong with the getting data from database, as you suggest before: timeouts, execution time, memory… or i don't know what else :-(
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I have same problem. Three times "Assistant of configuration" or three times "Welcome to the genealogy site"
Using phpgedview 4.2.3 for the first time (not an upgrade)
Thanks for help.
Aalin
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
When you're first setting up the site, you need to have full read/write/modify (777) permission on file "config.php".
You always need full read/write/modify (777) permission on directory "index", directory "media", and all their files and subdirectories.
You may need to replace file "config.php" with a fresh copy from your original PGV 4.2.3 distribution. If you do this, when you launch PGV you should be taken directly to the Install wizard. Be sure to fill in each field properly, and click the "next" button at the bottom of each panel to advance to the next stage. DO NOT use the navigation menu at the left of the configuration panels.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi,
I have exactly the same problem… :( My site is: http://www.skierkowski.pl. I've tried everything you all sugested in this thread without any success… The PGV portal seems to be working correctly (inside), but the first page is really ugly because of these bad displayed blocks. My PGV version is 4.2.3 installed from scratch (tried basic version and also full).
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Maybe this would be a hint: I have my site on OVH server. Internal path to the PGV directory is like: /homez.103/skier/www/phpgedview/, and is slightly different than the external one…
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
skierro:
Depending on which version of PGV you have, you might have to manually edit the "config.php" file to make the server URL value empty.
If you do this, PGV will, when you launch it, determine what the proper URL is.
If you're using version 4.2.3 (the most recent version), the Install wizard should determine the correct value for the server URL. If what's displayed in this field is NOT the same as the calculated value, you should simply clear the field. Be sure to click the "Next" button until the configuration has been saved.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I have deleted version 4.2.3, and use now 4.2.1 and it works fine. I followed exactly the same procedure, same permissions, same GED database, same mysql database, etc.
I do not understand, but at least it works
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Alain
There are several reasons for this issue and why you don't have it when using 4.2.1.
1) This feature did not exist in 4.2.1. Of course there are hundreds of bugs and a slew of missing features between 4.2.1 and 4.2.3+
2) Much of this problem was minor code issues, resolved since the stable 4.2.3 release. That's why I always recommend the installation of v4.2.3+ from the SVN tarball.
a) Memory is a key issue here. If you have a gedcom of any significant size (over 500 people), then 64mb is really a minimum.
b) Supporting software versions. The latest MySQL and PHP. Other databases and older versions may throw errors.
c) Underlying hardware: processor type and speed, total ram, memory available to PGV, connection speeds, reliability of connection
I run my own server on a very fast machine with ample ram (32gb with 1gb to PGV). This is obviously overkill. The HD is a 3-disk mirrored RAID with striped reads and a nightly clone as well as Time Machine on an external drive. We have a 4mb uplink cable connection that rarely fails. We have NEVER had this problem with PGV and have identified all previous occurrences as attributable to either hardware, supporting software or PGV configuration issues (including permissions).
I wholeheartedly do not recommend the use of 4.2.1 when the outstanding security and interface enhancements are available in v4.2.3. You know something is wrong with what you are doing, or the platform you are using, when there are thousands of successful sites operating on the current code without any issues. It is quite stable with only a few minor bugs that don't affect stability or security.
-Stephen
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I agree with you on principle, latest version would be better. But pragmatically, it does not work, and I can't figure out why. In addition, I noticed that the websites mentioned by other contributors to this thread still display the same problems too. So using 4.2.1 seems a good idea, on a temporary basis.
I'll give the latest SVN tarball a try though, and will report the result here.
Here are my technical details:
mySQL 5.1
PHP 5.2
Memory is 32mb for the moment, but I have only 318 individuals in the database at this point
Underlying hardware. I am on www.ovh.com, no idea what they're using.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I downloaded the latest svn trunk, using the command:
svn checkout https://phpgedview.svn.sourceforge.net/svnroot/phpgedview/trunk/phpGedView phpgedview
I am not familiar with SVN and development releases, but I noticed differences in files. There is no config.php in the files downloaded. Is this the correct batch of files ? SHould I use another command to download 4.2.3+ ?
Thanks
Alain
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi,
I have a problem with displaying the blocks on the main page and on mygedview portal. Sometimes, everything loads as it should (very rare) but more often it loads two or three blocks, the others are displayed as „site is currently unavailable, „instalation wizard” or login site (look at the attached screenshots). I don't know what's the problem, first I thought that this was PHP execution time, but the site generates in less than 10 seconds and the max execution time is set to 30 seconds. What else should I check?
Thanks for any suggestions.
my website http://www.paterki.com
I agree there is something very strange about your site. What version of PGV is it?
Is it a new install, and how long has it had this problem?
It is possible that your GEDCOM data is corrupt. Try running "Check" against it (from GEDCPM Configuration page). Leep it set to "Critical" errors only, and see if that reports any issues.
It's PGV 4.2.3, problem exists since the installation, it is new installation not an upgrade. I am a newbie with PGV :-)
And no there is no critical errors, there are only "errors" with gedcom tags "ADDR", "CEME".
oh well, i will try to reinstall PGV, maybe it helps :-)
I wouldn't rush into re-installing. Now that we have eliminated GEDCOM errors, it is more likely to be a server of configuration problem. Can you answer a few more questions:
1 - What are the details of your set up (PHP, MYSQL, version numbers etc. )?
2 - What are you memory settings, time-out limits etc?
2 - What are you config settings (you can post the relevant parts of config.php here - but blank out user names, passwords etc first).
I just had nother look at your site, and tried to go to the Individual Lists. It threw this error, whcich gives a big clue to the likely problem:
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE: Syntax error or access violation: 1253 COLLATION 'utf8_unicode_ci' is not valid for CHARACTER SET 'latin1''
It looks like you have inconsistent collations on your database, . You might even have set "Use the database to provide UTF-8 collation" in Database set up AFTER you had created the tables. (The help screen there specifically says don't do that.
To correct it go to this patch, and follow the instructions VERY CAREFULLY, after taking backups of everything first:
https://sourceforge.net/tracker/?func=detail&aid=2318005&group_id=55456&atid=477081
PHP ver 5.2.12 but i also tried on ver 5.3.1
MYSQL Server version: 5.0.88-log, Protocol version: 10, MySQL charset: UTF-8 Unicode (utf8) , MySQL connection collation: utf8_unicode_ci
memory limit: local value 32M, master value 64M
mysql.connect_timeout: local and master 60
max_execution_time:local and master 30
max_file_uploads: local and master 20
max_input_nesting_level: local and master 64
max_input_time: local and master -1
post_max_size:local and master 32M
realpath_cache_size: local and master 16K
realpath_cache_ttl: local and master 120
config.php:
if (preg_match('/\Wconfig.php/', $_SERVER)>0) {
print 'Got your hand caught in the cookie jar.';
exit;
}
$DBTYPE='mysql';
$DBHOST='mysql5-1.start';
$DBPORT='3306';
$DBUSER=;
$DBPASS=;
$DBNAME=;
$DB_UTF8_COLLATION=false;
$TBLPREFIX='pgv_';
$INDEX_DIRECTORY='./index/';
$AUTHENTICATION_MODULE = "authentication.php";
$PGV_STORE_MESSAGES=true;
$PGV_SIMPLE_MAIL=true;
$USE_REGISTRATION_MODULE=true;
$REQUIRE_ADMIN_AUTH_REGISTRATION=true;
$ALLOW_USER_THEMES=false;
$ALLOW_CHANGE_GEDCOM=false;
$LOGFILE_CREATE='monthly';
$LOG_LANG_ERROR = false;
$PGV_SESSION_SAVE_PATH='';
$PGV_SESSION_TIME='7200';
$SERVER_URL='';
$LOGIN_URL='';
$MAX_VIEWS='30';
$MAX_VIEW_TIME='1';
$PGV_MEMORY_LIMIT='32M';
$COMMIT_COMMAND='';
$CONFIGURED=true;
require_once './includes/session.php';
wait, cause when i was checking the settings of the MySQL i saw that "collation thing" (i am unfamiliar with PHP and MySQL, but i'm working on it :-) ) and i've changed the settings in PGV - old settings was $DB_UTF8_COLLATION=false now i changed to true.
so now i've messed up, upps ok i will try to repair this tommorow
thanks
ok i've set $DB_UTF8_COLLATION back to "false" and there is no error about the collation, all the genealogical data seams to be ok, but the blocks still displays wrong, any suggestions about the config.php or server settings?
Some of the blocks on the welcome page are cached. Delete all the files in index/cache/.
deleting the files in cache folders, didn't help
Does you index folder have the right permissions? They must be full read/write (777) on the folder, files and all sub-folders? I'm wondering if caching cannot happen because permissions are wrong?
permisions are as they should. i don't think that the problem is with the caching, cause blocks are loading incorrect randomly (sometimes "login" and "random media" loads other times it is GEDCOM Welcome and statistics, etc.) IMO it's something wrong with the getting data from database, as you suggest before: timeouts, execution time, memory… or i don't know what else :-(
I have same problem. Three times "Assistant of configuration" or three times "Welcome to the genealogy site"
Using phpgedview 4.2.3 for the first time (not an upgrade)
Thanks for help.
Aalin
When you're first setting up the site, you need to have full read/write/modify (777) permission on file "config.php".
You always need full read/write/modify (777) permission on directory "index", directory "media", and all their files and subdirectories.
You may need to replace file "config.php" with a fresh copy from your original PGV 4.2.3 distribution. If you do this, when you launch PGV you should be taken directly to the Install wizard. Be sure to fill in each field properly, and click the "next" button at the bottom of each panel to advance to the next stage. DO NOT use the navigation menu at the left of the configuration panels.
Hi,
I have exactly the same problem… :( My site is: http://www.skierkowski.pl. I've tried everything you all sugested in this thread without any success… The PGV portal seems to be working correctly (inside), but the first page is really ugly because of these bad displayed blocks. My PGV version is 4.2.3 installed from scratch (tried basic version and also full).
Sorry - the right address is: http://1000gp.ovh.net/~skierkow/phpgedview/
Have you set $SERVER_URL in your config.php?
Does it help if you leave this value empty?
I've tried with several values… :D Current value is: 'http://1000gp.ovh.net/~skierkow/phpgedview/'
Maybe this would be a hint: I have my site on OVH server. Internal path to the PGV directory is like: /homez.103/skier/www/phpgedview/, and is slightly different than the external one…
skierro:
Depending on which version of PGV you have, you might have to manually edit the "config.php" file to make the server URL value empty.
If you do this, PGV will, when you launch it, determine what the proper URL is.
If you're using version 4.2.3 (the most recent version), the Install wizard should determine the correct value for the server URL. If what's displayed in this field is NOT the same as the calculated value, you should simply clear the field. Be sure to click the "Next" button until the configuration has been saved.
I have the same problem, exactly. using 4.2.3.
I have not solved this problem yet, despite this discussion.
I have deleted version 4.2.3, and use now 4.2.1 and it works fine. I followed exactly the same procedure, same permissions, same GED database, same mysql database, etc.
I do not understand, but at least it works
Alain
There are several reasons for this issue and why you don't have it when using 4.2.1.
1) This feature did not exist in 4.2.1. Of course there are hundreds of bugs and a slew of missing features between 4.2.1 and 4.2.3+
2) Much of this problem was minor code issues, resolved since the stable 4.2.3 release. That's why I always recommend the installation of v4.2.3+ from the SVN tarball.
a) Memory is a key issue here. If you have a gedcom of any significant size (over 500 people), then 64mb is really a minimum.
b) Supporting software versions. The latest MySQL and PHP. Other databases and older versions may throw errors.
c) Underlying hardware: processor type and speed, total ram, memory available to PGV, connection speeds, reliability of connection
I run my own server on a very fast machine with ample ram (32gb with 1gb to PGV). This is obviously overkill. The HD is a 3-disk mirrored RAID with striped reads and a nightly clone as well as Time Machine on an external drive. We have a 4mb uplink cable connection that rarely fails. We have NEVER had this problem with PGV and have identified all previous occurrences as attributable to either hardware, supporting software or PGV configuration issues (including permissions).
I wholeheartedly do not recommend the use of 4.2.1 when the outstanding security and interface enhancements are available in v4.2.3. You know something is wrong with what you are doing, or the platform you are using, when there are thousands of successful sites operating on the current code without any issues. It is quite stable with only a few minor bugs that don't affect stability or security.
-Stephen
I agree with you on principle, latest version would be better. But pragmatically, it does not work, and I can't figure out why. In addition, I noticed that the websites mentioned by other contributors to this thread still display the same problems too. So using 4.2.1 seems a good idea, on a temporary basis.
I'll give the latest SVN tarball a try though, and will report the result here.
Here are my technical details:
mySQL 5.1
PHP 5.2
Memory is 32mb for the moment, but I have only 318 individuals in the database at this point
Underlying hardware. I am on www.ovh.com, no idea what they're using.
Hello okbigkid
I downloaded the latest svn trunk, using the command:
svn checkout https://phpgedview.svn.sourceforge.net/svnroot/phpgedview/trunk/phpGedView phpgedview
I am not familiar with SVN and development releases, but I noticed differences in files. There is no config.php in the files downloaded. Is this the correct batch of files ? SHould I use another command to download 4.2.3+ ?
Thanks
Alain