[PlusR2] MySQL errors causing D/C

[FatalLulz]

Hey,

All of a sudden PlusR2 has started giving me this MySQL error;

Error in query: 
UPDATE items SET user_id = 1, room_id='' WHERE id = 3142
MySql.Data.MySqlClient.MySqlException (0x80004005): Incorrect integer value: '' for column 'room_id' at row 1
   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.ExecuteNonQuery()
   at Database_Manager.Database.Session_Details.QueryAdapter.runQuery() in D:\Users\localuser\Documents\GitHub\Silverwave\Silverwave Emulator\DatabaseManager\Database_Manager\Database\Session_Details\QueryAdapter.cs:line 193

Nothing has been changed for it throw an exception like that. All I did, was place some furni in my room, reloaded the client and now when I try to pick it up, it gives me that error. Any ideas?

[MentaL]

[Rush Retros]

ave u deleted some items from your databasen but didnt remove them form your room/inventory ?

[FatalLulz]

ave u deleted some items from your databasen but didnt remove them form your room/inventory ?

No. I've double checked that and nothing was removed. It's causing major d/c's for me and my users. Logging errors and is causing major lag.

Any other ideas?

[Rush Retros]

No. I've double checked that and nothing was removed. It's causing major d/c's for me and my users. Logging errors and is causing major lag.

Any other ideas?

All i can think of is that 1, but maybe theres a bug somewhere thats a user did without notice it and the caused a bug in the db?

[YoWesty]

Search room_id='' WHERE id in your emulator and just change it to
room_id='0'

[FatalLulz]

Fixed.

For some reason 2 items had totally bugged out. They were there, but touching them would screw it all up.

[Flowy Otaku]

delete