Web based family history software

Solved 404 error page after upgrading from 1.7.20 to 2.0.26

  • littlegolf
  • Topic Author
  • Offline
  • New Member
  • New Member
More
1 year 5 months ago - 1 year 4 months ago #1 by littlegolf
Hi to all,
I have 2 (old) webtrees sites on 2 differents subfolders ( www.mariogolfetto.it/webtrees/golfetty and www.mariogolfetto.it/durigon ) hosted by Aruba.
PHP Version 7.3.33 (for now)
Today I tried to update the first site: I read webtrees.net/upgrade/manual/ and webtrees.net/upgrade/2.0/
So I copied files, I modified config.ini.php (two rows added) and I deleted old php files (but not index.php).
No symbolic links in /data or /../; I don't use robot.txt or sitemap.xml

Now, the problem is: I get no homepage with 404 error page.
The link I read on browser "shots" to a public tree (no login nedded) without succeed.

How I can fix?
PS: The second installation of webtrees is the same of the first, but I don't upgrade for now.

EDIT:
I setup the site in offline mode for security reasons.

Mario Golfetto | OpenSource & debian enthusiastic fan
[I'm sorry for my english...]
Last edit: 1 year 4 months ago by littlegolf. Reason: solved.

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

More
1 year 5 months ago - 1 year 5 months ago #2 by Franz Frese
1. you have to replace all files from the distribution (unpacked files from github.com/fisharebest/webtrees/releases.../webtrees-2.0.26.zip ): index.php too !!!!

for www.mariogolfetto.it/webtrees/golfetty/ you have to:
Delete the file data/offline.txt
Last edit: 1 year 5 months ago by Franz Frese.

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

  • littlegolf
  • Topic Author
  • Offline
  • New Member
  • New Member
More
1 year 5 months ago #3 by littlegolf
Hi Franz,

thanks!

I yet replaced the file of zip file downloade from github.
Have I to do it again?

Mario Golfetto | OpenSource & debian enthusiastic fan
[I'm sorry for my english...]

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

More
1 year 5 months ago #4 by Franz Frese

Hi Franz,

thanks!

I yet replaced the file of zip file downloade from github.
Have I to do it again?
That is your decision. The uploaded files do not change themselfs. But if you are not sure that they are already replaced and up to date.

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

More
1 year 5 months ago #5 by hermann
Please check that you have deleted the folder /modules_v3 because the old custom modules are not compatible with the new version of webtrees. There should be an empty folder /modules_v4.

You can check the upgrade information in the German webtrees manual , maybe translating them to Italian by using the function in your browser.

Hermann
Designer of the custom module "Extended Family"

webtrees 2.1.21 (all custom modules installed, PHP 8.3.12, MariaDB 10.6) @ ahnen.hartenthaler.eu

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

More
1 year 5 months ago - 1 year 5 months ago #6 by fisharebest
Did you set the correct "base_url" for each site? (in the file config.ini.php).

webtrees.net/upgrade/2.0/

Greg Roach - greg@subaqua.co.uk - @fisharebest@phpc.social - fisharebest.webtrees.net
Last edit: 1 year 5 months ago by fisharebest.

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

  • littlegolf
  • Topic Author
  • Offline
  • New Member
  • New Member
More
1 year 5 months ago #7 by littlegolf

Did you set the correct "base_url" for each site? (in the file config.ini.php).

webtrees.net/upgrade/2.0/

Yes (only for the updated site, the first)

Mario Golfetto | OpenSource & debian enthusiastic fan
[I'm sorry for my english...]

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

  • littlegolf
  • Topic Author
  • Offline
  • New Member
  • New Member
More
1 year 5 months ago #8 by littlegolf

Please check that you have deleted the folder /modules_v3 because the old custom modules are not compatible with the new version of webtrees. There should be an empty folder /modules_v4.

You can check the upgrade information in the German webtrees manual , maybe translating them to Italian by using the function in your browser.

Thanks for your messagge.
I renamed the folder, no changes...

Mario Golfetto | OpenSource & debian enthusiastic fan
[I'm sorry for my english...]

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

  • littlegolf
  • Topic Author
  • Offline
  • New Member
  • New Member
More
1 year 5 months ago #9 by littlegolf

Hi Franz,

thanks!

I yet replaced the file of zip file downloade from github.
Have I to do it again?
That is your decision. The uploaded files do not change themselfs. But if you are not sure that they are already replaced and up to date.

Thank you.
I'm now uploading the files.

Mario Golfetto | OpenSource & debian enthusiastic fan
[I'm sorry for my english...]

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

More
1 year 5 months ago - 1 year 5 months ago #10 by Franz Frese

Did you set the correct "base_url" for each site? (in the file config.ini.php).

webtrees.net/upgrade/2.0/

Yes (only for the updated site, the first)
What is it?
If your answer is only yes.....
Last edit: 1 year 5 months ago by Franz Frese.

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

  • littlegolf
  • Topic Author
  • Offline
  • New Member
  • New Member
More
1 year 5 months ago #11 by littlegolf

You can check the upgrade information in the German webtrees manual , maybe translating them to Italian by using the function in your browser.

Thank you for the link to the german manual!

Mario Golfetto | OpenSource & debian enthusiastic fan
[I'm sorry for my english...]

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

  • littlegolf
  • Topic Author
  • Offline
  • New Member
  • New Member
More
1 year 5 months ago #12 by littlegolf

Did you set the correct "base_url" for each site? (in the file config.ini.php).

webtrees.net/upgrade/2.0/

Yes (only for the updated site, the first)
What is it?
If your answer is only yes.....

Yes, I mean that I set the config.ini.php file for www.mariogolfetto.it/webtrees/golfetty , not for each

Mario Golfetto | OpenSource & debian enthusiastic fan
[I'm sorry for my english...]

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

More
1 year 5 months ago #13 by Franz Frese
But what is the content for base-url?

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

  • littlegolf
  • Topic Author
  • Offline
  • New Member
  • New Member
More
1 year 5 months ago #14 by littlegolf

I'm now uploading the files.

Files and /data just uploaded; config.ini.php ok, but... same 404 error page.

Mario Golfetto | OpenSource & debian enthusiastic fan
[I'm sorry for my english...]

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

  • littlegolf
  • Topic Author
  • Offline
  • New Member
  • New Member
More
1 year 5 months ago #15 by littlegolf

But what is the content for base-url?

last 2 rows:
Code:
base_url="https://www.mariogolfetto.it/webtrees/golfetty" rewrite_urls="1"

Mario Golfetto | OpenSource & debian enthusiastic fan
[I'm sorry for my english...]

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

  • littlegolf
  • Topic Author
  • Offline
  • New Member
  • New Member
More
1 year 5 months ago - 1 year 5 months ago #16 by littlegolf

But what is the content for base-url?

last 2 rows:
Code:
base_url="https://www.mariogolfetto.it/webtrees/golfetty" rewrite_urls="1"

I just deleted the last row
Code:
rewrite_urls="1"

I now get the site but I read various messagges in the central box:
Code:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'wt' in 'field list' (SQL: select `wt-g_individuals`.*, wt-g_death.d_julianday2 - wt-g_birth.d_julianday1 AS days from `wt-g_individuals` inner join `wt-g_dates` as `wt-g_birth` on `wt-g_birth`.`d_file` = `i_file` and `wt-g_birth`.`d_gid` = `i_id` inner join `wt-g_dates` as `wt-g_death` on `wt-g_death`.`d_file` = `i_file` and `wt-g_death`.`d_gid` = `i_id` where `i_file` = 3 and `wt-g_birth`.`d_fact` = BIRT and `wt-g_death`.`d_fact` = DEAT and `wt-g_death`.`d_julianday1` >= `wt-g_birth`.`d_julianday2` and `wt-g_birth`.`d_julianday2` <> 0 order by `days` desc limit 1) …/vendor/illuminate/database/Connection.php:664 #0 …/vendor/illuminate/database/Connection.php(624): Illuminate\Database\Connection->runQueryCallback('select `wt-g_in...', Array, Object(Closure)) #1 …/vendor/illuminate/database/Connection.php(333): Illuminate\Database\Connection->run('select `wt-g_in...', Array, Object(Closure)) #2 …/vendor/illuminate/database/Query/Builder.php(2130): Illuminate\Database\Connection->select('select `wt-g_in...', Array, true) #3 …/vendor/illuminate/database/Query/Builder.php(2118): Illuminate\Database\Query\Builder->runSelect() #4 …/vendor/illuminate/database/Query/Builder.php(2604): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}() #5 …/vendor/illuminate/database/Query/Builder.php(2119): Illuminate\Database\Query\Builder->onceWithColumns(Array, Object(Closure)) #6 …/vendor/illuminate/database/Concerns/BuildsQueries.php(77): Illuminate\Database\Query\Builder->get(Array) #7 …/app/Statistics/Repository/IndividualRepository.php(824): Illuminate\Database\Query\Builder->first() #8 …/app/Statistics/Repository/IndividualRepository.php(857): Fisharebest\webtrees\Statistics\Repository\IndividualRepository->longlifeQuery('full', 'BOTH') #9 …/app/Statistics.php(1130): Fisharebest\webtrees\Statistics\Repository\IndividualRepository->longestLife() #10 …/resources/views/modules/gedcom_stats/statistics.phtml(214): Fisharebest\webtrees\Statistics->longestLife() #11 …/app/View.php(184): include('/web/htdocs/www...') #12 …/app/View.php(279): Fisharebest\webtrees\View->render() #13 …/app/Helpers/functions.php(200): Fisharebest\webtrees\View::make('modules/gedcom_...', Array) #14 …/app/Module/FamilyTreeStatisticsModule.php(160): view('modules/gedcom_...', Array) #15 …/app/Http/RequestHandlers/TreePageBlock.php(70): Fisharebest\webtrees\Module\FamilyTreeStatisticsModule->getBlock(Object(Fisharebest\webtrees\Tree), 155, 'tree') #16 …/app/Http/Middleware/WrapHandler.php(83): Fisharebest\webtrees\Http\RequestHandlers\TreePageBlock->handle(Object(Nyholm\Psr7\ServerRequest)) #17 …/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\WrapHandler->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #18 …/app/Module/HitCountFooterModule.php(157): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #19 …/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\webtrees\Module\HitCountFooterModule->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #20 …/app/Http/Middleware/CheckCsrf.php(75): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #21 …/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\CheckCsrf->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #22 …/vendor/oscarotero/middleland/src/Dispatcher.php(118): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #23 …/app/Http/Middleware/Router.php(166): Middleland\Dispatcher->dispatch(Object(Nyholm\Psr7\ServerRequest)) #24 …/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\Router->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #25 …/app/Http/Middleware/BootModules.php(62): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #26 …/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\BootModules->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #27 …/app/Http/Middleware/LoadRoutes.php(76): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #28 …/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\LoadRoutes->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #29 …/app/Http/Middleware/UseTransaction.php(45): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #30 …/vendor/illuminate/database/Concerns/ManagesTransactions.php(29): Fisharebest\webtrees\Http\Middleware\UseTransaction::Fisharebest\webtrees\Http\Middleware\{closure}(Object(Illuminate\Database\MySqlConnection)) #31 …/app/Http/Middleware/UseTransaction.php(46): Illuminate\Database\Connection->transaction(Object(Closure), 3) #32 …/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\UseTransaction->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #33 …/app/Http/Middleware/DoHousekeeping.php(74): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #34 …/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\DoHousekeeping->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #35 …/app/Http/Middleware/UseTheme.php(70): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #36 …/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\UseTheme->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #37 …/app/Http/Middleware/CheckForMaintenanceMode.php(51): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #38 …/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\CheckForMaintenanceMode->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #39 …/app/Http/Middleware/UseLanguage.php(70): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #40 …/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\UseLanguage->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #41 …/app/Http/Middleware/UseSession.php(71): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #42 …/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\UseSession->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #43 …/app/Http/Middleware/UpdateDatabaseSchema.php(58): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #44 …/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\UpdateDatabaseSchema->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #45 …/app/Http/Middleware/UseDatabase.php(117): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #46 …/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\UseDatabase->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #47 …/app/Http/Middleware/BadBotBlocker.php(223): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #48 …/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\BadBotBlocker->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #49 …/app/Http/Middleware/CompressResponse.php(75): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #50 …/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\CompressResponse->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #51 …/app/Http/Middleware/ContentLength.php(40): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #52 …/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\ContentLength->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #53 …/vendor/middlewares/client-ip/src/ClientIp.php(81): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #54 …/app/Http/Middleware/ClientIp.php(47): Middlewares\ClientIp->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #55 …/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\ClientIp->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #56 …/app/Http/Middleware/HandleExceptions.php(90): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #57 …/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\HandleExceptions->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #58 …/app/Http/Middleware/BaseUrl.php(77): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #59 …/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\BaseUrl->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #60 …/app/Http/Middleware/ReadConfigIni.php(69): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #61 …/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\ReadConfigIni->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #62 …/app/Http/Middleware/SecurityHeaders.php(48): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #63 …/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\SecurityHeaders->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #64 …/app/Http/Middleware/EmitResponse.php(57): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #65 …/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\EmitResponse->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #66 …/vendor/oscarotero/middleland/src/Dispatcher.php(118): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #67 …/app/webtrees.php(239): Middleland\Dispatcher->dispatch(Object(Nyholm\Psr7\ServerRequest)) #68 …/app/webtrees.php(226): Fisharebest\webtrees\webtrees::dispatch(Object(Nyholm\Psr7\ServerRequest), Array) #69 …/index.php(44): Fisharebest\webtrees\webtrees->httpRequest() #70 {main}

Curiously, when I log in, I don't get the error messagges, but my account is not tha administrator (instead I'm sure yes!)

Mario Golfetto | OpenSource & debian enthusiastic fan
[I'm sorry for my english...]
Last edit: 1 year 5 months ago by littlegolf.

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

More
1 year 5 months ago - 1 year 5 months ago #17 by Franz Frese
So now you changed something.
No longer 404 but a database error.

So that is now, where to look

?reinstall your db backup

I am not the expert for switching the db from 1.7 to 2.0
Last edit: 1 year 5 months ago by Franz Frese.

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

  • littlegolf
  • Topic Author
  • Offline
  • New Member
  • New Member
More
1 year 5 months ago - 1 year 5 months ago #18 by littlegolf

So now you changed something.
?reinstall your db backup

I am not the expert for switching the db from 1.7 to 2.0

I just deleted the db tables and uploaded the db backup: same errors...
Thanks for your help and time!

Mario Golfetto | OpenSource & debian enthusiastic fan
[I'm sorry for my english...]
Last edit: 1 year 5 months ago by littlegolf.

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

More
1 year 5 months ago #19 by Franz Frese

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

More
1 year 5 months ago #20 by hermann
There is a prefix for the tables defined in config.ini.php (like wt_). It should be the same as it is used in the names of the database tables.

Hermann
Designer of the custom module "Extended Family"

webtrees 2.1.21 (all custom modules installed, PHP 8.3.12, MariaDB 10.6) @ ahnen.hartenthaler.eu

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

Powered by Kunena Forum