MySQLConnectorUE4Plugin icon indicating copy to clipboard operation
MySQLConnectorUE4Plugin copied to clipboard
verified publisher icon KhArtNJava

I can't package my app to android due to library errors

Open GameDevMurras opened this issue 4 years ago • 1 comments

i never had any problems with this plugin when i packaged a game on windows...but when i tried to package a mobile game it started to show this error right here...

How can i fix that?

`Running AutomationTool... Parsing command line: -ScriptsForProject=D:/Murras/repos/UE4_Projects/SPK_235_PERPLAN_FLORIANO_ed/SPK_235.uproject BuildCookRun -project=D:/Murras/repos/UE4_Projects/SPK_235_PERPLAN_FLORIANO_ed/SPK_235.uproject -noP4 -clientconfig=Shipping -serverconfig=Shipping -nocompileeditor -installed -ue4exe="E:\ProgramFiles\Epic Games\UE_4.26\Engine\Binaries\Win64\UE4Editor-Cmd.exe" -utf8output -platform=Android -targetplatform=Android -cookflavor=ASTC -build -cook -map=Realistic_01+APARTAMENTOS+CORRECAO+ENTORNO+LAZER+MOVEIS+NOBAKE+POIS_APTO+SOBRESSOLO+SPK+SUBSOLO_1+TERREO+VEGETACAO_TERREO -unversionedcookedcontent -pak -createreleaseversion=1.0 -stage -package -stagingdirectory=D:/Murras/repos/UE4_Projects/SPK_235_PERPLAN_FLORIANO_ed/PackagedApp/ -cmdline=" -Messaging" -addcmdline="-SessionId=5EC3456F4233D50900D1B9A1906B2A0D -SessionOwner='murra' -SessionName='AndroidSPK_Study - Android APK' " -archive -archivedirectory=D:/Murras/repos/UE4_Projects/AndroidSPK_Study/PackagedApps/App/1.0 Setting up ProjectParams for D:\Murras\repos\UE4_Projects\SPK_235_PERPLAN_FLORIANO_ed\SPK_235.uproject ********** BUILD COMMAND STARTED ********** Running: E:\ProgramFiles\Epic Games\UE_4.26\Engine\Binaries\DotNET\UnrealBuildTool.exe ARCHVIZ_NEW Android Shipping -Project=D:\Murras\repos\UE4_Projects\SPK_235_PERPLAN_FLORIANO_ed\SPK_235.uproject D:\Murras\repos\UE4_Projects\SPK_235_PERPLAN_FLORIANO_ed\SPK_235.uproject -NoUBTMakefiles -remoteini="D:\Murras\repos\UE4_Projects\SPK_235_PERPLAN_FLORIANO_ed" -skipdeploy -Manifest=D:\Murras\repos\UE4_Projects\SPK_235_PERPLAN_FLORIANO_ed\Intermediate\Build\Manifest.xml -NoHotReload -log="C:\Users\murra\AppData\Roaming\Unreal Engine\AutomationTool\Logs\E+ProgramFiles+Epic+Games+UE_4.26\UBT-ARCHVIZ_NEW-Android-Shipping.txt" D:\Murras\repos\UE4_Projects\SPK_235_PERPLAN_FLORIANO_ed\Plugins\UE4MySQL\Source\UE4MySQL\UE4MySQL.Build.cs: warning: Referenced directory 'E:\ProgramFiles\Epic Games\UE_4.26\Engine\Source\MySQLConnectorPlugin4UE4\Public' does not exist. D:\Murras\repos\UE4_Projects\SPK_235_PERPLAN_FLORIANO_ed\Plugins\UE4MySQL\Source\UE4MySQL\UE4MySQL.Build.cs: warning: Referenced directory 'D:\Murras\repos\UE4_Projects\SPK_235_PERPLAN_FLORIANO_ed\Plugins\UE4MySQL\Source\MySQLConnectorPlugin4UE4\Private' does not exist. PLATFORM_ANDROID_NDK_VERSION = 210500 NDK toolchain: r21e, NDK version: 21, GccVersion: 4.9, ClangVersion: 9.0.9 Compiling Native 64-bit code with NDK API 'android-21' Writing manifest to D:\Murras\repos\UE4_Projects\SPK_235_PERPLAN_FLORIANO_ed\Intermediate\Build\Manifest.xml Building ARCHVIZ_NEW... Building 2 actions with 8 processes... [1/2] ARCHVIZ_NEW-Android-Shipping-arm64.so ld.lld: error: undefined symbol: mysql_ping >>> referenced by MySQLConnection.cpp:14 (D:/Murras\repos\UE4_Projects\SPK_235_PERPLAN_FLORIANO_ed\Plugins\UE4MySQL\Source\UE4MySQL\Private\MySQLConnection.cpp:14) >>> D:/Murras/repos/UE4_Projects/SPK_235_PERPLAN_FLORIANO_ed/Plugins/UE4MySQL/Intermediate/Build/Android/UE4/Shipping/UE4MySQL/Module.UE4MySQL.cppa8.o:(UMySQLConnection::MySQLCheckConnection()) >>> referenced by MySQLConnection.cpp:14 (D:/Murras\repos\UE4_Projects\SPK_235_PERPLAN_FLORIANO_ed\Plugins\UE4MySQL\Source\UE4MySQL\Private\MySQLConnection.cpp:14) >>> D:/Murras/repos/UE4_Projects/SPK_235_PERPLAN_FLORIANO_ed/Plugins/UE4MySQL/Intermediate/Build/Android/UE4/Shipping/UE4MySQL/Module.UE4MySQL.cppa8.o:(UMySQLConnection::MySQLCloseConnection(UMySQLConnection*)) >>> referenced by MySQLDatabase.cpp:0 (D:/Murras\repos\UE4_Projects\SPK_235_PERPLAN_FLORIANO_ed\Plugins\UE4MySQL\Source\UE4MySQL\Private\MySQLDatabase.cpp:0) >>> D:/Murras/repos/UE4_Projects/SPK_235_PERPLAN_FLORIANO_ed/Plugins/UE4MySQL/Intermediate/Build/Android/UE4/Shipping/UE4MySQL/Module.UE4MySQL.cppa8.o:(UMySQLDatabase::MySQLInitConnection(FString, FString, FString, FString)) >>> referenced by MySQLDatabase.cpp:0 (D:/Murras\repos\UE4_Projects\SPK_235_PERPLAN_FLORIANO_ed\Plugins\UE4MySQL\Source\UE4MySQL\Private\MySQLDatabase.cpp:0) >>> D:/Murras/repos/UE4_Projects/SPK_235_PERPLAN_FLORIANO_ed/Plugins/UE4MySQL/Intermediate/Build/Android/UE4/Shipping/UE4MySQL/Module.UE4MySQL.cppa8.o:(UMySQLDatabase::MySQLInitConnection(FString, FString, FString, FString)) >>> referenced by MySQLConnection.cpp:14 (D:/Murras\repos\UE4_Projects\SPK_235_PERPLAN_FLORIANO_ed\Plugins\UE4MySQL\Source\UE4MySQL\Private\MySQLConnection.cpp:14) >>> D:/Murras/repos/UE4_Projects/SPK_235_PERPLAN_FLORIANO_ed/Plugins/UE4MySQL/Intermediate/Build/Android/UE4/Shipping/UE4MySQL/Module.UE4MySQL.cppa8.o:(UMySQLDatabase::CreateTable(FString, TArray<FMySQLConnectorTableField, TSizedDefaultAllocator<32> >, UMySQLConnection*)) >>> referenced by MySQLConnection.cpp:14 (D:/Murras\repos\UE4_Projects\SPK_235_PERPLAN_FLORIANO_ed\Plugins\UE4MySQL\Source\UE4MySQL\Private\MySQLConnection.cpp:14) >>> D:/Murras/repos/UE4_Projects/SPK_235_PERPLAN_FLORIANO_ed/Plugins/UE4MySQL/Intermediate/Build/Android/UE4/Shipping/UE4MySQL/Module.UE4MySQL.cppa8.o:(UMySQLDatabase::RunQueryAndGetResults(FString, UMySQLConnection*)) >>> referenced by MySQLConnection.cpp:14 (D:/Murras\repos\UE4_Projects\SPK_235_PERPLAN_FLORIANO_ed\Plugins\UE4MySQL\Source\UE4MySQL\Private\MySQLConnection.cpp:14) >>> D:/Murras/repos/UE4_Projects/SPK_235_PERPLAN_FLORIANO_ed/Plugins/UE4MySQL/Intermediate/Build/Android/UE4/Shipping/UE4MySQL/Module.UE4MySQL.cppa8.o:(UMySQLDatabase::MySQLConnectorGetData(FString const&, UMySQLConnection*))

ld.lld: error: undefined symbol: mysql_close
>>> referenced by MySQLConnection.cpp:24 (D:/Murras\repos\UE4_Projects\SPK_235_PERPLAN_FLORIANO_ed\Plugins\UE4MySQL\Source\UE4MySQL\Private\MySQLConnection.cpp:24)
>>>               D:/Murras/repos/UE4_Projects/SPK_235_PERPLAN_FLORIANO_ed/Plugins/UE4MySQL/Intermediate/Build/Android/UE4/Shipping/UE4MySQL/Module.UE4MySQL.cppa8.o:(UMySQLConnection::MySQLCloseConnection(UMySQLConnection*))
>>> referenced by MySQLDatabase.cpp:0 (D:/Murras\repos\UE4_Projects\SPK_235_PERPLAN_FLORIANO_ed\Plugins\UE4MySQL\Source\UE4MySQL\Private\MySQLDatabase.cpp:0)
>>>               D:/Murras/repos/UE4_Projects/SPK_235_PERPLAN_FLORIANO_ed/Plugins/UE4MySQL/Intermediate/Build/Android/UE4/Shipping/UE4MySQL/Module.UE4MySQL.cppa8.o:(UMySQLDatabase::MySQLInitConnection(FString, FString, FString, FString))

ld.lld: error: undefined symbol: mysql_server_end
>>> referenced by MySQLConnection.cpp:26 (D:/Murras\repos\UE4_Projects\SPK_235_PERPLAN_FLORIANO_ed\Plugins\UE4MySQL\Source\UE4MySQL\Private\MySQLConnection.cpp:26)
>>>               D:/Murras/repos/UE4_Projects/SPK_235_PERPLAN_FLORIANO_ed/Plugins/UE4MySQL/Intermediate/Build/Android/UE4/Shipping/UE4MySQL/Module.UE4MySQL.cppa8.o:(UMySQLConnection::MySQLCloseConnection(UMySQLConnection*))
>>> referenced by MySQLDatabase.cpp:0 (D:/Murras\repos\UE4_Projects\SPK_235_PERPLAN_FLORIANO_ed\Plugins\UE4MySQL\Source\UE4MySQL\Private\MySQLDatabase.cpp:0)
>>>               D:/Murras/repos/UE4_Projects/SPK_235_PERPLAN_FLORIANO_ed/Plugins/UE4MySQL/Intermediate/Build/Android/UE4/Shipping/UE4MySQL/Module.UE4MySQL.cppa8.o:(UMySQLDatabase::MySQLInitConnection(FString, FString, FString, FString))

ld.lld: error: undefined symbol: mysql_server_init
>>> referenced by MySQLDatabase.cpp:20 (D:/Murras\repos\UE4_Projects\SPK_235_PERPLAN_FLORIANO_ed\Plugins\UE4MySQL\Source\UE4MySQL\Private\MySQLDatabase.cpp:20)
>>>               D:/Murras/repos/UE4_Projects/SPK_235_PERPLAN_FLORIANO_ed/Plugins/UE4MySQL/Intermediate/Build/Android/UE4/Shipping/UE4MySQL/Module.UE4MySQL.cppa8.o:(UMySQLDatabase::MySQLInitConnection(FString, FString, FString, FString))

ld.lld: error: undefined symbol: mysql_init
>>> referenced by MySQLDatabase.cpp:28 (D:/Murras\repos\UE4_Projects\SPK_235_PERPLAN_FLORIANO_ed\Plugins\UE4MySQL\Source\UE4MySQL\Private\MySQLDatabase.cpp:28)
>>>               D:/Murras/repos/UE4_Projects/SPK_235_PERPLAN_FLORIANO_ed/Plugins/UE4MySQL/Intermediate/Build/Android/UE4/Shipping/UE4MySQL/Module.UE4MySQL.cppa8.o:(UMySQLDatabase::MySQLInitConnection(FString, FString, FString, FString))

ld.lld: error: undefined symbol: mysql_real_connect
>>> referenced by MySQLDatabase.cpp:36 (D:/Murras\repos\UE4_Projects\SPK_235_PERPLAN_FLORIANO_ed\Plugins\UE4MySQL\Source\UE4MySQL\Private\MySQLDatabase.cpp:36)
>>>               D:/Murras/repos/UE4_Projects/SPK_235_PERPLAN_FLORIANO_ed/Plugins/UE4MySQL/Intermediate/Build/Android/UE4/Shipping/UE4MySQL/Module.UE4MySQL.cppa8.o:(UMySQLDatabase::MySQLInitConnection(FString, FString, FString, FString))

ld.lld: error: undefined symbol: mysql_set_character_set
>>> referenced by MySQLDatabase.cpp:48 (D:/Murras\repos\UE4_Projects\SPK_235_PERPLAN_FLORIANO_ed\Plugins\UE4MySQL\Source\UE4MySQL\Private\MySQLDatabase.cpp:48)
>>>               D:/Murras/repos/UE4_Projects/SPK_235_PERPLAN_FLORIANO_ed/Plugins/UE4MySQL/Intermediate/Build/Android/UE4/Shipping/UE4MySQL/Module.UE4MySQL.cppa8.o:(UMySQLDatabase::MySQLInitConnection(FString, FString, FString, FString))

ld.lld: error: undefined symbol: mysql_query
>>> referenced by MySQLDatabase.cpp:76 (D:/Murras\repos\UE4_Projects\SPK_235_PERPLAN_FLORIANO_ed\Plugins\UE4MySQL\Source\UE4MySQL\Private\MySQLDatabase.cpp:76)
>>>               D:/Murras/repos/UE4_Projects/SPK_235_PERPLAN_FLORIANO_ed/Plugins/UE4MySQL/Intermediate/Build/Android/UE4/Shipping/UE4MySQL/Module.UE4MySQL.cppa8.o:(UMySQLDatabase::MySQLConnectorExecuteQuery(FString, UMySQLConnection*))
>>> referenced by MySQLDatabase.cpp:307 (D:/Murras\repos\UE4_Projects\SPK_235_PERPLAN_FLORIANO_ed\Plugins\UE4MySQL\Source\UE4MySQL\Private\MySQLDatabase.cpp:307)
>>>               D:/Murras/repos/UE4_Projects/SPK_235_PERPLAN_FLORIANO_ed/Plugins/UE4MySQL/Intermediate/Build/Android/UE4/Shipping/UE4MySQL/Module.UE4MySQL.cppa8.o:(UMySQLDatabase::RunQueryAndGetResults(FString, UMySQLConnection*))

ld.lld: error: undefined symbol: mysql_store_result
>>> referenced by MySQLDatabase.cpp:312 (D:/Murras\repos\UE4_Projects\SPK_235_PERPLAN_FLORIANO_ed\Plugins\UE4MySQL\Source\UE4MySQL\Private\MySQLDatabase.cpp:312)
>>>               D:/Murras/repos/UE4_Projects/SPK_235_PERPLAN_FLORIANO_ed/Plugins/UE4MySQL/Intermediate/Build/Android/UE4/Shipping/UE4MySQL/Module.UE4MySQL.cppa8.o:(UMySQLDatabase::RunQueryAndGetResults(FString, UMySQLConnection*))

ld.lld: error: undefined symbol: mysql_num_fields
>>> referenced by MySQLDatabase.cpp:323 (D:/Murras\repos\UE4_Projects\SPK_235_PERPLAN_FLORIANO_ed\Plugins\UE4MySQL\Source\UE4MySQL\Private\MySQLDatabase.cpp:323)
>>>               D:/Murras/repos/UE4_Projects/SPK_235_PERPLAN_FLORIANO_ed/Plugins/UE4MySQL/Intermediate/Build/Android/UE4/Shipping/UE4MySQL/Module.UE4MySQL.cppa8.o:(UMySQLDatabase::RunQueryAndGetResults(FString, UMySQLConnection*))

ld.lld: error: undefined symbol: mysql_fetch_fields
>>> referenced by MySQLDatabase.cpp:329 (D:/Murras\repos\UE4_Projects\SPK_235_PERPLAN_FLORIANO_ed\Plugins\UE4MySQL\Source\UE4MySQL\Private\MySQLDatabase.cpp:329)
>>>               D:/Murras/repos/UE4_Projects/SPK_235_PERPLAN_FLORIANO_ed/Plugins/UE4MySQL/Intermediate/Build/Android/UE4/Shipping/UE4MySQL/Module.UE4MySQL.cppa8.o:(UMySQLDatabase::RunQueryAndGetResults(FString, UMySQLConnection*))

ld.lld: error: undefined symbol: mysql_fetch_row
>>> referenced by MySQLDatabase.cpp:349 (D:/Murras\repos\UE4_Projects\SPK_235_PERPLAN_FLORIANO_ed\Plugins\UE4MySQL\Source\UE4MySQL\Private\MySQLDatabase.cpp:349)
>>>               D:/Murras/repos/UE4_Projects/SPK_235_PERPLAN_FLORIANO_ed/Plugins/UE4MySQL/Intermediate/Build/Android/UE4/Shipping/UE4MySQL/Module.UE4MySQL.cppa8.o:(UMySQLDatabase::RunQueryAndGetResults(FString, UMySQLConnection*))
>>> referenced by MySQLDatabase.cpp:349 (D:/Murras\repos\UE4_Projects\SPK_235_PERPLAN_FLORIANO_ed\Plugins\UE4MySQL\Source\UE4MySQL\Private\MySQLDatabase.cpp:349)
>>>               D:/Murras/repos/UE4_Projects/SPK_235_PERPLAN_FLORIANO_ed/Plugins/UE4MySQL/Intermediate/Build/Android/UE4/Shipping/UE4MySQL/Module.UE4MySQL.cppa8.o:(UMySQLDatabase::RunQueryAndGetResults(FString, UMySQLConnection*))

ld.lld: error: undefined symbol: mysql_free_result
>>> referenced by MySQLDatabase.cpp:390 (D:/Murras\repos\UE4_Projects\SPK_235_PERPLAN_FLORIANO_ed\Plugins\UE4MySQL\Source\UE4MySQL\Private\MySQLDatabase.cpp:390)
>>>               D:/Murras/repos/UE4_Projects/SPK_235_PERPLAN_FLORIANO_ed/Plugins/UE4MySQL/Intermediate/Build/Android/UE4/Shipping/UE4MySQL/Module.UE4MySQL.cppa8.o:(UMySQLDatabase::RunQueryAndGetResults(FString, UMySQLConnection*))
clang++: error: linker command failed with exit code 1 (use -v to see invocation)

Took 4,3622859s to run UnrealBuildTool.exe, ExitCode=6 UnrealBuildTool failed. See log for more details. (C:\Users\murra\AppData\Roaming\Unreal Engine\AutomationTool\Logs\E+ProgramFiles+Epic+Games+UE_4.26\UBT-ARCHVIZ_NEW-Android-Shipping.txt) AutomationTool exiting with ExitCode=6 (6) BUILD FAILED

`

GameDevMurras avatar Nov 04 '21 14:11 GameDevMurras

This is because the right libraries are lot being loaded. Refer to this pull request to understand a little bit more: https://github.com/KhArtNJava/MySQLConnectorUE4Plugin/pull/4

ldeazevedo avatar Nov 29 '22 11:11 ldeazevedo