BCSTORM error(s)

Results 1 to 2 of 2
  1. #1
    Elite Member louis23401 is offline
    Member +Rank
    Mar 2012 Join Date
    UkLocation
    105Posts

    sad 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!


  2. #2
    Developer PremiumEye is offline
    Grand MasterRank
    Nov 2011 Join Date
    NetherlandsLocation
    550Posts

    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



Advertisement