aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/install
diff options
context:
space:
mode:
authorMeik Sievertsen <acydburn@phpbb.com>2009-03-30 10:44:18 +0000
committerMeik Sievertsen <acydburn@phpbb.com>2009-03-30 10:44:18 +0000
commit1fae177b9a424db90c33d9cde373d360ebeac878 (patch)
tree939c3e793570d421a96d65edaf6e17d5a720907f /phpBB/install
parente6ed42ed4dde41812b88b47c6e5bb5c41402f14c (diff)
downloadforums-1fae177b9a424db90c33d9cde373d360ebeac878.tar
forums-1fae177b9a424db90c33d9cde373d360ebeac878.tar.gz
forums-1fae177b9a424db90c33d9cde373d360ebeac878.tar.bz2
forums-1fae177b9a424db90c33d9cde373d360ebeac878.tar.xz
forums-1fae177b9a424db90c33d9cde373d360ebeac878.zip
Fix bug in postgresql db layer for LIMIT ALL clauses (reported by JRSweets)
git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@9412 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/install')
-rw-r--r--phpBB/install/database_update.php6
1 files changed, 5 insertions, 1 deletions
diff --git a/phpBB/install/database_update.php b/phpBB/install/database_update.php
index 0639f41b35..42af092d8b 100644
--- a/phpBB/install/database_update.php
+++ b/phpBB/install/database_update.php
@@ -947,7 +947,11 @@ function change_database_data(&$no_updates, $version)
FROM ' . ACL_OPTIONS_TABLE . "
WHERE auth_option = '" . $db->sql_escape($option) . "'
ORDER BY auth_option_id DESC";
- $result = $db->sql_query_limit($sql, 0, 1);
+ // sql_query_limit not possible here, due to bug in postgresql layer
+ $result = $db->sql_query($sql);
+
+ // Skip first row, this is our original auth option we want to preserve
+ $row = $db->sql_fetchrow($result);
while ($row = $db->sql_fetchrow($result))
{