Moodlights Error.

[Berk]

Heyo guys.
Been trying to add moodlights to my room and emulator came up with these logs:

Error in query:
INSERT INTO `room_items_moodlight` (item_id,enabled,current_preset,preset_one,preset_two,preset_three) VALUES (1129,0,1,'#000000,255,0','#000000,255,0','#000000,255,0')
MySql.Data.MySqlClient.MySqlException (0x80004005): Data truncated for column 'enabled' at row 1
   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& 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.ExecuteNonQuery()
   at Plus.Database.Adapter.QueryAdapter.RunQuery() in C:\Users\Sledmore\Desktop\PlusEMU\Database\Adapter\QueryAdapter.cs:line 177

There is nothing in room_items_moodlight table. I don't know what to do?

 

[TheRealMoonman]

What is the datatype of Enabled?

 

[Berk]

What is the datatype of Enabled?

Enum, 0 and 1.

 

[TheRealMoonman]

Enum, 0 and 1.

Hm, I have ran into this problem before i believe, pretty sure MySQL treats integers that are being inserted into an enumeration column as 1 based index, I personally changed the column datatype to an int value and have the default set as 0.

 

[JynX]

Pastebin the file where the query is located.

 

[Berk]

Got fixed, thanks!

 

[JynX]

Got fixed, thanks!

Whilst it is a fix, it's not something you should do as it can easily be fixed within the emulator. But you do you