chandler icon indicating copy to clipboard operation
chandler copied to clipboard

Can not select existing contact for relationships

Open bgutman opened this issue 1 year ago • 1 comments

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||

bgutman avatar Mar 01 '23 16:03 bgutman

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?

djaiss avatar Mar 22 '23 12:03 djaiss