Been away for a while, watching the feedback on v4.2.2 installs. Now I can share an experience of my own!
Internal error while updating PGV_SCHEMA_VERSION to 1
I am trying to set up a "publicly accessible / test" site using the new version. At about step 2 of the install, I get the error message in the post title. I am using a "blank" database, which was previously used for another php-project install, but all table have since been dropped. The database is setup for UTF-8, so I think I left "no" checked in the install step. Connected to database OK, but then error appears.
I was able to skip over this error message and go on to the next step, but after checking phpAdmin, no tables are setup. Now I can't re-start the Install Process and all I get is this message on a blank page when I go the the site URL.
ps. Host is 1&1, php5.2.10 with PDO for mySQL
Please help. Thanks in advance.
RL
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Roland
I've done over 30 installs of v4.2.2 on either my machines or others servers. After carefully reviewing the server configurations, making sure that all progs meet the minimum requirements and setting RAM at a minimum of 64mb, I have not had one new install fail.
New installs are routinely (in my experience) easier than upgrading, only in that one has to use extra precautions about which files to replace and which to save, which to relocate and which to leave alone, which files need to have permissions modified and which don't - all of which are only a major concern during an upgrade.
Either change the CONFIG.php to configured = false, or replace it and you can reenter the http://yourPGVsite/install.php url to begin again - after, and only after, you confirm your permissions and DB configuration.
Stephen
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
This would indicate that PGV caught a database error in the script db_schema/db_schema_0_1.php.
This script does two things. It creates the table pgv_site_settings, and then inserts a row with values "PGV_DB_SCHEMA", "1".
You might like to look at whether either of these things happened. If not, then look your database permissions - e.g. does this username/password have create-table rights in this database. etc.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
First let me say this was a False Alarm. But I am very grateful to Okbigkid and Fisharebest for jumping right in to come to my rescue. Having two "heavy-hitters" chime in on this issue is quite refreshing after having been away from the Forum for a while.
Now for the record, let me explain what I had to do to correct the problem. First mistake was working late-night and in a hurry. Re-using the databse from another project was also a bad idea, as it was only mysql4.0, which I totally overlooked in the Control Panel. After creating a new mysql 5.0 database to use, the installation of PGV 4.2.2 went without a hitch. While I did have some problems getting my Ged installed, this was entirely due to memory limits and timing issues well discussed in the Forum before now.
I am happy to report that I have my second PGV install running and intend to use it for testing new features and helping debug issues that a (L)user like myself might have from time to time. The "wet-noodle" treatment begins shortly and will be streamed live from the new site. . .
Many Thanks again.
RL
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Problm solved. I was trying toinstall PGV with a mySQL base version 4.0, while at least 4.1 is required. I upgraded the database and all went fine !
Alain
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Alain
Glad to hear it was simply an issue with you failing to review the installation instructions and confirming the system requirements. Most often, this is the case, as PGV is truly a pretty easy install, particularly when you've done it a few times. When in doubt, re-read the WIKI.
A significant improvement to the install procedure is certainly possible, but its doubtful that any current developer will enhance it as there are other more pressing matters; it works well, other things don't.
-Stephen
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Max:
Instead of trying to resurrect an old post like this, you should start your own Help topic. In this new topic, please describe precisely what errors you are encountering.
I see that the memory limit set by your ISP is 50 Mb. You should be OK with this limit, but you need to make sure that the site configuration, launched when you first start your new PhpGedView installation, agrees with this limit. You'll fnd this option in Step 4 of the Install wizard, "Advanced" tab.
Your ISP supports mysql version 5.0.90. You should ask about getting a more recent version. This one is very old, and could possibly be the source of your problems. My site runs 5.1.37, and even that is outdated.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hello All -
Been away for a while, watching the feedback on v4.2.2 installs. Now I can share an experience of my own!
Internal error while updating PGV_SCHEMA_VERSION to 1
I am trying to set up a "publicly accessible / test" site using the new version. At about step 2 of the install, I get the error message in the post title. I am using a "blank" database, which was previously used for another php-project install, but all table have since been dropped. The database is setup for UTF-8, so I think I left "no" checked in the install step. Connected to database OK, but then error appears.
I was able to skip over this error message and go on to the next step, but after checking phpAdmin, no tables are setup. Now I can't re-start the Install Process and all I get is this message on a blank page when I go the the site URL.
ps. Host is 1&1, php5.2.10 with PDO for mySQL
Please help. Thanks in advance.
RL
Roland
I've done over 30 installs of v4.2.2 on either my machines or others servers. After carefully reviewing the server configurations, making sure that all progs meet the minimum requirements and setting RAM at a minimum of 64mb, I have not had one new install fail.
New installs are routinely (in my experience) easier than upgrading, only in that one has to use extra precautions about which files to replace and which to save, which to relocate and which to leave alone, which files need to have permissions modified and which don't - all of which are only a major concern during an upgrade.
Either change the CONFIG.php to configured = false, or replace it and you can reenter the http://yourPGVsite/install.php url to begin again - after, and only after, you confirm your permissions and DB configuration.
Stephen
This would indicate that PGV caught a database error in the script db_schema/db_schema_0_1.php.
This script does two things. It creates the table pgv_site_settings, and then inserts a row with values "PGV_DB_SCHEMA", "1".
You might like to look at whether either of these things happened. If not, then look your database permissions - e.g. does this username/password have create-table rights in this database. etc.
Hello All -
First let me say this was a False Alarm. But I am very grateful to Okbigkid and Fisharebest for jumping right in to come to my rescue. Having two "heavy-hitters" chime in on this issue is quite refreshing after having been away from the Forum for a while.
Now for the record, let me explain what I had to do to correct the problem. First mistake was working late-night and in a hurry. Re-using the databse from another project was also a bad idea, as it was only mysql4.0, which I totally overlooked in the Control Panel. After creating a new mysql 5.0 database to use, the installation of PGV 4.2.2 went without a hitch. While I did have some problems getting my Ged installed, this was entirely due to memory limits and timing issues well discussed in the Forum before now.
I am happy to report that I have my second PGV install running and intend to use it for testing new features and helping debug issues that a (L)user like myself might have from time to time. The "wet-noodle" treatment begins shortly and will be streamed live from the new site. . .
Many Thanks again.
RL
I have the same problem. Any suggestion ?
Thanks
Alain
Ooops, I didn't at once notice the replies to the first message. I'll look into this, as it seems to help solving the issue.
Alain
Problm solved. I was trying toinstall PGV with a mySQL base version 4.0, while at least 4.1 is required. I upgraded the database and all went fine !
Alain
Alain
Glad to hear it was simply an issue with you failing to review the installation instructions and confirming the system requirements. Most often, this is the case, as PGV is truly a pretty easy install, particularly when you've done it a few times. When in doubt, re-read the WIKI.
A significant improvement to the install procedure is certainly possible, but its doubtful that any current developer will enhance it as there are other more pressing matters; it works well, other things don't.
-Stephen
Hello all,
I'm having the same problem of roland.
I didn't find support anywhere, I just find this post:
http://www.forumphpgedview.fr/viewtopic.php?f=3&t=874
can anyone help me?
TIA
Max
Didn't see all the posts, sorry!
Anyway, I can't upgrade memory limit beacuase of I do not have this privilege (my ISP doesn't allow this, I think).
Any other suggestion?
here is my php version:
http://webx8.aruba.it/ver.php
Max:
Instead of trying to resurrect an old post like this, you should start your own Help topic. In this new topic, please describe precisely what errors you are encountering.
I see that the memory limit set by your ISP is 50 Mb. You should be OK with this limit, but you need to make sure that the site configuration, launched when you first start your new PhpGedView installation, agrees with this limit. You'll fnd this option in Step 4 of the Install wizard, "Advanced" tab.
Your ISP supports mysql version 5.0.90. You should ask about getting a more recent version. This one is very old, and could possibly be the source of your problems. My site runs 5.1.37, and even that is outdated.