brouznouf / fivem-mysql-async

MySql Async Library for FiveM
MIT License
111 stars 106 forks source link

Problem with essential mod #67

Closed loganSk closed 5 years ago

loganSk commented 5 years ago

hi i try to do a fivem server with my friends and when i install essentialmode on the server i have this error in the console after mysql-async started :

Started resource mysql-async Loaded SQLite.net, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null into ScriptDomain_1988338831 Failed to instantiate instance of script SQLite.Main: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.DllNotFoundException: SQLite.Interop.dll at (wrapper managed-to-native) System.Data.SQLite.UnsafeNativeMethods.sqlite3_config_none(System.Data.SQLite.SQLiteConfigOpsEnum) at System.Data.SQLite.SQLite3.StaticIsInitialized () [0x0001d] in <2dbd34e157eb4fefbab8047bc0d9632d>:0 at System.Data.SQLite.SQLiteLog.Initialize (System.String className) [0x00026] in <2dbd34e157eb4fefbab8047bc0d9632d>:0 at System.Data.SQLite.SQLiteConnection..ctor (System.String connectionString, System.Boolean parseViaFramework) [0x00046] in <2dbd34e157eb4fefbab8047bc0d9632d>:0 at System.Data.SQLite.SQLiteConnection..ctor (System.String connectionString) [0x00000] in <2dbd34e157eb4fefbab8047bc0d9632d>:0 at (wrapper remoting-invoke-with-check) System.Data.SQLite.SQLiteConnection..ctor(string) at SQLite.Main..ctor () [0x0004f] in :0 at (wrapper managed-to-native) System.Reflection.MonoCMethod.InternalInvoke(System.Reflection.MonoCMethod,object,object[],System.Exception&) at System.Reflection.MonoCMethod.InternalInvoke (System.Object obj, System.Object[] parameters, System.Boolean wrapExceptions) [0x00005] in :0 --- End of inner exception stack trace --- at System.Reflection.MonoCMethod.InternalInvoke (System.Object obj, System.Object[] parameters, System.Boolean wrapExceptions) [0x00017] in :0 at System.RuntimeType.CreateInstanceMono (System.Boolean nonPublic, System.Boolean wrapExceptions) [0x000a8] in :0 at System.RuntimeType.CreateInstanceSlow (System.Boolean publicOnly, System.Boolean wrapExceptions, System.Boolean skipCheckThis, System.Boolean fillCache, System.Threading.StackCrawlMark& stackMark) [0x00009] in :0 at System.RuntimeType.CreateInstanceDefaultCtor (System.Boolean publicOnly, System.Boolean skipCheckThis, System.Boolean fillCache, System.Boolean wrapExceptions, System.Threading.StackCrawlMark& stackMark) [0x00027] in :0 at System.Activator.CreateInstance (System.Type type, System.Boolean nonPublic, System.Boolean wrapExceptions) [0x00020] in :0 at System.Activator.CreateInstance (System.Type type, System.Boolean nonPublic) [0x00000] in :0 at System.Activator.CreateInstance (System.Type type) [0x00000] in :0 at CitizenFX.Core.InternalManager.CreateAssemblyInternal (System.Byte[] assemblyData, System.Byte[] symbolData) [0x00067] in /src/code/client/clrcore/InternalManager.cs:86 Started resource essentialmode Started resource esplugin_mysql Started resource es_admin2 Authenticating server license key...

When i delete essentialmode i don't have any errors. Someone knowing how i can fix it ?

KilluaZoldyck0099 commented 5 years ago

Did you find solution?

Duhsten commented 5 years ago

@loganSk, You need to navigate to the essentialmode/x64. (depending on what architecture your computer is, mines 64bit) folder and then move the SQLite.Interop.dll file to your root server folder. It's the same folder that you start the server in

KilluaZoldyck0099 commented 5 years ago

hmmm I'm hosting in zap hosting and I'm using Linux sytem so i don't think the dll file will work

12 Απρ 2019 10:41, ο/η Dustin Osborne notifications@github.com έγραψε:

@loganSk, You need to navigate to the essentialmode/x64. (depending on what architecture your computer is, mines 64bit) folder and then move the SQLite.Interop.dll file to your root server folder. It's the same folder that you start the server in

— You are receiving this because you commented. Reply to this email directly, view it on GitHub, or mute the thread.

kalho115 commented 4 years ago

@loganSk, You need to navigate to the essentialmode/x64. (depending on what architecture your computer is, mines 64bit) folder and then move the SQLite.Interop.dll file to your root server folder. It's the same folder that you start the server in

IT WORKS! ty <3

kalho115 commented 4 years ago

Now im getting this error:

Error running system event handling function for resource esplugin_mysql: citizen:/scripting/lua/scheduler.lua:41: Failed to execute thread: citizen:/scripting/lua/scheduler.lua:655: No such export mysql_fetch_all in resource mysql-async stack traceback: [C]: in function 'error' citizen:/scripting/lua/scheduler.lua:655: in metamethod '__index' @mysql-async/lib/MySQL.lua:143: in field 'fetchAll' server.lua:15: in upvalue 'handler' citizen:/scripting/lua/scheduler.lua:175: in function <citizen:/scripting/lua/scheduler.lua:174> stack traceback: [C]: in function 'error' citizen:/scripting/lua/scheduler.lua:41: in field 'CreateThreadNow' citizen:/scripting/lua/scheduler.lua:174: in function <citizen:/scripting/lua/scheduler.lua:138>