What type of hardware are you using: VPS bought online
What YunoHost version are you running: 12.0.12
What app is this about: Webtrees
Describe your issue
I installed Webtrees using the web admin ui and started the app. The result was the error message below.
Thank you in advance for any help!
Share relevant logs or error messages
Web page content at /webtrees:
PDOException: SQLSTATE[HY000]: General error: 1005 Can’t create table webtrees.wt_module_privacy (errno: 150 “Foreign key constraint is incorrectly formed”) in /var/www/webtrees/vendor/illuminate/database/Connection.php:571
Stack trace:
#0 /var/www/webtrees/vendor/illuminate/database/Connection.php(571): PDOStatement->execute()
#1 /var/www/webtrees/vendor/illuminate/database/Connection.php(812): Illuminate\Database\Connection->Illuminate\Database{closure}()
#2 /var/www/webtrees/vendor/illuminate/database/Connection.php(779): Illuminate\Database\Connection->runQueryCallback()
#3 /var/www/webtrees/vendor/illuminate/database/Connection.php(560): Illuminate\Database\Connection->run()
#4 /var/www/webtrees/vendor/illuminate/database/Schema/Blueprint.php(117): Illuminate\Database\Connection->statement()
#5 /var/www/webtrees/vendor/illuminate/database/Schema/Builder.php(564): Illuminate\Database\Schema\Blueprint->build()
#6 /var/www/webtrees/vendor/illuminate/database/Schema/Builder.php(418): Illuminate\Database\Schema\Builder->build()
#7 /var/www/webtrees/app/Schema/Migration42.php(56): Illuminate\Database\Schema\Builder->create()
#8 /var/www/webtrees/app/Services/MigrationService.php(61): Fisharebest\Webtrees\Schema\Migration42->upgrade()
#9 /var/www/webtrees/app/Http/Middleware/UpdateDatabaseSchema.php(55): Fisharebest\Webtrees\Services\MigrationService->updateSchema()
#10 /var/www/webtrees/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\UpdateDatabaseSchema->process()
#11 /var/www/webtrees/app/Http/Middleware/UseDatabase.php(60): Middleland\Dispatcher->handle()
#12 /var/www/webtrees/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\UseDatabase->process()
#13 /var/www/webtrees/app/Http/Middleware/BadBotBlocker.php(308): Middleland\Dispatcher->handle()
#14 /var/www/webtrees/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\BadBotBlocker->process()
#15 /var/www/webtrees/app/Http/Middleware/CompressResponse.php(71): Middleland\Dispatcher->handle()
#16 /var/www/webtrees/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\CompressResponse->process()
#17 /var/www/webtrees/app/Http/Middleware/ContentLength.php(40): Middleland\Dispatcher->handle()
#18 /var/www/webtrees/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\ContentLength->process()
#19 /var/www/webtrees/vendor/middlewares/client-ip/src/ClientIp.php(65): Middleland\Dispatcher->handle()
#20 /var/www/webtrees/app/Http/Middleware/ClientIp.php(47): Middlewares\ClientIp->process()
#21 /var/www/webtrees/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\ClientIp->process()
#22 /var/www/webtrees/app/Http/Middleware/PublicFiles.php(62): Middleland\Dispatcher->handle()
#23 /var/www/webtrees/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\PublicFiles->process()
#24 /var/www/webtrees/app/Http/Middleware/HandleExceptions.php(89): Middleland\Dispatcher->handle()
#25 /var/www/webtrees/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\HandleExceptions->process()
#26 /var/www/webtrees/app/Http/Middleware/SecurityHeaders.php(49): Middleland\Dispatcher->handle()
#27 /var/www/webtrees/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\SecurityHeaders->process()
#28 /var/www/webtrees/app/Http/Middleware/BaseUrl.php(73): Middleland\Dispatcher->handle()
#29 /var/www/webtrees/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\BaseUrl->process()
#30 /var/www/webtrees/app/Http/Middleware/ReadConfigIni.php(68): Middleland\Dispatcher->handle()
#31 /var/www/webtrees/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\ReadConfigIni->process()
#32 /var/www/webtrees/app/Http/Middleware/EmitResponse.php(57): Middleland\Dispatcher->handle()
#33 /var/www/webtrees/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\EmitResponse->process()
#34 /var/www/webtrees/app/Http/Middleware/ErrorHandler.php(38): Middleland\Dispatcher->handle()
#35 /var/www/webtrees/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\ErrorHandler->process()
#36 /var/www/webtrees/vendor/oscarotero/middleland/src/Dispatcher.php(118): Middleland\Dispatcher->handle()
#37 /var/www/webtrees/app/Webtrees.php(280): Middleland\Dispatcher->dispatch()
#38 /var/www/webtrees/app/Webtrees.php(251): Fisharebest\Webtrees\Webtrees->httpRequest()
#39 /var/www/webtrees/index.php(24): Fisharebest\Webtrees\Webtrees->run()
#40 {main}
Next Illuminate\Database\QueryException: SQLSTATE[HY000]: General error: 1005 Can’t create table webtrees.wt_module_privacy (errno: 150 “Foreign key constraint is incorrectly formed”) (Connection: default, SQL: alter table wt_module_privacy add constraint wt_module_privacy_module_name_foreign foreign key (module_name) references wt_module (module_name) on delete cascade) in /var/www/webtrees/vendor/illuminate/database/Connection.php:825
Stack trace:
#0 /var/www/webtrees/vendor/illuminate/database/Connection.php(779): Illuminate\Database\Connection->runQueryCallback()
#1 /var/www/webtrees/vendor/illuminate/database/Connection.php(560): Illuminate\Database\Connection->run()
#2 /var/www/webtrees/vendor/illuminate/database/Schema/Blueprint.php(117): Illuminate\Database\Connection->statement()
#3 /var/www/webtrees/vendor/illuminate/database/Schema/Builder.php(564): Illuminate\Database\Schema\Blueprint->build()
#4 /var/www/webtrees/vendor/illuminate/database/Schema/Builder.php(418): Illuminate\Database\Schema\Builder->build()
#5 /var/www/webtrees/app/Schema/Migration42.php(56): Illuminate\Database\Schema\Builder->create()
#6 /var/www/webtrees/app/Services/MigrationService.php(61): Fisharebest\Webtrees\Schema\Migration42->upgrade()
#7 /var/www/webtrees/app/Http/Middleware/UpdateDatabaseSchema.php(55): Fisharebest\Webtrees\Services\MigrationService->updateSchema()
#8 /var/www/webtrees/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\UpdateDatabaseSchema->process()
#9 /var/www/webtrees/app/Http/Middleware/UseDatabase.php(60): Middleland\Dispatcher->handle()
#10 /var/www/webtrees/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\UseDatabase->process()
#11 /var/www/webtrees/app/Http/Middleware/BadBotBlocker.php(308): Middleland\Dispatcher->handle()
#12 /var/www/webtrees/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\BadBotBlocker->process()
#13 /var/www/webtrees/app/Http/Middleware/CompressResponse.php(71): Middleland\Dispatcher->handle()
#14 /var/www/webtrees/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\CompressResponse->process()
#15 /var/www/webtrees/app/Http/Middleware/ContentLength.php(40): Middleland\Dispatcher->handle()
#16 /var/www/webtrees/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\ContentLength->process()
#17 /var/www/webtrees/vendor/middlewares/client-ip/src/ClientIp.php(65): Middleland\Dispatcher->handle()
#18 /var/www/webtrees/app/Http/Middleware/ClientIp.php(47): Middlewares\ClientIp->process()
#19 /var/www/webtrees/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\ClientIp->process()
#20 /var/www/webtrees/app/Http/Middleware/PublicFiles.php(62): Middleland\Dispatcher->handle()
#21 /var/www/webtrees/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\PublicFiles->process()
#22 /var/www/webtrees/app/Http/Middleware/HandleExceptions.php(89): Middleland\Dispatcher->handle()
#23 /var/www/webtrees/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\HandleExceptions->process()
#24 /var/www/webtrees/app/Http/Middleware/SecurityHeaders.php(49): Middleland\Dispatcher->handle()
#25 /var/www/webtrees/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\SecurityHeaders->process()
#26 /var/www/webtrees/app/Http/Middleware/BaseUrl.php(73): Middleland\Dispatcher->handle()
#27 /var/www/webtrees/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\BaseUrl->process()
#28 /var/www/webtrees/app/Http/Middleware/ReadConfigIni.php(68): Middleland\Dispatcher->handle()
#29 /var/www/webtrees/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\ReadConfigIni->process()
#30 /var/www/webtrees/app/Http/Middleware/EmitResponse.php(57): Middleland\Dispatcher->handle()
#31 /var/www/webtrees/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\EmitResponse->process()
#32 /var/www/webtrees/app/Http/Middleware/ErrorHandler.php(38): Middleland\Dispatcher->handle()
#33 /var/www/webtrees/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\ErrorHandler->process()
#34 /var/www/webtrees/vendor/oscarotero/middleland/src/Dispatcher.php(118): Middleland\Dispatcher->handle()
#35 /var/www/webtrees/app/Webtrees.php(280): Middleland\Dispatcher->dispatch()
#36 /var/www/webtrees/app/Webtrees.php(251): Fisharebest\Webtrees\Webtrees->httpRequest()
#37 /var/www/webtrees/index.php(24): Fisharebest\Webtrees\Webtrees->run()
#38 {main}