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
Can't walk .. BUG - NEED HELP
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="uttmmmm5" data-source="post: 440107" data-attributes="member: 68424"><p>[CODE]</p><p>Error in query:</p><p>UPDATE `users` SET `online` = '0' WHERE `online` = '1'</p><p>MySql.Data.MySqlClient.MySqlException (0x80004005): Deadlock found when trying to get lock; try restarting transaction</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.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 Plus.Database.Adapter.QueryAdapter.RunQuery() in C:\Users\soz\Desktop\HoloRP Workspace\PlusRP Emulator\Database\Adapter\QueryAdapter.cs:line 177</p><p></p><p></p><p>Error in query:</p><p>UPDATE `users` SET online = '0', `auth_ticket` = NULL</p><p>MySql.Data.MySqlClient.MySqlException (0x80004005): Column 'auth_ticket' cannot be null</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.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 Plus.Database.Adapter.QueryAdapter.RunQuery() in C:\Users\soz\Desktop\HoloRP Workspace\PlusRP Emulator\Database\Adapter\QueryAdapter.cs:line 177</p><p></p><p></p><p>Error in query:</p><p>UPDATE `users` SET online = '0', `auth_ticket` = NULL</p><p>MySql.Data.MySqlClient.MySqlException (0x80004005): Column 'auth_ticket' cannot be null</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.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 Plus.Database.Adapter.QueryAdapter.RunQuery() in C:\Users\soz\Desktop\HoloRP Workspace\PlusRP Emulator\Database\Adapter\QueryAdapter.cs:line 177</p><p></p><p></p><p>Error in query:</p><p>SELECT enabled,current_preset,preset_one,preset_two,preset_three FROM room_items_moodlight WHERE item_id = '160231' LIMIT 1</p><p>MySql.Data.MySqlClient.MySqlException (0x80004005): Table 'roleplay.room_items_moodlight' doesn't exist</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.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 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)</p><p> at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)</p><p> at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)</p><p> at Plus.Database.Adapter.QueryAdapter.getRow() in C:\Users\soz\Desktop\HoloRP Workspace\PlusRP Emulator\Database\Adapter\QueryAdapter.cs:line 77</p><p></p><p></p><p>Error in query:</p><p>INSERT INTO `room_items_moodlight` (item_id,enabled,current_preset,preset_one,preset_two,preset_three) VALUES (160231,0,1,'#000000,255,0','#000000,255,0','#000000,255,0')</p><p>MySql.Data.MySqlClient.MySqlException (0x80004005): Table 'roleplay.room_items_moodlight' doesn't exist</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.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 Plus.Database.Adapter.QueryAdapter.RunQuery() in C:\Users\soz\Desktop\HoloRP Workspace\PlusRP Emulator\Database\Adapter\QueryAdapter.cs:line 177</p><p></p><p></p><p>Error in query:</p><p>SELECT enabled,current_preset,preset_one,preset_two,preset_three FROM room_items_moodlight WHERE item_id=160231 LIMIT 1</p><p>MySql.Data.MySqlClient.MySqlException (0x80004005): Table 'roleplay.room_items_moodlight' doesn't exist</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.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 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)</p><p> at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)</p><p> at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)</p><p> at Plus.Database.Adapter.QueryAdapter.getRow() in C:\Users\soz\Desktop\HoloRP Workspace\PlusRP Emulator\Database\Adapter\QueryAdapter.cs:line 77</p><p></p><p></p><p>Error in query:</p><p>SELECT enabled,current_preset,preset_one,preset_two,preset_three FROM room_items_moodlight WHERE item_id = '160231' LIMIT 1</p><p>MySql.Data.MySqlClient.MySqlException (0x80004005): Table 'roleplay.room_items_moodlight' doesn't exist</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.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 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)</p><p> at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)</p><p> at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)</p><p> at Plus.Database.Adapter.QueryAdapter.getRow() in C:\Users\soz\Desktop\HoloRP Workspace\PlusRP Emulator\Database\Adapter\QueryAdapter.cs:line 77</p><p></p><p></p><p>Error in query:</p><p>INSERT INTO `room_items_moodlight` (item_id,enabled,current_preset,preset_one,preset_two,preset_three) VALUES (160231,0,1,'#000000,255,0','#000000,255,0','#000000,255,0')</p><p>MySql.Data.MySqlClient.MySqlException (0x80004005): Table 'roleplay.room_items_moodlight' doesn't exist</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.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 Plus.Database.Adapter.QueryAdapter.RunQuery() in C:\Users\soz\Desktop\HoloRP Workspace\PlusRP Emulator\Database\Adapter\QueryAdapter.cs:line 177</p><p></p><p>[/CODE]</p><p></p><p>These are the MySQL-Errors which i get after i debugged the emulator and tried then to shutdown with the "shutdown"-Command</p><p>Have someone an idea?</p><p>Is there maybe something which can be the problem why i can't walk after a few hours ?</p></blockquote><p></p>
[QUOTE="uttmmmm5, post: 440107, member: 68424"] [CODE] Error in query: UPDATE `users` SET `online` = '0' WHERE `online` = '1' MySql.Data.MySqlClient.MySqlException (0x80004005): Deadlock found when trying to get lock; try restarting transaction at MySql.Data.MySqlClient.MySqlStream.ReadPacket() at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, 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.MySqlCommand.ExecuteNonQuery() at Plus.Database.Adapter.QueryAdapter.RunQuery() in C:\Users\soz\Desktop\HoloRP Workspace\PlusRP Emulator\Database\Adapter\QueryAdapter.cs:line 177 Error in query: UPDATE `users` SET online = '0', `auth_ticket` = NULL MySql.Data.MySqlClient.MySqlException (0x80004005): Column 'auth_ticket' cannot be null at MySql.Data.MySqlClient.MySqlStream.ReadPacket() at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, 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.MySqlCommand.ExecuteNonQuery() at Plus.Database.Adapter.QueryAdapter.RunQuery() in C:\Users\soz\Desktop\HoloRP Workspace\PlusRP Emulator\Database\Adapter\QueryAdapter.cs:line 177 Error in query: UPDATE `users` SET online = '0', `auth_ticket` = NULL MySql.Data.MySqlClient.MySqlException (0x80004005): Column 'auth_ticket' cannot be null at MySql.Data.MySqlClient.MySqlStream.ReadPacket() at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, 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.MySqlCommand.ExecuteNonQuery() at Plus.Database.Adapter.QueryAdapter.RunQuery() in C:\Users\soz\Desktop\HoloRP Workspace\PlusRP Emulator\Database\Adapter\QueryAdapter.cs:line 177 Error in query: SELECT enabled,current_preset,preset_one,preset_two,preset_three FROM room_items_moodlight WHERE item_id = '160231' LIMIT 1 MySql.Data.MySqlClient.MySqlException (0x80004005): Table 'roleplay.room_items_moodlight' doesn't exist at MySql.Data.MySqlClient.MySqlStream.ReadPacket() at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, 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 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at Plus.Database.Adapter.QueryAdapter.getRow() in C:\Users\soz\Desktop\HoloRP Workspace\PlusRP Emulator\Database\Adapter\QueryAdapter.cs:line 77 Error in query: INSERT INTO `room_items_moodlight` (item_id,enabled,current_preset,preset_one,preset_two,preset_three) VALUES (160231,0,1,'#000000,255,0','#000000,255,0','#000000,255,0') MySql.Data.MySqlClient.MySqlException (0x80004005): Table 'roleplay.room_items_moodlight' doesn't exist at MySql.Data.MySqlClient.MySqlStream.ReadPacket() at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, 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.MySqlCommand.ExecuteNonQuery() at Plus.Database.Adapter.QueryAdapter.RunQuery() in C:\Users\soz\Desktop\HoloRP Workspace\PlusRP Emulator\Database\Adapter\QueryAdapter.cs:line 177 Error in query: SELECT enabled,current_preset,preset_one,preset_two,preset_three FROM room_items_moodlight WHERE item_id=160231 LIMIT 1 MySql.Data.MySqlClient.MySqlException (0x80004005): Table 'roleplay.room_items_moodlight' doesn't exist at MySql.Data.MySqlClient.MySqlStream.ReadPacket() at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, 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 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at Plus.Database.Adapter.QueryAdapter.getRow() in C:\Users\soz\Desktop\HoloRP Workspace\PlusRP Emulator\Database\Adapter\QueryAdapter.cs:line 77 Error in query: SELECT enabled,current_preset,preset_one,preset_two,preset_three FROM room_items_moodlight WHERE item_id = '160231' LIMIT 1 MySql.Data.MySqlClient.MySqlException (0x80004005): Table 'roleplay.room_items_moodlight' doesn't exist at MySql.Data.MySqlClient.MySqlStream.ReadPacket() at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, 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 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at Plus.Database.Adapter.QueryAdapter.getRow() in C:\Users\soz\Desktop\HoloRP Workspace\PlusRP Emulator\Database\Adapter\QueryAdapter.cs:line 77 Error in query: INSERT INTO `room_items_moodlight` (item_id,enabled,current_preset,preset_one,preset_two,preset_three) VALUES (160231,0,1,'#000000,255,0','#000000,255,0','#000000,255,0') MySql.Data.MySqlClient.MySqlException (0x80004005): Table 'roleplay.room_items_moodlight' doesn't exist at MySql.Data.MySqlClient.MySqlStream.ReadPacket() at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, 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.MySqlCommand.ExecuteNonQuery() at Plus.Database.Adapter.QueryAdapter.RunQuery() in C:\Users\soz\Desktop\HoloRP Workspace\PlusRP Emulator\Database\Adapter\QueryAdapter.cs:line 177 [/CODE] These are the MySQL-Errors which i get after i debugged the emulator and tried then to shutdown with the "shutdown"-Command Have someone an idea? Is there maybe something which can be the problem why i can't walk after a few hours ? [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
Server Development
Habbo Retros
Habbo Q&A
Can't walk .. BUG - NEED HELP
Top