Plus EMU - Moodlight not working

[Evilsmoothie]

Hello ragezone!
Well for some days now, I've been trying to find the reason the moodlights in plus emu doesn't work. I'm not sharpest, but I gave it a try atleast.

You can't put the moodlight down in the room. The emulator says it's an error in query, but it doesn't output to the logs.

Thanks for any help. :-)

UPDATE
The emulator decided to output the errors, and quite a few of them too..
http://pastebin.com/gjGsEY68

[MentaL]

[JackHoll]

Try to match your room_items_moodlight with mine, I'm running PlusEmu (Eubbo.pw release) and I had the exact same problem.

But I solved it by adjusting the table slightly.

http://puu.sh/57eR1.png

Also, the error logs my emulator produced (If it helps)

Error in query: INSERT INTO room_items_moodlight (item_id,enabled,current_preset,preset_one,preset_two,preset_three) VALUES (1,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, 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.ExecuteNonQuery()
at Database_Manager.Database.Session_Details.QueryAdapter.runQuery() in c:\Users\Jack\Desktop\emu4\DatabaseManager\Database_Manager\Database\Session_Details\QueryAdapter.cs:line 193

[Evilsmoothie]

Try to match your room_items_moodlight with mine, I'm running PlusEmu (Eubbo.pw release) and I had the exact same problem.

But I solved it by adjusting the table slightly.

http://puu.sh/57eR1.png

Also, the error logs my emulator produced (If it helps)

Well.. no that didn't solve it. I can place down moodlights on my localhost, but not on the vps. So I suspect that is caused by some changes I've made in the db. But, moodlight settings don't stay enabled. So when the room is unloaded or the emu is restarted, it's back to blank.
Thanks for trying atleast :-)

[Evilsmoothie]

Sorry, but bump. Feel my case should have another go as I got the error and probably alot more people could help or atleast have an idea.

UPDATE
The emulator decided to output the errors, and quite a few of them too..
mysql logs - Pastebin.com