Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

Bcstorm!

Junior Spellweaver
Joined
Mar 3, 2012
Messages
105
Reaction score
17
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!
 
Custom Title Activated
Loyal Member
Joined
Jun 27, 2009
Messages
1,571
Reaction score
170
If you don't understand coding or server hosting in general don't even bother your just wasting other people time. Just go use Phoenix it's already done for you :)
 
Upvote 0
Back
Top