Web based family history software

Question Composer require 7.4.0

  • thomas52
  • Topic Author
  • Offline
  • Premium Member
  • Premium Member
  • Western North Carolina
More
5 months 3 weeks ago #1 by thomas52
Composer require 7.4.0 was created by thomas52
I think I missed a step.  Upgrading 1.7.20 to 2.1.20, I get an error message:
Composer detected issues in your platform: Your Composer dependencies require a PHP version ">= 7.4.0".
How to fix?

"Failure is an amazing teacher." (L'échec est un professeur extraordinaire.)

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

  • Franz Frese
  • Away
  • Elite Member
  • Elite Member
More
5 months 3 weeks ago - 5 months 3 weeks ago #2 by Franz Frese
Replied by Franz Frese on topic Composer require 7.4.0
At what step of updating do you get that message?

Afaik there is no need for execution of the composer.
Last edit: 5 months 3 weeks ago by Franz Frese.

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

More
5 months 3 weeks ago - 5 months 3 weeks ago #3 by Lars1963
Replied by Lars1963 on topic Composer require 7.4.0
webtrees does not need composer. This means you didn't download the release file. You have used the dev files from github.
Download the release files from here webtrees.net/install/ and eveything will work without a problem.

And have you read this webtrees.net/upgrade/ ? You can't upgrade from 1.7.20 directly to 2.1.20. You'll have to go to 2.0.26 first. 
Last edit: 5 months 3 weeks ago by Lars1963.

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

  • thomas52
  • Topic Author
  • Offline
  • Premium Member
  • Premium Member
  • Western North Carolina
More
5 months 3 weeks ago #4 by thomas52
Replied by thomas52 on topic Composer require 7.4.0
I understand "differences between webtrees 1.7 and webtrees 2.0." Then the manual upgrade says: "Download webtrees-2.1.20.zip." I don't understand what went wrong? I did read the instructions.

"Failure is an amazing teacher." (L'échec est un professeur extraordinaire.)

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

  • Franz Frese
  • Away
  • Elite Member
  • Elite Member
More
5 months 3 weeks ago #5 by Franz Frese
Replied by Franz Frese on topic Composer require 7.4.0
You do not get the message above at downloading the webtrees zip: So again ? At what step do you get the error message?

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

  • thomas52
  • Topic Author
  • Offline
  • Premium Member
  • Premium Member
  • Western North Carolina
More
5 months 3 weeks ago #6 by thomas52
Replied by thomas52 on topic Composer require 7.4.0
Oops, misread the PHP. I have 7.3.3
"For PHP 7.4 to 8.3, download webtrees-2.1.20.zip.
For PHP 7.1 to 7.3, download webtrees-2.0.26.zip."
Should I upload 2.0.26, or should I change the pho version to a later version first?

"Failure is an amazing teacher." (L'échec est un professeur extraordinaire.)

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

  • thomas52
  • Topic Author
  • Offline
  • Premium Member
  • Premium Member
  • Western North Carolina
More
5 months 3 weeks ago #7 by thomas52
Replied by thomas52 on topic Composer require 7.4.0
I have restored backup. I am at adkins.ws
Many thanks for guidance.

"Failure is an amazing teacher." (L'échec est un professeur extraordinaire.)

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

  • thomas52
  • Topic Author
  • Offline
  • Premium Member
  • Premium Member
  • Western North Carolina
More
5 months 3 weeks ago #8 by thomas52
Replied by thomas52 on topic Composer require 7.4.0
Franz: Thank you. Just minutes after beginning upload, I went to www.adkins.ws to check offline.txt, and saw error message re: composer. Then I got a message from host saying I was uploading "malicious" files. Then I canceled upload and restored backup. So now I will download 2.0.26 & start over.

"Failure is an amazing teacher." (L'échec est un professeur extraordinaire.)

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

  • Franz Frese
  • Away
  • Elite Member
  • Elite Member
More
5 months 3 weeks ago - 5 months 3 weeks ago #9 by Franz Frese
Replied by Franz Frese on topic Composer require 7.4.0
see  webtrees.net/upgrade/manual/
so, if you have installed a php-version needed for 2.1, you can use the 2.1 webtrees zip-file (extract and upload).

Simply wait until upload is finished.
Last edit: 5 months 3 weeks ago by Franz Frese.

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

  • thomas52
  • Topic Author
  • Offline
  • Premium Member
  • Premium Member
  • Western North Carolina
More
5 months 3 weeks ago #10 by thomas52
Replied by thomas52 on topic Composer require 7.4.0
It's been a while now, and my site is still not visible. I get "Maximum execution time of 120 seconds exceeded
/home/customer/www/adkins.ws/public_html/vendor/illuminate/database/Connection.php: 375
... should I just wait?

"Failure is an amazing teacher." (L'échec est un professeur extraordinaire.)

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

More
5 months 3 weeks ago #11 by fisharebest
Replied by fisharebest on topic Composer require 7.4.0

I think I missed a step.  Upgrading 1.7.20 to 2.1.20, I get an error message:
Composer detected issues in your platform: Your Composer dependencies require a PHP version ">= 7.4.0".
How to fix?
 
webtrees 1.7 runs on PHP 5.3 - 7.3
webtrees 2.1 runs on PHP 7.4 - 8.4

So as well as upgrading webtrees, you also need to upgrade PHP on your server.
In most cases, you can select the version of PHP in your web-host's control panel.

You will also need to add a line to the file data/config.ini.pnp and do a couple of other checks.
See webtrees.net/upgrade/2.0/

If you are having problems, try the following.

1) make a backup!
2) if you previously stored your media files in /media (or somewhere other than /data/media), then move them to /data/media
3) delete all files EXCEPT /data and anything that you may have added to webtrees (e.g. custom graphics for use on your home page).
4) download/unzip github.com/fisharebest/webtrees/releases.../webtrees-2.1.20.zip
5) copy the files to your server

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

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

  • thomas52
  • Topic Author
  • Offline
  • Premium Member
  • Premium Member
  • Western North Carolina
More
5 months 3 weeks ago #12 by thomas52
Replied by thomas52 on topic Composer require 7.4.0
Host now says:
I performed strace to see where the website is stalling and it appears that it keeps making database queries infinitely.

The repetitive part of the strace calls are:

1718139510.468773 (+ 0.000194) sendto(7, "\5\0\0\0\31\345\0\0\0", 9, MSG_DONTWAIT, NULL, 0) = 9
1718139510.469049 (+ 0.000279) sendto(7, "J\0\0\0\26update `wt_placelocation` set `pl_parent_id` = ? where `pl_parent_id` = ?", 78, MSG_DONTWAIT, NULL, 0) = 78
1718139510.469124 (+ 0.000072) poll([{fd=7, events=POLLIN|POLLERR|POLLHUP}], 1, 86400000) = 1 ([{fd=7, revents=POLLIN}])
1718139510.469258 (+ 0.000132) recvfrom(7, "\f\0\0\1\0\346\0\0\0\0\0\2\0\0\0\0\27\0\0\2\3def\0\0\0\1?\0\f?\0\25\0\0\0\10\200\0\0\0\0\27\0\0\3\3def\0\0\0\1?\0\f?\0\25\0\0\0\10\200\0\0\0\0\5\0\0\4\376\0\0\2\0", 32768, MSG_DONTWAIT, NULL, NULL) = 79
1718139510.469342 (+ 0.000082) sendto(7, "\34\0\0\0\27\346\0\0\0\0\1\0\0\0\0\1\375\0\375\0\00538240\00556301", 32, MSG_DONTWAIT, NULL, 0) = 32
1718139510.469404 (+ 0.000065) poll([{fd=7, events=POLLIN|POLLERR|POLLHUP}], 1, 86400000) = 1 ([{fd=7, revents=POLLIN}])
1718139510.469609 (+ 0.000235) recvfrom(7, "0\0\0\1\0\0\0\2\0\0\0(Rows matched: 0 Changed: 0 Warnings: 0", 32768, MSG_DONTWAIT, NULL, NULL) = 52
1718139510.469718 (+ 0.000075) sendto(7, "\5\0\0\0\31\346\0\0\0", 9, MSG_DONTWAIT, NULL, 0) = 9
1718139510.469863 (+ 0.000145) sendto(7, "1\0\0\0\26delete from `wt_placelocation` where `pl_id` = ?", 53, MSG_DONTWAIT, NULL, 0) = 53
1718139510.469918 (+ 0.000054) poll([{fd=7, events=POLLIN|POLLERR|POLLHUP}], 1, 86400000) = 1 ([{fd=7, revents=POLLIN}])
1718139510.469975 (+ 0.000056) recvfrom(7, "\f\0\0\1\0\347\0\0\0\0\0\1\0\0\0\0\27\0\0\2\3def\0\0\0\1?\0\f?\0\25\0\0\0\10\200\0\0\0\0\5\0\0\3\376\0\0\2\0", 32768, MSG_DONTWAIT, NULL, NULL) = 52
1718139510.470030 (+ 0.000054) sendto(7, "\24\0\0\0\27\347\0\0\0\0\1\0\0\0\0\1\375\0\00556301", 24, MSG_DONTWAIT, NULL, 0) = 24
1718139510.470084 (+ 0.000053) poll([{fd=7, events=POLLIN|POLLERR|POLLHUP}], 1, 86400000) = 1 ([{fd=7, revents=POLLIN}])
1718139510.470171 (+ 0.000085) recvfrom(7, "\7\0\0\1\0\0\0\2\0\0\0", 32768, MSG_DONTWAIT, NULL, NULL) = 11
1718139510.470226 (+ 0.000057) sendto(7, "\5\0\0\0\31\347\0\0\0", 9, MSG_DONTWAIT, NULL, 0) = 9
1718139510.470352 (+ 0.000123) sendto(7, "\204\0\0\0\26select MIN(pl_id) AS min, MAX(pl_id) AS max from `wt_placelocation` group by `pl_parent_id`, `pl_place` having COUNT(*) > ? limit 1", 136, MSG_DONTWAIT, NULL, 0) = 136
1718139510.470406 (+ 0.000054) poll([{fd=7, events=POLLIN|POLLERR|POLLHUP}], 1, 86400000) = 1 ([{fd=7, revents=POLLIN}])
1718139510.470496 (+ 0.000092) recvfrom(7, "\f\0\0\1\0\350\0\0\0\2\0\1\0\0\0\0\27\0\0\2\3def\0\0\0\1?\0\f?\0\25\0\0\0\10\200\0\0\0\0\5\0\0\3\376\0\0\2\0\31\0\0\4\3def\0\0\0\3min\0\f?\0\v\0\0\0\3\200\0\0\0\0\31\0\0\5\3def\0\0\0\3max\0\f?\0\v\0\0\0\3\200\0\0\0\0\5\0\0\6\376\0\0\2\0", 32768, MSG_DONTWAIT, NULL, NULL) = 119
1718139510.470564 (+ 0.000066) sendto(7, "\20\0\0\0\27\350\0\0\0\0\1\0\0\0\0\1\375\0\0011", 20, MSG_DONTWAIT, NULL, 0) = 20
1718139510.470633 (+ 0.000070) poll([{fd=7, events=POLLIN|POLLERR|POLLHUP}], 1, 86400000) = 1 ([{fd=7, revents=POLLIN}])
1718139511.522841 (+ 1.052231) recvfrom(7, "\1\0\0\1\2\31\0\0\2\3def\0\0\0\3min\0\f?\0\v\0\0\0\3\0\20\0\0\0\31\0\0\3\3def\0\0\0\3max\0\f?\0\v\0\0\0\3\0\20\0\0\0\5\0\0\4\376\0\0\"\0\n\0\0\5\0\0`\225\0\0\352\333\0\0\5\0\0\6\376\0\0\"\10", 32768, MSG_DONTWAIT, NULL, NULL) = 95

"Failure is an amazing teacher." (L'échec est un professeur extraordinaire.)

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

More
5 months 3 weeks ago #13 by fisharebest
Replied by fisharebest on topic Composer require 7.4.0
> wt_placelocation

This table contains all your latitude/longitude coordinates.

The data is supposed to be hierarchical, but in 1.7 there were few checks, and it is possible to create non-hierarchical data. e.g. London is in England, and England is in London, etc.

I guess that there is an issue with this data.

You might want to make a copy of this table. e.g.

CREATE TABLE wt_place_location_copy AS SELECT * FROM wt_place_location;

Then delete the data. e.g.

DELETE FROM wt_place_location;

This will, of course, lose all your lat/long coords. But it should allow the upgrade to continue.

Alternatively if you feel confident, you can manually try to repair this table. Make sure that every record has a valid parent record. Make sure there are no duplicates (England and ENGLAND would count as a duplicate). etc.

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

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

  • Franz Frese
  • Away
  • Elite Member
  • Elite Member
More
5 months 3 weeks ago #14 by Franz Frese
Replied by Franz Frese on topic Composer require 7.4.0
Has there been a csv export of Geographic data in 1.7. So you do not loose all your coords.

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

  • thomas52
  • Topic Author
  • Offline
  • Premium Member
  • Premium Member
  • Western North Carolina
More
5 months 3 weeks ago #15 by thomas52
Replied by thomas52 on topic Composer require 7.4.0
Forgive my ignorance, but I don't know what you just said. I would surely not like to lose all my lat/longs.
That aside, I did find in my place list:
"... Japan, Okinawa
Kiribati
Kiribati, Tarawa
Korea (South)
Kuwait
Macomb
Macomb, Washington
Mexico
Mexico, Monterrey
Netherlands
Netherlands, Gelderland..."
Macomb & Macomb, Washington are not valid places. How do I delete or fix these errors?

"Failure is an amazing teacher." (L'échec est un professeur extraordinaire.)

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

  • Franz Frese
  • Away
  • Elite Member
  • Elite Member
More
5 months 3 weeks ago #16 by Franz Frese
Replied by Franz Frese on topic Composer require 7.4.0
in wt 2 you can export the coords to a human readable format (editor, excel, calc) , and reimport that in case of an accident.
Structure is:
Level;Place0;Longitude;Latitude;Zoom;Icon
where zoom and icon are empty.

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

  • thomas52
  • Topic Author
  • Offline
  • Premium Member
  • Premium Member
  • Western North Carolina
More
5 months 3 weeks ago #17 by thomas52
Replied by thomas52 on topic Composer require 7.4.0
Franz: Many thanks, but I would need more explicit instructions to save my lat/longs. BTW, my site is adkins.ws

"Failure is an amazing teacher." (L'échec est un professeur extraordinaire.)

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

  • thomas52
  • Topic Author
  • Offline
  • Premium Member
  • Premium Member
  • Western North Carolina
More
5 months 3 weeks ago #18 by thomas52
Replied by thomas52 on topic Composer require 7.4.0
Also, welcome suggestions on how to delete or fix my two "non-places."

"Failure is an amazing teacher." (L'échec est un professeur extraordinaire.)

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

More
5 months 3 weeks ago #19 by fisharebest
Replied by fisharebest on topic Composer require 7.4.0
If your 1.7 site is still running, then use the export function for the place locations. This will save them as a CSV file.

Then delete them from the database as above.

Then upgrade to 2.1.

Then import the CSV file.

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

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

  • thomas52
  • Topic Author
  • Offline
  • Premium Member
  • Premium Member
  • Western North Carolina
More
5 months 3 weeks ago #20 by thomas52
Replied by thomas52 on topic Composer require 7.4.0
I think I may need some professional assistance here. I know how to export a GEDCOM, but not how to export the place locations. I need to figure out how to fix or delete my two "non-places." And then I can get my site upgraded.

"Failure is an amazing teacher." (L'échec est un professeur extraordinaire.)

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

Powered by Kunena Forum