Fix /users/@me/settings get and migrarion

1 files changed, 6 insertions, 0 deletions

diff --git a/util/src/migrations/1660689892073-mobileFixes2.ts b/util/src/migrations/1660689892073-mobileFixes2.ts

index 34328966..bd28694e 100644
--- a/util/src/migrations/1660689892073-mobileFixes2.ts
+++ b/util/src/migrations/1660689892073-mobileFixes2.ts
@@ -8,9 +8,15 @@ export class mobileFixes21660689892073 implements MigrationInterface {
             ALTER TABLE \`user_settings\`
             ADD \`banner_color\` varchar(255) NULL
         `);
+		await queryRunner.query(`
+			UPDATE \`channels\` SET \`nsfw\` = 0 WHERE \`nsfw\` = NULL
+		`);
         await queryRunner.query(`
             ALTER TABLE \`channels\` CHANGE \`nsfw\` \`nsfw\` tinyint NOT NULL
         `);
+		await queryRunner.query(`
+			UPDATE \`guilds\` SET \`nsfw\` = 0 WHERE \`nsfw\` = NULL
+		`);
         await queryRunner.query(`
             ALTER TABLE \`guilds\` CHANGE \`nsfw\` \`nsfw\` tinyint NOT NULL
         `);