monicahq / chandler

The upcoming brand new version of Monica. Not suitable for production use at the moment.
GNU Affero General Public License v3.0
269 stars 12 forks source link

Can not select existing contact for relationships #437

Open bgutman opened 1 year ago

bgutman commented 1 year ago

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

djaiss commented 1 year ago

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?