[How to switch properly from manual updates to automatic updates ?]

You need to add applied updates to the `updates` table of your databases to tell the DBUpdater that the update was applied already.

You can leave the hash empty (the core will insert it for you) and set the state to `RELEASED` (the core will correct it as well).

 

[[SOLVED]Worldserver crashes on database update]

Thanks for report, I fixed the assertion in https://github.com/TrinityCore/TrinityCore/commit/c43b80866593af3e9743fb55a395508c7dfb5d71

[[SOLVED]Worldserver crashes on database update]

I guess it's an assertion left behind as I wrote the PR (https://github.com/TrinityCore/TrinityCore/blob/6.x/src/server/database/Updater/UpdateFetcher.cpp#L143) - didn't expect it to fail. I will add proper error handling to it.

 

[Useing the last DB]

Run

git clean -f

on your source which will remove all untracked files.

Then remove all your databases and restart the worldserver.

Follow the worldservers instructions to setup clean databases.

 

Note: Never merge the updates manually!

 

[[SOLVED]-DPREFIX deprecated?]

--- Canned message start --- It appears the issue in the original post was solved, so this thread shall be closed. Should you encounter any other difficulties, please open a new thread. --- Canned message end ---

[[SOLVED]-DPREFIX deprecated?]

Use

CMAKE_INSTALL_PREFIX

instead.

[Database auto updates, separate MySQL host]

could you try it with the protocol and without the host entry?

[Database auto updates, separate MySQL host]

Theoretically there is no reason why it shouldn't work if you host the mysql server on a different machine.

 

Could you give it a try and revert the following commits locally according to your branch: https://github.com/TrinityCore/TrinityCore/commit/c1bd3282f8149890003bb353186131afe4708172 https://github.com/TrinityCore/TrinityCore/commit/fd660d725d62f56ab20e5bd170dc2614e202d050

[Database auto updates, separate MySQL host]

What happens if you try to connect through ip instead  of sockets?

[_deleted]

Should be fixed in https://github.com/TrinityCore/TrinityCore/commit/4335611010de3e1f6c0903b4a46508b8e22db5d3

[_deleted]

Are you using an empty password? Seems like there is a bug with the auto updater.

["unknown column" "missing table" "duplicate column" error / sql problems / SQLDriverLogFile < answer on 1st post of 1st page]

According to

DBUpdater: Given update include directory "/Users/ikirserver/Applications/trinityserver/sql/updates/world" isn't existing, skipped!

the update doesn't recognize your update directories.

Maybe you need to set this option: https://github.com/TrinityCore/TrinityCore/blob/6.x/src/server/worldserver/worldserver.conf.dist#L1159

[Compile or cmake problems]

Maybe you can try to to compile with MinGW (but im sure that it needs some code adaptions).

The better solution would be to upgrade your system to Windows 7/8.1 which requires less resources then Vista.