search

Sarjuuk / aowow

Database viewer for TrinityCore based on aowow by @LordJZ, based on the JS-Engine of Wowhead
204 stars 217 forks source link

Setup returns error on TrinityCore db version `TDB 335.21101` + many `WARNS` #423

Closed jzizka91 closed 5 months ago

jzizka91 commented 5 months ago

Hi again. When running the setup I encountered the following:

Even though I'm using TrinityCore World db version TDB 335.21101 that should be supported according to the Aowow guide I'm getting this Error and hundreds of WARNS during the setup. I noticed the WARNS are present on newer TC world db versions as well.

17:37:42    [0]  aowow                OK      mysqli://root:**********@mysql_aowow_db/aowow  table prefix: aowow_  AoWoW DB version @ 2024/06/02 18:50:15
17:37:42    [1]  world                OK      mysqli://root:**********@mysql_world_db/world  table prefix: world   TrinityDB version @ TDB 335.21101
17:37:42    [2]  auth                 <empty>                                                                       
17:37:42    [N]  new characters DB                                                                                          
17:37:42    [R]  retest / reload DBs                                                                                        

17:37:44  [INFO]  leaving db setup...

17:37:44  [ERR]   could not establish connection to:
17:37:44           * world: doesn't seem to contain TrinityCore world tables!
[c]ontinue anyway? [r]etry? [a]bort?:

The setup was completed successfully after ignoring the initial db error and warnings.

18:20:40          checking sql updates
18:20:40  [OK]     -> 04.06.2024 #01: 0 queries applied
18:20:40  [OK]    applied 1 update(s)
18:20:41          FileGen::init() - creating required directories
18:20:41          created 9 extra paths

18:20:41          Please create your admin account.
Press any key to continue: 
Username:
Enter Password:
Confirm Password: 

18:35:34  [OK]    account admin created successfully
18:35:34  [OK]    setup finished

WARNS examples:

17:08:30           - reading dungeonmap.dbc
17:08:30             - fetching taverns
17:08:30             - calculation teleporter coordinates
17:08:30  [WARN]     * AT 45 teleporter endpoint Scarlet Monastery - Graveyard (Entrance) could not be matched to displayable area [M:189; X:1687.27; Y:1050.09]
17:08:30  [WARN]     * AT 78 teleporter endpoint DeadMines Entrance could not be matched to displayable area [M:36; X:-14.5732; Y:-385.475]
17:08:30  [WARN]     * AT 101 teleporter endpoint Stormwind Stockades Entrance could not be matched to displayable area [M:34; X:54.23; Y:0.28]
17:08:30  [WARN]     * AT 107 teleporter endpoint Stormwind Vault Entrance could not be matched to displayable area [M:35; X:-0.91; Y:40.57]
17:08:30  [WARN]     * AT 145 teleporter endpoint Shadowfang Keep Entrance could not be matched to displayable area [M:33; X:-228.191; Y:2111.41]

17:10:15          SqlGen::generate() - filling aowow_currencies with data
17:10:15           - reading currencytypes.dbc
17:10:15  [WARN]  item #44209 referenced by currency #181 not in item_template
17:13:57           - fixing glyph data
17:13:57  [WARN]  could not match Glyph of the White Bear (54292) with affected spells
17:14:39  [WARN]  could not match Glyph of the Black Bear (58132) with affected spells
17:15:08  [WARN]  could not match Glyph of the Ghoul (58686) with affected spells
17:26:43           - reading soundemitters.dbc
17:27:54  [WARN]  GUID 40591 could not be matched to displayable area [A:0; X:16320.2; Y:16243.6]
17:27:54  [WARN]  GUID 40591 could not be matched to displayable area [A:0; X:16320.2; Y:16243.6]
17:28:32  [WARN]  GUID 60863 could not be matched to displayable area [A:0; X:-10531.1; Y:-4098.5]
17:28:32  [WARN]  GUID 60863 could not be matched to displayable area [A:0; X:-10531.1; Y:-4098.5]

18:00:56           *  88594 / 151327 (58.5%) [<creature spawns>, gameobject spawns, sound emitter spawns, areatrigger spawns, script_waypoint table, waypoints table, w
18:00:56           *  88807 / 151327 (58.7%) [<creature spawns>, gameobject spawns, sound emitter spawns, areatrigger spawns, script_waypoint table, waypoints table, w
18:00:57           *  89027 / 151327 (58.8%) [<creature spawns>, gameobject spawns, sound emitter spawns, areatrigger spawns, script_waypoint table, waypoints table, w
18:00:57           *  89361 / 151327 (59.1%) [<creature spawns>, gameobject spawns, sound emitter spawns, areatrigger spawns, script_waypoint table, waypoints table, w

and many others...

System:

Sarjuuk commented 5 months ago

The warnings are mostly expected. Base WotLK doesn't have map coverage of the whole world unless you jump through a lot of hoops. So setup can't place entities inside classic instances and warns you about it. Other stuff is probably just unused dbc data.

18:00:57 * 89027 / 151327 (58.8%) [<creature spawns>, gameobject spawns, sound emitter spawns, areatrigger spawns, script_waypoint table, waypoints table, w .. or not even a warning.