[TnTSCS]

I use the SQLite (built in with SM)

[s.m.a.c head]

Originally Posted by Bacardi Ok, need look someday when have time. Need setup MySQL also in my computer.... You both (if you are reading), are you using SQLite or MySQL connection ? Dunno would this error happen when have somekind slow connection with MySQL or something like that.

I have SQlite but dont use it I have it set just to save to file , it used to work on my windows server im on linux now and get these errors ,everything is setup how it used to be

sm_stb2_banlist
L 07/01/2012 - 11:28:05: [SM] Native "SQL_LockDatabase" reported: Invalid database Handle 0 (error: 4)
L 07/01/2012 - 11:28:05: [SM] Displaying call stack trace for plugin "stb2.smx":
L 07/01/2012 - 11:28:05: [SM]   [0]  Line 120, stb2.sp::admcmd_list()
sm_stb2_unbanlist
L 07/01/2012 - 11:30:27: [SM] Native "SQL_LockDatabase" reported: Invalid database Handle 0 (error: 4)
L 07/01/2012 - 11:30:27: [SM] Displaying call stack trace for plugin "stb2.smx":
L 07/01/2012 - 11:30:27: [SM]   [0]  Line 120, stb2.sp::admcmd_list()

[Bacardi]

pfff.....
- Show current cvars, type in server console sm cvars plugin_id_number
- Could you show your ...addons/sourcemod/configs/databases.cfg without username+passwords.
- Can you attach in post your ...addons/sourcemod/data/stb2.sq3 in zip.

[TnTSCS]

it doesn't reply all the time with that error... like today, no error.

Here are the CVars:

08:21:48 sm cvars 36
08:21:48 [SM] Listing 2 convars for: [STB2] Save Temporary Bans 2
           [Name]                           [Value]
           stb2_leave_srcds_ban             0
           stb2_mode                        2

databases.cfg

"Databases"
{
	"driver_default"		"mysql"
	
	// When specifying "host", you may use an IP address, a hostname, or a socket file path
	
	"default"
	{
		"driver"			"default"
		"host"				"localhost"
		"database"			"sourcemod"
		"user"				""
		"pass"				""
		//"timeout"			"0"
		//"port"			"0"
	}
	
	"storage-local"
	{
		"driver"			"sqlite"
		"database"			"sourcemod-local"
	}

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

	"stb2"
	{
		"driver"			"sqlite"
		"host"				"localhost"
		"database"			"stb2"
	}
}

sq3 attached

...:: TnT Test ::...
Just did a test ban on myself then executed the sm_stb2_banlist and it's working as expected... weird that it works sometimes and others not

sm_stb2_banlist

STEAM_1:0:3599266  = 2012-07-01 10:36:02


L 07/01/2012 - 10:31:11: [SM] STB2 command executed from server console
STEAM_1:0:3599266  = 2012-07-01 10:36:02

[s.m.a.c head]

well for some strange reason it works today ?O_O?
I banned myself then in console wrote
sm_stb2_banlist
and it shows my steam id and a time and date
but Im not banned I can join is this because im admin ?

[TnTSCS]

Yes...

Immunity
Admins with flag "e" (unban).

[s.m.a.c head]

Originally Posted by TnTSCS Yes... Immunity Admins with flag "e" (unban).

ok nice it seems to work then , just for the record I didnt change anything so I dont know why I was getting the said error
well thanks everyone for your help
here have crabs ;)

[pubhero]

The plugin works well for me. Thanks.
But:

- Come on guys. No one can't do translations for this plugin?
Here are the HU translation:

[VJScope]

Works in CSGO too! Great job bacardi.

[killjoy64]

Do you need to put exec autoexec in server.cfg?