search

bwong789 / webtrees-favorites-menu

Webtrees module that presents Favorites as a menu item
GNU General Public License v3.0
5 stars 0 forks source link

Cannot add or update a child row: a foreign key constraint fails #2

Closed hartenthaler closed 1 year ago

hartenthaler commented 1 year ago

using the newest version of your module I got the following error:

SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails ("DBxxxxxx"."wt_user_setting", CONSTRAINT "wt_user_setting_user_id_foreign" FOREIGN KEY ("user_id") REFERENCES "wt_user" ("user_id")) (SQL: insert into `wt_user_setting` (`user_id`, `setting_name`, `setting_value`) values (0, favorites-menu-settings, a:2:{s:13:"default_group";s:0:"";s:9:"secondary";a:0:{}})) …/vendor/illuminate/database/Connection.php:712
#0 …/vendor/illuminate/database/Connection.php(672): Illuminate\Database\Connection->runQueryCallback()
#1 …/vendor/illuminate/database/Connection.php(490): Illuminate\Database\Connection->run()
#2 …/vendor/illuminate/database/Connection.php(454): Illuminate\Database\Connection->statement()
#3 …/vendor/illuminate/database/Query/Builder.php(2978): Illuminate\Database\Connection->insert()
#4 …/modules_v4/webtrees-favorites-menu-main/module.php(604): Illuminate\Database\Query\Builder->insert()
#5 …/modules_v4/webtrees-favorites-menu-main/module.php(253): Fisharebest\Webtrees\Module\AbstractModule@anonymous->getSettings()
hartenthaler commented 1 year ago

after updating webtrees to 2.1.18 the error disappeared

bwong789 commented 1 year ago

I should probably note that the minimum would be 2.1.x. I am running on the latest version of Webtrees.