Kristopher
Photographer
- Dec 25, 2010
- 803
- 68
After transfering to another server I also get this error...
Error in query:
UPDATE items SET user_id = 19, room_id='' WHERE id = 8928
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.ExecuteNonQuery()
at Database_Manager.Database.Session_Details.QueryAdapter.runQuery() in c:\Users\Administrator\Desktop\FadeEmulator\Plus Emulator\DatabaseManager\Database_Manager\Database\Session_Details\QueryAdapter.cs:line 193
Error in query:
UPDATE items SET room_id='' WHERE id=8924 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.ExecuteNonQuery()
at Database_Manager.Database.Session_Details.QueryAdapter.runQuery() in c:\Users\Administrator\Desktop\FadeEmulator\Plus Emulator\DatabaseManager\Database_Manager\Database\Session_Details\QueryAdapter.cs:line 193
Error in query:
UPDATE items SET user_id = 19, room_id='' WHERE id = 8924
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.ExecuteNonQuery()
at Database_Manager.Database.Session_Details.QueryAdapter.runQuery() in c:\Users\Administrator\Desktop\FadeEmulator\Plus Emulator\DatabaseManager\Database_Manager\Database\Session_Details\QueryAdapter.cs:line 193
UPDATE items SET user_id = 19, room_id='' WHERE id = 8928
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.ExecuteNonQuery()
at Database_Manager.Database.Session_Details.QueryAdapter.runQuery() in c:\Users\Administrator\Desktop\FadeEmulator\Plus Emulator\DatabaseManager\Database_Manager\Database\Session_Details\QueryAdapter.cs:line 193
Error in query:
UPDATE items SET room_id='' WHERE id=8924 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.ExecuteNonQuery()
at Database_Manager.Database.Session_Details.QueryAdapter.runQuery() in c:\Users\Administrator\Desktop\FadeEmulator\Plus Emulator\DatabaseManager\Database_Manager\Database\Session_Details\QueryAdapter.cs:line 193
Error in query:
UPDATE items SET user_id = 19, room_id='' WHERE id = 8924
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.ExecuteNonQuery()
at Database_Manager.Database.Session_Details.QueryAdapter.runQuery() in c:\Users\Administrator\Desktop\FadeEmulator\Plus Emulator\DatabaseManager\Database_Manager\Database\Session_Details\QueryAdapter.cs:line 193