Hello Devbest,
Looking for a solution to this error
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:
Any help will be appreciated, thanks in advance!
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
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
Any help will be appreciated, thanks in advance!