Bcstorm create rooms dont work!

[louis23401]

hello, my users keep on asking me why when they try to make a new room, it dont work, for some reason i thought it was an error in the MySQLErrors saying this:

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.ExecuteReader()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteScalar()
at Database_Manager.Database.Session_Details.QueryAdapter.insertQuery()


can someone help me AS SOON AS POSSIBLE?!?!?

 

[PremiumEye]

Read please your error. It's saying field description in the table rooms doesn't have a default value. I actually don't know which field type description needs but try to import the table rooms again.

On mobile by Tapatalk

 

[louis23401]

Read please your error. It's saying field description in the table rooms doesn't have a default value. I actually don't know which field type description needs but try to import the table rooms again.

On mobile by Tapatalk

I already have had users make rooms... im sure they do not want to start again. any other possible way of doing this?

 

[Emily]

Change:

INSERT INTO rooms (roomtype,caption,owner,model_name) VALUES ('private',@caption,@username,@model)

Into:

INSERT INTO rooms (roomtype,caption,owner,model_name,description) VALUES ('private',@caption,@username,@model,'')

 

[louis23401]

Change:

INSERT INTO rooms (roomtype,caption,owner,model_name) VALUES ('private',@caption,@username,@model)

Into:

INSERT INTO rooms (roomtype,caption,owner,model_name,description) VALUES ('private',@caption,@username,@model,'')

Field 'public_ccts' doesn't have a default value......

 

[PremiumEye]

Change:

INSERT INTO rooms (roomtype,caption,owner,model_name) VALUES ('private',@caption,@username,@model)

Into:

INSERT INTO rooms (roomtype,caption,owner,model_name,description) VALUES ('private',@caption,@username,@model,'')

Mysql should make from description NULL. Even with other fields who are in the table.

On mobile by Tapatalk

 

[KeineChance]

Add this SQL in your database:

SET@@global.sql_mode ='';

 

[louis23401]

Add this SQL in your database:

SET@@global.sql_mode ='';

already tried, didnt work someone please help?

 

[PremiumEye]

already tried, didnt work someone please help?

Try to allow null value for description in the database

 

[Noman]

Add this SQL in your database:

SET@@global.sql_mode ='';

That command doesn't even work lol.

 

[Ma Ma]

Add default values from navicat , to your public ctt , password , description i forgot the type but i fixed it for someone last night i think for public cct should me text and put default to empty string easy fix just read the msql and use your brain and look at other default in the room tables

 

[TimNL]

Open your PHP.ini and set

sql_mode = '';

save and restart IIS/Apache
Run this query then.

[COLOR=#333333][I]SET@@global.sql_mode ='';
[/I][/COLOR]

No thanks ;-)

*And restart your emulator *

 

[duckietm]

I have the same problem

 

[louis23401]

Open your PHP.ini and set

sql_mode = '';

save and restart IIS/Apache
Run this query then.

[COLOR=#333333][I]SET@@global.sql_mode ='';
[/I][/COLOR]

No thanks ;-)

*And restart your emulator *

i did this, and it happened again, any help?

 

[Matata]

Field 'description' doesn't have a default value
Set a default value to 'description'. It's really that easy.

 

[louis23401]

Field 'description' doesn't have a default value
Set a default value to 'description'. It's really that easy.

i did that, then asked for more default value stuff, so i did that, then restarted emulator, all of a sudden as i go on navigator it dont work, and crashes

 

[Flare]

SIMPLE. go to mysql/ my.ini and go to the file open it and look for : # Set the SQL mode to strict


and then under it delete that line nad put sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"


restart MYSQL and done