sourcebans-pp icon indicating copy to clipboard operation
sourcebans-pp copied to clipboard

[8.1] Fatal Error on Logs - Search

Open Rushaway opened this issue 3 years ago • 0 comments

What are the steps to reproduce this issue?

  1. Go on Sourcebans Settings -> Logs.
  2. Open search bar
  3. Click on Date and put only the year (ex : 2022 See Screenshoot)
  4. 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

Rushaway avatar Sep 22 '22 05:09 Rushaway