Fix Mysql and Postgresql bug

3 files changed, 3 insertions, 3 deletions

diff --git a/app/Model/CommentHistory.php b/app/Model/CommentHistory.php
index 5b94729c..5988c026 100644
--- a/app/Model/CommentHistory.php
+++ b/app/Model/CommentHistory.php
@@ -98,7 +98,7 @@ class CommentHistory extends BaseHistory
             LEFT JOIN tasks ON tasks.id=comment_has_events.task_id
             WHERE comment_has_events.project_id = ?
             ORDER BY comment_has_events.id DESC
-            LIMIT 0, '.$limit.'
+            LIMIT '.$limit.' OFFSET 0
         ';
 
         $rq = $this->db->execute($sql, array($project_id));
diff --git a/app/Model/SubtaskHistory.php b/app/Model/SubtaskHistory.php
index bbf6ce3d..89076261 100644
--- a/app/Model/SubtaskHistory.php
+++ b/app/Model/SubtaskHistory.php
@@ -105,7 +105,7 @@ class SubtaskHistory extends BaseHistory
             LEFT JOIN users AS assignees ON assignees.id=task_has_subtasks.user_id
             WHERE subtask_has_events.project_id = ?
             ORDER BY subtask_has_events.id DESC
-            LIMIT 0, '.$limit.'
+            LIMIT '.$limit.' OFFSET 0
         ';
 
         $rq = $this->db->execute($sql, array($project_id));
diff --git a/app/Model/TaskHistory.php b/app/Model/TaskHistory.php
index 35b7cb27..af0b4cff 100644
--- a/app/Model/TaskHistory.php
+++ b/app/Model/TaskHistory.php
@@ -96,7 +96,7 @@ class TaskHistory extends BaseHistory
             LEFT JOIN columns ON columns.id=tasks.column_id
             WHERE task_has_events.project_id = ?
             ORDER BY task_has_events.id DESC
-            LIMIT 0, '.$limit.'
+            LIMIT '.$limit.' OFFSET 0
         ';
 
         $rq = $this->db->execute($sql, array($project_id));