SQL error

[Stevee]

hiya,

this SQL error keeps popping up..

not sure why, i've tried the fix i used last time, didn't work.

this is the SQL error:
Error in query:
INSERT INTO room_items_moodlight (item_id,enabled,current_preset,preset_one,preset_two,preset_three) VALUES (840,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 e:\Documents\Emulator [L]\Emulator [L]\Plus Emulator\DatabaseManager\Database_Manager\Database\Session_Details\QueryAdapter.cs:line 193



Thanks,
steve

 

[JayC]

If your trying to run a sql there is no table called "room_items_moodlight" lol.

 

[Stevee]

If your trying to run a sql there is no table called "room_items_moodlight" lol.

No, I sorted this,..

Now my last issue is this.. i think its gotta do with the swfs.

You must be registered for see links

 

[JayC]

You're right. External variables