[Donski]

I don't think it's a connection issue since it seems like it found the database, but could not find the exact tables.

Maybe check the config.php in your Sourcebans install (should be on root folder I believe) and make sure DB_PREFIX is set correctly.

EDIT: Oops, ninja'ed. After you changed the DB_PREFIX to _ your webpage stopped working, but were you still getting the error in your game server?

[sparkie951]

Originally Posted by Donski I don't think it's a connection issue since it seems like it found the database, but could not find the exact tables. Maybe check the config.php in your Sourcebans install (should be on root folder I believe) and make sure DB_PREFIX is set correctly.

It is in the root folder.. The webpage works great and that is what uses the config.php... The problem is in the database.cfg file in the fact that the sourcebans.smx file uses the sourcemod\configs\database.cfg. It is accessing the server but it is trying to open up the wrong file names... For Example

Table name: sb_bans on the SQL Server is being called from sourcebans.smx as sbbans. Note that it is leaving out all the underscores when accessing this...

Excert from my addons\sourcemod\configs\database.cfg

"sourcebans"
{
"driver" "mysql"
"host" "173.12.236.113"
"database" "ins"
"user" "insuser"
"pass" "xxxxxxxx"
"port" "3306"
}

[Dr_Knuckles]

That's very odd. Last time I had an issue where my server wouldn't connect right I had the ServerID in sourcebans.cfg wrong.

Edit: Speaking of the sourcebans.cfg, is:

"DatabasePrefix" "sb"

set right?

[Donski]

I understand that, but I was under the impression that the plugin was also using some information from the webpanel's configs. I guess not.

[Donski]

There's also a line in sourcebans.cfg (addons/sourcemod/configs/sourcebans/sourcebans.cfg):

"DatabasePrefix" "sb"

Maybe check that? I think it never needs to be changed since both use sb as default prefix but I'm running out of ideas

I downloaded a fresh copy of 1.4.11 and checked the code it definitely has the underscores though.

[Jammy]

Again, this is a simple prefix issue as I've already mentioned. You are likely running into a php error when the web page loads blank after you make config changes. When that happens view the web pages source and see what the error is.

[micazoid]

Did you try to open firewall for all? Just for testing purposes. If it works then, you have to open some ports