diff options
| author | Brice Maron <brice@bmaron.net> | 2011-10-17 13:49:33 +0200 |
|---|---|---|
| committer | Brice Maron <brice@bmaron.net> | 2011-10-17 13:49:33 +0200 |
| commit | 492931562fda62b1495af197b10e39f6c89a9949 (patch) | |
| tree | 0982ef85ebd2ad8574647364286fa87aff1b4ba3 /apps/bookmarks/ajax | |
| parent | 4d1776faf959c71ac81ea1724e0d270e5414e953 (diff) | |
| download | nextcloud-server-492931562fda62b1495af197b10e39f6c89a9949.tar.gz nextcloud-server-492931562fda62b1495af197b10e39f6c89a9949.zip | |
Fix bookmark listing with mysql: limit is binded as string.
Diffstat (limited to 'apps/bookmarks/ajax')
| -rw-r--r-- | apps/bookmarks/ajax/updateList.php | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/apps/bookmarks/ajax/updateList.php b/apps/bookmarks/ajax/updateList.php index 7a5c0476b43..d2a5397452f 100644 --- a/apps/bookmarks/ajax/updateList.php +++ b/apps/bookmarks/ajax/updateList.php @@ -46,7 +46,6 @@ if($filterTag){ } $offset = isset($_GET['page']) ? intval($_GET['page']) * 10 : 0; -$params[] = $offset; $sort = isset($_GET['sort']) ? ($_GET['sort']) : 'bookmarks_sorting_recent'; if($sort == 'bookmarks_sorting_clicks') { @@ -62,6 +61,7 @@ if( $CONFIG_DBTYPE == 'sqlite' or $CONFIG_DBTYPE == 'sqlite3' ){ } if($CONFIG_DBTYPE == 'pgsql' ){ + $params[] = $offset; $query = OC_DB::prepare(' SELECT id, url, title, array_to_string(array_agg(tag), \' \') as tags FROM *PREFIX*bookmarks @@ -92,7 +92,7 @@ if($CONFIG_DBTYPE == 'pgsql' ){ GROUP BY url '.$sqlFilterTag.' ORDER BY *PREFIX*bookmarks.'.$sqlSort.' - LIMIT ?, 10'); + LIMIT '.$offset.', 10'); } $bookmarks = $query->execute($params)->fetchAll(); |