-
Originally Posted by
Somboo
Okay, now it does not complain about it missing but it complains about no spell values.
Using configuration file /home/wow/server/etc/authserver.conf.
Using SSL version: OpenSSL 1.0.2n 7 Dec 2017 (library: OpenSSL 1.0.2n 7 Dec 2017)
Using Boost version: 1.65.1
Searching for available patches.
Opening DatabasePool 'auth'. Asynchronous connections: 1, synchronous connections: 1.
MySQL client library: 5.7.24
MySQL server ver: 5.7.24-0ubuntu0.18.04.1
Connected to MySQL database at 127.0.0.1
MySQL client library: 5.7.24
MySQL server ver: 5.7.24-0ubuntu0.18.04.1
Connected to MySQL database at 127.0.0.1
DatabasePool 'auth' opened successfully. 2 total connections running.
In mysql_stmt_prepare() id: 84, sql: "INSERT INTO account_spells VALUES (?, ?)"
Column count doesn't match value count at row 1
Closing down DatabasePool 'auth'.
Asynchronous connections on DatabasePool 'auth' terminated. Proceeding with synchronous connections.
All connections on DatabasePool 'auth' closed.
Could not prepare statements of the Login database, see log for details.
Remove the entry column. It is expecting only 2 columns.
-
Post Thanks / Like - 1 Thanks
Somboo (1 members gave Thanks to stoneharry for this useful post)
-
Member
Originally Posted by
stoneharry
Remove the entry column. It is expecting only 2 columns.
Thanks! I ran into an issue with ip2nationContries but compared it with a different server but I have this one which I can't figure out...
Using configuration file /home/wow/server/etc/worldserver.conf.
Using SSL version: OpenSSL 1.0.2n 7 Dec 2017 (library: OpenSSL 1.0.2n 7 Dec 2017)
Using Boost version: 1.65.1
In mysql_stmt_prepare() id: 466, sql: "REPLACE INTO item_template_virtual (entry, base_entry, itemguid, Quality, StatsCount, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, armor, socket1, socket2, socket3) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
Table 'characters.item_template_virtual' doesn't exist
Could not prepare statements of the Character database, see log for details.
-
Member
Nevermind figured it out! Thanks so much Stoneharry! I played Edge of Chaos and loved it! I hope I love this too!
-
Member
Originally Posted by
stoneharry
Remove the entry column. It is expecting only 2 columns.
Oh I guess I should share this cause I have files missing... some custom maps I think.
Incorrect DataDir value in worldserver.conf or ALL required *.dbc files (10 not found by path: ../data//lua_scripts/Dropbox/dbc
-
Post Thanks / Like - 1 Thanks
stoneharry (1 members gave Thanks to Somboo for this useful post)
-
Originally Posted by
Somboo
Oh I guess I should share this cause I have files missing... some custom maps I think.
Incorrect DataDir value in worldserver.conf or ALL required *.dbc files (10
not found by path: ../data//lua_scripts/Dropbox/dbc
Can you share some more of the logs? I might be able to work out what is missing.
-
Post Thanks / Like - 1 Thanks
Somboo (1 members gave Thanks to stoneharry for this useful post)
-
Member
Originally Posted by
stoneharry
Can you share some more of the logs? I might be able to work out what is missing.
Here they are.
Using configuration file /home/wow/server/etc/worldserver.conf.
Using SSL version: OpenSSL 1.0.2n 7 Dec 2017 (library: OpenSSL 1.0.2n 7 Dec 2017)
Using Boost version: 1.65.1
Realm running as realm ID 1
Using World DB: Unknown
Will clear `logs` table of entries older than 1209600 seconds every 10 minutes.
Using DataDir ../data/
WORLD: MMap data directory is: ../data/mmaps
VMap support included. LineOfSight: 1, getHeight: 1, indoorCheck: 1
VMap data directory is: ../data/vmaps
Initialize Eluna Lua Engine...
[Eluna]: Searching scripts from `lua_scripts`
Loading Trinity strings...
>> Loaded 1030 trinity strings in 3 ms
Initialize data stores...
Incorrect DataDir value in worldserver.conf or ALL required *.dbc files (108) not found by path: ../data//lua_scripts/Dropbox/dbc
-
Originally Posted by
Somboo
Here they are.
Using configuration file /home/wow/server/etc/worldserver.conf.
Using SSL version: OpenSSL 1.0.2n 7 Dec 2017 (library: OpenSSL 1.0.2n 7 Dec 2017)
Using Boost version: 1.65.1
Realm running as realm ID 1
Using World DB: Unknown
Will clear `logs` table of entries older than 1209600 seconds every 10 minutes.
Using DataDir ../data/
WORLD: MMap data directory is: ../data/mmaps
VMap support included. LineOfSight: 1, getHeight: 1, indoorCheck: 1
VMap data directory is: ../data/vmaps
Initialize Eluna Lua Engine...
[Eluna]: Searching scripts from `lua_scripts`
Loading Trinity strings...
>> Loaded 1030 trinity strings in 3 ms
Initialize data stores...
Incorrect DataDir value in worldserver.conf or ALL required *.dbc files (10
not found by path: ../data//lua_scripts/Dropbox/dbc
It's trying to find the DBC files in that directory and it looks like it comes from the worldserver config.
-
Member
Originally Posted by
stoneharry
It's trying to find the DBC files in that directory and it looks like it comes from the worldserver config.
Okay I fixed that issue but now run into this:
Using configuration file /home/wow/server/etc/worldserver.conf.
Using SSL version: OpenSSL 1.0.2n 7 Dec 2017 (library: OpenSSL 1.0.2n 7 Dec 2017)
Using Boost version: 1.65.1
Realm running as realm ID 1
Using World DB: Unknown
Will clear `logs` table of entries older than 1209600 seconds every 10 minutes.
Using DataDir ../data/
WORLD: MMap data directory is: ../data/mmaps
VMap support included. LineOfSight: 1, getHeight: 1, indoorCheck: 1
VMap data directory is: ../data/vmaps
Initialize Eluna Lua Engine...
[Eluna]: Searching scripts from `lua_scripts`
Loading Trinity strings...
>> Loaded 1030 trinity strings in 2 ms
Initialize data stores...
>> Loading Cinematic Camera files
>> Loaded 0 cinematic waypoint sets in 0 ms
>> Initialized 108 data stores in 213 ms
Using enUS DBC Locale as default. All available DBC locales: enUS
Loading SpellInfo store...
>> Loaded SpellInfo store in 30 ms
Loading SpellInfo corrections...
>> Loaded SpellInfo corrections in 6 ms
Loading SkillLineAbilityMultiMap Data...
>> Loaded 10219 SkillLineAbility MultiMap Data in 2 ms
Loading SpellInfo custom attributes...
[1054] Unknown column 'accountWide' in 'field list'
Your database structure is not up to date. Please make sure you've executed all queries in the sql/updates folders.
Aborted (core dumped)
-
Originally Posted by
Somboo
Okay I fixed that issue but now run into this:
Using configuration file /home/wow/server/etc/worldserver.conf.
Using SSL version: OpenSSL 1.0.2n 7 Dec 2017 (library: OpenSSL 1.0.2n 7 Dec 2017)
Using Boost version: 1.65.1
Realm running as realm ID 1
Using World DB: Unknown
Will clear `logs` table of entries older than 1209600 seconds every 10 minutes.
Using DataDir ../data/
WORLD: MMap data directory is: ../data/mmaps
VMap support included. LineOfSight: 1, getHeight: 1, indoorCheck: 1
VMap data directory is: ../data/vmaps
Initialize Eluna Lua Engine...
[Eluna]: Searching scripts from `lua_scripts`
Loading Trinity strings...
>> Loaded 1030 trinity strings in 2 ms
Initialize data stores...
>> Loading Cinematic Camera files
>> Loaded 0 cinematic waypoint sets in 0 ms
>> Initialized 108 data stores in 213 ms
Using enUS DBC Locale as default. All available DBC locales: enUS
Loading SpellInfo store...
>> Loaded SpellInfo store in 30 ms
Loading SpellInfo corrections...
>> Loaded SpellInfo corrections in 6 ms
Loading SkillLineAbilityMultiMap Data...
>> Loaded 10219 SkillLineAbility MultiMap Data in 2 ms
Loading SpellInfo custom attributes...
[1054] Unknown column 'accountWide' in 'field list'
Your database structure is not up to date. Please make sure you've executed all queries in the sql/updates folders.
Aborted (core dumped)
It looks like accountWide was not found as a column in the SpellInfo table. You might need to turn on debug logging to get some more useful information. You can change console output levels in the config files.
-
Member
Originally Posted by
stoneharry
It looks like accountWide was not found as a column in the SpellInfo table. You might need to turn on debug logging to get some more useful information. You can change console output levels in the config files.
Thanks so much! I just fixed all the issues with it. Now the world and auth server runs! Thanks again Stoneharry and have a great day!!!
-
Member
Originally Posted by
Somboo
Thanks so much! I just fixed all the issues with it. Now the world and auth server runs! Thanks again Stoneharry and have a great day!!!
Oh was a little quick to think it is working... here is the log (WAY BIG) LOG
-
Originally Posted by
Somboo
Oh was a little quick to think it is working... here is the log (WAY BIG)
LOG
It prints:
Code:
TC>Segmentation fault (core dumped)
Something broke. You will have to open the crash dump with visual studio to see where it crashed.
edit: My guess this backup isn't exactly up to date and it's going to be a lot of effort to get it running. If you do want to keep persisting I can offer advise but can't really debug it for you - I don't have anything setup to do that. Opening up the .dmp file created in visual studio should let you see which file and line of code is causing the crash. Looking down the stack trace will let you see what called it and if that is the thing missing.
Last edited by stoneharry; 12-07-2018 at 08:24 PM.
-
Member
Originally Posted by
stoneharry
It prints:
Code:
TC>Segmentation fault (core dumped)
Something broke. You will have to open the crash dump with visual studio to see where it crashed.
edit: My guess this backup isn't exactly up to date and it's going to be a lot of effort to get it running. If you do want to keep persisting I can offer advise but can't really debug it for you - I don't have anything setup to do that. Opening up the .dmp file created in visual studio should let you see which file and line of code is causing the crash. Looking down the stack trace will let you see what called it and if that is the thing missing.
Okay, but I will use a different program because I actually use Linux, so I can't exactly open Visual studio...
-
Originally Posted by
Somboo
Okay, but I will use a different program because I actually use Linux, so I can't exactly open Visual studio...
Ah - there may be some Windows specific code in the emulator. If you find a way to debug it then you can probably fix the code relatively easily, but again no easy task.
-
Member
Originally Posted by
stoneharry
Ah - there may be some Windows specific code in the emulator. If you find a way to debug it then you can probably fix the code relatively easily, but again no easy task.
I just ported it to windows so I can debug what is wrong a little easier.