[Solved] Mangos Zero Errors Help please 1.12.1

[e46ad]

Hi guys got my core compile etc have a few problems with start up I'm getting some errors, I have checked my log and don't know quite what the problem is am I missing some files or something ?

I am using https://github.com/mangoszero/database I used the Mangos DB installer to input the DB into MySQL, And then used some of the updates in the SRC/Database-master folder everything seamed to go okay with extracting the SQL updates. Am I just doing something totally wrong here?

First error I see is, 2015-03-07 15:43:15 >> Loaded `npc_vendor_template`, table is empty!

2015-03-07 15:43:15 ERROR:Table `npc_vendor` has `maxcount`=0 for item 4496 of vendor 491 but `incrtime`<>0, ignoring

2015-03-07 16:12:06 >> Loaded `npc_vendor_template`, table is empty!

2015-03-07 16:12:06 ERROR:Table `npc_vendor` has `maxcount`=0 for item 4496 of vendor 491 but `incrtime`<>0, ignoring

2015-03-07 16:12:06 >> Loaded 0 creature locale strings. DB table `locales_creature` is empty.

2015-03-07 16:12:06

2015-03-07 16:12:06 >> Loaded 0 gameobject locale strings. DB table `locales_gameobject` is empty.

2015-03-07 16:12:06

2015-03-07 16:12:06 >> Loaded 0 Item locale strings. DB table `locales_item` is empty.

2015-03-07 16:12:06

2015-03-07 16:12:06 >> Loaded 0 Quest locale strings. DB table `locales_quest` is empty.

2015-03-07 16:12:06

2015-03-07 16:12:06 >> Loaded 0 Quest locale strings. DB table `locales_npc_text` is empty.

2015-03-07 16:12:06

2015-03-07 16:12:06 >> Loaded 0 PageText locale strings. DB table `locales_page_text` is empty.

2015-03-07 16:12:06

2015-03-07 16:12:06 >> Loaded 0 gossip_menu_option locale strings. DB table `locales_gossip_menu_option` is empty.

2015-03-07 16:12:06

2015-03-07 16:12:06 >> Loaded 0 points_of_interest locale strings. DB table `locales_points_of_interest` is empty.

2015-03-07 16:12:06 >>> Localization strings loaded

2015-03-07 15:55:29 Loading Creature Items...

2015-03-07 15:55:29 ERROR:creature_item_template table is empty!

2015-03-07 15:55:29 >> Loaded 0 creature item template

2015-03-07 15:55:29

2015-03-07 15:55:29 Loading Equipment templates...

2015-03-07 15:55:29 ERROR:creature_equip_template table is empty!

Then I get

2015-03-07 16:12:07 >> Loaded 20 CreatureEventAI summon definitions

2015-03-07 16:12:07 Loading CreatureEventAI Scripts...

2015-03-07 16:12:07 ERROR CreatureEventAI: Event 43101 Action1 uses incorrect Target type 6 for event-type 12

2015-03-07 16:12:07 ERROR CreatureEventAI: Event 58702 Action1 uses incorrect Target type 6 for event-type 13

2015-03-07 16:12:07 ERROR CreatureEventAI: Event 154004 Action1 uses incorrect Target type 6 for event-type 13

2015-03-07 16:12:07 ERROR CreatureEventAI: Event 166404 Action1 uses incorrect Target type 6 for event-type 13

2015-03-07 16:12:07 ERROR CreatureEventAI: Event 178703 Action1 uses incorrect Target type 6 for event-type 12

2015-03-07 16:12:07 ERROR CreatureEventAI: Event 193701 Action1 uses incorrect Target type 1 for event-type 10 (can not be used OOC)

2015-03-07 16:12:07 ERROR CreatureEventAI: Event 193801 Action1 uses incorrect Target type 1 for event-type 10 (can not be used OOC)

2015-03-07 16:12:07 ERROR CreatureEventAI: Event 195201 Action1 uses incorrect Target type 1 for event-type 10 (can not be used OOC)

2015-03-07 16:12:07 ERROR CreatureEventAI: Event 212101 Action1 uses incorrect Target type 1 for event-type 10 (can not be used OOC)

