Web based family history software

Question Upgrade to 1.7.19 failed

  • GordonD
  • Topic Author
  • Offline
  • New Member
  • New Member
More
1 year 9 months ago #1 by GordonD
Upgrade to 1.7.19 failed was created by GordonD
My webtrees installation was still on version 1.3.0 so I followed the instructions to manually upgrade to 1.7.19 before going on to 2.0 (I moved the media folder to data in order to avoid the media fire wall problem). My first attempts would not load the home page at all, and produced either timeout or general serve error messages.
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
  • Away
  • Administrator
  • Administrator
More
1 year 9 months ago #2 by fisharebest
Replied by fisharebest on topic Upgrade to 1.7.19 failed
> or general serve error messages.

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
  • New Member
More
1 year 9 months ago #3 by GordonD
Replied by GordonD on topic Upgrade to 1.7.19 failed
I had already checked the FAQ 500 page, but it didn't help.
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
  • Away
  • Administrator
  • Administrator
More
1 year 9 months ago #4 by fisharebest
Replied by fisharebest on topic Upgrade to 1.7.19 failed
> but it didn't help.

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
  • New Member
More
1 year 9 months ago #5 by GordonD
Replied by GordonD on topic Upgrade to 1.7.19 failed
Sorry, I should have been more specific about this.

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
  • Away
  • Administrator
  • Administrator
More
1 year 9 months ago #6 by fisharebest
Replied by fisharebest on topic Upgrade to 1.7.19 failed
> Now the site loads the page header but nothing else.

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
  • New Member
More
1 year 9 months ago #7 by GordonD
Replied by GordonD on topic Upgrade to 1.7.19 failed
Attempting to load my webtrees site does not put an entry in to the error log.
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
  • Away
  • Elite Member
  • Elite Member
More
1 year 9 months ago #8 by Franz Frese

Please Log in or Create an account to join the conversation.

  • fisharebest
  • Away
  • Administrator
  • Administrator
More
1 year 9 months ago #9 by fisharebest
Replied by fisharebest on topic Upgrade to 1.7.19 failed
The error message will be in a file on your server. You won't see it in your browser.

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
  • New Member
More
1 year 9 months ago #10 by GordonD
Replied by GordonD on topic Upgrade to 1.7.19 failed
Okay. Thanks.
Must be just my browser.

Please Log in or Create an account to join the conversation.

  • GordonD
  • Topic Author
  • Offline
  • New Member
  • New Member
More
1 year 9 months ago #11 by GordonD
Replied by GordonD on topic Upgrade to 1.7.19 failed
I access the error logs on the host server via an admin control panel. I can see error messages relating to (I think) when I upgraded Wordpress and Webtrees, but did not yet have PHP upgraded enough:

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
  • Away
  • Administrator
  • Administrator
More
1 year 9 months ago #12 by fisharebest
Replied by fisharebest on topic Upgrade to 1.7.19 failed
Hmm. Looks like something wrong with PHP.

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
  • New Member
More
1 year 9 months ago #13 by GordonD
Replied by GordonD on topic Upgrade to 1.7.19 failed
It was on PHP 5.3 before I started the upgrades. I needed to go to 5.6 for Wordpress. But then upgraded further to 7.3.5. I have attempted the webtrees upgrade for each of these versions but have never got it to succeed.

Please Log in or Create an account to join the conversation.

  • GordonD
  • Topic Author
  • Offline
  • New Member
  • New Member
More
1 year 9 months ago #14 by GordonD
Replied by GordonD on topic Upgrade to 1.7.19 failed
Hi Greg,
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
  • Away
  • Administrator
  • Administrator
More
1 year 9 months ago #15 by fisharebest
Replied by fisharebest on topic Upgrade to 1.7.19 failed
Have you upgraded to a newer version, and then downgraded to 1.3.0?

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
  • New Member
More
1 year 9 months ago #16 by GordonD
Replied by GordonD on topic Upgrade to 1.7.19 failed
I have now successfully reinstated a working copy of my original webtrees 1.3.0 system (with PHP 5.3) after restoring a backup of the original webtrees MySQL db tables. Attempts to upgrade this to 1.7.19 are still failing though.
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
  • Away
  • Administrator
  • Administrator
More
1 year 9 months ago #17 by fisharebest
Replied by fisharebest on topic Upgrade to 1.7.19 failed
> Attempts to upgrade to webtrees 1.7.19 always stall

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
  • New Member
More
1 year 9 months ago #18 by GordonD
Replied by GordonD on topic Upgrade to 1.7.19 failed
Thanks for that advice Greg.
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
  • Away
  • Elite Member
  • Elite Member
More
1 year 9 months ago #19 by Franz Frese
Replied by Franz Frese on topic Upgrade to 1.7.19 failed
That is a module.
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
  • Away
  • Administrator
  • Administrator
More
1 year 9 months ago #20 by fisharebest
Replied by fisharebest on topic Upgrade to 1.7.19 failed
You can delete the entire folder modules_v3

Greg Roach - greg@subaqua.co.uk - @fisharebest@phpc.social - fisharebest.webtrees.net

Please Log in or Create an account to join the conversation.

Moderators: makitso
Powered by Kunena Forum
}