From c4a1811ea888fa98fe7cd6932d82b3d63d366f28 Mon Sep 17 00:00:00 2001 From: Chocobozzz Date: Thu, 9 Jan 2020 14:00:34 +0100 Subject: Use lower instead of ilike to login users --- server/models/account/user.ts | 8 ++++++-- 1 file changed, 6 insertions(+), 2 deletions(-) (limited to 'server') diff --git a/server/models/account/user.ts b/server/models/account/user.ts index 27262af42..4c2c5e278 100644 --- a/server/models/account/user.ts +++ b/server/models/account/user.ts @@ -1,4 +1,4 @@ -import { FindOptions, literal, Op, QueryTypes } from 'sequelize' +import { FindOptions, literal, Op, QueryTypes, where, fn, col } from 'sequelize' import { AfterDestroy, AfterUpdate, @@ -465,7 +465,11 @@ export class UserModel extends Model { const query = { where: { - [ Op.or ]: [ { username: { [ Op.iLike ]: username } }, { email } ] + [ Op.or ]: [ + where(fn('lower', col('username')), fn('lower', username)), + + { email } + ] } } -- cgit v1.2.3