Emu Error help

[iTzScronnie]

How do I fix this?

Error in query: 
UPDATE items SET room_id='' WHERE id=295 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 e:\Documents\Emulator [L]\Emulator [L]\Plus Emulator\DatabaseManager\Database_Manager\Database\Session_Details\QueryAdapter.cs:line 193

[MentaL]

[iTzScronnie]

Bump ^^
@AKllX

Do you know how to fix this? I keep getting this error.

[AKllX]

You are trying to insert a empty value when placing an item on the floor. It can be either a query in which the argument is invalid or the room id is invalid. First you search for ' UPDATE items SET room_id= ' and make sure that the argument in defined. Them, you try to print it into the console to check if it's value is null or not. Or you can use my version of Plus

[iTzScronnie]

@AKllX

I want your version but I can't find swfs that will work for it at all. Could you hooke me up with a link to your emu and swfs?

[The General]

I've said this to tens of other threads having the same issue: Change where it sets the NULL value to a 0.

[iTzScronnie]

I've said this to tens of other threads having the same issue: Change where it sets the NULL value to a 0.

where at tho?

[nixia12]

yes, i have the same issue..help me too :(

[The General]

where at tho?

for the field room_id in the emulator source.

If people actually read the errors and atleast tried to understand what it says, we would've less help threads.

[iTzScronnie]

for the field room_id in the emulator source.

If people actually read the errors and atleast tried to understand what it says, we would've less help threads.

Well I still get the error even after doing that js