2015-03-07 16:12:07 ERROR CreatureEventAI: Event 214001 Action1 uses incorrect Target type 1 for event-type 10 (can not be used OOC)

2015-03-07 16:12:07 ERROR CreatureEventAI: Event 258301 Action1 uses incorrect Target type 1 for event-type 1 (can not be used OOC)

2015-03-07 16:12:07 ERROR CreatureEventAI: Event 264906 Action1 uses incorrect Target type 6 for event-type 12

2015-03-07 16:12:07 ERROR CreatureEventAI: Event 312902 Action1 uses incorrect Target type 6 for event-type 13

2015-03-07 16:12:07 ERROR CreatureEventAI: Event 319204 Action1 uses incorrect Target type 6 for event-type 13

2015-03-07 16:12:07 ERROR CreatureEventAI: Event 355101 Action1 uses incorrect Target type 1 for event-type 10 (can not be used OOC)

2015-03-07 16:12:07 ERROR CreatureEventAI: Event 355201 Action1 uses incorrect Target type 1 for event-type 10 (can not be used OOC)

2015-03-07 16:12:07 ERROR CreatureEventAI: Event 355301 Action1 uses incorrect Target type 1 for event-type 10 (can not be used OOC)

2015-03-07 16:12:07 ERROR CreatureEventAI: Event 355401 Action1 uses incorrect Target type 1 for event-type 10 (can not be used OOC)

2015-03-07 16:12:07 ERROR CreatureEventAI: Event 355501 Action1 uses incorrect Target type 1 for event-type 10 (can not be used OOC)

2015-03-07 16:12:07 ERROR CreatureEventAI: Event 355601 Action1 uses incorrect Target type 1 for event-type 10 (can not be used OOC)

2015-03-07 16:12:07 ERROR CreatureEventAI: Event 355701 Action1 uses incorrect Target type 1 for event-type 10 (can not be used OOC)

2015-03-07 16:12:07 ERROR CreatureEventAI: Event 373906 Action1 uses incorrect Target type 6 for event-type 13

2015-03-07 16:12:07 ERROR CreatureEventAI: Event 463702 Action1 uses incorrect Target type 6 for event-type 12

2015-03-07 16:12:07 ERROR CreatureEventAI: Event 536401 Action1 uses incorrect Target type 6 for event-type 12

2015-03-07 16:12:07 ERROR CreatureEventAI: Event 560106 Action1 uses incorrect Target type 6 for event-type 13

2015-03-07 16:12:07 ERROR CreatureEventAI: Event 580803 Action1 uses incorrect Target type 6 for event-type 13

2015-03-07 16:12:07 ERROR CreatureEventAI: Event 580903 Action1 uses incorrect Target type 6 for event-type 13

2015-03-07 16:12:07 ERROR CreatureEventAI: Event 588601 Action1 uses incorrect Target type 1 for event-type 10 (can not be used OOC)

2015-03-07 16:12:07 ERROR CreatureEventAI: Event 598201 Action1 uses incorrect Target type 6 for event-type 12

2015-03-07 16:12:07 ERROR CreatureEventAI: Event 606906 Action1 uses incorrect Target type 6 for event-type 13

2015-03-07 16:12:07 ERROR CreatureEventAI: Event 638901 Action1 uses incorrect Target type 1 for event-type 10 (can not be used OOC)

2015-03-07 16:12:07 ERROR CreatureEventAI: Event 639102 Action1 uses incorrect Target type 6 for event-type 13

2015-03-07 16:12:07 ERROR CreatureEventAI: Event 684602 Action1 uses incorrect Target type 6 for event-type 0

2015-03-07 16:12:07 ERROR CreatureEventAI: Event 684602 Action2 uses incorrect Target type 6 for event-type 0

2015-03-07 16:12:07 ERROR CreatureEventAI: Event 684602 Action3 uses incorrect Target type 6 for event-type 0

2015-03-07 16:12:07 ERROR CreatureEventAI: Event 727404 Action1 uses incorrect Target type 6 for event-type 12

2015-03-07 16:12:07 ERROR CreatureEventAI: Event 779703 Action1 uses incorrect Target type 6 for event-type 12

