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
[PlusEMU HELP] User_achievements Error [PlusEMU 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="Xaoss" data-source="post: 430776" data-attributes="member: 76499"><p>Hello Devbest,</p><p></p><p>Looking for a solution to this error</p><p></p><p>[CODE]REPLACE INTO `user_achievements` VALUES ('1', @group, '0', '50')</p><p>System.InvalidOperationException: Connection must be valid and open.</p><p> at MySql.Data.MySqlClient.ExceptionInterceptor.Throw(Exception exception)</p><p> at MySql.Data.MySqlClient.MySqlCommand.CheckState()</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\Sandows\Desktop\Emulator\Database\Adapter\QueryAdapter.cs:line 177[/CODE]</p><p></p><p>Ignore the ('1', @group, '0', '50') part that's just an example of someone who was having the same issue my numbers are different and vary however I have restarted the EMU so will have to wait for the Error to show up again.</p><p></p><p>Anyway, this Error happens Sporadically can happen 4hrs after Emu is up or sometimes 2 days after the Emu has been up. When the Error does occur it cause a major LAG spike across the hotel and continue to do so until I restart the EMU and rinse and repeat.</p><p></p><p>I'm guessing it's something to do with the @group not being defined.</p><p></p><p>There is also a similar Error:</p><p>[CODE]UPDATE `server_status` SET `users_online` = @users, `loaded_rooms` = @loadedRooms LIMIT 1;</p><p>System.InvalidOperationException: Connection must be valid and open.</p><p> at MySql.Data.MySqlClient.ExceptionInterceptor.Throw(Exception exception)</p><p> at MySql.Data.MySqlClient.MySqlCommand.CheckState()</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\Sandows\Desktop\Emulator\Database\Adapter\QueryAdapter.cs:line 177</p><p></p><p> [/CODE]</p><p></p><p>Any help will be appreciated, thanks in advance!</p></blockquote><p></p>
[QUOTE="Xaoss, post: 430776, member: 76499"] Hello Devbest, Looking for a solution to this error [CODE]REPLACE INTO `user_achievements` VALUES ('1', @group, '0', '50') System.InvalidOperationException: Connection must be valid and open. at MySql.Data.MySqlClient.ExceptionInterceptor.Throw(Exception exception) at MySql.Data.MySqlClient.MySqlCommand.CheckState() at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery() at Plus.Database.Adapter.QueryAdapter.RunQuery() in C:\Users\Sandows\Desktop\Emulator\Database\Adapter\QueryAdapter.cs:line 177[/CODE] Ignore the ('1', @group, '0', '50') part that's just an example of someone who was having the same issue my numbers are different and vary however I have restarted the EMU so will have to wait for the Error to show up again. Anyway, this Error happens Sporadically can happen 4hrs after Emu is up or sometimes 2 days after the Emu has been up. When the Error does occur it cause a major LAG spike across the hotel and continue to do so until I restart the EMU and rinse and repeat. I'm guessing it's something to do with the @group not being defined. There is also a similar Error: [CODE]UPDATE `server_status` SET `users_online` = @users, `loaded_rooms` = @loadedRooms LIMIT 1; System.InvalidOperationException: Connection must be valid and open. at MySql.Data.MySqlClient.ExceptionInterceptor.Throw(Exception exception) at MySql.Data.MySqlClient.MySqlCommand.CheckState() at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery() at Plus.Database.Adapter.QueryAdapter.RunQuery() in C:\Users\Sandows\Desktop\Emulator\Database\Adapter\QueryAdapter.cs:line 177 [/CODE] Any help will be appreciated, thanks in advance! [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
Server Development
Habbo Retros
Habbo Q&A
[PlusEMU HELP] User_achievements Error [PlusEMU HELP]
Top