[8.1] Fatal Error on Logs - Search
What are the steps to reproduce this issue?
- Go on Sourcebans Settings -> Logs.
- Open search bar
- Click on Date and put only the year (ex : 2022 See Screenshoot)
- Error.
What happens?
Fatal Error.
What were you expecting to happen?
Same results as Master branch (7.4)
Any logs, error output, etc.?
Fatal error: Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1 in /var/www/vhosts/nide.gg/upgradebans.nide.gg/includes/Database.php:124 Stack trace: #0 /var/www/vhosts/nide.gg/upgradebans.nide.gg/includes/Database.php(124): PDOStatement->execute() #1 /var/www/vhosts/nide.gg/upgradebans.nide.gg/includes/Database.php(145): Database->execute() #2 /var/www/vhosts/nide.gg/upgradebans.nide.gg/includes/Log.php(78): Database->single() #3 /var/www/vhosts/nide.gg/upgradebans.nide.gg/pages/admin.settings.php(84): Log::getCount() #4 /var/www/vhosts/nide.gg/upgradebans.nide.gg/includes/page-builder.php(143): require_once('...') #5 /var/www/vhosts/nide.gg/upgradebans.nide.gg/index.php(29): build() #6 {main} thrown in /var/www/vhosts/nide.gg/upgradebans.nide.gg/includes/Database.php on line 124
Any other comments?
What versions of software are you using?
Operating System: nginx SourceBans++ Version: 1.7.0 (php 8.1 branch) with the lastest release. PHP Version: 8.1.10 MySQL Version: 10.6.7-MariaDB-2ubuntu1 - Ubuntu 22.04 Link to your project: https://upgradebans.nide.gg/index.php Link to a phpinfo() output: https://upgradebans.nide.gg/phpinfo.php