2015-03-07 16:12:07 ERROR CreatureEventAI: Event 838501 Action1 uses incorrect Target type 1 for event-type 10 (can not be used OOC)

2015-03-07 16:12:07 ERROR CreatureEventAI: Event 945111 Action1 uses incorrect Target type 6 for event-type 13

2015-03-07 16:12:07 ERROR CreatureEventAI: Event 955301 Action1 uses incorrect Target type 1 for event-type 10 (can not be used OOC)

2015-03-07 16:12:07 ERROR CreatureEventAI: Event 997901 Action1 uses incorrect Target type 1 for event-type 10 (can not be used OOC)

2015-03-07 16:12:07 ERROR CreatureEventAI: Event 1047203 Action1 uses incorrect Target type 6 for event-type 13

2015-03-07 16:12:07 ERROR CreatureEventAI: Event 1082406 Action1 uses incorrect Target type 6 for event-type 9

2015-03-07 16:12:07 ERROR CreatureEventAI: Event 1082407 Action1 uses incorrect Target type 6 for event-type 9

2015-03-07 16:12:07 ERROR CreatureEventAI: Event 1102204 Action1 uses incorrect Target type 6 for event-type 13

2015-03-07 16:12:07 ERROR CreatureEventAI: Event 1145502 Action1 uses incorrect Target type 5 for event-type 1 (can not be used OOC)

2015-03-07 16:12:07 ERROR CreatureEventAI: Event 1146102 Action1 uses incorrect Target type 6 for event-type 13

2015-03-07 16:12:07 ERROR CreatureEventAI: Event 1148606 Action1 uses incorrect Target type 6 for event-type 13

2015-03-07 16:12:07 ERROR CreatureEventAI: Event 1156101 Action1 uses incorrect Target type 6 for event-type 13

2015-03-07 16:12:07 ERROR CreatureEventAI: Event 1236902 Action1 uses incorrect Target type 6 for event-type 13

2015-03-07 16:12:07 ERROR CreatureEventAI: Event 1280109 Action1 uses incorrect Target type 6 for event-type 13

2015-03-07 16:12:07 ERROR CreatureEventAI: Event 1383908 Action1 uses incorrect Target type 6 for event-type 13

2015-03-07 16:12:07 ERROR CreatureEventAI: Event 1432105 Action1 uses incorrect Target type 6 for event-type 13

2015-03-07 16:12:07 ERROR CreatureEventAI: Event 1432305 Action1 uses incorrect Target type 6 for event-type 13

2015-03-07 16:12:07 ERROR CreatureEventAI: Event 1432605 Action1 uses incorrect Target type 6 for event-type 13

2015-03-07 16:12:07 ERROR CreatureEventAI: Event 1552702 Action1 uses incorrect Target type 6 for event-type 13

2015-03-07 16:12:07 ERROR CreatureEventAI: Event 1562102 Action1 uses incorrect Target type 6 for event-type 13

2015-03-07 16:12:07 ERROR CreatureEventAI: Event 1571802 Action1 uses incorrect Target type 6 for event-type 9

2015-03-07 16:12:07 ERROR CreatureEventAI: Creature 12143 has EFLAG_REPEATABLE set. Event can never be repeatable. Removing flag for event 1214301.

2015-03-07 16:12:07 ERROR CreatureEventAI: Creature 15215 has EFLAG_REPEATABLE set. Event can never be repeatable. Removing flag for event 1521501.

2015-03-07 16:12:07 ERROR CreatureEventAI: Event 494903 Action 2 uses nonexistent SpellID 0.

2015-03-07 16:12:07 ERROR CreatureEventAI: EventAI not has script for creature entry (4509), but AIName = 'EventAI'.

2015-03-07 16:12:07

2015-03-07 16:12:07 >> Loaded 13693 CreatureEventAI scripts

2015-03-07 16:12:07 Initializing Scripts...

2015-03-07 16:12:07 ___ _ _ ___ ___

2015-03-07 16:12:07 / __| __ _ _(_)_ __| |_| \ _____ _|_ )

2015-03-07 16:12:07 \__ \/ _| '_| | '_ \ _| |) / -_) V // /

