- Posts: 11
Question Upgrade to 1.7.19 failed
- GordonD
- Topic Author
- Offline
- New Member
I updated the PHP from 5.3 to 7.3.5 and tried the upgrade again. This time the page header appears but nothing else, just a blank. The login button does not function.
I tried to return to version 1.3.0 but this does not work now.
My website is www.walkerhill.org.uk/family/
Any suggestions?
Please Log in or Create an account to join the conversation.
- fisharebest
- Offline
- Administrator
It's really helpful if you can copy/paste the error messages here...
> tried to return to version 1.3.0 but this does not work now.
The upgrade would have made changes to the database structure, so downgrading isn't possible.
> This time the page header appears but nothing else, just a blank.
See webtrees.net/faq/500/
Greg Roach - greg@subaqua.co.uk - @fisharebest@phpc.social - fisharebest.webtrees.net
Please Log in or Create an account to join the conversation.
- GordonD
- Topic Author
- Offline
- New Member
- Posts: 11
Is it worth trying an upgrade to 2.0, or would that make things worse?
Please Log in or Create an account to join the conversation.
- fisharebest
- Offline
- Administrator
OK - the FAQ page said that there is a helpful error message in your server logs, and you need to find it.
When you say "didn't help", what do you mean? You found the error message but didn't understand what it meant?
> Is it worth trying an upgrade to 2.0, or would that make things worse?
Without knowing the error, it's really hard to say.
Can you make/restore a database backup?
If yes, then now would be a good time to make a backup.
Greg Roach - greg@subaqua.co.uk - @fisharebest@phpc.social - fisharebest.webtrees.net
Please Log in or Create an account to join the conversation.
- GordonD
- Topic Author
- Offline
- New Member
- Posts: 11
Initially, after attempting to upgrade from 1.3.0 to 1.7.19, when I tried to access the site I was getting either:
"Oops! The webserver is unable to connect to the database server. It could be busy, undergoing maintenance or simply broken. You should try again in a few minutes or contact the website administrator.
SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction"
or HTTP 500 internal server error.
Now the site loads the page header but nothing else.
I searched this forum, the webtrees documentation and googled about the two errors but did not find anything that seemed relevant to my situation.
I did back up the database before I started but this includes both webtrees and wordpress tables. But I could probably find a way of restoring just the webtrees tables.
Please Log in or Create an account to join the conversation.
- fisharebest
- Offline
- Administrator
A blank page indicates that a fatal error occured, and is not displayed.
You should be able to find the error in your apache error logs.
Can you find these error logs and tell us what the error says?
Greg Roach - greg@subaqua.co.uk - @fisharebest@phpc.social - fisharebest.webtrees.net
Please Log in or Create an account to join the conversation.
- GordonD
- Topic Author
- Offline
- New Member
- Posts: 11
One oddity I have just noticed is that it is when using the link "walkerhill.org.uk/family/" that the page header appears. Using " www.walkerhill.org.uk/family/ " it is completely blank.
Please Log in or Create an account to join the conversation.
- Franz Frese
- Offline
- Elite Member
Please Log in or Create an account to join the conversation.
- fisharebest
- Offline
- Administrator
Maybe your webhost provides a control panel that allows you to view error log files.
Maybe you need to use FTP/SFTP to access the error log files.
Greg Roach - greg@subaqua.co.uk - @fisharebest@phpc.social - fisharebest.webtrees.net
Please Log in or Create an account to join the conversation.
- GordonD
- Topic Author
- Offline
- New Member
- Posts: 11
Must be just my browser.
Please Log in or Create an account to join the conversation.
- GordonD
- Topic Author
- Offline
- New Member
- Posts: 11
Wed Jun 01 14:20:05.808594 2022] [fcgid:emerg] [pid 3406091] (22)Invalid argument: [client 46.161.11.53:61573] mod_fcgid: can't lock process table in pid 3406091, referer: www.walkerhill.org.uk/#comment-28780/
[Wed Jun 01 14:20:33.072793 2022] [fcgid:emerg] [pid 3406369] (22)Invalid argument: [client 114.119.144.88:45755] mod_fcgid: can't lock process table in pid 3406369, referer: walkerhill.org.uk/family/fanchart.php?ro...4&ged=donald&lang=fr
[Thu Jun 02 18:15:32.833333 2022] [fcgid:emerg] [pid 3877067] (22)Invalid argument: [client 78.147.126.36:60796] mod_fcgid: can't lock process table in pid 3877067, referer: www.walkerhill.org.uk/
No entries after these.
Please Log in or Create an account to join the conversation.
- fisharebest
- Offline
- Administrator
What version of PHP do you think you are using?
Can you try others. Do they give the same error or something different?
Greg Roach - greg@subaqua.co.uk - @fisharebest@phpc.social - fisharebest.webtrees.net
Please Log in or Create an account to join the conversation.
- GordonD
- Topic Author
- Offline
- New Member
- Posts: 11
Please Log in or Create an account to join the conversation.
- GordonD
- Topic Author
- Offline
- New Member
- Posts: 11
I have now had the opportunity to copy the webtrees files and MySQL database for testing with both PHP 5.3 (as it was originally) and 7.3.5, and I have activated PHP error logging.
Now when I try and load webtrees (v1.3.0) the home page header appears but nothing else. The PHP error log shows:
[23-Jun-2022 13:53:51 Europe/London] PHP Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'm_gedfile' in 'where clause'' in /hsphere/local/home/walkerhill/wcs-online.org.uk/family/library/WT/DBStatement.php:88
Stack trace:
#0 [internal function]: PDOStatement->execute(Array)
#1 /hsphere/local/home/walkerhill/wcs-online.org.uk/family/library/WT/DBStatement.php(88): call_user_func_array(Array, Array)
#2 /hsphere/local/home/walkerhill/wcs-online.org.uk/family/library/WT/MenuBar.php(298): WT_DBStatement->__call('execute', Array)
#3 /hsphere/local/home/walkerhill/wcs-online.org.uk/family/library/WT/MenuBar.php(298): WT_DBStatement->execute(Array)
#4 /hsphere/local/home/walkerhill/wcs-online.org.uk/family/themes/colors/header.php(116): WT_MenuBar::getListsMenu()
#5 /hsphere/local/home/walkerhill/wcs-online.org.uk/family/library/WT/Controller/Base.php(248): require('/hsphere/local/...')
#6 /hsphere/local/home/walkerhill/wcs-online.org.uk/family/index.php(87): WT_Controller_Base->pageHeader()
#7 {main}
in /hsphere/local/home/walkerhill/wcs-online.org.uk/family/library/WT/DBStatement.php on line 88
Is this an indication that the db has somehow been corrupted changed along the way?
Please Log in or Create an account to join the conversation.
- fisharebest
- Offline
- Administrator
webtrees.net/faq/downgrade/
If so, then you probably have the database structure for a newer version of webtrees than the one you are using...
You have a database backup???
Greg Roach - greg@subaqua.co.uk - @fisharebest@phpc.social - fisharebest.webtrees.net
Please Log in or Create an account to join the conversation.
- GordonD
- Topic Author
- Offline
- New Member
- Posts: 11
I think there's been two things happening: (1) webtrees 1.3.0 won't work with PHP 7.3.5; (2) Attempts to upgrade to webtrees 1.7.19 always stall for reasons I haven't yet worked out, but this then alters the db tables so that version 1.3.0 can no longer use the db.
Please Log in or Create an account to join the conversation.
- fisharebest
- Offline
- Administrator
This is too vauge to provide any useful feedback.
What exactly happens? What error message?
Maybe trying upgrading incrementally...
1.3.2
1.4.6
1.5.3
1.6.2
1.7.20
Greg Roach - greg@subaqua.co.uk - @fisharebest@phpc.social - fisharebest.webtrees.net
Please Log in or Create an account to join the conversation.
- GordonD
- Topic Author
- Offline
- New Member
- Posts: 11
I have successfully carried the following incremental upgrades:
1.3.0 to 1.4.6
1.4.6 to 1.5.3
1.5.3 to 1.6.2
However, when I try and go from 1.6.2 to 1.7.20 I get a blank screen and the following entry in the php error log:
[27-Jun-2022 13:19:14 UTC] PHP Fatal error: Class 'WT_Module' not found in /hsphere/local/home/walkerhill/wcs-online.org.uk/webtrees17/modules_v3/address_report/module.php on line 31
All this is with PHP 5.3.
I am still able to run 1.6.2 without restoring a previous copy of the db.
Please Log in or Create an account to join the conversation.
- Franz Frese
- Offline
- Elite Member
Install Modules of the appropriate wt-version.
You surely should disable / remove all modules and install them at the end of the upgrading process..
Please Log in or Create an account to join the conversation.
- fisharebest
- Offline
- Administrator
Greg Roach - greg@subaqua.co.uk - @fisharebest@phpc.social - fisharebest.webtrees.net
Please Log in or Create an account to join the conversation.