Server Support - Printable Version

Server Support - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Server (https://sampforum.blast.hk/forumdisplay.php?fid=6)
+--- Forum: Server Support (https://sampforum.blast.hk/forumdisplay.php?fid=19)
+--- Thread: Server Support (/showthread.php?tid=615091)

Server Support - Uvais - 17.08.2016

Well im having some problem with my server. When ever i join in game. It shows the register dialog , i type my password and then no login dialog box. It has an auto kick of not logging in , in 60 secs so i get kicked for it. Basically the problem is i cant login. I took a look at Server Log and here's what i found.

Код:

[05:02:33] [connection] 127.0.0.1:55305 requests connection cookie.
[05:02:33] [connection] incoming connection: 127.0.0.1:55305 id: 0
[05:02:34] [join] Uvais_Ali has joined the server (0:127.0.0.1)
[05:03:12] [MySQL] Query Error - (ErrorID: 1364) (Handle: 1)
[05:03:12] [MySQL] Check mysql_log.txt to review the query that threw the error.
[05:03:12] Dumping query from 2016/8/17 (5:3:12)

Description: Field 'BanReason' doesn't have a default value (index 0). Query:


[05:03:12] INSERT INTO `accounts` (`RegiDate`, `LastLogin`, `Username`, `Key`) VALUES (NOW(), NOW(), 'Uvais_Ali','178645A2EC6265FEBD70EE4FB6F0E50D5A2B1BBC7DD952D5218A06A36E1B5D69DA2F8A5813C89C1A72705F01120BDCEF4B6467BF37A00F00B0534A1C5E1B293C')
[05:04:05] [part] Uvais_Ali has left the server (0:1)

Re: Server Support - BR3TT - 18.08.2016

"Description: Field 'BanReason' doesn't have a default value (index 0). Query:"

Two things, is this what comes up when you're 'kicked' for not logging in? And you should check to make sure BanReason has a default value inside your table because it's expecting one.