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
mySQL errors?
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="Stevee" data-source="post: 232229" data-attributes="member: 2643"><p>Hi, I was wondering how to fix these.. I tried to fix it myself, didn't work.</p><p></p><p></p><p></p><p> Exceptions:</p><p></p><p></p><p></p><p>This one:</p><p>[CODE]9/11/2013 9:02:13 PM: Error: MySql.Data.MySqlClient.MySqlException (0x80004005): Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.TimeoutException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond ---> System.IO.IOException: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond. ---> System.Net.Sockets.SocketException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond</p><p> at System.Net.Sockets.Socket.Receive(Byte[] buffer, Int32 offset, Int32 size, SocketFlags socketFlags)</p><p> at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)</p><p> --- End of inner exception stack trace ---</p><p> at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)</p><p> at MySql.Data.Common.MyNetworkStream.Read(Byte[] buffer, Int32 offset, Int32 count)</p><p> --- End of inner exception stack trace ---</p><p> at MySql.Data.Common.MyNetworkStream.HandleOrRethrowException(Exception e)</p><p> at MySql.Data.Common.MyNetworkStream.Read(Byte[] buffer, Int32 offset, Int32 count)</p><p> at MySql.Data.MySqlClient.TimedStream.Read(Byte[] buffer, Int32 offset, Int32 count)</p><p> at System.IO.BufferedStream.Read(Byte[] array, Int32 offset, Int32 count)</p><p> at MySql.Data.MySqlClient.MySqlStream.ReadFully(Stream stream, Byte[] buffer, Int32 offset, Int32 count)</p><p> at MySql.Data.MySqlClient.MySqlStream.LoadPacket()</p><p> at MySql.Data.MySqlClient.MySqlStream.ReadPacket()</p><p> at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)</p><p> at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& 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.ExceptionInterceptor.Throw(Exception exception)</p><p> at MySql.Data.MySqlClient.MySqlConnection.Throw(Exception ex)</p><p> at MySql.Data.MySqlClient.MySqlConnection.HandleTimeoutOrThreadAbort(Exception ex)</p><p> at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)</p><p> at MySql.Data.MySqlClient.MySqlCommand.ExecuteScalar()</p><p> at Phoenix.Storage.DatabaseClient.ExecuteQuery(String sQuery) in c:\Users\Leon\Desktop\Development\Phoenix Neto Source\Source\Phoenix\Storage\DatabaseClient.cs:line 32</p><p> at Phoenix.HabboHotel.Rooms.Class33.method_1(GameClient class16_0, String string_1, Boolean bool_13) in c:\Users\Leon\Desktop\Development\Phoenix Neto Source\Source\Phoenix\HabboHotel\Rooms\Class33.cs:line 282</p><p> at Phoenix.Communication.Messages.Rooms.Chat.ChatMessageEvent.imethod_0(GameClient class16_0, ClientMessage class18_0) in c:\Users\Leon\Desktop\Development\Phoenix Neto Source\Source\Phoenix\Communication\Messages\Rooms\Chat\Class257.cs:line 17</p><p> at Phoenix.HabboHotel.GameClients.GameClient.method_13(Byte[]& byte_0) in c:\Users\Leon\Desktop\Development\Phoenix Neto Source\Source\Phoenix\HabboHotel\GameClients\GameClient.cs:line 482</p><p>[/CODE]</p><p></p><p>This one:</p><p>[CODE]9/11/2013 9:02:13 PM: Error: System.NullReferenceException: Object reference not set to an instance of an object.</p><p> at Phoenix.Communication.Messages.Rooms.Chat.CancelTypingMessageEvent.imethod_0(GameClient class16_0, ClientMessage class18_0) in c:\Users\Leon\Desktop\Development\Phoenix Neto Source\Source\Phoenix\Communication\Messages\Rooms\Chat\Class253.cs:line 11</p><p> at Phoenix.HabboHotel.GameClients.GameClient.method_13(Byte[]& byte_0) in c:\Users\Leon\Desktop\Development\Phoenix Neto Source\Source\Phoenix\HabboHotel\GameClients\GameClient.cs:line 482</p><p>[/CODE]</p><p></p><p>and last but not least: </p><p></p><p>[CODE]9/11/2013 9:02:56 PM: Error: System.NullReferenceException: Object reference not set to an instance of an object.</p><p> at MySql.Data.MySqlClient.MySqlCommand.ExecuteScalar()</p><p> at Phoenix.Storage.DatabaseClient.ExecuteQuery(String sQuery) in c:\Users\Leon\Desktop\Development\Phoenix Neto Source\Source\Phoenix\Storage\DatabaseClient.cs:line 32</p><p> at Phoenix.HabboHotel.Users.Habbo.method_10(UInt32 RoomId) in c:\Users\Leon\Desktop\Development\Phoenix Neto Source\Source\Phoenix\HabboHotel\Users\Habbo.cs:line 535</p><p> at Phoenix.HabboHotel.Rooms.Room.method_46(GameClient class16_0, Boolean bool_13) in c:\Users\Leon\Desktop\Development\Phoenix Neto Source\Source\Phoenix\HabboHotel\Rooms\Room.cs:line 3858</p><p> at Phoenix.Communication.Messages.Rooms.Engine.GetRoomEntryDataMessageEvent.imethod_0(GameClient class16_0, ClientMessage class18_0) in c:\Users\Leon\Desktop\Development\Phoenix Neto Source\Source\Phoenix\Communication\Messages\Rooms\Engine\Class250.cs:line 62</p><p> at Phoenix.HabboHotel.GameClients.GameClient.method_13(Byte[]& byte_0) in c:\Users\Leon\Desktop\Development\Phoenix Neto Source\Source\Phoenix\HabboHotel\GameClients\GameClient.cs:line 482</p><p>[/CODE]</p><p></p><p></p><p>Critical Exceptions: </p><p></p><p></p><p>[CODE]9/11/2013 9:02:14 PM: Error during saving wired items for room 35. Stack: System.NullReferenceException: Object reference not set to an instance of an object.</p><p> at MySql.Data.MySqlClient.MySqlCommand.ExecuteScalar()</p><p> at Phoenix.Storage.DatabaseClient.ExecuteQuery(String sQuery) in c:\Users\Leon\Desktop\Development\Phoenix Neto Source\Source\Phoenix\Storage\DatabaseClient.cs:line 32</p><p> at Phoenix.HabboHotel.Rooms.Room.method_64() in c:\Users\Leon\Desktop\Development\Phoenix Neto Source\Source\Phoenix\HabboHotel\Rooms\Room.cs:line 4396</p><p>Query: DELETE FROM wired_items WHERE item_id = '1389' LIMIT 1; INSERT INTO wired_items (item_id,extra1,extra2,extra3,extra4,extra5) VALUES ('1389',@1389Extra1,@1389Extra2,@1389Extra3,@1389Extra4,@1389Extra5); DELETE FROM wired_items WHERE item_id = '8241' LIMIT 1; INSERT INTO wired_items (item_id,extra1,extra2,extra3,extra4,extra5) VALUES ('8241',@8241Extra1,@8241Extra2,@8241Extra3,@8241Extra4,@8241Extra5);</p><p>[/CODE]</p><p></p><p></p><p>any ideas thanks steve</p></blockquote><p></p>
[QUOTE="Stevee, post: 232229, member: 2643"] Hi, I was wondering how to fix these.. I tried to fix it myself, didn't work. Exceptions: This one: [CODE]9/11/2013 9:02:13 PM: Error: MySql.Data.MySqlClient.MySqlException (0x80004005): Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.TimeoutException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond ---> System.IO.IOException: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond. ---> System.Net.Sockets.SocketException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond at System.Net.Sockets.Socket.Receive(Byte[] buffer, Int32 offset, Int32 size, SocketFlags socketFlags) at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size) --- End of inner exception stack trace --- at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size) at MySql.Data.Common.MyNetworkStream.Read(Byte[] buffer, Int32 offset, Int32 count) --- End of inner exception stack trace --- at MySql.Data.Common.MyNetworkStream.HandleOrRethrowException(Exception e) at MySql.Data.Common.MyNetworkStream.Read(Byte[] buffer, Int32 offset, Int32 count) at MySql.Data.MySqlClient.TimedStream.Read(Byte[] buffer, Int32 offset, Int32 count) at System.IO.BufferedStream.Read(Byte[] array, Int32 offset, Int32 count) at MySql.Data.MySqlClient.MySqlStream.ReadFully(Stream stream, Byte[] buffer, Int32 offset, Int32 count) at MySql.Data.MySqlClient.MySqlStream.LoadPacket() at MySql.Data.MySqlClient.MySqlStream.ReadPacket() at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId) at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& 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.ExceptionInterceptor.Throw(Exception exception) at MySql.Data.MySqlClient.MySqlConnection.Throw(Exception ex) at MySql.Data.MySqlClient.MySqlConnection.HandleTimeoutOrThreadAbort(Exception ex) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at MySql.Data.MySqlClient.MySqlCommand.ExecuteScalar() at Phoenix.Storage.DatabaseClient.ExecuteQuery(String sQuery) in c:\Users\Leon\Desktop\Development\Phoenix Neto Source\Source\Phoenix\Storage\DatabaseClient.cs:line 32 at Phoenix.HabboHotel.Rooms.Class33.method_1(GameClient class16_0, String string_1, Boolean bool_13) in c:\Users\Leon\Desktop\Development\Phoenix Neto Source\Source\Phoenix\HabboHotel\Rooms\Class33.cs:line 282 at Phoenix.Communication.Messages.Rooms.Chat.ChatMessageEvent.imethod_0(GameClient class16_0, ClientMessage class18_0) in c:\Users\Leon\Desktop\Development\Phoenix Neto Source\Source\Phoenix\Communication\Messages\Rooms\Chat\Class257.cs:line 17 at Phoenix.HabboHotel.GameClients.GameClient.method_13(Byte[]& byte_0) in c:\Users\Leon\Desktop\Development\Phoenix Neto Source\Source\Phoenix\HabboHotel\GameClients\GameClient.cs:line 482 [/CODE] This one: [CODE]9/11/2013 9:02:13 PM: Error: System.NullReferenceException: Object reference not set to an instance of an object. at Phoenix.Communication.Messages.Rooms.Chat.CancelTypingMessageEvent.imethod_0(GameClient class16_0, ClientMessage class18_0) in c:\Users\Leon\Desktop\Development\Phoenix Neto Source\Source\Phoenix\Communication\Messages\Rooms\Chat\Class253.cs:line 11 at Phoenix.HabboHotel.GameClients.GameClient.method_13(Byte[]& byte_0) in c:\Users\Leon\Desktop\Development\Phoenix Neto Source\Source\Phoenix\HabboHotel\GameClients\GameClient.cs:line 482 [/CODE] and last but not least: [CODE]9/11/2013 9:02:56 PM: Error: System.NullReferenceException: Object reference not set to an instance of an object. at MySql.Data.MySqlClient.MySqlCommand.ExecuteScalar() at Phoenix.Storage.DatabaseClient.ExecuteQuery(String sQuery) in c:\Users\Leon\Desktop\Development\Phoenix Neto Source\Source\Phoenix\Storage\DatabaseClient.cs:line 32 at Phoenix.HabboHotel.Users.Habbo.method_10(UInt32 RoomId) in c:\Users\Leon\Desktop\Development\Phoenix Neto Source\Source\Phoenix\HabboHotel\Users\Habbo.cs:line 535 at Phoenix.HabboHotel.Rooms.Room.method_46(GameClient class16_0, Boolean bool_13) in c:\Users\Leon\Desktop\Development\Phoenix Neto Source\Source\Phoenix\HabboHotel\Rooms\Room.cs:line 3858 at Phoenix.Communication.Messages.Rooms.Engine.GetRoomEntryDataMessageEvent.imethod_0(GameClient class16_0, ClientMessage class18_0) in c:\Users\Leon\Desktop\Development\Phoenix Neto Source\Source\Phoenix\Communication\Messages\Rooms\Engine\Class250.cs:line 62 at Phoenix.HabboHotel.GameClients.GameClient.method_13(Byte[]& byte_0) in c:\Users\Leon\Desktop\Development\Phoenix Neto Source\Source\Phoenix\HabboHotel\GameClients\GameClient.cs:line 482 [/CODE] Critical Exceptions: [CODE]9/11/2013 9:02:14 PM: Error during saving wired items for room 35. Stack: System.NullReferenceException: Object reference not set to an instance of an object. at MySql.Data.MySqlClient.MySqlCommand.ExecuteScalar() at Phoenix.Storage.DatabaseClient.ExecuteQuery(String sQuery) in c:\Users\Leon\Desktop\Development\Phoenix Neto Source\Source\Phoenix\Storage\DatabaseClient.cs:line 32 at Phoenix.HabboHotel.Rooms.Room.method_64() in c:\Users\Leon\Desktop\Development\Phoenix Neto Source\Source\Phoenix\HabboHotel\Rooms\Room.cs:line 4396 Query: DELETE FROM wired_items WHERE item_id = '1389' LIMIT 1; INSERT INTO wired_items (item_id,extra1,extra2,extra3,extra4,extra5) VALUES ('1389',@1389Extra1,@1389Extra2,@1389Extra3,@1389Extra4,@1389Extra5); DELETE FROM wired_items WHERE item_id = '8241' LIMIT 1; INSERT INTO wired_items (item_id,extra1,extra2,extra3,extra4,extra5) VALUES ('8241',@8241Extra1,@8241Extra2,@8241Extra3,@8241Extra4,@8241Extra5); [/CODE] any ideas thanks steve [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
Server Development
Habbo Retros
Habbo Q&A
mySQL errors?
Top