[One] DB setup

antz · March 25, 2013

im still getting this when i start my sd.exe
Error in gameobject_template table, probably sql file format was updated (there should be 33 fields in sql).

also note. my cmd wind. still says 6360...

Have you rebuilt mangos from the sourcecode and copied the files onto the server ?

tifalita · March 25, 2013

i followed your steps yes. if there is more to do than im incomplete. I executed all the sql's that you mentioned. Is there an unpdated exe or something im missing?

Edit: I could share my database with you and you could see it or we could sync databases with one you have establisted... all options if your willing.

antz · March 26, 2013

sorry, i think you misunderstood me...

You will need to rebuild the mangos core

- In a nutshell the following will allow you to do it, but in the simplest way to do it. Check the wiki area for various guides to how to do

If you are using windows/visual studio, go into the server/win folder. Then open the solution file and rebuild all (using release rather than debug)

Once this is done, look in the server/bin folder and copy these files over your existing server install

tifalita · March 27, 2013

yes ive never done anything like that before. I will give it a attempt and report back to you

tifalita · March 27, 2013

ok i was able to rebuild the files successfully. pretty easy actually. guess you guys do all the hard work anyhow

Now im getting errors of a different kind

Im now on revision 1926 and im getting my data base is something and should be something else... is there a tutorial somewhere or a noob guide im missing.

antz · March 27, 2013

ok, that's a good start....

if you look through this post http://getmangos.eu/bb/topic/158/wiki-from-nothing-to-online-server-mangos-zero-windows/

- I think about step 7 is where you are atm

tifalita · March 27, 2013

hmmm it cant find my /maps folder...

antz · March 27, 2013

sorry step 8

.. But I imagine you will need to do the extraction steps earlier in this guide

tifalita · March 27, 2013

nvm it finds it but says .map is non-compatible version (outdated) please create new using ad.exe program. i dont know if there is an updated ad.exe or what not. but i used it again and still go the same result.

i found the new ad.exe nvm. will update soon

tifalita · March 28, 2013

when i run mangosd.exe everything seems to load fine except this new pop up error. "the procedure entry point ?LoadCreatureAddon@Creature@@QAE_N_N@Z could not be located in the dynamic link library mangosd.exe

antz · March 28, 2013

does this happen immediately or does it display messages during startup before this ?

smallbus · March 28, 2013

when i run mangosd.exe everything seems to load fine except this new pop up error. "the procedure entry point ?LoadCreatureAddon@Creature@@QAE_N_N@Z could not be located in the dynamic link library mangosd.exe

We get this error after it loads quite a bit of the other information.

antz · March 28, 2013

when i run mangosd.exe everything seems to load fine except this new pop up error. "the procedure entry point ?LoadCreatureAddon@Creature@@QAE_N_N@Z could not be located in the dynamic link library mangosd.exe
We get this error after it loads quite a bit of the other information.

Are you able to post any of the messages / logs ?

tifalita · March 29, 2013

2013-03-28 21:13:44 >>> Loaded 84 path templates with 2123 nodes and 24 behaviors

2013-03-28 21:13:44 Loading Localization strings...

2013-03-28 21:13:44

2013-03-28 21:13:44 >> Loaded 0 creature locale strings. DB table `locales_creature` is empty.

2013-03-28 21:13:44

2013-03-28 21:13:44 >> Loaded 0 gameobject locale strings. DB table `locales_gameobject` is empty.

2013-03-28 21:13:44

2013-03-28 21:13:44 >> Loaded 0 Item locale strings. DB table `locales_item` is empty.

2013-03-28 21:13:44

2013-03-28 21:13:44 >> Loaded 0 Quest locale strings. DB table `locales_quest` is empty.

2013-03-28 21:13:44

2013-03-28 21:13:44 >> Loaded 0 Quest locale strings. DB table `locales_npc_text` is empty.

2013-03-28 21:13:44

2013-03-28 21:13:44 >> Loaded 0 PageText locale strings. DB table `locales_page_text` is empty.

2013-03-28 21:13:44

2013-03-28 21:13:44 >> Loaded 0 gossip_menu_option locale strings. DB table `locales_gossip_menu_option` is empty.

2013-03-28 21:13:44

2013-03-28 21:13:44 >> Loaded 0 points_of_interest locale strings. DB table `locales_points_of_interest` is empty.

2013-03-28 21:13:44 >>> Localization strings loaded

2013-03-28 21:13:44

2013-03-28 21:13:44 Loading Auctions...

2013-03-28 21:13:44

2013-03-28 21:13:44 >> Loaded 0 auction items

