Menu
Forums
All threads
Latest threads
New posts
Trending threads
New posts
Search forums
Trending
What's new
New posts
New profile posts
Latest activity
Members
Current visitors
New profile posts
Search profile posts
Upgrades
Log in
Register
What's new
Search
Search
Search titles only
By:
All threads
Latest threads
New posts
Trending threads
New posts
Search forums
Menu
Log in
Register
Navigation
Install the app
Install
More options
Contact us
Close Menu
Forums
Server Development
Habbo Retros
Habbo Q&A
Error in Query Caught
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="wolf788" data-source="post: 222119" data-attributes="member: 2211"><p>Here is MySQLerrors.txt :</p><p>[CODE]</p><p>Error in query:</p><p>INSERT INTO rooms (roomtype,caption,owner,model_name) VALUES ('private',@caption,@username,@model)</p><p>MySql.Data.MySqlClient.MySqlException (0x80004005): Field 'description' doesn't have a default value</p><p> at MySql.Data.MySqlClient.MySqlStream.ReadPacket()</p><p> at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int32& insertedId)</p><p> at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int32& insertedId)</p><p> at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)</p><p> at MySql.Data.MySqlClient.MySqlDataReader.NextResult()</p><p> at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)</p><p> at MySql.Data.MySqlClient.MySqlCommand.ExecuteScalar()</p><p> at Database_Manager.Database.Session_Details.QueryAdapter.insertQuery()</p><p> </p><p> </p><p>Error in query:</p><p>INSERT INTO rooms (roomtype,caption,owner,model_name) VALUES ('private',@caption,@username,@model)</p><p>MySql.Data.MySqlClient.MySqlException (0x80004005): Field 'description' doesn't have a default value</p><p> at MySql.Data.MySqlClient.MySqlStream.ReadPacket()</p><p> at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int32& insertedId)</p><p> at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int32& insertedId)</p><p> at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)</p><p> at MySql.Data.MySqlClient.MySqlDataReader.NextResult()</p><p> at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)</p><p> at MySql.Data.MySqlClient.MySqlCommand.ExecuteScalar()</p><p> at Database_Manager.Database.Session_Details.QueryAdapter.insertQuery()</p><p> </p><p> </p><p>Error in query:</p><p>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 ;</p><p>MySql.Data.MySqlClient.MySqlException (0x80004005): Out of range value for column 'activity_points_lastupdate' at row 1</p><p> at MySql.Data.MySqlClient.MySqlStream.ReadPacket()</p><p> at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int32& insertedId)</p><p> at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int32& insertedId)</p><p> at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)</p><p> at MySql.Data.MySqlClient.MySqlDataReader.NextResult()</p><p> at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)</p><p> at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()</p><p> at Database_Manager.Database.Session_Details.QueryAdapter.runQuery()</p><p>[/CODE]</p><p> </p><p> </p><p>Please help!</p><p></p><p>[CODE]</p><p>Error in packet [1930] BODY: [0][0][0][0]:</p><p>TokenID: 0System.ArgumentOutOfRangeException: 'minValue' cannot be greater than maxValue.</p><p>Parameter name: minValue</p><p> at System.Random.Next(Int32 minValue, Int32 maxValue)</p><p> at Butterfly.HabboHotel.Navigators.Navigator.SerializePublicRooms() in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\HabboHotel\Navigators\Navigator.cs:line 325</p><p> at Butterfly.Messages.GameClientMessageHandler.GetPubs() in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\Messages\GameClientMessageHandler.cs:line 2178</p><p> at Butterfly.Messages.StaticMessageHandlers.SharedPacketLib.GetPubs(GameClientMessageHandler handler) in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\Messages\StaticMessageHandlers\SharedPacketLib.cs:line 350</p><p> 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</p><p> at Butterfly.Messages.GameClientMessageHandler.HandleRequest(ClientMessage request) in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\Messages\GameClientMessageHandler.cs:line 2814</p><p> at Butterfly.HabboHotel.GameClients.GameClient.parser_onNewPacket(ClientMessage Message) in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\HabboHotel\GameClients\GameClient.cs:line 136</p><p> </p><p> </p><p>Error in packet [1930] BODY: [0][0][0][0]:</p><p>TokenID: 0System.ArgumentOutOfRangeException: 'minValue' cannot be greater than maxValue.</p><p>Parameter name: minValue</p><p> at System.Random.Next(Int32 minValue, Int32 maxValue)</p><p> at Butterfly.HabboHotel.Navigators.Navigator.SerializePublicRooms() in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\HabboHotel\Navigators\Navigator.cs:line 325</p><p> at Butterfly.Messages.GameClientMessageHandler.GetPubs() in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\Messages\GameClientMessageHandler.cs:line 2178</p><p> at Butterfly.Messages.StaticMessageHandlers.SharedPacketLib.GetPubs(GameClientMessageHandler handler) in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\Messages\StaticMessageHandlers\SharedPacketLib.cs:line 350</p><p> 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</p><p> at Butterfly.Messages.GameClientMessageHandler.HandleRequest(ClientMessage request) in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\Messages\GameClientMessageHandler.cs:line 2814</p><p> at Butterfly.HabboHotel.GameClients.GameClient.parser_onNewPacket(ClientMessage Message) in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\HabboHotel\GameClients\GameClient.cs:line 136</p><p> </p><p> </p><p>Error in packet [1930] BODY: [0][0][0][0]:</p><p>TokenID: 0System.ArgumentOutOfRangeException: 'minValue' cannot be greater than maxValue.</p><p>Parameter name: minValue</p><p> at System.Random.Next(Int32 minValue, Int32 maxValue)</p><p> at Butterfly.HabboHotel.Navigators.Navigator.SerializePublicRooms() in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\HabboHotel\Navigators\Navigator.cs:line 325</p><p> at Butterfly.Messages.GameClientMessageHandler.GetPubs() in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\Messages\GameClientMessageHandler.cs:line 2178</p><p> at Butterfly.Messages.StaticMessageHandlers.SharedPacketLib.GetPubs(GameClientMessageHandler handler) in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\Messages\StaticMessageHandlers\SharedPacketLib.cs:line 350</p><p> 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</p><p> at Butterfly.Messages.GameClientMessageHandler.HandleRequest(ClientMessage request) in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\Messages\GameClientMessageHandler.cs:line 2814</p><p> at Butterfly.HabboHotel.GameClients.GameClient.parser_onNewPacket(ClientMessage Message) in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\HabboHotel\GameClients\GameClient.cs:line 136</p><p> </p><p> </p><p>Error in packet [1930] BODY: [0][0][0][0]:</p><p>TokenID: 0System.ArgumentOutOfRangeException: 'minValue' cannot be greater than maxValue.</p><p>Parameter name: minValue</p><p> at System.Random.Next(Int32 minValue, Int32 maxValue)</p><p> at Butterfly.HabboHotel.Navigators.Navigator.SerializePublicRooms() in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\HabboHotel\Navigators\Navigator.cs:line 325</p><p> at Butterfly.Messages.GameClientMessageHandler.GetPubs() in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\Messages\GameClientMessageHandler.cs:line 2178</p><p> at Butterfly.Messages.StaticMessageHandlers.SharedPacketLib.GetPubs(GameClientMessageHandler handler) in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\Messages\StaticMessageHandlers\SharedPacketLib.cs:line 350</p><p> 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</p><p> at Butterfly.Messages.GameClientMessageHandler.HandleRequest(ClientMessage request) in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\Messages\GameClientMessageHandler.cs:line 2814</p><p> at Butterfly.HabboHotel.GameClients.GameClient.parser_onNewPacket(ClientMessage Message) in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\HabboHotel\GameClients\GameClient.cs:line 136</p><p> </p><p> </p><p>Error in packet [1930] BODY: [0][0][0][0]:</p><p>TokenID: 0System.ArgumentOutOfRangeException: 'minValue' cannot be greater than maxValue.</p><p>Parameter name: minValue</p><p> at System.Random.Next(Int32 minValue, Int32 maxValue)</p><p> at Butterfly.HabboHotel.Navigators.Navigator.SerializePublicRooms() in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\HabboHotel\Navigators\Navigator.cs:line 325</p><p> at Butterfly.Messages.GameClientMessageHandler.GetPubs() in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\Messages\GameClientMessageHandler.cs:line 2178</p><p> at Butterfly.Messages.StaticMessageHandlers.SharedPacketLib.GetPubs(GameClientMessageHandler handler) in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\Messages\StaticMessageHandlers\SharedPacketLib.cs:line 350</p><p> 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</p><p> at Butterfly.Messages.GameClientMessageHandler.HandleRequest(ClientMessage request) in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\Messages\GameClientMessageHandler.cs:line 2814</p><p> at Butterfly.HabboHotel.GameClients.GameClient.parser_onNewPacket(ClientMessage Message) in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\HabboHotel\GameClients\GameClient.cs:line 136</p><p> </p><p> </p><p>Error in packet [1930] BODY: [0][0][0][0]:</p><p>TokenID: 0System.ArgumentOutOfRangeException: 'minValue' cannot be greater than maxValue.</p><p>Parameter name: minValue</p><p> at System.Random.Next(Int32 minValue, Int32 maxValue)</p><p> at Butterfly.HabboHotel.Navigators.Navigator.SerializePublicRooms() in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\HabboHotel\Navigators\Navigator.cs:line 325</p><p> at Butterfly.Messages.GameClientMessageHandler.GetPubs() in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\Messages\GameClientMessageHandler.cs:line 2178</p><p> at Butterfly.Messages.StaticMessageHandlers.SharedPacketLib.GetPubs(GameClientMessageHandler handler) in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\Messages\StaticMessageHandlers\SharedPacketLib.cs:line 350</p><p> 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</p><p> at Butterfly.Messages.GameClientMessageHandler.HandleRequest(ClientMessage request) in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\Messages\GameClientMessageHandler.cs:line 2814</p><p> at Butterfly.HabboHotel.GameClients.GameClient.parser_onNewPacket(ClientMessage Message) in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\HabboHotel\GameClients\GameClient.cs:line 136</p><p> </p><p> </p><p>Error in packet [1930] BODY: [0][0][0][0]:</p><p>TokenID: 0System.ArgumentOutOfRangeException: 'minValue' cannot be greater than maxValue.</p><p>Parameter name: minValue</p><p> at System.Random.Next(Int32 minValue, Int32 maxValue)</p><p> at Butterfly.HabboHotel.Navigators.Navigator.SerializePublicRooms() in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\HabboHotel\Navigators\Navigator.cs:line 325</p><p> at Butterfly.Messages.GameClientMessageHandler.GetPubs() in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\Messages\GameClientMessageHandler.cs:line 2178</p><p> at Butterfly.Messages.StaticMessageHandlers.SharedPacketLib.GetPubs(GameClientMessageHandler handler) in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\Messages\StaticMessageHandlers\SharedPacketLib.cs:line 350</p><p> 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</p><p> at Butterfly.Messages.GameClientMessageHandler.HandleRequest(ClientMessage request) in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\Messages\GameClientMessageHandler.cs:line 2814</p><p> at Butterfly.HabboHotel.GameClients.GameClient.parser_onNewPacket(ClientMessage Message) in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\HabboHotel\GameClients\GameClient.cs:line 136</p><p> </p><p> </p><p>Error in packet [1930] BODY: [0][0][0][0]:</p><p>TokenID: 0System.ArgumentOutOfRangeException: 'minValue' cannot be greater than maxValue.</p><p>Parameter name: minValue</p><p> at System.Random.Next(Int32 minValue, Int32 maxValue)</p><p> at Butterfly.HabboHotel.Navigators.Navigator.SerializePublicRooms() in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\HabboHotel\Navigators\Navigator.cs:line 325</p><p> at Butterfly.Messages.GameClientMessageHandler.GetPubs() in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\Messages\GameClientMessageHandler.cs:line 2178</p><p> at Butterfly.Messages.StaticMessageHandlers.SharedPacketLib.GetPubs(GameClientMessageHandler handler) in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\Messages\StaticMessageHandlers\SharedPacketLib.cs:line 350</p><p> 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</p><p> at Butterfly.Messages.GameClientMessageHandler.HandleRequest(ClientMessage request) in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\Messages\GameClientMessageHandler.cs:line 2814</p><p> at Butterfly.HabboHotel.GameClients.GameClient.parser_onNewPacket(ClientMessage Message) in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\HabboHotel\GameClients\GameClient.cs:line 136</p><p> </p><p> </p><p>Error in packet [1650] BODY: [0][0][0]][0][0]????:</p><p>TokenID: 0System.NullReferenceException: Object reference not set to an instance of an object.</p><p> at Butterfly.Messages.GameClientMessageHandler.PrepareRoomForUser(UInt32 Id, String Password) in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\Messages\GameClientMessageHandler.cs:line 4818</p><p> at Butterfly.Messages.GameClientMessageHandler.enterOnRoom() in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\Messages\GameClientMessageHandler.cs:line 1535</p><p> at Butterfly.Messages.StaticMessageHandlers.SharedPacketLib.enterOnRoom(GameClientMessageHandler handler) in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\Messages\StaticMessageHandlers\SharedPacketLib.cs:line 205</p><p> 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</p><p> at Butterfly.Messages.GameClientMessageHandler.HandleRequest(ClientMessage request) in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\Messages\GameClientMessageHandler.cs:line 2814</p><p> at Butterfly.HabboHotel.GameClients.GameClient.parser_onNewPacket(ClientMessage Message) in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\HabboHotel\GameClients\GameClient.cs:line 136</p><p> </p><p> </p><p>Error in packet [1930] BODY: [0][0][0][0]:</p><p>TokenID: 0System.ArgumentOutOfRangeException: 'minValue' cannot be greater than maxValue.</p><p>Parameter name: minValue</p><p> at System.Random.Next(Int32 minValue, Int32 maxValue)</p><p> at Butterfly.HabboHotel.Navigators.Navigator.SerializePublicRooms() in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\HabboHotel\Navigators\Navigator.cs:line 325</p><p> at Butterfly.Messages.GameClientMessageHandler.GetPubs() in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\Messages\GameClientMessageHandler.cs:line 2178</p><p> at Butterfly.Messages.StaticMessageHandlers.SharedPacketLib.GetPubs(GameClientMessageHandler handler) in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\Messages\StaticMessageHandlers\SharedPacketLib.cs:line 350</p><p> 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</p><p> at Butterfly.Messages.GameClientMessageHandler.HandleRequest(ClientMessage request) in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\Messages\GameClientMessageHandler.cs:line 2814</p><p> at Butterfly.HabboHotel.GameClients.GameClient.parser_onNewPacket(ClientMessage Message) in c:\Users\Leon\Desktop\Development\C#\BcStorm\Butterfly\HabboHotel\GameClients\GameClient.cs:line 136</p><p>[/CODE] Packet error - deleted some to be able to add</p></blockquote><p></p>
[QUOTE="wolf788, post: 222119, member: 2211"] 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() [/CODE] 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 [/CODE] Packet error - deleted some to be able to add [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
Server Development
Habbo Retros
Habbo Q&A
Error in Query Caught
Top