Web based family history software

Question webtree script for MySQL8

More
2 months 4 weeks ago - 2 months 3 weeks ago #1 by JAS90
webtree script for MySQL8 was created by JAS90
I have been asked by my hosting company to 'update the webtrees script to the latest version so that it runs with MySQL 8' as the server supporting MySQL 5.7, upon which my site is hosted, will close on the 19th August. As I am a novice when it comes to the innards of the operation of my webtrees application, I searched the forum to see how this should be done (I don't really understand what they want), but found nothing that relates to webtrees script applicable to MySQL 8. Please point me in the right direction (as jargon free as possible please!).
Last edit: 2 months 3 weeks ago by makitso.

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

  • norwegian_sardines
  • Offline
  • Platinum Member
  • Platinum Member
More
2 months 4 weeks ago #2 by norwegian_sardines
Replied by norwegian_sardines on topic Webtree script for MySQL8
What release of webtrees are you currently using?

Ken

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

More
2 months 4 weeks ago #3 by fisharebest
Replied by fisharebest on topic Webtree script for MySQL8
> 'update the webtrees script to the latest version so that it runs with MySQL 8'

webtrees works with MySQL 5.7 or later.
i.e. all versions from 5.7 to 9.0

You don't need to do anything to webtdrees.
Just upgrade MySQL on your server (or let your host do this).

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

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

More
2 months 4 weeks ago #4 by JAS90
Replied by JAS90 on topic Webtree script for MySQL8
1.7.11

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

More
2 months 4 weeks ago #5 by JAS90
Replied by JAS90 on topic Webtree script for MySQL8
When they did that the site produces blank pages, so the site was returned to the old server so I could fix the issue (if I knew how).

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

More
2 months 4 weeks ago - 2 months 4 weeks ago #6 by Lars1963
Replied by Lars1963 on topic Webtree script for MySQL8
You're using an old version of WT; 1.7.x has reached EOL a long time ago and does not support msql 8.

See webtrees.net/install/requirements/
Last edit: 2 months 4 weeks ago by Lars1963.

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

More
2 months 4 weeks ago #7 by JAS90
Replied by JAS90 on topic Webtree script for MySQL8
So I need to upgrade to a new version. I was trying to avoid that as it seems very challenging. Is there a simple way to do this?

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

More
2 months 4 weeks ago - 2 months 4 weeks ago #8 by Lars1963
Replied by Lars1963 on topic Webtree script for MySQL8
You'll have to do a manual upgrade, see  webtrees.net/upgrade/
Ist quite straight forward, but make sure to make a gedcom export as save backup before doing that. 
Last edit: 2 months 4 weeks ago by Lars1963.

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

More
2 months 4 weeks ago #9 by JAS90
Replied by JAS90 on topic Webtree script for MySQL8
Thanks. Will do that and when I mess up (which I will) I may be back!

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

More
2 months 4 weeks ago #10 by fisharebest
Replied by fisharebest on topic Webtree script for MySQL8
The blank page issue may be that you are using a older version of PHP that doesn't work with MySQL 8.

So don't forget to upgrade PHP as well. Usually, this is a config option in a control panel.

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

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

More
2 months 4 weeks ago - 2 months 4 weeks ago #11 by Lars1963
Replied by Lars1963 on topic Webtree script for MySQL8
Do not forget to read and follow the instructions here  webtrees.net/upgrade/2.0/
That's the only tricky part. 😂
Last edit: 2 months 4 weeks ago by Lars1963.

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

  • bertkoor
  • Offline
  • Platinum Member
  • Platinum Member
  • Greetings from Utrecht, Holland
More
2 months 4 weeks ago #12 by bertkoor
Replied by bertkoor on topic Webtree script for MySQL8
FYI, just yesterday I was forced to upgrade from 1.7 to 2.1, since my hosting provider switched my server to PHP 8.1.

I have just uploaded the php scripts (different folder on server since I also now use https) copied the data/config.ini.php and data/media/*.
Oh, and I added a line base_url=https:// to the config.ini.php

All seems to basically work as expected.

stamboom.BertKoor.nl runs on webtrees v2.1.20

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

More
2 months 4 weeks ago #13 by JAS90
Replied by JAS90 on topic Webtree script for MySQL8
Thanks. Hope all goes well 🤞🏼

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

More
2 months 3 weeks ago #14 by JAS90
Replied by JAS90 on topic Webtree script for MySQL8
My upgrade seems to be partially working, though there are a series of issues that require attention:
1) The media files are no longer connected to the individuals on the family tree and the media list indicates no files. How do I reconnect the photographs to the ged file?
2) Checking on the control panel leads to a list of what seem to be 94 data/upgrade errors. Furthermore, there is no possibility to get into the control panel itself of into the user list.
3) The national flags from the maps are missing. Is this a change to the programme or an issue with the upgrade.
4) The search function repeatedly notes too many results, making searching family lists very difficult. Can this be rectified?
5) Viewing a gedcom file for each individual only provides a snippet of the individual. Is it possible to still view and edit the complete individual gedcom files?

Sorry for so many issues, though the first two are the most urgent.

Any help on this issues would be appreciated.

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

More
2 months 3 weeks ago #15 by fisharebest
Replied by fisharebest on topic Webtree script for MySQL8
> ) The media files are no longer connected to the individuals on the family tree

The files are presumably still there on your server. What folder?

What setting do you have for the "data folder" in the website preferences in the control panel?
What setting do you have for the "media folder" in the family-tree preferences.

> Checking on the control panel leads to a list of what seem to be 94 data/upgrade errors

You will need to tell us what these errors are. They may well be harmless.

> 3) The national flags from the maps are missing

webtrees 2.0 does not use flags on the maps.

> 4) The search function repeatedly notes too many results

The search functions have a limit of 5000 results.

> 5) Viewing a gedcom file for each individual only provides a snippet of the individual.

Not sure what you are saying. From any record page, there is an edit menu that lets you view/edit the entire GEDCOM record.

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

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

More
2 months 3 weeks ago #16 by JAS90
Replied by JAS90 on topic Webtree script for MySQL8
Thanks for that. At this stage I cannot get into the control panel to check the media file destination. Pressing the control panel produces the following long error report:

Class 'finfo' not found …/vendor/league/mime-type-detection/src/FinfoMimeTypeDetector.php:48
#0 …/vendor/league/flysystem/src/Local/LocalFilesystemAdapter.php(96): League\MimeTypeDetection\FinfoMimeTypeDetector->__construct()
#1 …/app/Http/RequestHandlers/ControlPanel.php(135): League\Flysystem\Local\LocalFilesystemAdapter->__construct('/home/isdzijyd/...')
#2 …/app/Http/Middleware/RequestHandler.php(55): Fisharebest\Webtrees\Http\RequestHandlers\ControlPanel->handle(Object(Nyholm\Psr7\ServerRequest))
#3 …/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\RequestHandler->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher))
#4 …/app/Module/HitCountFooterModule.php(154): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest))
#5 …/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Module\HitCountFooterModule->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher))
#6 …/app/Module/CheckForNewVersion.php(122): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest))
#7 …/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Module\CheckForNewVersion->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher))
#8 …/app/Http/Middleware/AuthAdministrator.php(53): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest))
#9 …/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\AuthAdministrator->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher))
#10 …/app/Http/Middleware/CheckCsrf.php(80): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest))
#11 …/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\CheckCsrf->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher))
#12 …/vendor/oscarotero/middleland/src/Dispatcher.php(118): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest))
#13 …/app/Webtrees.php(275): Middleland\Dispatcher->dispatch(Object(Nyholm\Psr7\ServerRequest))
#14 …/app/Http/Middleware/Router.php(163): Fisharebest\Webtrees\Webtrees::dispatch(Object(Nyholm\Psr7\ServerRequest), Array)
#15 …/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\Router->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher))
#16 …/app/Http/Middleware/BootModules.php(58): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest))
#17 …/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\BootModules->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher))
#18 …/app/Http/Middleware/RegisterGedcomTags.php(54): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest))
#19 …/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\RegisterGedcomTags->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher))
#20 …/app/Http/Middleware/LoadRoutes.php(75): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest))
#21 …/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\LoadRoutes->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher))
#22 …/app/Http/Middleware/CheckForNewVersion.php(57): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest))
#23 …/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\CheckForNewVersion->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher))
#24 …/app/Http/Middleware/UseTransaction.php(45): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest))
#25 …/vendor/illuminate/database/Concerns/ManagesTransactions.php(29): Fisharebest\Webtrees\Http\Middleware\UseTransaction::Fisharebest\Webtrees\Http\Middleware\{closure}(Object(Illuminate\Database\MySqlConnection))
#26 …/app/Http/Middleware/UseTransaction.php(46): Illuminate\Database\Connection->transaction(Object(Closure), 3)
#27 …/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\UseTransaction->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher))
#28 …/app/Http/Middleware/DoHousekeeping.php(71): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest))
#29 …/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\DoHousekeeping->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher))
#30 …/app/Http/Middleware/UseTheme.php(67): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest))
#31 …/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\UseTheme->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher))
#32 …/app/Http/Middleware/CheckForMaintenanceMode.php(51): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest))
#33 …/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\CheckForMaintenanceMode->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher))
#34 …/app/Http/Middleware/UseLanguage.php(69): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest))
#35 …/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\UseLanguage->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher))
#36 …/app/Http/Middleware/UseSession.php(78): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest))
#37 …/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\UseSession->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher))
#38 …/app/Http/Middleware/UpdateDatabaseSchema.php(57): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest))
#39 …/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\UpdateDatabaseSchema->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher))
#40 …/app/Http/Middleware/UseDatabase.php(122): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest))
#41 …/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\UseDatabase->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher))
#42 …/app/Http/Middleware/BadBotBlocker.php(308): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest))
#43 …/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\BadBotBlocker->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher))
#44 …/app/Http/Middleware/CompressResponse.php(71): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest))
#45 …/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\CompressResponse->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher))
#46 …/app/Http/Middleware/ContentLength.php(40): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest))
#47 …/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\ContentLength->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher))
#48 …/vendor/middlewares/client-ip/src/ClientIp.php(65): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest))
#49 …/app/Http/Middleware/ClientIp.php(47): Middlewares\ClientIp->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher))
#50 …/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\ClientIp->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher))
#51 …/app/Http/Middleware/HandleExceptions.php(89): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest))
#52 …/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\HandleExceptions->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher))
#53 …/app/Http/Middleware/BaseUrl.php(73): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest))
#54 …/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\BaseUrl->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher))
#55 …/app/Http/Middleware/ReadConfigIni.php(68): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest))
#56 …/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\ReadConfigIni->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher))
#57 …/app/Http/Middleware/SecurityHeaders.php(48): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest))
#58 …/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\SecurityHeaders->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher))
#59 …/app/Http/Middleware/EmitResponse.php(57): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest))
#60 …/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\EmitResponse->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher))
#61 …/vendor/oscarotero/middleland/src/Dispatcher.php(118): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest))
#62 …/app/Webtrees.php(275): Middleland\Dispatcher->dispatch(Object(Nyholm\Psr7\ServerRequest))
#63 …/app/Webtrees.php(262): Fisharebest\Webtrees\Webtrees::dispatch(Object(Nyholm\Psr7\ServerRequest), Array)
#64 …/index.php(51): Fisharebest\Webtrees\Webtrees->httpRequest()
#65 {main}

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

More
2 months 3 weeks ago - 2 months 3 weeks ago #17 by Franz Frese
Replied by Franz Frese on topic Webtree script for MySQL8
what php-version did you activate?

afaik finfo is part of php since 5.3.0 .

I suppose you have to change your php version to a compatible one (see needs links above in previous messages or use this link ).
Last edit: 2 months 3 weeks ago by Franz Frese.

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

More
2 months 3 weeks ago #18 by JAS90
Replied by JAS90 on topic Webtree script for MySQL8
I am not entirely sure. On the server I see multiple php numbers and it is not clear to me which one I am using. I am very confused.

Do I select this myself, or is is done by the hosting company?

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

More
2 months 3 weeks ago #19 by fisharebest
Replied by fisharebest on topic Webtree script for MySQL8
> Class 'finfo' not found

PHP has a number of extensions. Many are included by default. fileinfo is one of those.

Sometimes, a web-host will provide a control-panel that allows you to add/remove PHP extensions. (Note that you must add them for each and every version of PHP that you use).

If not, then you will need to raise a ticket with your provider to ask them to install/enable the necessary PHP extensions. There is a list of them here:

github.com/fisharebest/webtrees/blob/2.1...omposer.json#L33-L44

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

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

More
2 months 3 weeks ago #20 by Franz Frese
Replied by Franz Frese on topic Webtree script for MySQL8
see here
and or ask your provider.

create a php-file with the following content:
Code:
<?php phpinfo(); ?>

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

Powered by Kunena Forum