Error in Query Caught

wolf788

wolf788

Member
Jan 12, 2011
99
2
Here is MySQLerrors.txt :
Code: 
Error in query:
INSERT INTO rooms (roomtype,caption,owner,model_name) VALUES ('private',@caption,@username,@model)
MySql.Data.MySqlClient.MySqlException (0x80004005): Field 'description' doesn't have a default value
  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.ExecuteScalar()
  at Database_Manager.Database.Session_Details.QueryAdapter.insertQuery()
 
 
Error in query:
INSERT INTO rooms (roomtype,caption,owner,model_name) VALUES ('private',@caption,@username,@model)
MySql.Data.MySqlClient.MySqlException (0x80004005): Field 'description' doesn't have a default value
  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.ExecuteScalar()
  at Database_Manager.Database.Session_Details.QueryAdapter.insertQuery()
 
 
Error in query:
UPDATE users SET users.online = '0', users.points_online = '2', users.last_online = '8/12/2013 1:50:36 AM', activity_points = 10100, activity_points_lastupdate = '1376286611', credits = 8100, achievement_points = 5 WHERE id = 6 ;
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!

Code: 
Error in packet [1930] BODY: [0][0][0][0]:
TokenID: 0System.ArgumentOutOfRangeException: 'minValue' cannot be greater than maxValue.
Parameter name: minValue
  at System.Random.Next(Int32 minValue, Int32 maxValue)
  at Butterfly.HabboHotel.Navigators.Navigator.SerializePublicRooms() in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\HabboHotel\Navigators\Navigator.cs:line 325
  at Butterfly.Messages.GameClientMessageHandler.GetPubs() in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\Messages\GameClientMessageHandler.cs:line 2178
  at Butterfly.Messages.StaticMessageHandlers.SharedPacketLib.GetPubs(GameClientMessageHandler handler) in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\Messages\StaticMessageHandlers\SharedPacketLib.cs:line 350
  at Butterfly.Messages.StaticMessageHandlers.StaticClientMessageHandler.HandlePacket(GameClientMessageHandler handler, ClientMessage message) in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\Messages\StaticMessageHandlers\StaticClientMessageHandler.cs:line 29
  at Butterfly.Messages.GameClientMessageHandler.HandleRequest(ClientMessage request) in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\Messages\GameClientMessageHandler.cs:line 2814
  at Butterfly.HabboHotel.GameClients.GameClient.parser_onNewPacket(ClientMessage Message) in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\HabboHotel\GameClients\GameClient.cs:line 136
 
 
Error in packet [1930] BODY: [0][0][0][0]:
TokenID: 0System.ArgumentOutOfRangeException: 'minValue' cannot be greater than maxValue.
Parameter name: minValue
  at System.Random.Next(Int32 minValue, Int32 maxValue)
  at Butterfly.HabboHotel.Navigators.Navigator.SerializePublicRooms() in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\HabboHotel\Navigators\Navigator.cs:line 325
  at Butterfly.Messages.GameClientMessageHandler.GetPubs() in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\Messages\GameClientMessageHandler.cs:line 2178
  at Butterfly.Messages.StaticMessageHandlers.SharedPacketLib.GetPubs(GameClientMessageHandler handler) in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\Messages\StaticMessageHandlers\SharedPacketLib.cs:line 350
  at Butterfly.Messages.StaticMessageHandlers.StaticClientMessageHandler.HandlePacket(GameClientMessageHandler handler, ClientMessage message) in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\Messages\StaticMessageHandlers\StaticClientMessageHandler.cs:line 29
  at Butterfly.Messages.GameClientMessageHandler.HandleRequest(ClientMessage request) in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\Messages\GameClientMessageHandler.cs:line 2814
  at Butterfly.HabboHotel.GameClients.GameClient.parser_onNewPacket(ClientMessage Message) in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\HabboHotel\GameClients\GameClient.cs:line 136
 
 
