[Davethegreat]

That update did nothing!
Latest Added Bans Total bans: 65

Now its gone down 2
Banlist Overview - Total Bans: 52

[sirmoe]

The pop up says you can upload .dem rar or zip, but it only allows rar or zip.

[KawMAN]

Originally Posted by HaX0788 Same problem during installation. I'm having an error on Step 4 of Installation: Warning Error <image> <image> There was an error creating the table structure. Please read the message above to help debug the problem. However, there is no "error above".

1. Delete install folder
2. Download and unpack query.zip
3. import query.sql to your DB
4. CHMOD the following folders to 766:
/demos
/includes/querycache
5.Create config.php and upload to sourcebans folder

<?php
/**
 * config.php
 * 
 * This file contains all of the configuration for the db
 * that will 
 * @author SteamFriends Development Team
 * @version 1.0.0
 * @copyright SteamFriends (www.SteamFriends.com)
 * @package SourceBans
 */
if(!defined('IN_SB')){echo 'You should not be here. Only follow links!';die();}

define('DB_HOST', 'dbhost');               // The host/ip to your SQL server
define('DB_USER', 'dbuser');                    // The username to connect with
define('DB_PASS', 'dbpass');                        // The password
define('DB_NAME', 'dbname');                          // Database name    
define('DB_PREFIX', 'sb');                            // DONT CHANGE`
define('DB_PORT','3306');                            // The SQL port (Default: 3306)
?>

6. Now go to http://yourhost.com/your_sourcebans/
7. Login: admin Password: sourcebans CHANGE PASS and MAIL

[J@y-R]

Why can not any this install ???

[Nolongerinthegame]

Ive done a full reinstall, and kawmans thing works. However when i ban of the server, the ban is in place, but doesnt go to the webpanel.

If i ban of webpanel, im getting this message:

Error: the XML response that was returned from the server is invalid. Received:
Duplicate entry '0' for key 1

SQL Query type: EXECUTE
Script: '/sourcebans/index.php'
SQL Query: INSERT INTO `sb_banhistory` (`Type` , `RemovedOn` , `RemovedBy` , `IP` , `AuthId` , `Name` , `Created` , `Ends` , `Length` , `Reason` , `AdminId` , `AdminIp` , `SId`) SELECT 'E', UNIX_TIMESTAMP(), '0', `ip` , `authid` , `name` , `Created` , `Ends` , `Length` , `Reason` , `aid` , `adminIp` , `sid` FROM `sb_bans` WHERE `Length` != '0' AND `Ends` < UNIX_TIMESTAMP()
SQL Params:

--------------------------------------------------------------------------------

Duplicate entry '0' for key 1

SQL Query type: EXECUTE
Script: '/sourcebans/index.php'
SQL Query: INSERT INTO sb_log(type,title,message, function, query, aid, host, created) VALUES ('e','sql error','Duplicate entry \'0\' for key 1

Query: INSERT INTO `sb_banhistory` (`Type` , `RemovedOn` , `RemovedBy` , `IP` , `AuthId` , `Name` , `Created` , `Ends` , `Length` , `Reason` , `AdminId` , `AdminIp` , `SId`) \r\n SELECT \'E\', UNIX_TIMESTAMP(), \'0\', `ip` , `authid` , `name` , `Created` , `Ends` , `Length` , `Reason` , `aid` , `adminIp` , `sid` FROM `sb_bans` WHERE `Length` != \'0\' AND `Ends` < UNIX_TIMESTAMP()','/mounted-storage/home59c/sub001/sc37219-RPSA/www/sourcebans/includes/adodb/adodb.inc.php - 916
/mounted-storage/home59c/sub001/sc37219-RPSA/www/sourcebans/includes/adodb/adodb.inc.php - 891
/mounted-storage/home59c/sub001/sc37219-RPSA/www/sourcebans/includes/system-functions.php - 650
/mounted-storage/home59c/sub001/sc37219-RPSA/www/sourcebans/includes/sb-callback.php - 1261
','N/A','1','78.86.4.24',121206275
SQL Params:

--------------------------------------------------------------------------------

Duplicate entry '0' for key 1

SQL Query type: EXECUTE
Script: '/sourcebans/index.php'
SQL Query: INSERT INTO sb_bans(created,ip,authid,name,ends,length,re ason,aid,adminIp ) VALUES (UNIX_TIMESTAMP(),'','STEAM_0:1:24224244','ko ma',(UNIX_TIMESTAMP() + 3600),3600,'ANother test','1','78.86.4.24')
SQL Params:

--------------------------------------------------------------------------------

Duplicate entry '0' for key 1

SQL Query type: EXECUTE
Script: '/sourcebans/index.php'
SQL Query: INSERT INTO sb_log(type,title,message, function, query, aid, host, created) VALUES ('e','sql error','Duplicate entry \'0\' for key 1

Query: INSERT INTO sb_bans(created,ip,authid,name,ends,length,re ason,aid,adminIp ) VALUES \r\n (UNIX_TIMESTAMP(),\'\',\'STEAM_0:1:24224244\' ,\'koma\',(UNIX_TIMESTAMP() + 3600),3600,\'ANother test\',\'1\',\'78.86.4.24\')','/mounted-storage/home59c/sub001/sc37219-RPSA/www/sourcebans/includes/adodb/adodb.inc.php - 916
/mounted-storage/home59c/sub001/sc37219-RPSA/www/sourcebans/includes/adodb/adodb.inc.php - 872
/mounted-storage/home59c/sub001/sc37219-RPSA/www/sourcebans/includes/sb-callback.php - 1280
/mounted-storage/home59c/sub001/sc37219-RPSA/www/sourcebans/includes/xajax.inc.php - 1095
','N/A','1','78.86.4.24',121206275
SQL Params:

--------------------------------------------------------------------------------

Duplicate entry '0' for key 1

SQL Query type: EXECUTE
Script: '/sourcebans/index.php'
SQL Query: INSERT INTO sb_log(type,title,message, function, query, aid, host, created) VALUES ('m','Ban Added','Ban against (STEAM_0:1:24224244) has been added, reason: ANother test, length: 60','/mounted-storage/home59c/sub001/sc37219-RPSA/www/sourcebans/includes/xajax.inc.php - 1095
/mounted-storage/home59c/sub001/sc37219-RPSA/www/sourcebans/includes/xajax.inc.php - 744
/mounted-storage/home59c/sub001/sc37219-RPSA/www/sourcebans/index.php - 21
','N/A','1','78.86.4.24',121206275
SQL Params:

--------------------------------------------------------------------------------

$('steam.msg').setStyle('display', 'none');$('steam.msg').setStyle('display', 'none');TabToReload();

[sirmoe]

How many servers would you recommend monitoring max with this? It seems to be overloading our webserver constantly causing random 403 and permission errors on all websites hosted on that webserver.

We adjusted the memory allocated to php and tweaked what we could, seems to be having little effect.

[DJ Tsunami]

SteamFriends is using this for 11 servers and is having no problems with it, so.

[sirmoe]

Originally Posted by DJ Tsunami SteamFriends is using this for 11 servers and is having no problems with it, so.

I have 14 running,

[Olly]

Originally Posted by sirmoe I have 14 running,

You could have 1000 servers using sourcebans, and it will not affect the webserver. The only thing it will use is MySQL server, and if your sql server cant handle a few queries from 14 servers, then you need some new hardware.

In any case, 403 errors are not caused by any web-application, but the way that you have it all setup. So check your config.

[sirmoe]

A few queries being 55,000 per hour in our case