From ec96f665b847ecf534e3d24659475dfa940a800b Mon Sep 17 00:00:00 2001 From: "Michael J. Rubinsky" Date: Wed, 28 Jul 2010 10:48:52 -0400 Subject: [PATCH] ...actually remove the LIMIT from the SQL statement --- news/lib/Driver/sql.php | 3 +-- 1 file changed, 1 insertion(+), 2 deletions(-) diff --git a/news/lib/Driver/sql.php b/news/lib/Driver/sql.php index 6c6d755b6..6070a5c08 100644 --- a/news/lib/Driver/sql.php +++ b/news/lib/Driver/sql.php @@ -585,8 +585,7 @@ class News_Driver_sql extends News_Driver { } $sql = 'SELECT l.tags, n.publish FROM ' . $this->prefix . '_body AS l, ' - . $this->prefix . ' AS n WHERE l.lang = ? AND n.id = l.id AND n.status = ? ORDER BY n.publish DESC LIMIT 0, ' - . ($minimize ? '100' : '500'); + . $this->prefix . ' AS n WHERE l.lang = ? AND n.id = l.id AND n.status = ? ORDER BY n.publish DESC'; $result = $this->db->limitQuery($sql, 0, ($minimize ? '100' : '500'), array($GLOBALS['registry']->preferredLang(), News::CONFIRMED)); if ($result instanceof PEAR_Error) { -- 2.11.0