[Scofield11]

Hello, I started using a MySQL based script and I've been facing some problems, I'd appreciate if someone could help me
I have a problem in the account save (login system). When I register a new account, I log-out, relog again and it says "Please register a new account". Basically the account does not save when I logout.

PS: this problem occurs only in my Linux VPS, it works perfectly in Windows.

This is the .sql file: https://pastebin.com/ZajiAsgQ

This is taken from mysql_log.txt

Код:

[05:05:36 08/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1364) Field 'Level' doesn't have a default value (Query: "INSERT INTO `players` (`Name`, `Key_`) VALUES('Clark_Peter', 'cncr‡OPO')")
[05:05:36 08/08/17] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0') (Query: "SELECT `ID` FROM `players` WHERE `name` = 'Clark_Peter' LIMIT 1")
[05:05:36 08/08/17] [ERROR] cache_get_field_content_int - invalid datatype
[05:10:33 08/08/17] [WARNING] CMySQLHandle::DeleteSavedResult - invalid result id ('0')
[05:11:21 08/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1364) Field 'AdminLvl' doesn't have a default value (Query: "INSERT INTO `players` (`Name`, `Key_`) VALUES('Clark_Peter', 'fwek‘‚“‰є»НЛ)')")
[05:11:21 08/08/17] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0') (Query: "SELECT `ID` FROM `players` WHERE `name` = 'Clark_Peter' LIMIT 1")
[05:11:21 08/08/17] [ERROR] cache_get_field_content_int - invalid datatype
[05:11:32 08/08/17] [WARNING] CMySQLHandle::DeleteSavedResult - invalid result id ('0')
[05:18:05 08/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1364) Field 'AdminLvl' doesn't have a default value (Query: "INSERT INTO `players` (`Name`, `Key_`) VALUES('Clark_Peter', '1;85P`‡€№Ж')")
[05:18:05 08/08/17] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0') (Query: "SELECT `ID` FROM `players` WHERE `name` = 'Clark_Peter' LIMIT 1")
[05:18:05 08/08/17] [ERROR] cache_get_field_content_int - invalid datatype
[05:18:05 08/08/17] [WARNING] CMySQLHandle::DeleteSavedResult - invalid result id ('0')
[05:18:50 08/08/17] [ERROR] CMySQLQuery::Execute[] - (error #1364) Field 'AdminLvl' doesn't have a default value (Query: "INSERT INTO `players` (`Name`, `Key_`) VALUES('Clark_Peter', 'hgnl‹•ЌЋДѕ‹‰е')")
[05:18:50 08/08/17] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0') (Query: "SELECT `ID` FROM `players` WHERE `name` = 'Clark_Peter' LIMIT 1")
[05:18:50 08/08/17] [ERROR] cache_get_field_content_int - invalid datatype
[05:20:42 08/08/17] [WARNING] CMySQLHandle::DeleteSavedResult - invalid result id ('0')
[05:21:25 08/08/17] [WARNING] CMySQLHandle::DeleteSavedResult - invalid result id ('0')

This is taken from server_logs.txt

Код:

[05:18:38] [join] Clark_Peter has joined the server (0:**.92.80.155)
[05:18:44] mysql_tquery OnPlayerRequestClass
[05:18:50] mysql_tquery OnPlayerRegister
[05:18:50] Account created for Clark_Peter
[05:18:50] [MySQL] SQLSave(start) Clark_Peter.
[05:18:50] [MySQL] SQLSave(end) Clark_Peter.
[05:18:50] mysql_tquery SetPlayerID
[05:18:50] OnQueryError: errorid: 1364, error: Field 'AdminLvl' doesn't have a default value, callback: , query: INSERT INTO `players` (`Name`, `Key_`) VALUES('Clark_Peter', 'hgnl‹•ЌЋДѕ‹‰е'), connectionHandle: 1
[05:18:50] SetPlayerID: Clark_Peter - BEFORE: 0 | AFTER: 0

[05:20:42] [MySQL] SQLSave(start) Clark_Peter.
[05:20:42] [MySQL] SQLSave(end) Clark_Peter.

[05:20:42] [part] Clark_Peter has left the server (0:1)
[05:21:11] [connection] **.**.6.239:33176 requests connection cookie.
[05:21:12] [connection] incoming connection: **.**.6.239:33176 id: 0

[05:21:12] [join] Clark_Peter has joined the server (0:**.**.6.239)

[05:21:16] [HouseInfo] 0 houses were saved.
[05:21:16] mysql_tquery SaveStuff
[05:21:18] mysql_tquery OnPlayerRequestClass

[05:21:25] [part] Clark_Peter has left the server (0:2)

Please help me, I really need this fixed as soon as possible. Tell me if I have to provide anything else, thanks.