Found a solution in the old bug report, only issue is that it doesn't work in e2e rooms
here is the solution https://github.com/matrix-org/synapse/issues/12023#issuecomment-1044337550
That seemed to work because when uploading to an unencrypted room the upload does start, but when uploading in a e2e room it just failed (doesn't even start uploading) Does anyone have an idea on how we can make this work in e2e rooms as well?
btw for anyone trying to apply it do the following
1, go to the terminal. 2, click postgress then type psql and press enter.
3, paste in the following to change media_length from integer to bigint
ALTER TABLE local_media_repository
ALTER COLUMN media_length TYPE bigint;
you can use the following to check if the change was applied
SELECT data_type
FROM information_schema.columns
WHERE table_name = 'local_media_repository'
AND column_name = 'media_length';