Raised This Month: $51 Target: $400
 12% 

Bug Report Ban List Blank (SourceBans Fork)


Post New Thread Reply   
 
Thread Tools Display Modes
Sarabveer
Veteran Member
Join Date: Feb 2014
Old 05-14-2015 , 17:06   Re: Ban List Blank (SourceBans Fork)
Reply With Quote #11

Quote:
Originally Posted by Rytis View Post
But that change above was added by you. I've used SourceBans only on MariaDB and it worked without problems.
Cause, that change stops the Banlist from lagging if your running MySQL 5.6+
__________________
Sarabveer is offline
DarkDeviL
SourceMod Moderator
Join Date: Apr 2012
Old 05-16-2015 , 08:44   Re: Ban List Blank (SourceBans Fork)
Reply With Quote #12

Quote:
Originally Posted by xCoderx View Post
Fixed by removing:

PHP Code:
if (version_compare($GLOBALS['db_version'], "5.6.0") >= 0)
{
  
$GLOBALS['db']->Execute("set session optimizer_switch='block_nested_loop=off';");

Must be something to do with MariaDB.
SourceBans was as previously told build to work with MySQL. Using other things (or things on top of MySQL) will change the behavior and most obviously, the final result.

Please put a file (e.g. db_info.php) in your SourceBans root folder, with this content:
PHP Code:
<?php
  
include_once("init.php");
  
$msv $GLOBALS["db"]->ServerInfo();
  echo 
"<pre>";
  
var_dump($msv);
  echo 
"</pre>";
?>
Then go to your SourceBans site, assuming you called the file db_info.php, you would go to http://your-sourcebans-link/db_info.php

It will output some information, please copy that information into a CODE/PHP tags in this thread.

We may then be able to do something, so it won't send these queries if it is possible to detect MariaDB.

Quote:
Originally Posted by Rytis View Post
But that change above was added by you. I've used SourceBans only on MariaDB and it worked without problems.
The thing that you have been running your stuff in a way which is not supported, that is completely irrelevant to the fact that SourceBans was built to work with MySQL (and not anything else!).

Just good for you that it has been working for you without any issues.
__________________
Mostly known as "DarkDeviL".

Dropbox FastDL: Public folder will no longer work after March 15, 2017!
For more info, see the [SRCDS Thread], or the [HLDS Thread].
DarkDeviL is offline
Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 02:22.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode