diff options
| author |  Marien Fressinaud <dev@marienfressinaud.fr>
| 2013-09-15 11:29:31 +0200 |
|---|---|---|
| committer | Marien Fressinaud <dev@marienfressinaud.fr>
| 2013-09-15 11:29:31 +0200 |
| commit | 35dcb5e39aee8029fee541d5649456bc385cd649 (patch) | |
| tree | a40dc62604e0fc1bc6a9bf1f82679e302ad172ec | |
| parent | 6f8b260ebf1768fdf567a03989556b50c9cbda25 (diff) | |
Issue #155 : correction bug prefix table SQL
Le préfixe freshrss_ était rentré en dur dans une des requêtes
| -rwxr-xr-x | app/models/Entry.php | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/app/models/Entry.php b/app/models/Entry.php index d73ce7245..ed350cad8 100755 --- a/app/models/Entry.php +++ b/app/models/Entry.php @@ -399,7 +399,7 @@ class EntryDAO extends Model_pdo { $where .= ' AND is_read = 1'; } if (!empty($limitFromId)) { //TODO: Consider using LPAD(e.date, 11) //CONCAT is for cases when many entries have the same date - $where .= ' AND CONCAT(e.date, e.id) ' . ($order === 'low_to_high' ? '<=' : '>=') . ' (SELECT CONCAT(s.date, s.id) from freshrss_entry s WHERE s.id = "' . $limitFromId . '")'; + $where .= ' AND CONCAT(e.date, e.id) ' . ($order === 'low_to_high' ? '<=' : '>=') . ' (SELECT CONCAT(s.date, s.id) FROM ' . $this->prefix . 'entry s WHERE s.id = "' . $limitFromId . '")'; } if ($order == 'low_to_high') { |