PDA

View Full Version : Could not ban user


Nican
02-08-2007, 04:02
Today a guy entered in my server and started to ask for SA and say a bunch of ****** things

When I clicked at him to see his profile, it displayed a error message, saying something about invalid characters.
So I banned him, 5 seconds later he comes back, so I went into the logs, and this error message was there:

01-08-07 19:07:18,ERROR,All,SQL, ExcecSQL Error: SQL logic error or missing database in query: insert into ts2_bans
(i_ban_server_id,
s_ban_ip,
s_ban_by,
dt_ban_created,
i_ban_minutes)
values
(2,
'72.153.26.121',
'Nican132[LoginName: nican] banned Guess 1 i rock fuck you XD

Apparently he used some kind of character that bugged the SQL query...

I already banned him manually, but can you please fix this error?

BHKai
02-08-2007, 04:05
What server version are you using?

Nican
02-08-2007, 04:47
Server Version: 2.0.20.1

Adress:
nican.no-ip.org:8768

BHKai
02-08-2007, 07:06
Try updating your server and see if that fixes it.

Nican
02-08-2007, 07:27
ok..

But I don't think another guy with the same bad intentions will show up again so soon


Well, thank you anyway

BHKai
02-08-2007, 09:19
The update fixes many things. It is easy to replace a file with an updated one than to recover what is lost. Never know what tomorrow brings.