2015-03-07 16:12:07 |___/\__|_| |_| .__/\__|___/\___|\_//___|

2015-03-07 16:12:07 |_|

2015-03-07 16:12:07 http://scriptdev2.com/

2015-03-07 16:12:07 SD2: Using configuration file mangosd.conf

2015-03-07 16:12:07

2015-03-07 16:12:07 MySQL client library: 5.5.37

2015-03-07 16:12:07 MySQL server ver: 5.6.21

2015-03-07 16:12:07 MySQL client library: 5.5.37

2015-03-07 16:12:07 MySQL server ver: 5.6.21

2015-03-07 16:12:07 SD2: ScriptDev2 database initialized.

2015-03-07 16:12:07

2015-03-07 16:12:07 Loading ScriptDev2 (for MaNGOS Zero Release 0.19+) Revision [Rel0.19] (*) * * (Win32)

2015-03-07 16:12:07 SD2: Loading Script Texts...

2015-03-07 16:12:07 Loading texts from script_texts, with additional data

2015-03-07 16:12:07 >> Loaded 1316 text templates from script_texts

2015-03-07 16:12:07

2015-03-07 16:12:07 SD2: Loading Custom Texts...

2015-03-07 16:12:07 Loading texts from custom_texts, with additional data

2015-03-07 16:12:07

2015-03-07 16:12:07 >> Loaded 0 string templates. DB table `custom_texts` is empty.

2015-03-07 16:12:07 SD2: Loading Gossip Texts...

2015-03-07 16:12:07 Loading texts from gossip_texts

2015-03-07 16:12:07 >> Loaded 23 string templates from gossip_texts

2015-03-07 16:12:07

2015-03-07 16:12:07 SD2: Loading Script Waypoints for 53 creature(s)...

2015-03-07 16:12:07 >> Loaded 1378 Script Waypoint nodes.

2015-03-07 16:12:07 SD2: Loading C++ scripts

2015-03-07 16:12:07 <SD2 ERROR>: Script registering but ScriptName npc_onyxian_warder is not assigned in database. Script will not be used.

2015-03-07 16:12:07 >> Loaded 314 C++ Scripts.

2015-03-07 16:12:07 Scripting library loaded.

2015-03-07 16:12:07 Initialize Eluna Lua Engine...

2015-03-07 16:12:07 [Eluna]: Searching scripts from `lua_scripts`

2015-03-07 16:12:07 [Eluna]: Executed 4 Lua scripts in 3 ms

2015-03-07 16:12:07 DEBUG:: Initialize game time and timers

2015-03-07 16:12:07 Starting Map System

2015-03-07 16:12:07 Starting BattleGround System

2015-03-07 16:12:07

2015-03-07 16:12:07 >> Loaded 3 battlegrounds

2015-03-07 16:12:07 Starting Outdoor PvP System

2015-03-07 16:12:07

2015-03-07 16:12:07 >> Loaded 2 Outdoor PvP zones

2015-03-07 16:12:07 Loading Transports...

2015-03-07 16:12:07

2015-03-07 16:12:07 >> Loaded 8 transports

2015-03-07 16:12:07 Deleting expired bans...

2015-03-07 16:12:07 Starting server Maintenance system...

2015-03-07 16:12:07 Loading Honor Standing list...

2015-03-07 16:12:07

2015-03-07 16:12:07 >> Loaded 0 Horde and 0 Ally honor standing definitions

2015-03-07 16:12:07 Starting Game Event system...

2015-03-07 16:12:07 GameEvent 3 "Pyrewood Village - Day" started.

2015-03-07 16:12:07 GameEvent 18 "Call to Arms: Alterac Valley!" started.

2015-03-07 16:12:07 GameEvent 35 "Winter Season Fishing" started.

2015-03-07 16:12:07 Player::DeleteOldChars: Deleting all characters which have been deleted 30 days before...

2015-03-07 16:12:07 Initialize AuctionHouseBot...

2015-03-07 16:12:07 AHBot using configuration file ahbot.conf

2015-03-07 16:12:07 AHBOT is Disabled. (If you want to use it please set config in 'ahbot.conf')

