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/FilesSearch/FilesIndexManager.php | |
| parent | e9c5a61a21d57b3d14a0ed7beeaaf63f841859e0 (diff) | |
adjust queries to avoid 'Numeric value out of range' error, fixes #894
Closes #894
Diffstat (limited to 'lib/classes/FilesSearch/FilesIndexManager.php')
| -rw-r--r-- | lib/classes/FilesSearch/FilesIndexManager.php | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/lib/classes/FilesSearch/FilesIndexManager.php b/lib/classes/FilesSearch/FilesIndexManager.php index 818bb21..9f762d5 100644 --- a/lib/classes/FilesSearch/FilesIndexManager.php +++ b/lib/classes/FilesSearch/FilesIndexManager.php @@ -197,7 +197,7 @@ class FilesIndexManager private static function relevance($base, $modifier) { // 31556926 is the number of seconds in one year - return "POW( $base , ((UNIX_TIMESTAMP() - $modifier ) / 31556926)) AS relevance"; + return "POW( $base , ((UNIX_TIMESTAMP() - CAST($modifier AS SIGNED)) / 31556926)) AS relevance"; } /** |