search

FICTURE7 / CoCSharp

Clash of Clans library, proxy and server written in .NET [Unmaintained]
MIT License
109 stars 57 forks source link

SQL DB Errors #102

Closed ghost closed 7 years ago

ghost commented 7 years ago

I compiled the latest source in VS2017 and it manages to compile with no errors and gets as far as loading into the assetmanager. However, it then breaks and outputs the following to the error.log file:

[17/02/22 - 11:53:08.626][error] - Unable to start IDbManager instance: MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown database 'cocsharp' at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Runtime.CompilerServices.ConfiguredValueTaskAwaitable`1.ConfiguredValueTaskAwaiter.GetResult() at MySql.Data.Serialization.MySqlSession.d22.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at MySql.Data.MySqlClient.MySqlConnection.d60.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at MySql.Data.MySqlClient.MySqlConnection.d__12.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at MySql.Data.MySqlClient.MySqlConnection.Open() at CoCSharp.Server.Db.MySqlDbManager..ctor(IServer server) in C:\Users\marti\Desktop\CoCSharp\src\CoCSharp.Server\Db\MySqlDbManager.cs:line 86 at CoCSharp.Server.Server.Start() in C:\Users****\Desktop\CoCSharp\src\CoCSharp.Server\Server.cs:line 166.

I have tried both mysql for windows and xampp and it is the same error on both. There are no warnings in warn.log as well and all of the detail in server_config.xml are all correct for the DB which fully works.

If you need anything else, please tell me.

FICTURE7 commented 7 years ago

You should run this script in a MySQL shell.

ghost commented 7 years ago

Thanks, it runs now on windows.

FICTURE7 commented 7 years ago

Great, I guess I can close this now. ^^