This Help forum is for issues relates to webtrees 1.7. For issues related to webtrees 2.0, please use that forum.
Before asking for help please read "Requesting Help and Suggestions" by clicking on that tab above here."
  • Page:
  • 1
  • 2

TOPIC:

Upgrade to 1.7.19 failed 3 weeks 4 days ago #1

  • GordonD
  • GordonD's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 11
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.

Upgrade to 1.7.19 failed 3 weeks 4 days ago #2

  • fisharebest
  • fisharebest's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 16089
> 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 - This email address is being protected from spambots. You need JavaScript enabled to view it. - fisharebest.webtrees.net

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

Upgrade to 1.7.19 failed 3 weeks 4 days ago #3

  • GordonD
  • GordonD's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 11
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.

Upgrade to 1.7.19 failed 3 weeks 4 days ago #4

  • fisharebest
  • fisharebest's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 16089
> 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 - This email address is being protected from spambots. You need JavaScript enabled to view it. - fisharebest.webtrees.net

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

Upgrade to 1.7.19 failed 3 weeks 3 days ago #5

  • GordonD
  • GordonD's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 11
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.

Upgrade to 1.7.19 failed 3 weeks 3 days ago #6

  • fisharebest
  • fisharebest's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 16089
> 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 - This email address is being protected from spambots. You need JavaScript enabled to view it. - fisharebest.webtrees.net

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

Upgrade to 1.7.19 failed 3 weeks 3 days ago #7

  • GordonD
  • GordonD's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 11
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.

Upgrade to 1.7.19 failed 3 weeks 3 days ago #8

  • Franz Frese
  • Franz Frese's Avatar
  • Offline
  • Senior Member
  • Senior Member
  • Posts: 331
No
Attachments:

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

Do you need a web hosting solution for your webtrees site?
If you prefer a host that specialises in webtrees, the following page lists some suppliers able to provide one for you: 

Upgrade to 1.7.19 failed 3 weeks 3 days ago #9

  • fisharebest
  • fisharebest's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 16089
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 - This email address is being protected from spambots. You need JavaScript enabled to view it. - fisharebest.webtrees.net

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

Upgrade to 1.7.19 failed 3 weeks 3 days ago #10

  • GordonD
  • GordonD's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 11
Okay. Thanks.
Must be just my browser.

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

Upgrade to 1.7.19 failed 3 weeks 3 days ago #11

  • GordonD
  • GordonD's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 11
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.

Upgrade to 1.7.19 failed 3 weeks 3 days ago #12

  • fisharebest
  • fisharebest's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 16089
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 - This email address is being protected from spambots. You need JavaScript enabled to view it. - fisharebest.webtrees.net

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

Upgrade to 1.7.19 failed 3 weeks 3 days ago #13

  • GordonD
  • GordonD's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 11
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.

Upgrade to 1.7.19 failed 5 days 18 hours ago #14

  • GordonD
  • GordonD's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 11
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.

Upgrade to 1.7.19 failed 5 days 17 hours ago #15

  • fisharebest
  • fisharebest's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 16089
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 - This email address is being protected from spambots. You need JavaScript enabled to view it. - fisharebest.webtrees.net

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

Upgrade to 1.7.19 failed 2 days 18 hours ago #16

  • GordonD
  • GordonD's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 11
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.

Upgrade to 1.7.19 failed 2 days 17 hours ago #17

  • fisharebest
  • fisharebest's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 16089
> 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 - This email address is being protected from spambots. You need JavaScript enabled to view it. - fisharebest.webtrees.net

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

Upgrade to 1.7.19 failed 1 day 19 hours ago #18

  • GordonD
  • GordonD's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 11
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.

Upgrade to 1.7.19 failed 1 day 19 hours ago #19

  • Franz Frese
  • Franz Frese's Avatar
  • Offline
  • Senior Member
  • Senior Member
  • Posts: 331
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.

Upgrade to 1.7.19 failed 1 day 18 hours ago #20

  • fisharebest
  • fisharebest's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 16089
You can delete the entire folder modules_v3
Greg Roach - This email address is being protected from spambots. You need JavaScript enabled to view it. - fisharebest.webtrees.net

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

  • Page:
  • 1
  • 2
Powered by Kunena Forum