From 2f3dc51dfd3a547d110bd7c74738db705a75a963 Mon Sep 17 00:00:00 2001 From: matthiasgrimm Date: Sun, 11 Jun 2006 18:43:47 +0200 Subject: MySQL 3.23 compatibility issue MySQL 3.23 doesn't support the keyword OFFSET in the LIMIT statement. This patch changes the code to the second alternative syntax. darcs-hash:20060611164347-7ef76-b38861cebe45604c253bd4436451825733fe7083.gz --- inc/auth/mysql.class.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'inc/auth/mysql.class.php') diff --git a/inc/auth/mysql.class.php b/inc/auth/mysql.class.php index 71788f57d..da89dd845 100644 --- a/inc/auth/mysql.class.php +++ b/inc/auth/mysql.class.php @@ -339,7 +339,7 @@ class auth_mysql extends auth_basic { if($this->_openDB()) { $this->_lockTables("READ"); $sql = $this->_createSQLFilter($this->cnf['getUsers'], $filter); - $sql .= " ".$this->cnf['SortOrder']." LIMIT $limit OFFSET $first"; + $sql .= " ".$this->cnf['SortOrder']." LIMIT $first, $limit"; $result = $this->_queryDB($sql); foreach ($result as $user) -- cgit v1.2.3