chandler
chandler copied to clipboard
Can not select existing contact for relationships
fresh pull with docker image ghcr.io/monicahq/monica-next:main Steps: created contact for my wife. add relationship selected spouse selected Choose existing contact, filled in my name no results.
Went to my contact add relationship selected spouse selected Choose existing contact, filled in her name no result
From logs: [01/Mar/2023:16:27:41 +0000] "GET /vaults/1/contacts/1/tabs/social HTTP/1.1" 200 20741 "http://192.168.1.121:4545/vaults/1/contacts/1/tabs/life-goals" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/110.0" [01/Mar/2023:16:27:48 +0000] "GET /vaults/1/contacts/1/relationships/create HTTP/1.1" 200 10300 "http://192.168.1.121:4545/vaults/1/contacts/1/tabs/social" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/110.0" [2023-03-01 16:28:02] production.ERROR: This database engine does not support fulltext search operations. {"userId":1,"exception":"[object] (RuntimeException(code: 0): This database engine does not support fulltext search operations. at /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Query/Grammars/Grammar.php:706) [01/Mar/2023:16:28:02 +0000] "POST /vaults/1/search/user/contacts HTTP/1.1" 500 1575 "http://192.168.1.121:4545/vaults/1/contacts/1/relationships/create" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/110.0"
Contacts table from database.sqlite 1|9895a95d-3116-48e4-a5ef-9c38ac15c550|1|||1||John||Smith||||||0|1|||||2023-03-01 15:46:30|2023-03-01 15:46:30|| 2|9895b67a-6684-4100-ae96-d31723a48dc7|1|||1||Jane||Smith||Doe||||1|1|||2023-03-01 16:23:10||2023-03-01 16:23:10|2023-03-01 16:23:10||
Thanks for this bug report. We didn't expect this. @asbiin apparently SQLite does not support search. Perhaps we could use mysql in the docker image instead?