Quote:
Originally Posted by xCoderx
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
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.
__________________