HOW TO FIX THIS?

[StephanProject]

Error in query:
UPDATE items SET user_id = 29, room_id='' WHERE id = 5345
MySql.Data.MySqlClient.MySqlException (0x80004005): Incorrect integer value: '' for column 'room_id' at row 1


When i pickup an furniture, it emtpy my inventory, and not showing furniture. how to fix this ^

 

[Xuxu]

i believe it has to do with a column in your database called "room_id" not sure what table it is found in though. you have a invalid integer for one of the rows of that column

 

[StephanProject]

i believe it has to do with a column in your database called "room_id" not sure what table it is found in though. you have a invalid integer for one of the rows of that column

Thanks that far was i, i know it where it is but how to fix it.. thats my question..

 

[Xuxu]

can you sceenshot the whole row of the column room_id?

 

[Zaka]

It's easy... The room_id column expects an integer, a number, and you provide it with a string when you do room_id = "", even tho it's empty, it's still a string.