[karppinen]

my server is spamming this error in the CHAT and restarting the round every 1 seconds. Cant join teams.
"Sorry, all the arenas are currently full. You are in position 1 in the waiting queue". Got the latest build in sourcemod and multi1v1.

[ghostofmybrain]

Originally Posted by karppinen my server is spamming this error in the CHAT and restarting the round every 1 seconds. Cant join teams. "Sorry, all the arenas are currently full. You are in position 1 in the waiting queue". Got the latest build in sourcemod and multi1v1.

Are you using a 1v1 map?

[TrappaTroopa]

So I tried to make a custom round called "AWP-Only and it didn't work. I put it in my Custom Rounds txt. So I took out the section I made and rebooted the server but now I am getting this spammed in my console every 3 seconds.

08/29/2016 - 23:27:13: [multi1v1.smx] Last SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-Only-Rating = -1500.000000 WHERE accountID = 354062014 AND serverID = 0' at line 1

Edit: Error seems to have stopped.

[splewis]

Originally Posted by TrappaTroopa So I tried to make a custom round called "AWP-Only and it didn't work. I put it in my Custom Rounds txt. So I took out the section I made and rebooted the server but now I am getting this spammed in my console every 3 seconds 08/29/2016 - 23:27:13: [multi1v1.smx] Last SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-Only-Rating = -1500.000000 WHERE accountID = 354062014 AND serverID = 0' at line 1

You should show how you created the round type.

It looks like you gave it a ratingFieldName that includes hypens. From a quick google that is only supported on MySQL if the name is surrounded in backticks (`) in the queries, which multi1v1 does not do (it probably should, though). I'd suggest just changing ratingFieldName.

[TrappaTroopa]

Originally Posted by splewis You should show how you created the round type. It looks like you gave it a ratingFieldName that includes hypens. From a quick google that is only supported on MySQL if the name is surrounded in backticks (`) in the queries, which multi1v1 does not do (it probably should, though). I'd suggest just changing ratingFieldName.

I appreciate the suggestion very much. I had in fact included hypens. I will try again tomorrow without hyphens.

I guess I need to create the Columns in my table first right? The plugins won't create them for me?

[splewis]

Originally Posted by TrappaTroopa I appreciate the suggestion very much. I had in fact included hypens. I will try again tomorrow without hyphens. I guess I need to create the Columns in my table first right? The plugins won't create them for me?

The plugin will add the column for you.

[Foskitox]

Originally Posted by ghostofmybrain For some reason, one of my 1v1 servers (I run 2 with identical settings) has started putting bots in the server. This only started today. I verified that bot_quota is set to 0 in both server config files (gamemode_casual_server and server.cfg) as well as /cfg/sourcemod/multi1v1/game_cvars.cfg. When I type "bot_quota" in console it replicates "10" for some reason. Since I haven't touched the server in weeks (I think the last thing i did was upgrade to version 1.1.3), and it's only happening on one server, I can't even begin to determine why this behavior might be happening. I'm using SourceMod Version: 1.7.3-dev+5280 on both servers.

Same, my 1st server stop running the plugin (??). I dont change anything.

The 2nd server start adding bots

[coltreane]

Great plugin! Everything works just fine except !stats / !rank commands. When i wisit my website, it is working as well. Any ideas?

[sneaK]

Originally Posted by coltreane Great plugin! Everything works just fine except !stats / !rank commands. When i wisit my website, it is working as well. Any ideas?

Are you using multi1v1_online_stats_viewer plugin?

Did you define the correct url as dictated in the config file under /cfg/sourcemod/multi1v1/multi1v1_online_stats_viewer.cfg ?

[coltreane]

Originally Posted by blackhawk74 Are you using multi1v1_online_stats_viewer plugin? Did you define the correct url as dictated in the config file under /cfg/sourcemod/multi1v1/multi1v1_online_stats_viewer.cfg ?

Yes, I am using it. It also is not in disabled folder.
I set up this into a cfg file

PHP Code:

http://www.czjackie.cz/stats/redirect.php?id={USER}&serverid={SERVER}
http://www.czjackie.cz/stats/redirect.php?serverid={SERVER} 


I did not changed anything else in here.
btw: if i am only retard and i should put something into "{SERVER}" and "{USER}" then i'm sorry
if so, what should i put in here? thx for reply