From 3fb27bdc550a0c3f84eff16a49cf78179a0b681c Mon Sep 17 00:00:00 2001
From: Mario Vavti <mario@mariovavti.com>
Date: Wed, 10 May 2023 18:04:19 +0200
Subject: fix query for postgres

---
 include/attach.php | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'include/attach.php')

diff --git a/include/attach.php b/include/attach.php
index fc146d008..b7fb17f38 100644
--- a/include/attach.php
+++ b/include/attach.php
@@ -220,7 +220,7 @@ function attach_list_files($channel_id, $observer, $hash = '', $filename = '', $
 		$sql_extra .= protect_sprintf(" and filetype like '%" . dbesc($filetype) . "%' ");
 
 	if($entries)
-		$limit = " limit " . intval($start) . ", " . intval($entries) . " ";
+		$limit = " LIMIT " . intval($entries) . " OFFSET " . intval($start) . " ";
 
 	if(! $since)
 		$since = NULL_DATE;
-- 
cgit v1.2.3