diff options
author | =Corey Hulen <corey@hulen.com> | 2015-07-12 19:12:23 -0800 |
---|---|---|
committer | =Corey Hulen <corey@hulen.com> | 2015-07-12 19:28:58 -0800 |
commit | af63080c0dba1bf2c93e4a7996fd7ec07546f289 (patch) | |
tree | ed6bb32e5e5e194a7e3202847efdbd14d38abc7e /store/sql_post_store.go | |
parent | 34d56294a240a38722d2d752c63ce087de625080 (diff) | |
download | chat-af63080c0dba1bf2c93e4a7996fd7ec07546f289.tar.gz chat-af63080c0dba1bf2c93e4a7996fd7ec07546f289.tar.bz2 chat-af63080c0dba1bf2c93e4a7996fd7ec07546f289.zip |
minor tweaks to make sure mysql still runs
Diffstat (limited to 'store/sql_post_store.go')
-rw-r--r-- | store/sql_post_store.go | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/store/sql_post_store.go b/store/sql_post_store.go index 4befe33dd..13e7b891d 100644 --- a/store/sql_post_store.go +++ b/store/sql_post_store.go @@ -301,7 +301,7 @@ func (s SqlPostStore) getRootPosts(channelId string, offset int, limit int) Stor result := StoreResult{} var posts []*model.Post - _, err := s.GetReplica().Select(&posts, "SELECT * FROM Posts WHERE ChannelId = :ChannelId AND DeleteAt = 0 ORDER BY CreateAt DESC OFFSET :Offset LIMIT :Limit", map[string]interface{}{"ChannelId": channelId, "Offset": offset, "Limit": limit}) + _, err := s.GetReplica().Select(&posts, "SELECT * FROM Posts WHERE ChannelId = :ChannelId AND DeleteAt = 0 ORDER BY CreateAt DESC LIMIT :Limit OFFSET :Offset", map[string]interface{}{"ChannelId": channelId, "Offset": offset, "Limit": limit}) if err != nil { result.Err = model.NewAppError("SqlPostStore.GetLinearPosts", "We couldn't get the posts for the channel", "channelId="+channelId+err.Error()) } else { @@ -339,7 +339,7 @@ func (s SqlPostStore) getParentsPosts(channelId string, offset int, limit int) S ChannelId = :ChannelId1 AND DeleteAt = 0 ORDER BY CreateAt DESC - OFFSET :Offset LIMIT :Limit) q3) q1 ON q1.RootId = q2.RootId + LIMIT :Limit OFFSET :Offset) q3) q1 ON q1.RootId = q2.RootId WHERE ChannelId = :ChannelId2 AND DeleteAt = 0 |