Error in packet [1930] BODY: [0][0][0][0]:
TokenID: 0System.ArgumentOutOfRangeException: 'minValue' cannot be greater than maxValue.
Parameter name: minValue
  at System.Random.Next(Int32 minValue, Int32 maxValue)
  at Butterfly.HabboHotel.Navigators.Navigator.SerializePublicRooms() in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\HabboHotel\Navigators\Navigator.cs:line 325
  at Butterfly.Messages.GameClientMessageHandler.GetPubs() in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\Messages\GameClientMessageHandler.cs:line 2178
  at Butterfly.Messages.StaticMessageHandlers.SharedPacketLib.GetPubs(GameClientMessageHandler handler) in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\Messages\StaticMessageHandlers\SharedPacketLib.cs:line 350
  at Butterfly.Messages.StaticMessageHandlers.StaticClientMessageHandler.HandlePacket(GameClientMessageHandler handler, ClientMessage message) in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\Messages\StaticMessageHandlers\StaticClientMessageHandler.cs:line 29
  at Butterfly.Messages.GameClientMessageHandler.HandleRequest(ClientMessage request) in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\Messages\GameClientMessageHandler.cs:line 2814
  at Butterfly.HabboHotel.GameClients.GameClient.parser_onNewPacket(ClientMessage Message) in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\HabboHotel\GameClients\GameClient.cs:line 136
 
 
Error in packet [1930] BODY: [0][0][0][0]:
TokenID: 0System.ArgumentOutOfRangeException: 'minValue' cannot be greater than maxValue.
Parameter name: minValue
  at System.Random.Next(Int32 minValue, Int32 maxValue)
  at Butterfly.HabboHotel.Navigators.Navigator.SerializePublicRooms() in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\HabboHotel\Navigators\Navigator.cs:line 325
  at Butterfly.Messages.GameClientMessageHandler.GetPubs() in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\Messages\GameClientMessageHandler.cs:line 2178
  at Butterfly.Messages.StaticMessageHandlers.SharedPacketLib.GetPubs(GameClientMessageHandler handler) in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\Messages\StaticMessageHandlers\SharedPacketLib.cs:line 350
  at Butterfly.Messages.StaticMessageHandlers.StaticClientMessageHandler.HandlePacket(GameClientMessageHandler handler, ClientMessage message) in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\Messages\StaticMessageHandlers\StaticClientMessageHandler.cs:line 29
  at Butterfly.Messages.GameClientMessageHandler.HandleRequest(ClientMessage request) in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\Messages\GameClientMessageHandler.cs:line 2814
  at Butterfly.HabboHotel.GameClients.GameClient.parser_onNewPacket(ClientMessage Message) in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\HabboHotel\GameClients\GameClient.cs:line 136
 
 
Error in packet [1930] BODY: [0][0][0][0]:
TokenID: 0System.ArgumentOutOfRangeException: 'minValue' cannot be greater than maxValue.
Parameter name: minValue
  at System.Random.Next(Int32 minValue, Int32 maxValue)
  at Butterfly.HabboHotel.Navigators.Navigator.SerializePublicRooms() in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\HabboHotel\Navigators\Navigator.cs:line 325
  at Butterfly.Messages.GameClientMessageHandler.GetPubs() in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\Messages\GameClientMessageHandler.cs:line 2178
  at Butterfly.Messages.StaticMessageHandlers.SharedPacketLib.GetPubs(GameClientMessageHandler handler) in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\Messages\StaticMessageHandlers\SharedPacketLib.cs:line 350
  at Butterfly.Messages.StaticMessageHandlers.StaticClientMessageHandler.HandlePacket(GameClientMessageHandler handler, ClientMessage message) in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\Messages\StaticMessageHandlers\StaticClientMessageHandler.cs:line 29
  at Butterfly.Messages.GameClientMessageHandler.HandleRequest(ClientMessage request) in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\Messages\GameClientMessageHandler.cs:line 2814
  at Butterfly.HabboHotel.GameClients.GameClient.parser_onNewPacket(ClientMessage Message) in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\HabboHotel\GameClients\GameClient.cs:line 136
 
 
