[PLUSEMU R2] Can't buy more than 1 item

[Diddy]

Hello,

Only recently ive been getting an issue were users can't buy more than 1 of the same item as you can see you type in the ammount and you should get that, but users only get one.

It lists 2 mysql errors but ive tried fixing but with no luck, could anyone help me out?

Error in query: INSERT INTO items (base_item, user_id) VALUES (20240, 36)
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 D:\Users\localuser\Documents\HypeEmulator\Silverwave\Silverwave Emulator\DatabaseManager\Database_Manager\Database\Session_Details\QueryAdapter.cs:line 164




Error in query:
INSERT INTO items (base_item, user_id) VALUES (999889078, 34)
MySql.Data.MySqlClient.MySqlException (0x80004005): Field 'wall_pos' 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 D:\Users\localuser\Documents\HypeEmulator\Silverwave\Silverwave Emulator\DatabaseManager\Database_Manager\Database\Session_Details\QueryAdapter.cs:line 164

Thanks, for your help.
Josh

- - - Updated - - -

Also when you try to pick up furni from your room it doesn't appear in your hand and this error is logged.
Error in query:
INSERT INTO items (base_item, user_id) VALUES (20240, 36)
MySql.Data.MySqlClient.MySqlException (0x80004005): Field 'wall_pos' 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 D:\Users\localuser\Documents\HypeEmulator\Silverwave\Silverwave Emulator\DatabaseManager\Database_Manager\Database\Session_Details\QueryAdapter.cs:line 164

- - - Updated - - -

Sorted this issue, researched more threads from The General and found were he said to edit in the emu, only thing is i'm having to run emu in debug mode as it will not recreate source.

[MentaL]