Latest UI [Field 'extra_data' doesn't have a default value]
While buying stuff in the shop it replaces my other furniture in the inventory, so i can only have 1 item in the inventory the other items just disappear and i get this error:
Error in query:
INSERT INTO items (base_item, user_id) VALUES (1773, 1)
MySql.Data.MySqlClient.MySqlException (0x80004005): Field 'extra_data' 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.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() in c:\Users\Robin\Desktop\Program\Flip filer 2014\new ui database,emu,cms\changeui\Silverwave Emulator\DatabaseManager\Database_Manager\Database\Session_Details\QueryAdapter.cs:line 164
Best Wishes
Flowy
Re: Latest UI [Field 'extra_data' doesn't have a default value]
Find in your emu: INSERT INTO items (base_item, user_id) VALUES
I dont know the base item and userid variables but you will see it after you searched the code.
Just add: extradata in it and a value with nothing in it.
Like:
Quote:
INSERT INTO items (base_item, user_id, extra_data) VALUES (BASEITEMID, USERID, ' ')
Re: Latest UI [Field 'extra_data' doesn't have a default value]