2013-03-28 21:13:44

2013-03-28 21:13:44 >> Loaded 0 auctions. DB table `auction` is empty.

2013-03-28 21:13:44 >>> Auctions loaded

2013-03-28 21:13:44

2013-03-28 21:13:44 Loading Guilds...

2013-03-28 21:13:44

2013-03-28 21:13:44 >> Loaded 0 guild definitions

2013-03-28 21:13:44 Loading ArenaTeams...

2013-03-28 21:13:44

2013-03-28 21:13:44 >> Loaded 0 arenateam definitions

2013-03-28 21:13:44 Loading Groups...

2013-03-28 21:13:44

2013-03-28 21:13:44 >> Loaded 0 group definitions

2013-03-28 21:13:44 Loading ReservedNames...

2013-03-28 21:13:44

2013-03-28 21:13:44 >> Loaded 0 reserved player names

2013-03-28 21:13:44 Loading GameObjects for quests...

2013-03-28 21:13:44

2013-03-28 21:13:44 >> Loaded 948 GameObjects for quests

2013-03-28 21:13:44 Loading BattleMasters...

2013-03-28 21:13:45

2013-03-28 21:13:45 >> Loaded 71 battlemaster entries

2013-03-28 21:13:45 Loading BattleGround event indexes...

2013-03-28 21:13:45

2013-03-28 21:13:45 >> Loaded 1236 battleground eventindexes

2013-03-28 21:13:45 Loading GameTeleports...

2013-03-28 21:13:45

2013-03-28 21:13:45 >> Loaded 421 GameTeleports

2013-03-28 21:13:45 Loading GM tickets...

2013-03-28 21:13:45

2013-03-28 21:13:45 >> Loaded `character_ticket`, table is empty.

2013-03-28 21:13:45 Returning old mails...

2013-03-28 21:13:45

2013-03-28 21:13:45 >> Only expired mails (need to be return or delete) or DB table `mail` is empty.

2013-03-28 21:13:45 Loading Scripts...

2013-03-28 21:13:45

2013-03-28 21:13:45 dbscripts_on_quest_start :

2013-03-28 21:13:45

2013-03-28 21:13:45 >> Loaded 231 script definitions

2013-03-28 21:13:45 dbscripts_on_quest_end :

2013-03-28 21:13:46

2013-03-28 21:13:46 >> Loaded 293 script definitions

2013-03-28 21:13:46 dbscripts_on_spell :

2013-03-28 21:13:46

2013-03-28 21:13:46 >> Loaded 10 script definitions

2013-03-28 21:13:46 dbscripts_on_go_use :

2013-03-28 21:13:46

2013-03-28 21:13:46 >> Loaded 54 script definitions

2013-03-28 21:13:46 dbscripts_on_go_template_use :

2013-03-28 21:13:46

2013-03-28 21:13:46 >> Loaded 18 script definitions

2013-03-28 21:13:46 dbscripts_on_event :

2013-03-28 21:13:46

2013-03-28 21:13:46 >> Loaded 484 script definitions

2013-03-28 21:13:46 dbscripts_on_creature_death :

2013-03-28 21:13:46

2013-03-28 21:13:46 >> Loaded 0 script definitions

2013-03-28 21:13:46 >>> Scripts loaded

2013-03-28 21:13:46

2013-03-28 21:13:46 Loading Scripts text locales...

2013-03-28 21:13:46

2013-03-28 21:13:46 >> Loaded 436 string templates from db_script_string

2013-03-28 21:13:46 Loading CreatureEventAI Texts...

2013-03-28 21:13:47

2013-03-28 21:13:47 >> Loaded 975 string templates from creature_ai_texts

2013-03-28 21:13:47 Loading EventAI Texts additional data...

2013-03-28 21:13:47

2013-03-28 21:13:47 >> Loaded 975 additional CreatureEventAI Texts data.

2013-03-28 21:13:47 Loading CreatureEventAI Summons...

2013-03-28 21:13:47

2013-03-28 21:13:47 >> Loaded 21 CreatureEventAI summon definitions

2013-03-28 21:13:47 Loading CreatureEventAI Scripts...

2013-03-28 21:13:48

2013-03-28 21:13:48 >> Loaded 20174 CreatureEventAI scripts

2013-03-28 21:13:48 Initializing Scripts...

2013-03-28 21:13:59 ERROR:Scripting library not found or not accessible.

2013-03-28 21:13:59 DEBUG:: Initialize game time and timers

2013-03-28 21:14:00 Starting Map System

