summaryrefslogtreecommitdiff
path: root/app/Model
diff options
context:
space:
mode:
Diffstat (limited to 'app/Model')
-rw-r--r--app/Model/CommentHistory.php2
-rw-r--r--app/Model/SubtaskHistory.php2
-rw-r--r--app/Model/TaskHistory.php2
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));