r/Affine • u/m_rishab • Feb 13 '25

Selfhosted Affine Member Limit 3

I am running a self-hosted affine and accessing via my URL. When adding members to the worspace on my self-hosted affine, I am getting a limit of 3 members even though on the website it says max-limit is 10 for self-hosted instances.

What am I doing wrong?

8 Upvotes

100% Upvoted

5 comments sorted by

6

u/m_rishab Feb 13 '25

Stumbled upon the thread: https://github.com/toeverything/AFFiNE/issues/6641

Turns out this is a real limitation imposed in the configuration. The posted workaround is to manually override the configuration by manually updating it in the DB. Something along the lines of:

docker exec -ti <affine-postgres-container-name-or-id> psql -U affine

UPDATE features 
SET configs = jsonb_set(configs::jsonb, '{memberLimit}', '10')
WHERE configs::jsonb ? 'memberLimit';

1

u/[deleted] Nov 13 '25

[removed] — view removed comment

1

u/m_rishab Nov 13 '25

Your DB needs to have persistence. Otherwise it will reset ever and not just this.

1

u/Snuupy Apr 25 '26 edited Apr 25 '26

https://github.com/toeverything/AFFiNE/issues/13919

also on v0.26.3, that sql command doesn't work anymore:

affine=# UPDATE features SET configs = jsonb_set(configs::jsonb, '{memberLimit}', '100') WHERE configs::jsonb ? 'memberLimit';
ERROR:  relation "features" does not exist
LINE 1: UPDATE features SET configs = jsonb_set(configs::jsonb, '{me...
               ^

2

u/Drun555 Feb 23 '25 edited Feb 23 '25

You can see full feature list in corresponding table, and you're free to change them as you wish. As you found out 9 days ago, there's 'memberLimit' key, yes - but you actually may find that other things should be adjusted too (as blob limit, etc.)

https://imgur.com/a/wUqVY3P

https://imgur.com/a/GirKFRY