AlliedModders

AlliedModders (https://forums.alliedmods.net/index.php)
-   Source Servers (SRCDS) (https://forums.alliedmods.net/forumdisplay.php?f=130)
-   -   How to create a funtional SQL database? (https://forums.alliedmods.net/showthread.php?t=305459)

Elpapuh 02-20-2018 14:42

How to create a funtional SQL database?
 
First of all, sorry for my bad english, but I'm Spanish.

Hi, I have a JailBreak server, and i want to add teambans, but when i edit configs/database.cfg and I ban someone from team blu (for example), in the console this error comes out:
  • [TF2Jail_TeamBans.smx] Error writing CTBan to Timed Ban database: 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 'm Papuh| Mockingbird', 0, 0, 'No reason given.')' at line 1

I need help to fix this config error

Neuro Toxin 02-20-2018 14:44

Re: How to create a funtional SQL database?
 
Doesnt look like a config error.

I would post this in the plugins thread.

Edit:

It looks SQL input is not escaped. This is a security risk allowing SQL injection. I suggest you disable the plugin until the issue resolved.

KillMan 02-23-2018 01:52

Re: How to create a funtional SQL database?
 
Possible that mysql don't understand these symbols. My friend got same with... And crash of mysql server, lol.


All times are GMT -4. The time now is 00:08.

Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.