Fix SQL query

2 files changed, 4 insertions, 4 deletions

diff --git a/server/models/actor/actor-follow.ts b/server/models/actor/actor-follow.ts
index 0f199d208..71ce9fa6f 100644
--- a/server/models/actor/actor-follow.ts
+++ b/server/models/actor/actor-follow.ts
@@ -311,7 +311,7 @@ export class ActorFollowModel extends Model<Partial<AttributesOnly<ActorFollowMo
         if (t.host) {
           return {
             [Op.and]: [
-              ActorModel.wherePreferredUsername(t.name, '$preferredUsername$'),
+              ActorModel.wherePreferredUsername(t.name),
               { $host$: t.host }
             ]
           }
@@ -319,7 +319,7 @@ export class ActorFollowModel extends Model<Partial<AttributesOnly<ActorFollowMo
 
         return {
           [Op.and]: [
-            ActorModel.wherePreferredUsername(t.name, '$preferredUsername$'),
+            ActorModel.wherePreferredUsername(t.name),
             { $serverId$: null }
           ]
         }
diff --git a/server/models/actor/actor.ts b/server/models/actor/actor.ts
index 1524e0533..80a646c77 100644
--- a/server/models/actor/actor.ts
+++ b/server/models/actor/actor.ts
@@ -381,7 +381,7 @@ export class ActorModel extends Model<Partial<AttributesOnly<ActorModel>>> {
       const query = {
         where: {
           [Op.and]: [
-            this.wherePreferredUsername(preferredUsername),
+            this.wherePreferredUsername(preferredUsername, '"ActorModel"."preferredUsername"'),
             {
               serverId: null
             }
@@ -431,7 +431,7 @@ export class ActorModel extends Model<Partial<AttributesOnly<ActorModel>>> {
 
   static loadByNameAndHost (preferredUsername: string, host: string): Promise<MActorFull> {
     const query = {
-      where: this.wherePreferredUsername(preferredUsername),
+      where: this.wherePreferredUsername(preferredUsername, '"ActorModel"."preferredUsername"'),
       include: [
         {
           model: ServerModel,