[MySQL] Issue with Database

[LT.Steiner]

Hello RAGE MP Community,

I have an issue with my Database, after sending data from Client-side to Server-side I want to insert all data I got from Client-side into database that I made all tables and fields exactly.

 

Console Error:

Could not load file or assembly 'Renci.SshNet, Version=2016.1.0.0, Culture=neutral, PublicKeyToken=1cee9f8bde3db106'. The system cannot find the file specified.
Could not load file or assembly 'System.Drawing.Common, Version=4.0.2.0, Culture=neutral, PublicKeyToken=cc7b13ffcd2ddd51'. The system cannot find the file specified.
Could not load file or assembly 'System.Drawing.Common, Version=4.0.2.0, Culture=neutral, PublicKeyToken=cc7b13ffcd2ddd51'. The system cannot find the file specified.
Could not load file or assembly 'System.Drawing.Common, Version=4.0.2.0, Culture=neutral, PublicKeyToken=cc7b13ffcd2ddd51'. The system cannot find the file specified.

 

Error in IDE:

https://imgur.com/0L7aptu

 

 

How can I solve this?

[Division]

MainPortal lol

 

Add the missing dependencies into runtime folder System.Drawing.Common.dll & Renci.SshNet.dll

[LT.Steiner]

hehehehe, yea MainPortal

 

Only copy the dll files? shouldn't sign any library? any using system or something like that?

[Division]

it is not a compiling issue so yea, just replace the dll files from your build folder to the runtime folder.

rage is loading in all the references from /runtime and if you add new deps or change their version, you have to move them from build to runtime to update them.

[LT.Steiner]

Hello again,

Special thank to you @Division

 

some of errors gone and still there is a weird error on console and IDE, it's Renci.SshNet.dll, I referenced that file in my IDE and dropped one copy of it in Runtime folder, there are my pictures.

Quote

public static string Portal = "SERVER=localhost;DATABASE=mydb;UID=root;PASSWORD=Mmd123!@#$%";

Error in IDE

https://imgur.com/387MwBI

 

Referenced in IDE

https://imgur.com/vJgMmP0

 

One copy of the dll file in runtime

https://imgur.com/eD5TKQ3

 

I don't know what should I do anymore, is there any way to use??? or what's another solution??! 😢

HELP

Edited October 30, 2021 by LT.Steiner

[Kopra]

Just use MySqlConnector.
NuGet Gallery | MySqlConnector 1.3.14

Edited October 31, 2021 by Kopra

[LT.Steiner]

Especially thank to @Kopra

 

I switched my library to MySqlConnector and it's new error, any body knows how to solve issue?

 

IDE Error

https://imgur.com/NgxdnQC

 

 

Console Error:

Could not load file or assembly 'H:\server-files\dotnet\resources\Project\bin\Debug\netcoreapp3.1\MySqlConnector.dll'. The system cannot find the file specified.
Could not load file or assembly 'MySqlConnector, Version=1.0.0.0, Culture=neutral, PublicKeyToken=d33d3e53aa5f8c92'. The system cannot find the file specified.

 

I googled for Physical file to download and place it into directory that required, but no result, anybody have the file?

[Kopra]

You need to put MySqlConnector.dll together with your gamemode .dll.

You can also put this in your .csproj file to make compiler do it.

<CopyLocalLockFileAssemblies>true</CopyLocalLockFileAssemblies>