Raised This Month: $12 Target: $400
 3% 

How to create a funtional SQL database?


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
Elpapuh
Member
Join Date: Aug 2017
Old 02-20-2018 , 14:42   How to create a funtional SQL database?
Reply With Quote #1

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

Last edited by Elpapuh; 02-20-2018 at 14:52. Reason: Moved to plugins section
Elpapuh is offline
Neuro Toxin
Veteran Member
Join Date: Oct 2013
Location: { closing the void; }
Old 02-20-2018 , 14:44   Re: How to create a funtional SQL database?
Reply With Quote #2

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.
__________________

Last edited by Neuro Toxin; 02-20-2018 at 14:49.
Neuro Toxin is offline
KillMan
Member
Join Date: Aug 2017
Location: Belarus
Old 02-23-2018 , 01:52   Re: How to create a funtional SQL database?
Reply With Quote #3

Possible that mysql don't understand these symbols. My friend got same with... And crash of mysql server, lol.
KillMan is offline
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 09:59.


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