BcStorm cannot make new rooms?
I go to make a room, and when I click the button nothing happens.
heres this MySQL log:
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()
Re: BcStorm cannot make new rooms?
Go to you'r table 'rooms' and find 'description' and set it like this:
`description` varchar(200) NOT NULL;
if you cant do it add me on skype: Tim.meiland
Greets,
Tim
Re: BcStorm cannot make new rooms?
My friend have the same problem, if i fixxed this, i will send you the fix ;-)
Re: BcStorm cannot make new rooms?
Insert this code in your database:
SET@@global.sql_mode ='';
Re: BcStorm cannot make new rooms?
Quote:
Originally Posted by
TimNL
My friend have the same problem, if i fixxed this, i will send you the fix ;-)
i am this friend =) and tims awesome