[xines]

Look changelog for information.

Updated to 1.5!

[sneaK]

On latest version 1.5, when I attempt to use sm_server_whitelist_add. SM 1.9, database configured properly.

L 06/15/2017 - 00:04:41: [SM] Exception reported: Invalid database Handle 0 (error: 4)
L 06/15/2017 - 00:04:41: [SM] Blaming: simple_mysql_whitelister.smx
L 06/15/2017 - 00:04:41: [SM] Call stack trace:
L 06/15/2017 - 00:04:41: [SM]   [0] Database.Query
L 06/15/2017 - 00:04:41: [SM]   [1] Line 417, G:\sourcemod 1.8\scripting\simple_mysql_whitelister.sp::Server_Command_Add

[xines]

Originally Posted by sneaK database configured properly.

Sure about that?

[sneaK]

Originally Posted by xines Sure about that?

Double checked, triple checked, quadruple checked. Exact same information as all of my other database entries, with the exception of the database name.

	"whitelister"
	{
		"driver"			"mysql"
		"host"				"xx.xx.xx.xx"
		"database"			"whitelist_surftop50"
		"user"				"xx"
		"pass"				"xx"
		"port"				"3306"
	}

[xines]

Originally Posted by sneaK Double checked, triple checked, quadruple checked. Exact same information as all of my other database entries, with the exception of the database name. "whitelister" { "driver" "mysql" "host" "xx.xx.xx.xx" "database" "whitelist_surftop50" "user" "xx" "pass" "xx" "port" "3306" }

Whats your defined database name in the .sp itself?

Also try markout the port, so it looks like the following.

	"whitelister"
	{
		"driver"			"mysql"
		"host"				"xx.xx.xx.xx"
		"database"			"whitelist_surftop50"
		"user"				"xx"
		"pass"				"xx"
		//"port"			"0"
	}

[sneaK]

I haven't modified the .sp at all, so it should be default "whitelister".

I originally had the database defined without port, thought that was the problem (since all of my other databases are specified with port), added it, and didn't fix the problem.

[xines]

Originally Posted by sneaK I haven't modified the .sp at all, so it should be default "whitelister".

/*-> Database table name to use for connection <-*/
#define DB_Name "mysql_whitelist"
/*###############################################*/

As you can see above, you missed the preset database table name mysql_whitelist, change the line to whitelist_surftop50, then recompile the plugin, put it in plugins, and restart server.

[sneaK]

Oh huh, thats odd. Kept it at the default db name, changed the name in the database config, created the new database, restarted server... and same error.

Solution: Figured out it was because the server was freshly restarted, and the plugin had not made the database connection yet. Disable hibernation and it works just fine!

[zwetch]

Database doesn't work, the flag does though.

Edit: Works if steamid changed from STEAM_0:0:00000 to STEAM_1:0:00000

[hoyxen]

nice plugin!