-
Elite Member
BCSTORM error(s)
Hello, i am currently running a powerfull hotel, with BCSTORM, and i need help with this MySQL error,
Error in query:
INSERT INTO rooms (roomtype,caption,owner,model_name) VALUES ('private',@caption,@username,@model)
MySql.Data.MySqlClient.MySqlException (0x80004005): Field 'tags' 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()
when i go to 'create room' on my hotel, it does not work, and this is the error why it is happening, i have had errors after errors just trying to fix this, i fixedmost errors, but it seems like this is the last error.
I need a query to make field 'tags' in the table 'rooms' a default value. SOMEONE PLEASE HELP AS SOON AS POSSIBLE!
-
-
Developer
Re: BCSTORM error(s)
Hey. Try to set the field tags in the table rooms to allow null. I got this error too. It worked for me ;).
On mobile by Tapatalk