mySQL error

[Stevee]

Hey, I'm using r63b plusEMU - Edited

and I'm getting this error right here, any idea how to fix it??

Error in query:
INSERT INTO items (base_item, user_id) VALUES (1739, 600)
MySql.Data.MySqlClient.MySqlException (0x80004005): Field 'id' doesn't have a default value
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int32& insertedId)
at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int32& 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.ExecuteScalar()
at Database_Manager.Database.Session_Details.QueryAdapter.insertQuery()



thanks, Steve

 

[bodge]

You could try:

INSERT INTO `items` (base_item, user_id) VALUES (1739, 600);

 

[Stevee]

Sorted this

mod close thread.