diff options
Diffstat (limited to 'store/sql_audit_store.go')
-rw-r--r-- | store/sql_audit_store.go | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/store/sql_audit_store.go b/store/sql_audit_store.go index dd9312007..a595d50e2 100644 --- a/store/sql_audit_store.go +++ b/store/sql_audit_store.go @@ -31,7 +31,7 @@ func (s SqlAuditStore) UpgradeSchemaIfNeeded() { } func (s SqlAuditStore) CreateIndexesIfNotExists() { - s.CreateIndexIfNotExists("idx_user_id", "Audits", "UserId") + s.CreateIndexIfNotExists("idx_audits_user_id", "Audits", "UserId") } func (s SqlAuditStore) Save(audit *model.Audit) StoreChannel { @@ -73,8 +73,8 @@ func (s SqlAuditStore) Get(user_id string, limit int) StoreChannel { } var audits model.Audits - if _, err := s.GetReplica().Select(&audits, "SELECT * FROM Audits WHERE UserId = ? ORDER BY CreateAt DESC LIMIT ?", - user_id, limit); err != nil { + if _, err := s.GetReplica().Select(&audits, "SELECT * FROM Audits WHERE UserId = :user_id ORDER BY CreateAt DESC LIMIT :limit", + map[string]interface{}{"user_id": user_id, "limit": limit}); err != nil { result.Err = model.NewAppError("SqlAuditStore.Get", "We encounted an error finding the audits", "user_id="+user_id) } else { result.Data = audits |