Error in packet [1930] BODY: [0][0][0][0]:
TokenID: 0System.ArgumentOutOfRangeException: 'minValue' cannot be greater than maxValue.
Parameter name: minValue
  at System.Random.Next(Int32 minValue, Int32 maxValue)
  at Butterfly.HabboHotel.Navigators.Navigator.SerializePublicRooms() in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\HabboHotel\Navigators\Navigator.cs:line 325
  at Butterfly.Messages.GameClientMessageHandler.GetPubs() in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\Messages\GameClientMessageHandler.cs:line 2178
  at Butterfly.Messages.StaticMessageHandlers.SharedPacketLib.GetPubs(GameClientMessageHandler handler) in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\Messages\StaticMessageHandlers\SharedPacketLib.cs:line 350
  at Butterfly.Messages.StaticMessageHandlers.StaticClientMessageHandler.HandlePacket(GameClientMessageHandler handler, ClientMessage message) in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\Messages\StaticMessageHandlers\StaticClientMessageHandler.cs:line 29
  at Butterfly.Messages.GameClientMessageHandler.HandleRequest(ClientMessage request) in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\Messages\GameClientMessageHandler.cs:line 2814
  at Butterfly.HabboHotel.GameClients.GameClient.parser_onNewPacket(ClientMessage Message) in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\HabboHotel\GameClients\GameClient.cs:line 136
 
 
Error in packet [1930] BODY: [0][0][0][0]:
TokenID: 0System.ArgumentOutOfRangeException: 'minValue' cannot be greater than maxValue.
Parameter name: minValue
  at System.Random.Next(Int32 minValue, Int32 maxValue)
  at Butterfly.HabboHotel.Navigators.Navigator.SerializePublicRooms() in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\HabboHotel\Navigators\Navigator.cs:line 325
  at Butterfly.Messages.GameClientMessageHandler.GetPubs() in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\Messages\GameClientMessageHandler.cs:line 2178
  at Butterfly.Messages.StaticMessageHandlers.SharedPacketLib.GetPubs(GameClientMessageHandler handler) in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\Messages\StaticMessageHandlers\SharedPacketLib.cs:line 350
  at Butterfly.Messages.StaticMessageHandlers.StaticClientMessageHandler.HandlePacket(GameClientMessageHandler handler, ClientMessage message) in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\Messages\StaticMessageHandlers\StaticClientMessageHandler.cs:line 29
  at Butterfly.Messages.GameClientMessageHandler.HandleRequest(ClientMessage request) in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\Messages\GameClientMessageHandler.cs:line 2814
  at Butterfly.HabboHotel.GameClients.GameClient.parser_onNewPacket(ClientMessage Message) in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\HabboHotel\GameClients\GameClient.cs:line 136
 
 
Error in packet [1930] BODY: [0][0][0][0]:
TokenID: 0System.ArgumentOutOfRangeException: 'minValue' cannot be greater than maxValue.
Parameter name: minValue
  at System.Random.Next(Int32 minValue, Int32 maxValue)
  at Butterfly.HabboHotel.Navigators.Navigator.SerializePublicRooms() in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\HabboHotel\Navigators\Navigator.cs:line 325
  at Butterfly.Messages.GameClientMessageHandler.GetPubs() in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\Messages\GameClientMessageHandler.cs:line 2178
  at Butterfly.Messages.StaticMessageHandlers.SharedPacketLib.GetPubs(GameClientMessageHandler handler) in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\Messages\StaticMessageHandlers\SharedPacketLib.cs:line 350
  at Butterfly.Messages.StaticMessageHandlers.StaticClientMessageHandler.HandlePacket(GameClientMessageHandler handler, ClientMessage message) in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\Messages\StaticMessageHandlers\StaticClientMessageHandler.cs:line 29
  at Butterfly.Messages.GameClientMessageHandler.HandleRequest(ClientMessage request) in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\Messages\GameClientMessageHandler.cs:line 2814
  at Butterfly.HabboHotel.GameClients.GameClient.parser_onNewPacket(ClientMessage Message) in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\HabboHotel\GameClients\GameClient.cs:line 136
 
 
