BC - STORM EMU error, PLEAS HELP!

[Kopperud]

Hello everyone, I need some help and hope someone here can answer it! I've set up a R63B hotel and I run bcstorm emulator! Everything works great except for one thing, it does not work to create new rooms!! When I press the button to make new room, the button does not work, so it is impossible to make room. But there comes a query code in the bcstorm emulator. You can see the code below.


Error in query:
INSERT INTO rooms (roomtype,caption,owner,model_name) VALUES ('private',@caption,@username,@model)
MySql.Data.MySqlClient.MySqlException (0x80004005): Field 'description' doesn't have a default value
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.ExecuteScalar()
at Database_Manager.Database.Session_Details.QueryAdapter.insertQuery()

Do any of you know how to fix the Problem? Had been nice if someone knew the answer and could explain me how to fix the error!

THANKS!! - Kopperud

 

[Evilsmoothie]

Field 'description' doesn't have a default value

Give description a default value then? I've had this problem before - but I don't remember exactly what I did to fix it.

 

[Kopperud]

Her you can see:

 

[Evilsmoothie]

Field 'description' doesn't have a default value

Give description a default value then? I've had this problem before - but I don't remember exactly what I did to fix it.

Tried to do that?

 

[Kopperud]

Sry, but how do you give description a default value?

 

[Kopperud]

used this "SET@@global.sql_mode ='';" and it worked THANKS

 

[Evilsmoothie]

used this "SET@@global.sql_mode ='';" and it worked THANKS

Congrats!