Question Composer require 7.4.0
- thomas52
- Topic Author
- Offline
- Premium Member
- Western North Carolina
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
Afaik there is no need for execution of the composer.
Please Log in or Create an account to join the conversation.
- Lars1963
- Offline
- Junior Member
- Posts: 231
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.
Please Log in or Create an account to join the conversation.
- thomas52
- Topic Author
- Offline
- Premium Member
- Western North Carolina
"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
Please Log in or Create an account to join the conversation.
- thomas52
- Topic Author
- Offline
- Premium Member
- Western North Carolina
"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
- Western North Carolina
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
- Western North Carolina
"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
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.
Please Log in or Create an account to join the conversation.
- thomas52
- Topic Author
- Offline
- Premium Member
- Western North Carolina
/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.
- fisharebest
- Offline
- Administrator
webtrees 1.7 runs on PHP 5.3 - 7.3I 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 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
- Western North Carolina
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.
- fisharebest
- Offline
- Administrator
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
Please Log in or Create an account to join the conversation.
- thomas52
- Topic Author
- Offline
- Premium Member
- Western North Carolina
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
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
- Western North Carolina
"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
- Western North Carolina
"Failure is an amazing teacher." (L'échec est un professeur extraordinaire.)
Please Log in or Create an account to join the conversation.
- fisharebest
- Offline
- Administrator
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
- Western North Carolina
"Failure is an amazing teacher." (L'échec est un professeur extraordinaire.)
Please Log in or Create an account to join the conversation.