[Czar_]

L 01/29/2017 - 17:094: [SM] Exception reported: Invalid query Handle 0 (error: 4)
L 01/29/2017 - 17:094: [SM] Blaming: togsclantags.smx
L 01/29/2017 - 17:094: [SM] Call stack trace:
L 01/29/2017 - 17:094: [SM] [0] DBResultSet.RowCount.get
L 01/29/2017 - 17:094: [SM] [1] Line 241, C:\Users\Daniel\Downloads\CSS\Server Builds\SM\addons\sourcemod\scripting\scriptin g1_8\togsclantags.sp::SQLCallback_SetupsCnt

Any help for this error would be great

[headline]

Originally Posted by Czar_ L 01/29/2017 - 17:094: [SM] Exception reported: Invalid query Handle 0 (error: 4) L 01/29/2017 - 17:094: [SM] Blaming: togsclantags.smx L 01/29/2017 - 17:094: [SM] Call stack trace: L 01/29/2017 - 17:094: [SM] [0] DBResultSet.RowCount.get L 01/29/2017 - 17:094: [SM] [1] Line 241, C:\Users\Daniel\Downloads\CSS\Server Builds\SM\addons\sourcemod\scripting\scriptin g1_8\togsclantags.sp::SQLCallback_SetupsCnt Any help for this error would be great

The query failed to retrieve any results. The error should be handled once the pr gets merged.

[ThatOneGuy]

Originally Posted by M4ketech Weird, its not working and error shows: L 01/29/2017 - 08:25:52: [SM] Exception reported: Error connecting to main database. Could not find database conf "togsclantags" L 01/29/2017 - 08:25:52: [SM] Blaming: togsclantags.smx L 01/29/2017 - 08:25:52: [SM] Call stack trace: L 01/29/2017 - 08:25:52: [SM] [0] SetFailState L 01/29/2017 - 08:25:52: [SM] [1] Line 166, C:\Users\Daniel\Downloads\CSS\Server Builds\SM\addons\sourcemod\scripting\scripting1_8\togsclantags.sp::SQLCallback_Connect L 01/29/2017 - 08:25:52: [SM] [3] Database.Connect L 01/29/2017 - 08:25:52: [SM] [4] Line 275, C:\Users\Daniel\Downloads\CSS\Server Builds\SM\addons\sourcemod\scripting\scripting1_8\togsclantags.sp::LoadSetups L 01/29/2017 - 08:25:52: [SM] [5] Line 214, C:\Users\Daniel\Downloads\CSS\Server Builds\SM\addons\sourcemod\scripting\scripting1_8\togsclantags.sp::OnMapStart L 01/29/2017 - 08:26:35: Error log file session closed. Chat is working but no tags showing.

This errors is produced by not having a setup defined in /addons/sourcemod/configs/databases.cfg. Please see example config here: https://github.com/ThatOneHomelessGu...%20example.txt

Then replace the database info with what applies to your setup.

Originally Posted by Headline Originally Posted by Czar_ L 01/29/2017 - 17:094: [SM] Exception reported: Invalid query Handle 0 (error: 4) L 01/29/2017 - 17:094: [SM] Blaming: togsclantags.smx L 01/29/2017 - 17:094: [SM] Call stack trace: L 01/29/2017 - 17:094: [SM] [0] DBResultSet.RowCount.get L 01/29/2017 - 17:094: [SM] [1] Line 241, C:\Users\Daniel\Downloads\CSS\Server Builds\SM\addons\sourcemod\scripting\scriptin g1_8\togsclantags.sp::SQLCallback_SetupsCnt Any help for this error would be great The query failed to retrieve any results. The error should be handled once the pr gets merged.

This has been merged, but wont solve the problem (i believe) as this seems to indicate (based on Headlines edit) that none of the setups created in the database apply to this server. Please verify that some of the setups apply to the server (server_ip field), or server_ip field is blank. If you still have problems, post your database setups and I will help you sort them out.

[M4ketech]

Originally Posted by ThatOneGuy This errors is produced by not having a setup defined in /addons/sourcemod/configs/databases.cfg. Please see example config here: https://github.com/ThatOneHomelessGu...%20example.txt Then replace the database info with what applies to your setup.

So i need setup database even if i dont use it? How we can add players with tags etc. to database?

[ThatOneGuy]

Originally Posted by M4ketech So i need setup database even if i dont use it? How we can add players with tags etc. to database?

Oh, i didnt notice that you had it set not to use a database. Was it set that one from the beginning? I recall that the default was to use a database, so it would have err'd out. If you changed the config file, rcon'd the cvar change and it still does it, then it is an issue on the plugin end. I'll look at the code.

EDIT: I looked at the line with your error, and the only way to get to that part in the code is to have mysql enabled. Simply changing the cvar in the file wont change the value that the server has cached. RCon the cvar change to the server to make the change take effect immediately.

[M4ketech]

Originally Posted by ThatOneGuy Oh, i didnt notice that you had it set not to use a database. Was it set that one from the beginning? I recall that the default was to use a database, so it would have err'd out. If you changed the config file, rcon'd the cvar change and it still does it, then it is an issue on the plugin end. I'll look at the code. EDIT: I looked at the line with your error, and the only way to get to that part in the code is to have mysql enabled. Simply changing the cvar in the file wont change the value that the server has cached. RCon the cvar change to the server to make the change take effect immediately.

Okey, i try once more, command is sm_cvar change togsclantags_use_mysql 0 in console?

BTW, how that database is working, how plugins adds players, tags or groups to database or do we need manually add them somehow? Im asking because we have multiple servers and adding everyone manually to each server is pain.

E: Working now, DB setup is still open how we do it and manage it.

[danyxcraft]

could you make this compatible with csco

[ThatOneGuy]

Originally Posted by M4ketech Okey, i try once more, command is sm_cvar change togsclantags_use_mysql 0 in console? BTW, how that database is working, how plugins adds players, tags or groups to database or do we need manually add them somehow? Im asking because we have multiple servers and adding everyone manually to each server is pain. E: Working now, DB setup is still open how we do it and manage it.

You have to manually create entries if using the database. Yes, other plugins can add them as well using the database info, or can also just use the "external" tags native provided by the plugin. Since you are not using mysql, use the config file to create setups. Setups are exhaustively explained at the top of the config file. Use of mysql would provide cross-server support, else you would need to copy/paste your config file.

[ThatOneGuy]

Originally Posted by danyxcraft could you make this compatible with csco

I dont see what makes it incompatible. It works well for csgo, and it isnt checking for the folder names. Are you getting an error? Perhaps you just need to configure it, like the above person? Post any errors you have, and the the last few posts, in case you are in the same boat as that guy.

[danyxcraft]

i make a database for the tags and still not working, its working on my csgo server but not csco