Question 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?

At what step of updating do you get that message?

Afaik there is no need for execution of the composer.

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. 

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.

You do not get the message above at downloading the webtrees zip: So again ? At what step do you get the error message?

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?

I have restored backup. I am at adkins.ws
Many thanks for guidance.

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.

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.

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?

thomas52 wrote:

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

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

> 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.

Has there been a csv export of Geographic data in 1.7. So you do not loose all your coords.

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?

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.

Franz: Many thanks, but I would need more explicit instructions to save my lat/longs. BTW, my site is adkins.ws

Also, welcome suggestions on how to delete or fix my two "non-places."

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.

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.