BanReason doesn't have a default value?
#1

Код:
[23:21:07] [join] John_Dalen has joined the server (0:127.0.0.1)
[23:21:25] [MySQL] Query Error - (ErrorID: 1364) (Handle: 1)
[23:21:25] [MySQL] Check mysql_log.txt to review the query that threw the error.
[23:21:25] Dumping query from 2016/9/10 (23:21:25)

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


[23:21:25] INSERT INTO `accounts` (`RegiDate`, `LastLogin`, `Username`, `Key`) VALUES (NOW(), NOW(), 'John_Dalen','771C4FE355D50AC373A9AB3D9878BE29A67A7A152119D5D2C68F8B54BDC3DB9A9B5726D9ACF976ACE3CDDA83950E7EAD5E38DEEDC42B9785879A1AD1682C0557')
[23:21:50] [part] John_Dalen has left the server (0:1)
Please tell me what the error is , i cannot find it.
Reply
#2

http://www.w3schools.com/sql/sql_default.asp

You need a default value on the BanReason field.

A similar thread to yours:

https://sampforum.blast.hk/showthread.php?tid=431630
Reply
#3

What value? Like 0 or 1 ? Anything?
Reply
#4

Its fixed , + rep to you.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)