Mark the shadow_banned column as boolean in synapse_port_db. (#8386)

3 files changed, 2 insertions, 0 deletions

diff --git a/.buildkite/test_db.db b/.buildkite/test_db.db

index f20567ba73..361369a581 100644
--- a/.buildkite/test_db.db
+++ b/.buildkite/test_db.db
Binary files differdiff --git a/changelog.d/8386.bugfix b/changelog.d/8386.bugfix
new file mode 100644

index 0000000000..24983a1e95
--- /dev/null
+++ b/changelog.d/8386.bugfix
@@ -0,0 +1 @@
+Fix a bug introduced in v1.20.0 which caused the `synapse_port_db` script to fail.
diff --git a/scripts/synapse_port_db b/scripts/synapse_port_db

index a34bdf1830..ecca8b6e8f 100755
--- a/scripts/synapse_port_db
+++ b/scripts/synapse_port_db
@@ -89,6 +89,7 @@ BOOLEAN_COLUMNS = {
     "redactions": ["have_censored"],
     "room_stats_state": ["is_federatable"],
     "local_media_repository": ["safe_from_quarantine"],
+    "users": ["shadow_banned"],
 }