Emulator query error.

Status
Not open for further replies.

EchoVide

New Member
Jul 8, 2013
28
0
Hey there, I've setup PlusEmu and I've been doing a lot of testing for bugs and what not, and I tried to use the :pickall command and I receive this in the logs.

Code:
Error in query:
UPDATE items SET room_id='' WHERE room_id = 5
MySql.Data.MySqlClient.MySqlException (0x80004005): Incorrect integer value: '' for column 'room_id' at row 66
  at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
  at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int32& insertedId)
  at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, 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.ExecuteReader()
  at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
  at Database_Manager.Database.Session_Details.QueryAdapter.runQuery() in C:\Users\Administrator\Desktop\PlusEMU\Plus Emulator\DatabaseManager\Database_Manager\Database\Session_Details\QueryAdapter.cs:line 193
 
 
Error in query:
UPDATE items SET room_id='' WHERE id='66' LIMIT 1
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.GetResult(Int32 statementId, Int32& affectedRows, 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.ExecuteReader()
  at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
  at Database_Manager.Database.Session_Details.QueryAdapter.runQuery() in C:\Users\Administrator\Desktop\PlusEMU\Plus Emulator\DatabaseManager\Database_Manager\Database\Session_Details\QueryAdapter.cs:line 193

How would I go about fixing this?
Thanks,
EchoVide.
 
Status
Not open for further replies.

Users who are viewing this thread

Top