hi guys this is my first post , i Really don't like asking for help ! but this one has had me stuck for over a week :mad: ill post some of the log and see if anyone knows what is causing the problem
Info: 03:46:19 - Loading databases...
Info: 03:46:19 - Databases.txt file loading in from: C:\arma_3\Databases.txt
Info: 03:46:19 - Type: mysql Database: arma3life IPAddress: localhost Port: 3306 Username: not shown Password: NotShownForSecurityReasons
Info: 03:46:20 - Received - Database: arma3life SQL Query: CALL resetLifeVehicles();
Info: 03:46:28 - Received - Database: arma3life SQL Query: SELECT playerid, name, cash, bankacc, civ_licenses, arrested, adminlevel, donatorlvl, civ_gear FROM players WHERE playerid='123456789'
Info: 03:46:28 - Received - Database: arma3life SQL Query: SELECT name, aliases FROM players WHERE playerid='1234567891011'
Info: 03:46:28 - Received - Database: arma3life SQL Query: INSERT INTO players (playerid, name, cash, bankacc, arrested, aliases, civ_gear) VALUES('1234567891011', 'Andy', '0', '6000', '0', '"[`Andy`]"','"[]"')
Warning: 03:46:28 - MySQL error. MySql.Data.MySqlClient.MySqlException (0x80004005): Field 'cop_licenses' doesn't have a default value
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader()
at Arma2NETMySQLPlugin.MySQL.RunOnDatabase(MySqlCommand command, Int32 maxResultSize)
so its a sql error Field 'cop_licenses' doesn't have a default value ? does anyone know the default value , if you can help ! i really cannot thank you enough this thing is driving me nutts lol , thanks so much for your time