[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?
Re: [PlusR2] MySQL errors causing D/C
ave u deleted some items from your databasen but didnt remove them form your room/inventory ?
Re: [PlusR2] MySQL errors causing D/C
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?
Re: [PlusR2] MySQL errors causing D/C
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?
Re: [PlusR2] MySQL errors causing D/C
Search room_id='' WHERE id in your emulator and just change it to
room_id='0'
Re: [PlusR2] MySQL errors causing D/C
Fixed.
For some reason 2 items had totally bugged out. They were there, but touching them would screw it all up.