Hey @elpatron68 - as you can see from the error message, it says “default for column cannot be cast automatically”.
If we look at your schema, we can see that the default value is '{}'::character varying
. Therefore, it is failing to change the column type to json.
The fix is to run alter table channelmembers alter column notifyprops drop default;
and then run the migration again.
I am not sure how your db got into that state, as we don’t set the default by our side.