2013-03-28 21:14:00 Starting BattleGround System

2013-03-28 21:14:00

2013-03-28 21:14:00 >> Loaded 8 battlegrounds

2013-03-28 21:14:00 Starting Outdoor PvP System

2013-03-28 21:14:00

2013-03-28 21:14:00 >> Loaded 6 Outdoor PvP zones

2013-03-28 21:14:00 Loading Transports...

2013-03-28 21:14:00

2013-03-28 21:14:00 >> Loaded 9 transports

2013-03-28 21:14:00 Deleting expired bans...

2013-03-28 21:14:00 Calculate next daily quest reset time...

2013-03-28 21:14:00 Starting Game Event system...

2013-03-28 21:14:00 GameEvent 16 "Gurubashi Arena Booty Run" started.

2013-03-28 21:14:00 GameEvent 21 "Call to Arms: Eye of the Storm!" started.

2013-03-28 21:14:00 GameEvent 31 "Edge of Madness, Renataki" started.

2013-03-28 21:14:00 GameEvent 47 "Brew of the Month - March" started.

2013-03-28 21:14:00 GameEvent 62 "Darkmoon Faire (Mulgore) - Building Stage 1" started.

2013-03-28 21:14:00 Player::DeleteOldChars: Deleting all characters which have been deleted 30 days before...

2013-03-28 21:14:00 Initialize AuctionHouseBot...

2013-03-28 21:14:00 AHBOT is Disabled. Unable to open configuration file(ahbot.conf).

2013-03-28 21:14:00 WORLD: World initialized

2013-03-28 21:14:00 SERVER STARTUP TIME: 1 minutes 2 seconds

2013-03-28 21:14:00 mangosd process priority class set to HIGH

2013-03-28 21:14:00

tifalita · March 29, 2013

i posted the concerning areas. should those be 0? and the error happens near the bottom loading scripts

tifalita · March 29, 2013

also when i try to build scriptdev2 project in visual studio 2012 i get "error MSB6006: "cmd.exe" exited with code 3

tifalita · March 29, 2013

also the title of this thread says ZERO, but this is for a ONE build. just incase thats what this means.

Christian Schamara · March 29, 2013

clone the core https://github.com/mangosone/server clone scripts https://github.com/mangosone/scripts clone database https://github.com/mangosone/database

move scripts folder in core folder under src/bindings

go in core folder win and open VC110.sln

set up to release mode push F7 and run

when done go to src/bindings/scripts and open VC110.sln change mode to release and run

when this done open database folder and navigate under _tools folder

click on make_full_db.bat (this create the full_db)

batch full with navicat or sqlyog than batch realmd and character + scripts database from core folder sql and core folder src/bindings/scripts/sql

setiing the config files and run the server

done

tifalita · March 29, 2013

ty ill give it a try

tifalita · March 29, 2013

ok i dont fully understand this part

move scripts folder in core folder under src/bindings

go in core folder win and open VC110.sln

set up to release mode push F7 and run

im using visual studio 2012. should i be using a different tool?

pushing f7 does nothing.

edit: im not getting the popup error anymore, but my scripts still are not loading.

log says, scripting library not found or not accessible.

edit2: also

"when done go to src/bindings/scripts and open VC110.sln change mode to release and run:

i goto src/bindings and there is no "scripts"folder there is a universal folder. But there is no sln to run

Christian Schamara · March 29, 2013

you must clone the scripts repo git clone git://github.com/mangosone/scripts.git

than you have a folder "name = scripts" this folder you move to src/bindings

tifalita · March 29, 2013

when i try to build the release version of scriptdev2 i get "error msb6006: "cmd.exe" exited with code 3

tifalita · March 29, 2013

i can build the debug, but not the release...

and all the sudden it works... but now what do i do with all these .obj files?

Christian Schamara · March 29, 2013

when i try to build the release version of scriptdev2 i get "error msb6006: "cmd.exe" exited with code 3

you must first build the core in release than you can scripts in release too

tifalita · March 29, 2013

OMG im a tard!!! I do believe it worked!!!! omg ty!!!

Sign In

[One] DB setup

Recommended Posts

antz

tifalita

antz

tifalita

tifalita

antz

tifalita

antz

tifalita

tifalita

antz

smallbus

antz

tifalita

tifalita

tifalita

tifalita

Christian Schamara

tifalita

tifalita

Christian Schamara

tifalita

tifalita

Christian Schamara

tifalita

Archived

Recently Browsing 0 members

Contact Us

Repositories

Support

Wiki

Browse

Activity

My Activity Streams

Important Information