hello, i keep on getting theese errors in MySqlErrors log, if someone could please help me, that would be great!
here are the errors:
Error in query:
INSERT INTO user_effects (user_id,effect_id,total_duration,is_activated,activated_stamp) VALUES (86,113,3600,0,0)
MySql.Data.MySqlClient.MySqlException (0x80004005): Data truncated for column 'is_activated' 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()
Error in query:
UPDATE users SET users.online = '0', users.points_online = '26', users.last_online = '2/3/2013 4:45:46 PM', activity_points = 650, activity_points_lastupdate = '1359905836', credits = 2572, achievement_points = 5, crystals = '0' WHERE id = 86 ;
MySql.Data.MySqlClient.MySqlException (0x80004005): Out of range value for column 'activity_points_lastupdate' 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()
Error in query:
UPDATE rooms SET caption = @caption, description = @description, password = @password, category = 15, state = 'open', tags = @tags, users_max = 25, allow_pets = 1, allow_pets_eat = 0, allow_walkthrough = 0, allow_hidewall = 0, floorthickness = 0, wallthickness = 0 WHERE id = 82
MySql.Data.MySqlClient.MySqlException (0x80004005): Data truncated for column 'allow_pets_eat' 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()
Error in query:
UPDATE users SET users.online = '0', users.points_online = '87', users.last_online = '2/3/2013 4:19:53 PM', activity_points = 700, activity_points_lastupdate = '1359903928', credits = 11550, achievement_points = 35, crystals = '0' WHERE id = 63 ;
MySql.Data.MySqlClient.MySqlException (0x80004005): Out of range value for column 'activity_points_lastupdate' 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()
Please help as soon as possible!
here are the errors:
Error in query:
INSERT INTO user_effects (user_id,effect_id,total_duration,is_activated,activated_stamp) VALUES (86,113,3600,0,0)
MySql.Data.MySqlClient.MySqlException (0x80004005): Data truncated for column 'is_activated' 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()
Error in query:
UPDATE users SET users.online = '0', users.points_online = '26', users.last_online = '2/3/2013 4:45:46 PM', activity_points = 650, activity_points_lastupdate = '1359905836', credits = 2572, achievement_points = 5, crystals = '0' WHERE id = 86 ;
MySql.Data.MySqlClient.MySqlException (0x80004005): Out of range value for column 'activity_points_lastupdate' 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()
Error in query:
UPDATE rooms SET caption = @caption, description = @description, password = @password, category = 15, state = 'open', tags = @tags, users_max = 25, allow_pets = 1, allow_pets_eat = 0, allow_walkthrough = 0, allow_hidewall = 0, floorthickness = 0, wallthickness = 0 WHERE id = 82
MySql.Data.MySqlClient.MySqlException (0x80004005): Data truncated for column 'allow_pets_eat' 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()
Error in query:
UPDATE users SET users.online = '0', users.points_online = '87', users.last_online = '2/3/2013 4:19:53 PM', activity_points = 700, activity_points_lastupdate = '1359903928', credits = 11550, achievement_points = 35, crystals = '0' WHERE id = 63 ;
MySql.Data.MySqlClient.MySqlException (0x80004005): Out of range value for column 'activity_points_lastupdate' 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()
Please help as soon as possible!