Sourcebans issue

[Tyrone]

i contacted support they tried to help however after a while whoever was on the otherside suggested i try my luck over here

whenever i ban someone using sourcebans it doesn't seem to connect properly to the mysql server
if i ban someone they get banned until the server restarts and if you look at the sourcebans page it doesn't show any bans done via the game only through the website same for phpmyadmin

here is my database cfg

Code: Select all

"Databases"
{
	"driver_default"		"mysql"
	
	"sourcebans"
	{
		"driver"		"mysql"
		"host"				"dongmaster420.com"
		"database"			"dongmaster420_sbans"
		"user"				"dongmaster420"
		"pass"				"removed"
		//"timeout"			"0"
		"port"			"3306"
	}

	
	"default"
	{
		"driver"			"default"
		"host"				"localhost"
		"database"			"sourcemod"
		"user"				"root"
		"pass"				""
		//"timeout"			"0"
		//"port"			"0"
	}
	
	"storage-local"
	{
		"driver"			"sqlite"
		"database"			"sourcemod-local"
	}

	"clientprefs"
	{
		"driver"			"sqlite"
		"host"				"localhost"
		"database"			"clientprefs-sqlite"
		"user"				"root"
		"pass"				""
		//"timeout"			"0"
		//"port"			"0"
	}
}

also here is a quick video
http://www.youtube.com/watch?v=w3Wo03_h7p4

edit: i should probably also show you my database page

[kraze]

Can you post some information from your log files so we can get an idea of what error Sourcebans is throwing?

[Tyrone]

Can you post some information from your log files so we can get an idea of what error Sourcebans is throwing?

i guess i was looking in the wrong logs folder because most of them had no helpful information
here is the sourcebans log now that i can finally see the problem i'm not sure if i should just reinstall the web part as it looks like it didn't generate the database fully

http://pastebin.com/raw.php?i=DY588AFL

[kraze]

The most recent errors in that log seem to be because the table it is trying to add information to does not exist, I would think Sbans would just create it but not sure how they have that set up.

Have you tried re-installing the website portion of it? It sounds like you may of just gotten a bad install.

[Tyrone]

The most recent errors in that log seem to be because the table it is trying to add information to does not exist, I would think Sbans would just create it but not sure how they have that set up.

Have you tried re-installing the website portion of it? It sounds like you may of just gotten a bad install.

thank you
that fixed it i don't know what i was thinking to be honest i really need some sleep