MaNGOSR2

MangosR2 is a free, open source MMORPG framework, derived from MaNGOS project


You are not connected. Please login or register

I have some problem with running mangosd.exe,please help me.

View previous topic View next topic Go down  Message [Page 1 of 1]

In the first,the problem is realmd.exe told me:realmd.sql is out of date(version:10008),because I can't find any update files for realmd.sql,so I simply rewrite the content of realmd.sql,changed the "10008_01_XXXX" to"12112_01_realmd_account_access",ok,realmd.exe no longer bother me since then.It works.

But when I run the mangosd.exe,it told me as follow:

Microsoft Windows [Version 6.1.7601]
All Rights Reserved (c) 2009 Microsoft Corporation。

C:\Users\robot>C:\GAMES\MaNGOS\bin\mangosd.exe
BOOT: [world-daemon] MangosR2/0.17 (Revision 2952), http://github.com/mangosR2/m
angos
BOOT: [world-daemon] mangosR2 branch (* * R2 Revision 2952 commit *) for Win32 (
little-endian)
BOOT: Please, visit to github branch or forum http://mangosr2.2x2forum.com for r
eport bugs
BOOT: Using configuration file C:/GAMES/MaNGOS/etc/mangosd.conf.
BOOT: Using OpenSSL 1.0.0d 8 Feb 2011 (Library: OpenSSL 1.0.0d 8 Feb 2011)
BOOT: Using ACE 5.8.3
BOOT: World Database total connections: 2
BOOT: Connected to MySQL database root@127.0.0.1:3306/mangos
BOOT: MySQL client library: 5.1.49
BOOT: MySQL server ver: 5.1.50-community-log
BOOT: MySQL autocommit succesfully enabled
BOOT: MySQL successfully turned on MYSQL_OPT_RECONNECT.
BOOT: Connected to MySQL database root@127.0.0.1:3306/mangos
BOOT: MySQL client library: 5.1.49
BOOT: MySQL server ver: 5.1.50-community-log
BOOT: MySQL autocommit succesfully enabled
BOOT: MySQL successfully turned on MYSQL_OPT_RECONNECT.
BOOT: Character Database total connections: 2
BOOT: Connected to MySQL database mangos@127.0.0.1:3306/characters
BOOT: MySQL client library: 5.1.49
BOOT: MySQL server ver: 5.1.50-community-log
BOOT: MySQL autocommit succesfully enabled
BOOT: MySQL successfully turned on MYSQL_OPT_RECONNECT.
BOOT: Connected to MySQL database mangos@127.0.0.1:3306/characters
BOOT: MySQL client library: 5.1.49
BOOT: MySQL server ver: 5.1.50-community-log
BOOT: MySQL autocommit succesfully enabled
BOOT: MySQL successfully turned on MYSQL_OPT_RECONNECT.
BOOT: Login Database total connections: 2
BOOT: Connected to MySQL database root@127.0.0.1:3306/realmd
BOOT: MySQL client library: 5.1.49
BOOT: MySQL server ver: 5.1.50-community-log
BOOT: MySQL autocommit succesfully enabled
BOOT: MySQL successfully turned on MYSQL_OPT_RECONNECT.
BOOT: Connected to MySQL database root@127.0.0.1:3306/realmd
BOOT: MySQL client library: 5.1.49
BOOT: MySQL server ver: 5.1.50-community-log
BOOT: MySQL autocommit succesfully enabled
BOOT: MySQL successfully turned on MYSQL_OPT_RECONNECT.
BOOT: Realm running as realm ID 1
BOOT: Using World DB: YTDB_0.14.7_R641_cMaNGOS_R12539_SD2_R2913_ACID_R310_RuDB_R
63
BOOT: Using creature EventAI: ACID 3.1.0 'Another Wild Adventure' - Full Release
for CMaNGOS-WOTLK (3.3.5a Client)
BOOT: Using DataDir C:\games\mangos\Data/
BOOT: VMap support included. LineOfSight:1, getHeight:1, indoorCheck:1
BOOT: VMap data directory is: C:\games\mangos\Data/vmaps
BOOT: mmap pathfinding enabled
BOOT: reset duel area disabled

Loading MaNGOS strings...
Loading texts from mangos_string
=>> Loaded 864 MaNGOS strings from table mangos_string00%


Initialize data stores...
===================================================== 102%
>> Initialized 97 data stores

Using enUS DBC Locale as default. All available DBC locales: enUS

Loading opcodes for realm (client build 12340)...
SQL: SELECT `name`, `value`, `flags` FROM `opcodes` WHERE `version`= 12340
query ERROR: Table 'mangos.opcodes' doesn't exist

