Please help with DB

[Ammon]

When i start mangosd.exe it is closed at once.

world-database.txt log:

2015-07-09 19:18:33 SQL: SELECT required_20007_01_Rel20_Release_Prep FROM db_version LIMIT 1

2015-07-09 19:18:33 query ERROR: Unknown column 'required_20007_01_Rel20_Release_Prep' in 'field list'

2015-07-09 19:18:33 The table `db_version` in your [WORLD] database indicates that this database is out of date!

2015-07-09 19:18:33

2015-07-09 19:18:33 [A] You have: --> `20007_18_Deadmines_Mr_Smite_Corrections.sql`

2015-07-09 19:18:33

2015-07-09 19:18:33 You need: --> `20007_01_Rel20_Release_Prep.sql`

2015-07-09 19:18:33

2015-07-09 19:18:33 You must apply all updates after [A] to to use mangos with this database.

2015-07-09 19:18:33 These updates are included in the sql/updates folder.

2015-07-09 19:18:33 Please read the included [README] in sql/updates for instructions on updating.

world -server.txt log

2015-07-09 19:38:43 20007 [world-daemon]

2015-07-09 19:38:43 <Ctrl-C> to stop.

__ __ _ _ ___ ___ ___

| \/ |__ _| \| |/ __|/ _ \/ __| We Love

| |\/| / _` | .` | (_ | (_) \__ \ Vanilla Wow

|_| |_\__,_|_|\_|\___|\___/|___/

____

For help and support please visit: /_ /___ _ _ ___

Website: https://getmangos.eu / // -_) '_/ _ \

Wiki: MaNGOS Wiki · GitHub /___\___|_| \___/

2015-07-09 19:38:43 Using configuration file mangosd.conf.

2015-07-09 19:38:43 World Database total connections: 2

2015-07-09 19:38:43 MySQL client library: 5.5.37

2015-07-09 19:38:43 MySQL server ver: 5.6.25-log

2015-07-09 19:38:43 MySQL client library: 5.5.37

2015-07-09 19:38:43 MySQL server ver: 5.6.25-log

2015-07-09 19:38:43 ERROR:SQL: SELECT required_20007_01_Rel20_Release_Prep FROM db_version LIMIT 1

2015-07-09 19:38:43 ERROR:query ERROR: Unknown column 'required_20007_01_Rel20_Release_Prep' in 'field list'

2015-07-09 19:38:43 ERROR:The table `db_version` in your [WORLD] database indicates that this database is out of date!

2015-07-09 19:38:43 ERROR:

2015-07-09 19:38:43 ERROR: [A] You have: --> `20007_18_Deadmines_Mr_Smite_Corrections.sql`

2015-07-09 19:38:43 ERROR:

2015-07-09 19:38:43 ERROR: You need: --> `20007_01_Rel20_Release_Prep.sql`

2015-07-09 19:38:43 ERROR:

2015-07-09 19:38:43 ERROR:You must apply all updates after [A] to to use mangos with this database.

2015-07-09 19:38:43 ERROR:These updates are included in the sql/updates folder.

2015-07-09 19:38:43 ERROR:Please read the included [README] in sql/updates for instructions on updating.

20007_01_Rel20_Release_Prep.sql updating isn't applied.

[esciar]

If you read the error log, it already tells you what you need to fix the problem.

2015-07-09 19:38:43 ERROR: [A] You have: --> `20007_18_Deadmines_Mr_Smite_Corrections.sql`

This one is the last sql compiled.

2015-07-09 19:38:43 ERROR: You need: --> `20007_01_Rel20_Release_Prep.sql`

This one is the las sql the server needs to be in the database to be run.

Then you need to execute the following sql files into the database:

20007_19_Start_Up_Error_fixes.sql

20007_20_Hotfix_Corrections_to_RegenerateStats.sql

I think the issue is you compiled the Trunk Rel 20 server, but used the sqls from the Release20.

[Ammon]

I compiled core from --recursive github.com/mangoszero/server

I installed DB from --recursive github.com/mangoszero/database

I applied sql updates 20007_19_Start_Up_Error_fixes.sql 20007_20_Hotfix_Corrections_to_RegenerateStats.sql

please tell me where to get the source code work and DB?

Can I use mysql 5.6.25x64 for core x86?

[hiperhiv]

I'm having the exact same problem as this guy.

I've cloned from github.com/mangoszero/server and /database got the error above even after applied all updates,

then I've tried to use different branch like deveop21 problem is I don't know how to compile that inside the win folder

there's only this .exe > MaNGOS_EasyBuild.exe which I've tried to make work but I can't, any guidance please I spent last hours trying to find solutions .

[Olion]

I compiled core from --recursive github.com/mangoszero/server

I installed DB from --recursive github.com/mangoszero/database

I applied sql updates 20007_19_Start_Up_Error_fixes.sql 20007_20_Hotfix_Corrections_to_RegenerateStats.sql

please tell me where to get the source code work and DB?

Can I use mysql 5.6.25x64 for core x86?

You might find the appropriate discussion here. As for 64-bit mysql build, it is, in theory, OK but not recommended still. I didn't test its compatibility personally though.

I'm having the exact same problem as this guy.

I've cloned from github.com/mangoszero/server and /database got the error above even after applied all updates,

then I've tried to use different branch like deveop21 problem is I don't know how to compile that inside the win folder

there's only this .exe > MaNGOS_EasyBuild.exe which I've tried to make work but I can't, any guidance please I spent last hours trying to find solutions .

That binary is intended to check requirements for the fresh install, nothing more. The develop21 branch is better in many aspects (in particular, it is used actually by the developers), but it does not contain pre-built VS solution files. You should create them with cmake (use 2.8 version from here). Just create a new folder for build files, in the Cmake GUI point to it as "Where to build binaries" and point to the root of your repo clone (where is the README.md file located) as "Where is the source code". Then "Configure" and "Generate". If the system requirements were met, you get the solution files in the build folder.

[hiperhiv]

What would be the fast fix in this case? Maybe installing older visual studio I remember this being a problem long time ago.

[Olion]

Do you have OpenSSL installed? It is a dependense since long ago. For your 32-bit build, use the same openssl build.

If yes, then change the value of the parameter OPENSSL_INCLUDE_DIR manually, pointing to the requested directory like my: C:/Apps/OpenSSL-Win32/include. Note also I do not take a risk to install this package into a dir containing spaces or non-ASCII characters.

[hiperhiv]

Olion blessed be your soul man !

Your way of explaining is excellent just like your knowledge.

[antz]

I'm having the exact same problem as this guy.

I've cloned from github.com/mangoszero/server and /database got the error above even after applied all updates,

then I've tried to use different branch like deveop21 problem is I don't know how to compile that inside the win folder

there's only this .exe > MaNGOS_EasyBuild.exe which I've tried to make work but I can't, any guidance please I spent last hours trying to find solutions .

Can you explain what went wrong with easybuild ?