Hello, how to compile this core?

I always get error like this:

LNK2019 unresolved external symbol "void __cdecl AddSC_export_commandscript(void)" (?AddSC_export_commandscript@@yaxxz) referenced in function "void __cdecl AddCommandsScripts(void)" (?AddCommandsScripts@@yaxxz) worldserver

Can you pls advise on what OpenSSL, boost and mysql are required?

you stupid people merge many crash and many error

After a successful server compilation.

Creating a database.
OpenLCore \ sql \ base \ auth_database.sql
OpenLCore \ sql \ base \ characters_database.sql
OpenLCore \ sql \ base \ hotfixes_database.sql

I did not find the world database.

I searched previous applications and found #8

Information from serayn links https://github.com/openlcoreteam/OpenLCore/releases recommended version 1.0
I tried both variants and unfortunately still can't start the world server.
After all updates, one error remains.

`OpenLCore/sql/openlcore/old/world" does not exist, skipped!

World database is up-to-date! Containing 22 new and 0 archived updates.
Could not prepare statements of the World database, see log for details.`

Verified https://github.com/openlcoreteam/OpenLCore/tree/master/sql/OpenLCore

DBerrors log:

`In mysql_stmt_prepare() id: 62, sql: "INSERT INTO creature (guid, id , map, spawnDifficulties, PhaseId, PhaseGroup, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, curhealth, curmana, MovementType, npcflag, unit_flags, unit_flags2, unit_flags3, dynamicflags, movementmode) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"`
Unknown column 'movementmode' in 'field list' `


Is it possible that I missed something?

Thanks

Describe the bug
跑worldserver 时报错

To Reproduce

一开始authserver报错
通过 https://community.trinitycore.org/topic/328-unknown-column-missing-table-duplicate-column-error-sql-problems-sqldriverlogfile-answer-on-1st-post-of-1st-page/page/35/
载入ipnation sql 解决

等到跑worldserver 时报错

In mysql_stmt_prepare() id: 225, sql: "SELECT Unk1, Name, Description, Unk2, Unk3, Unk4, Unk5, QuestID0, QuestID1, QuestID2, Unk7, Unk8, Unk9, Unk10, Unk11, Unk12, Unk13, Unk14, Unk15, Unk16, RequiredLevel, Unk18, ID, Unk19, QuestInfoID FROM QuestV2CliTask ORDER BY ID DESC"
Table 'hotfixes.QuestV2CliTask' doesn't exist
Could not prepare statements of the Hotfix database, see log for details.

OS: Ubuntu 18.04.5 LTS

No LSB modules are available.
Distributor ID:	Ubuntu
Description:	Ubuntu 18.04.5 LTS
Release:	18.04
Codename:	bionic

mysql version:

mariadb Ver 15.1 Distrib 10.1.47-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2

Using SSL version: OpenSSL 1.1.1 11 Sep 2018 (library: OpenSSL 1.1.1 11 Sep 2018)

Using Boost version: 1.67.0

编译版本：OpenLCore v0.1a

数据库从uiwow论坛获得，https://uiwow.com/thread-4401-1-1.html

相关的问题只找到一个帖子：https://community.trinitycore.org/topic/14560-worldserver-cant-start-735

Describe the bug
A clear and concise description of what the bug is.

To Reproduce
Steps to reproduce the behavior:

1. Go to '...'
2. Click on '....'
3. Scroll down to '....'
4. See error

Expected behavior
A clear and concise description of what you expected to happen.

Screenshots
If applicable, add screenshots to help explain your problem.

Desktop (please complete the following information):

• OS: [e.g. iOS]
• Browser [e.g. chrome, safari]
• Version [e.g. 22]

Smartphone (please complete the following information):

• Device: [e.g. iPhone6]
• OS: [e.g. iOS8.1]
• Browser [e.g. stock browser, safari]
• Version [e.g. 22]

Additional context
Add any other context about the problem here.

Describe the bug
A clear and concise description of what the bug is.
Only hace japanese, need more language locales
To Reproduce
Steps to reproduce the behavior:

1. Go to '...'
2. Click on '....'
3. Scroll down to '....'
4. See error

Expected behavior
A clear and concise description of what you expected to happen.

Screenshots
If applicable, add screenshots to help explain your problem.

Desktop (please complete the following information):

• OS: [e.g. iOS]
• Browser [e.g. chrome, safari]
• Version [e.g. 22]

Smartphone (please complete the following information):

• Device: [e.g. iPhone6]
• OS: [e.g. iOS8.1]
• Browser [e.g. stock browser, safari]
• Version [e.g. 22]

Additional context
Add any other context about the problem here.

When u freshly import the database with the "place to the bin folder" method, the worldserver.exe cannot import it.

-First problem is on the OCT_world_735.00.sql, game_event table not compatible with mysql somehow the start_time and the end_time. To successfully import i had to set the default values to current_timestamp and the '0000-00-00 00:00:00' things to NULL.

-Second problem is Unknown column 'velocity' in 'field list'.
But there is no update sql in the source directory to fix this.

Hi where is it databases?