Error in packet [1650] BODY: [0][0][0]][0][0]????:
TokenID: 0System.NullReferenceException: Object reference not set to an instance of an object.
  at Butterfly.Messages.GameClientMessageHandler.PrepareRoomForUser(UInt32 Id, String Password) in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\Messages\GameClientMessageHandler.cs:line 4818
  at Butterfly.Messages.GameClientMessageHandler.enterOnRoom() in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\Messages\GameClientMessageHandler.cs:line 1535
  at Butterfly.Messages.StaticMessageHandlers.SharedPacketLib.enterOnRoom(GameClientMessageHandler handler) in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\Messages\StaticMessageHandlers\SharedPacketLib.cs:line 205
  at Butterfly.Messages.StaticMessageHandlers.StaticClientMessageHandler.HandlePacket(GameClientMessageHandler handler, ClientMessage message) in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\Messages\StaticMessageHandlers\StaticClientMessageHandler.cs:line 29
  at Butterfly.Messages.GameClientMessageHandler.HandleRequest(ClientMessage request) in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\Messages\GameClientMessageHandler.cs:line 2814
  at Butterfly.HabboHotel.GameClients.GameClient.parser_onNewPacket(ClientMessage Message) in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\HabboHotel\GameClients\GameClient.cs:line 136
 
 
Error in packet [1930] BODY: [0][0][0][0]:
TokenID: 0System.ArgumentOutOfRangeException: 'minValue' cannot be greater than maxValue.
Parameter name: minValue
  at System.Random.Next(Int32 minValue, Int32 maxValue)
  at Butterfly.HabboHotel.Navigators.Navigator.SerializePublicRooms() in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\HabboHotel\Navigators\Navigator.cs:line 325
  at Butterfly.Messages.GameClientMessageHandler.GetPubs() in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\Messages\GameClientMessageHandler.cs:line 2178
  at Butterfly.Messages.StaticMessageHandlers.SharedPacketLib.GetPubs(GameClientMessageHandler handler) in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\Messages\StaticMessageHandlers\SharedPacketLib.cs:line 350
  at Butterfly.Messages.StaticMessageHandlers.StaticClientMessageHandler.HandlePacket(GameClientMessageHandler handler, ClientMessage message) in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\Messages\StaticMessageHandlers\StaticClientMessageHandler.cs:line 29
  at Butterfly.Messages.GameClientMessageHandler.HandleRequest(ClientMessage request) in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\Messages\GameClientMessageHandler.cs:line 2814
  at Butterfly.HabboHotel.GameClients.GameClient.parser_onNewPacket(ClientMessage Message) in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\HabboHotel\GameClients\GameClient.cs:line 136
Packet error - deleted some to be able to add
 
Sort by date Sort by votes
Sledmore

Sledmore

Chaturbate Livestreamer
Staff member
FindRetros Moderator
Jul 24, 2010
5,195
3,906
Okay so basically you need to give `description` in the `rooms` table a default value (empty string).

For the second one, change the value for `activity_points_lastupdate` a little higher (I have mine on double size 5, default 0).

Now the third log is pretty simple, the minValue (smallest value) is greater than the maxValue, so I'd assume add more public rooms or change some configuration you have set up.
 
Upvote 0 Downvote

Users who are viewing this thread

Total: 2 (members: 0, guests: 2)
☀️  Switch to Light Theme

Latest posts

Top