[PlusR2] MySQL errors causing D/C

Hey,

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

Code:

---

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?

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

Quote:

---

Originally Posted by Rush Retros

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?

Quote:

---

Originally Posted by FatalLulz

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?

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

Fixed.

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

delete