Hallo zusammen,
als ich jetzt nach längerer Pause mal wieder Webtrees aufgerufen habe, erhielt ich auf der ersten Seite folgende Fehlermeldung:
SQLSTATE[HY000]: General error: 1030 Got error 194 „Tablespace is missing for a table“ from storage engine InnoDB (Connection: default, SQL: select distinct
wt_individuals.* fromwt_individualsinner joinwt_datesoni_file=d_fileandi_id=d_gidwherei_file= 4 andd_fact= _TODO andd_julianday1< 5373484) …/vendor/illuminate/database/Connection.php:824 #0 …/vendor/illuminate/database/Connection.php(778): Illuminate\Database\Connection->runQueryCallback() #1 …/vendor/illuminate/database/Connection.php(397): Illuminate\Database\Connection->run() #2 …/vendor/illuminate/database/Query/Builder.php(3188): Illuminate\Database\Connection->select() #3 …/vendor/illuminate/database/Query/Builder.php(3173): Illuminate\Database\Query\Builder->runSelect() #4 …/vendor/illuminate/database/Query/Builder.php(3763): Illuminate\Database\Query\Builder->{closure:Illuminate\Database\Query\Builder::get():3172}() #5 …/vendor/illuminate/database/Query/Builder.php(3172): Illuminate\Database\Query\Builder->onceWithColumns() #6 …/app/Module/ResearchTaskModule.php(166): Illuminate\Database\Query\Builder->get() #7 …/app/Module/ResearchTaskModule.php(100): Fisharebest\Webtrees\Module\ResearchTaskModule->individualsWithTasks() #8 …/resources/views/user-page-block.phtml(20): Fisharebest\Webtrees\Module\ResearchTaskModule->getBlock() #9 …/app/View.php(183): include(‚…‘) #10 …/app/View.php(278): Fisharebest\Webtrees\View->render() #11 …/app/Helpers/functions.php(126): Fisharebest\Webtrees\View::make() #12 …/resources/views/user-page.phtml(30): view() #13 …/app/View.php(183): include(‚…‘) #14 …/app/View.php(278): Fisharebest\Webtrees\View->render() #15 …/app/Helpers/functions.php(126): Fisharebest\Webtrees\View::make() #16 …/app/Http/ViewResponseTrait.php(51): view() #17 …/app/Http/RequestHandlers/UserPage.php(80): Fisharebest\Webtrees\Http\RequestHandlers\UserPage->viewResponse() #18 …/app/Http/Middleware/RequestHandler.php(52): Fisharebest\Webtrees\Http\RequestHandlers\UserPage->handle() #19 …/app/Http/Dispatcher.php(76): Fisharebest\Webtrees\Http\Middleware\RequestHandler->process() #20 …/modules_v4/vesta_research_suggestions/ResearchSuggestionsModule.php(276): Psr\Http\Server\RequestHandlerInterface@anonymous->handle() #21 …/app/Http/Dispatcher.php(76): Cissee\Webtrees\Module\ResearchSuggestions\ResearchSuggestionsModule->process() #22 …/app/Module/HitCountFooterModule.php(149): Psr\Http\Server\RequestHandlerInterface@anonymous->handle() #23 …/app/Http/Dispatcher.php(76): Fisharebest\Webtrees\Module\HitCountFooterModule->process() #24 …/app/Module/CheckForNewVersion.php(112): Psr\Http\Server\RequestHandlerInterface@anonymous->handle() #25 …/app/Http/Dispatcher.php(76): Fisharebest\Webtrees\Module\CheckForNewVersion->process() #26 …/app/Http/Middleware/CheckCsrf.php(80): Psr\Http\Server\RequestHandlerInterface@anonymous->handle() #27 …/app/Http/Dispatcher.php(76): Fisharebest\Webtrees\Http\Middleware\CheckCsrf->process() #28 …/app/Http/Middleware/AuthLoggedIn.php(50): Psr\Http\Server\RequestHandlerInterface@anonymous->handle() #29 …/app/Http/Dispatcher.php(76): Fisharebest\Webtrees\Http\Middleware\AuthLoggedIn->process() #30 …/app/Http/Dispatcher.php(47): Psr\Http\Server\RequestHandlerInterface@anonymous->handle() #31 …/app/Http/Middleware/Router.php(136): Fisharebest\Webtrees\Http\Dispatcher::dispatch() #32 …/app/Http/Dispatcher.php(76): Fisharebest\Webtrees\Http\Middleware\Router->process() #33 …/app/Http/Middleware/BootModules.php(58): Psr\Http\Server\RequestHandlerInterface@anonymous->handle() #34 …/app/Http/Dispatcher.php(76): Fisharebest\Webtrees\Http\Middleware\BootModules->process() #35 …/app/Http/Middleware/RegisterGedcomTags.php(54): Psr\Http\Server\RequestHandlerInterface@anonymous->handle() #36 …/app/Http/Dispatcher.php(76): Fisharebest\Webtrees\Http\Middleware\RegisterGedcomTags->process() #37 …/app/Http/Middleware/LoadRoutes.php(75): Psr\Http\Server\RequestHandlerInterface@anonymous->handle() #38 …/app/Http/Dispatcher.php(76): Fisharebest\Webtrees\Http\Middleware\LoadRoutes->process() #39 …/app/Http/Middleware/CheckForNewVersion.php(57): Psr\Http\Server\RequestHandlerInterface@anonymous->handle() #40 …/app/Http/Dispatcher.php(76): Fisharebest\Webtrees\Http\Middleware\CheckForNewVersion->process() #41 …/app/Http/Middleware/UseTransaction.php(45): Psr\Http\Server\RequestHandlerInterface@anonymous->handle() #42 …/vendor/illuminate/database/Concerns/ManagesTransactions.php(32): Fisharebest\Webtrees\Http\Middleware\UseTransaction::{closure:Fisharebest\Webtrees\Http\Middleware\UseTransaction::process():44}() #43 …/app/Http/Middleware/UseTransaction.php(44): Illuminate\Database\Connection->transaction() #44 …/app/Http/Dispatcher.php(76): Fisharebest\Webtrees\Http\Middleware\UseTransaction->process() #45 …/app/Http/Middleware/DoHousekeeping.php(71): Psr\Http\Server\RequestHandlerInterface@anonymous->handle() #46 …/app/Http/Dispatcher.php(76): Fisharebest\Webtrees\Http\Middleware\DoHousekeeping->process() #47 …/app/Http/Middleware/UseTheme.php(66): Psr\Http\Server\RequestHandlerInterface@anonymous->handle() #48 …/app/Http/Dispatcher.php(76): Fisharebest\Webtrees\Http\Middleware\UseTheme->process() #49 …/app/Http/Middleware/CheckForMaintenanceMode.php(51): Psr\Http\Server\RequestHandlerInterface@anonymous->handle() #50 …/app/Http/Dispatcher.php(76): Fisharebest\Webtrees\Http\Middleware\CheckForMaintenanceMode->process() #51 …/app/Http/Middleware/UseLanguage.php(67): Psr\Http\Server\RequestHandlerInterface@anonymous->handle() #52 …/app/Http/Dispatcher.php(76): Fisharebest\Webtrees\Http\Middleware\UseLanguage->process() #53 …/app/Http/Middleware/UseSession.php(78): Psr\Http\Server\RequestHandlerInterface@anonymous->handle() #54 …/app/Http/Dispatcher.php(76): Fisharebest\Webtrees\Http\Middleware\UseSession->process() #55 …/app/Http/Middleware/UpdateDatabaseSchema.php(57): Psr\Http\Server\RequestHandlerInterface@anonymous->handle() #56 …/app/Http/Dispatcher.php(76): Fisharebest\Webtrees\Http\Middleware\UpdateDatabaseSchema->process() #57 …/app/Http/Middleware/UseDatabase.php(56): Psr\Http\Server\RequestHandlerInterface@anonymous->handle() #58 …/app/Http/Dispatcher.php(76): Fisharebest\Webtrees\Http\Middleware\UseDatabase->process() #59 …/app/Http/Middleware/BadBotBlocker.php(351): Psr\Http\Server\RequestHandlerInterface@anonymous->handle() #60 …/app/Http/Dispatcher.php(76): Fisharebest\Webtrees\Http\Middleware\BadBotBlocker->process() #61 …/app/Http/Middleware/CompressResponse.php(65): Psr\Http\Server\RequestHandlerInterface@anonymous->handle() #62 …/app/Http/Dispatcher.php(76): Fisharebest\Webtrees\Http\Middleware\CompressResponse->process() #63 …/app/Http/Middleware/ContentLength.php(40): Psr\Http\Server\RequestHandlerInterface@anonymous->handle() #64 …/app/Http/Dispatcher.php(76): Fisharebest\Webtrees\Http\Middleware\ContentLength->process() #65 …/vendor/middlewares/client-ip/src/ClientIp.php(68): Psr\Http\Server\RequestHandlerInterface@anonymous->handle() #66 …/app/Http/Middleware/ClientIp.php(47): Middlewares\ClientIp->process() #67 …/app/Http/Dispatcher.php(76): Fisharebest\Webtrees\Http\Middleware\ClientIp->process() #68 …/app/Http/Middleware/PublicFiles.php(62): Psr\Http\Server\RequestHandlerInterface@anonymous->handle() #69 …/app/Http/Dispatcher.php(76): Fisharebest\Webtrees\Http\Middleware\PublicFiles->process() #70 …/app/Http/Middleware/HandleExceptions.php(84): Psr\Http\Server\RequestHandlerInterface@anonymous->handle() #71 …/app/Http/Dispatcher.php(76): Fisharebest\Webtrees\Http\Middleware\HandleExceptions->process() #72 …/app/Http/Middleware/SecurityHeaders.php(49): Psr\Http\Server\RequestHandlerInterface@anonymous->handle() #73 …/app/Http/Dispatcher.php(76): Fisharebest\Webtrees\Http\Middleware\SecurityHeaders->process() #74 …/app/Http/Middleware/BaseUrl.php(73): Psr\Http\Server\RequestHandlerInterface@anonymous->handle() #75 …/app/Http/Dispatcher.php(76): Fisharebest\Webtrees\Http\Middleware\BaseUrl->process() #76 …/app/Http/Middleware/ReadConfigIni.php(68): Psr\Http\Server\RequestHandlerInterface@anonymous->handle() #77 …/app/Http/Dispatcher.php(76): Fisharebest\Webtrees\Http\Middleware\ReadConfigIni->process() #78 …/app/Http/Middleware/EmitResponse.php(55): Psr\Http\Server\RequestHandlerInterface@anonymous->handle() #79 …/app/Http/Dispatcher.php(76): Fisharebest\Webtrees\Http\Middleware\EmitResponse->process() #80 …/app/Http/Middleware/ErrorHandler.php(38): Psr\Http\Server\RequestHandlerInterface@anonymous->handle() #81 …/app/Http/Dispatcher.php(76): Fisharebest\Webtrees\Http\Middleware\ErrorHandler->process() #82 …/app/Http/Dispatcher.php(47): Psr\Http\Server\RequestHandlerInterface@anonymous->handle() #83 …/app/Webtrees.php(274): Fisharebest\Webtrees\Http\Dispatcher::dispatch() #84 …/app/Webtrees.php(247): Fisharebest\Webtrees\Webtrees->httpRequest() #85 …/index.php(24): Fisharebest\Webtrees\Webtrees->run() #86 {main}
Alle anderen Seiten funktionieren - soweit ich das bisher prüfen konnte - einwandfrei. Bei welcher Gelegenheit diese Fehlermeldung zum ersten Mal auftrat, kann ich leider nicht sagen. Leider sind alle funktionierenden Backups jetzt bereits mit der fehlerhaltigen Version überschrieben.
Kann mitr jemand einen Tipp geben, wie ich diesen Fehler in der Datenbank wieder geradebiegen kann?
Herzlichen Dank
Ulrich Rosenkranz