diff options
| author | Jan-Hendrik Willms <tleilax+studip@gmail.com> | 2022-04-20 15:57:32 +0000 |
|---|---|---|
| committer | Jan-Hendrik Willms <tleilax+studip@gmail.com> | 2022-04-20 15:57:32 +0000 |
| commit | 8dd6ffbe81e4107102cd56eb5bc6bc2d67b500c0 (patch) | |
| tree | 721a03dadc4aa66666cc495b609517080ad7bee8 /lib/classes/Score.class.php | |
| parent | e9c5a61a21d57b3d14a0ed7beeaaf63f841859e0 (diff) | |
adjust queries to avoid 'Numeric value out of range' error, fixes #894
Closes #894
Diffstat (limited to 'lib/classes/Score.class.php')
| -rw-r--r-- | lib/classes/Score.class.php | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/lib/classes/Score.class.php b/lib/classes/Score.class.php index ededb7e..5fa80d9 100644 --- a/lib/classes/Score.class.php +++ b/lib/classes/Score.class.php @@ -25,7 +25,7 @@ class Score $query = "SELECT nr.range_id as user_id, COUNT(*) AS newscount FROM news_range AS nr INNER JOIN news AS n ON (nr.news_id = n.news_id) - WHERE nr.range_id IN (?) AND (UNIX_TIMESTAMP() - n.date) <= n.expire + WHERE nr.range_id IN (?) AND UNIX_TIMESTAMP() <= n.date + n.expire GROUP BY nr.range_id ORDER BY NULL"; $statement = DBManager::get()->prepare($query); |