2015-03-07 16:12:07 WORLD: World initialized

2015-03-07 16:12:07 SERVER STARTUP TIME: 0 minutes 9 seconds

2015-03-07 16:12:07

2015-03-07 16:12:07 mangosd process priority class set to HIGH

2015-03-07 16:12:07

Can anyone help me with this issue please it's the last step i need to get my server running thanks all.

[Olion]

Firstly, I see from the log that the server started successfully. Are you worried about the errors? I would not But if you still are:

Secondly, it seems that you used the "master" branch of both repos. Though it is considered as a "stable one", it misses a great deal of fixes and improvements. Current branch (a "development one" of good enough quality to be merged into master) is named Rel20. To switch the repos to the branch, one has to issue the git command "git checkout -b Rel20" in each one. Then, surely, start again: building, DB importing so on. Sorry, with the old (Rel19 = master) branch I cannot help you, I never tried it.

[e46ad]

Solved that issue thanks for the help, I have one more question for you If you don't mind helping me out once more

I see https://github.com/mangoszero/LuaScripts Lua scripts on github site but I dont see Rel20 for them? I just see Server

Should i not be Git bash mangoszero/LuaScripts ? and just Server and Database ?

So the question is should i be getting the mangoszero/LuaScripts for my server or do they come with the compile ?

Thanks

[Olion]

The part of LUA engine to be compiled is integrated into the core, so it gets respective changes when you change the core repo branch. The LUA repo you mentioned contains only the scripts themselves, which never are compiled by C++. AFAIK the Eluna engine did not change substantially between the revisions, so the scripts are valid for any one. They should be simply copied "as is" into the server folder.

You are welcome. Avoiding repacks is a worthy task

[e46ad]

Hey thanks for the fast replies was great I am 99% ready now to compile the new rel20 I just have one more question hehe you say, They should be simply copied "as is" into the server folder.

Is this my Server folder i got from Git bash ? the Rel 20 were i compile, If so what folder do i move them to ? Or will i move them to my Mangos server folder once compiled ?

Also in my New server Folder rel 20 I no longer see the folder SQL ? did i do something wrong again ? But in Master Branch i see SQL

 Updated the name of an update SQL to match the name asked for.

Was that just an update to the Master Branch and not needed for REL 20 or do i have to Re do Git bash clone again ?

Hehe sorry about this just wornding if i need the SQL folder in my new Server Folder that i got from Rel 20 on git bash, As it seams not to be there on the Github website and in my New Server folder.

Thanks very much

[Olion]

LUA scripts are not related to C++, so they should be copied neither to the repo not to the build folder, but to the server folder from where it will start. After commenting out the line in mangosd.conf

#Eluna.ScriptPath = "lua_scripts"

I placed the scripts to the "lua_scripts/" folder beside "dbc/", "maps/" so on.

All SQL changes appear now in the DB repo. So after installing the DB (InstallDatabases.bat was ok to me), updates from World/Updates/Rel20 are to be installed in the order of default (by name) file sorting, and, maybe, the last one from Character/Updates/Rel20 (just forgot how I did it myself).

The core to DB correspondence is tracked in a, say, tricky way. Columns in

realmd.realmd_db_version
characters.character_db_version
mangos.db_version

change their names (beginning with "required"), and the names are checked against the hardcoded ones in

src\shared\revision_sql.h

If mismatched, the core will not start. Additional tracking (of non-critical mangos DB updates) is done via mangosd.db_version.version field, to which each update adds its signature.

[e46ad]

Hi I have ran in to a few errors with my compile i did as you said but i am stuck could you help me again please so i did as you say,

git checkout -b Rel20 my Git says Switched to a new Branch "Rel20" then i am stuck at what to do next what command to i issue after that to Merg the Rel 20 into my Master Server folder I have looked over the net and can't find anyone please help me this is stopping me compiling my core 100%

How do i Merg the Rel 20 to my Server Master i have it all loaded on Gut bash i just don't know what to do next please help

[Foereaper]

I'm assuming this has been resolved now that your server is up and running?

[e46ad]

Yes fixed thank you used the --recursive command and it worked.