diff options
| author | Meik Sievertsen <acydburn@phpbb.com> | 2005-11-21 09:24:58 +0000 |
|---|---|---|
| committer | Meik Sievertsen <acydburn@phpbb.com> | 2005-11-21 09:24:58 +0000 |
| commit | ee4d02132fc516a93c1444c12d6876b6601a74ac (patch) | |
| tree | a82c5139cba6c66e3b311b166442bd5aa2ee68e8 | |
| parent | 0202eb8a66920b43d37582bbd205a25f68523150 (diff) | |
| download | forums-ee4d02132fc516a93c1444c12d6876b6601a74ac.tar forums-ee4d02132fc516a93c1444c12d6876b6601a74ac.tar.gz forums-ee4d02132fc516a93c1444c12d6876b6601a74ac.tar.bz2 forums-ee4d02132fc516a93c1444c12d6876b6601a74ac.tar.xz forums-ee4d02132fc516a93c1444c12d6876b6601a74ac.zip | |
change total from -1 to max value
git-svn-id: file:///svn/phpbb/trunk@5311 89ea8834-ac86-4346-8a33-228a782c2dd0
| -rw-r--r-- | phpBB/includes/db/mysql4.php | 3 | ||||
| -rw-r--r-- | phpBB/includes/db/mysqli.php | 3 |
2 files changed, 4 insertions, 2 deletions
diff --git a/phpBB/includes/db/mysql4.php b/phpBB/includes/db/mysql4.php index bde53beab6..ce56efc664 100644 --- a/phpBB/includes/db/mysql4.php +++ b/phpBB/includes/db/mysql4.php @@ -147,7 +147,8 @@ class dbal_mysql4 extends dbal // if $total is set to 0 we do not want to limit the number of rows if ($total == 0) { - $total = -1; + // Because MySQL 4.1+ no longer supports -1 in LIMIT queries we set it to the maximum value + $total = 18446744073709551615; } $query .= "\n LIMIT " . ((!empty($offset)) ? $offset . ', ' . $total : $total); diff --git a/phpBB/includes/db/mysqli.php b/phpBB/includes/db/mysqli.php index 05846c717e..5bd4b124db 100644 --- a/phpBB/includes/db/mysqli.php +++ b/phpBB/includes/db/mysqli.php @@ -145,7 +145,8 @@ class dbal_mysqli extends dbal // if $total is set to 0 we do not want to limit the number of rows if ($total == 0) { - $total = -1; + // MySQL 4.1+ no longer supports -1 in limit queries + $total = 18446744073709551615; } $query .= "\n LIMIT " . ((!empty($offset)) ? $offset . ', ' . $total : $total); |