Loading opcodes - current opcodes set is empty!
..\..\..\src\game\ObjectMgr.cpp:10299: Error: Assertion in ObjectMgr::LoadOpcode
s failed: false
Stack Trace:
CreatureEventAI::~CreatureEventAI()+0xa2e5 [0x0]
Movement::MoveSplineInit<GameObject *>::Path()+0x802 [0x0]
SqlStmtFieldData::toUint8()+0x1336 [0x0]
EventProcessor::Update()+0x2264a [0x0]
BaseThreadInitThunk()+0x12 [0x0]
RtlInitializeExceptionChain()+0x63 [0x0]
RtlInitializeExceptionChain()+0x36 [0x0]
Loading GameObject models...
Loading SpellDbc...
SQL: SELECT MAX(Id) FROM spell_dbc
query ERROR: Table 'mangos.spell_dbc' doesn't exist
Error loading spell_dbc table (not exist?)

C:\Users\robot>


I just merely compiled mangosR2(use project_setup.bat).For Scriptdev2,I put it under the mangos/src/bindings folder(before compile mangosR2), it does not compile separately. Am I right?
Besides I had upgraded mangos'  sql database,but didn't applied the Scriptdev2 sql patch to database.

View user profile

rsa

avatar
Admin
your not correctly apply all SQL patches, also initial DB structure incorrect.
use /contrib/server_scripts/auto_update.sh
if cannot make this manually.

View user profile
rsa wrote:your not correctly apply all SQL patches, also initial DB structure incorrect.
use /contrib/server_scripts/auto_update.sh
if cannot make this manually.
Thank you very much! Rsa.Because auto_update.sh report errors.So I need do this manually.
Do I need apply patches in "mangos\src\bindings\ScriptDev2\sql\updates" to database?(those patches’name begin with the letter “r”,not"mr".)
Besides,is the following installation sequence correct or not?
for database ScriptDev2:
/src/bindings/ScriptDev2/sql/scriptdev2_create_structure_mysql.sql
/src/bindings/ScriptDev2/sql/scriptdev2_script_full.sql
/src/bindings/ScriptDev2/sql_mr/custom_scriptdev2_bsw_table.sql
/src/bindings/ScriptDev2/sql/mangos_scriptname_full.sql(to mangos database)
then apply all mr*scriptdev2*sql in the folder"/src/bindings/ScriptDev2/sql_mr/"

and my mangos database install sequence is:
after install and update YTDB to newest then apply:
/sql_mr/custom_mangos_tables.sql
/sql_mr/custom_rerun_every_mangos_DB_update.sql
/src/bindings/ScriptDev2/sql_mr/last_mangos_sql_at_every_db_update.sql
then apply all mr*mangos*sql in both folder "mangos/sql_mr"and "mangos/src/bindings/ScriptDev2/sql_mr/"



Last edited by ctrobot on Sun Sep 22 2013, 07:49; edited 2 times in total (Reason for editing : complete the question)

View user profile

rsa

avatar
Admin
for manual install requires next steps:
1. fill clean /sql/create_mysql.sql
2. fill all needed clean scriptdev2/sql/
3. fill last clean YTDB base
4. apply all needed clean updates (mangosR2/sql/updates scriptdev2/sql/updates)
5. apply all mangosR2/sql_mr/custom_* and scriptdev2/sql_mr/custom_*
6. apply all R2 updates step-by-step from /sql_mr/ folders (for core and SD2). some updates may be fail - this normal (included in custom_*).
7. rerun custom_rerun_every_mangos_DB_update.sql
enjoy.

View user profile
Thank you for so detailed reply,I basically know how to install it,only not sure about step5:
Is the following sequence correct to fill these files?

F:\mangos\sql_mr\custom_mangos_masquerade_begin.sql
F:\mangos\sql_mr\custom_mangos_masquerade_end.sql
F:\mangos\sql_mr\custom_mangos_tables.sql
F:\mangos\sql_mr\custom_rerun_every_mangos_DB_update.sql

and when step6 is done,rerun custom_rerun_every_mangos_DB_update.sql.

Last question is:how about "last_mangos_sql_at_every_db_update.sql"'s setup order? (This file is at \ScriptDev2\sql_mr\)

Thank you very much,rsa.

View user profile

rsa

avatar
Admin
last_mangos_sql_at_every_db_update.sql requires after NEW clean SQL update apply, not need after install.
*masquerade_* - special scripts for compartibility, used by auto_update.sh script.

View user profile
I understand,thank you!

View user profile

Sponsored content


View previous topic View next topic Back to top  Message [Page 1 of 1]

Permissions in this forum:
You cannot reply to topics in this forum