I finally got to updating phpgedview today as my shared server has been on PHP 7.3 for some time. Everything seemed to go OK updating to the current snapshot from SVN. I can see the family tree except where data have been hidden for privacy reasons.
Except, I can't seem to log in. It accepts my username and password (I get an error if it's wrong) and pgv-202101.log shows "Login Successful". However there is no admin link, only "Login" at top center. I requested and received a reset password, which "works" in that I don't get an error "Unable to authenticate user" as I do if I type a wrong password. My site has 4 users and I've tried with another (non-admin) user with a known password, with the same result.
I have full mysql, ftp, and command-line access (within my home directory) to this server, though I've failed so far to come up with any kind of PHP log. Running "php usermigrate_cli.php --export" from CLI gives me "You are not welcome here", though I'm not sure if I'm doing it right.
Is there any way to recover my site, short of starting over with a new database? (I've backed up my ged file before starting this process, so it wouldn't be catastrophic if I had to.)
The following errors can be seen in the "On this day" block:
ERROR 8: A non well formed numeric value encountered
0 Error occurred on line 1634 of file functions_print_lists.php in function print_events_table
1 called from line 102 of file todays_events.php in function print_todays_events
2 called from line 1 of file index.php(276) : eval()'d code in function eval
3 called from line 276 of file index.php
Thanks in advance.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
The line numbers shown in your error above do not make sense. They are nowhere near where they should be.
Which SVN snapshot did you download? Check the SVN number recorded near the top of the changelog.txt file.
A few days ago, the SVN was updated to version 7277, and today it got updated to 7278 with a minor update to handle IPv6 IP addressses.
You should download a new SVN snapshot, and upgrade your PhpGedView installation by simply replacing everything except file /config.php and directories /index and /media and all their contents.
Download the current SVN snapshot from here: [https://sourceforge.net/p/phpgedview/svn/HEAD/tree/trunk/phpGedView]
Another user had a similar problem that was cured by using phpmyadmin to manipulate the database. It had incorrectly recorded that the user in question was already logged in, and therefore could not log in again.
Start by looking at the pgv_users table. Here you will find your login ID and the corresponding internal user number.
Next, look at the pgv_user_setting table. Find the line that tells you the login status of your user number. The field in question is called "loggedin". If this is set to "Y", change it to "N".
If you got that famous "You are not welcome here" message, PhpGedView thinks that you were hacking. Your IP will be banned for an hour.
You can erase the timed ban. That's in the pgv_ip_address table. Look for a timed ban here, and just delete that line.
For any further communications, please e-mail me directly (don't use SourceForge).
gkroll (at) keldine (dot) ca
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Thanks for your help. I upgraded to today's version exactly as you described, so that wasn't the problem. The database, I'm quite sure, showed me as loggedin when I looked earlier, but just now it was set to "N" so I left it. Also the ip_address table was empty, so if I was banned, I'm not anymore.
Your second post suggested that I should try in a different browser, so instead of Firefox I fired up Edge, which let me log in on the first try. Also there are no errors in the "On This Day" box.
At this moment, Firefox still shows the errors, and won't let me log in (though it does show that there is "1 logged-in user"). There is no error or anything, just a silent failure. I'd really like not to reinstall, so I'll give it another look tomorrow, clearing cache, running without addons, etc. Hopefully it's just that something got cached and will eventually catch up.
Thanks for your email address and I'll contact you that way if I have further problems.
Eric
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I finally got to updating phpgedview today as my shared server has been on PHP 7.3 for some time. Everything seemed to go OK updating to the current snapshot from SVN. I can see the family tree except where data have been hidden for privacy reasons.
Except, I can't seem to log in. It accepts my username and password (I get an error if it's wrong) and pgv-202101.log shows "Login Successful". However there is no admin link, only "Login" at top center. I requested and received a reset password, which "works" in that I don't get an error "Unable to authenticate user" as I do if I type a wrong password. My site has 4 users and I've tried with another (non-admin) user with a known password, with the same result.
I have full mysql, ftp, and command-line access (within my home directory) to this server, though I've failed so far to come up with any kind of PHP log. Running "php usermigrate_cli.php --export" from CLI gives me "You are not welcome here", though I'm not sure if I'm doing it right.
Is there any way to recover my site, short of starting over with a new database? (I've backed up my ged file before starting this process, so it wouldn't be catastrophic if I had to.)
The following errors can be seen in the "On this day" block:
Thanks in advance.
The line numbers shown in your error above do not make sense. They are nowhere near where they should be.
Which SVN snapshot did you download? Check the SVN number recorded near the top of the changelog.txt file.
A few days ago, the SVN was updated to version 7277, and today it got updated to 7278 with a minor update to handle IPv6 IP addressses.
You should download a new SVN snapshot, and upgrade your PhpGedView installation by simply replacing everything except file /config.php and directories /index and /media and all their contents.
Download the current SVN snapshot from here:
[https://sourceforge.net/p/phpgedview/svn/HEAD/tree/trunk/phpGedView]
Another user had a similar problem that was cured by using phpmyadmin to manipulate the database. It had incorrectly recorded that the user in question was already logged in, and therefore could not log in again.
Start by looking at the pgv_users table. Here you will find your login ID and the corresponding internal user number.
Next, look at the pgv_user_setting table. Find the line that tells you the login status of your user number. The field in question is called "loggedin". If this is set to "Y", change it to "N".
If you got that famous "You are not welcome here" message, PhpGedView thinks that you were hacking. Your IP will be banned for an hour.
You can erase the timed ban. That's in the pgv_ip_address table. Look for a timed ban here, and just delete that line.
For any further communications, please e-mail me directly (don't use SourceForge).
gkroll (at) keldine (dot) ca
Sorry, ...
I forgot to add:
The user in question also had to uninstall and the re-install Chrome. The database fiddling did not work by itself.
Gerry,
Thanks for your help. I upgraded to today's version exactly as you described, so that wasn't the problem. The database, I'm quite sure, showed me as loggedin when I looked earlier, but just now it was set to "N" so I left it. Also the ip_address table was empty, so if I was banned, I'm not anymore.
Your second post suggested that I should try in a different browser, so instead of Firefox I fired up Edge, which let me log in on the first try. Also there are no errors in the "On This Day" box.
At this moment, Firefox still shows the errors, and won't let me log in (though it does show that there is "1 logged-in user"). There is no error or anything, just a silent failure. I'd really like not to reinstall, so I'll give it another look tomorrow, clearing cache, running without addons, etc. Hopefully it's just that something got cached and will eventually catch up.
Thanks for your email address and I'll contact you that way if I have further problems.
Eric