aowow icon indicating copy to clipboard operation
aowow copied to clipboard
verified publisher icon azerothcore

[ Bug ]: php aowow --setup cannot find the world version

Open mpfans opened this issue 7 months ago • 10 comments

Current Behaviour

php aowow --setup cannot find the world version Image

Use AzerothCore?

Yes

Steps to reproduce the problem

  1. clone aowow
  2. php aowow --setup
  3. Setup database information

Extra Notes

No response

Operating system

windows server 2016 x64

PHP version

8.3

Browser

edge

mpfans avatar Apr 27 '25 00:04 mpfans

It's a known issue, you can ignore it

Helias avatar Apr 27 '25 14:04 Helias

Cannot ignore, continuing will automatically exit

mpfans avatar Apr 27 '25 14:04 mpfans

Cannot ignore, continuing will automatically exit

Mhm, try to run the setup commands separately using:

php aowow --sql
php aowow --build

before running these commands edit the configs using php aowow --configure, let me know how it goes

Helias avatar Apr 27 '25 15:04 Helias

run php aowow --configure done.

run php aowow --sql

log

`07:34:45          [sql] filling aowow_classes with data
07:34:46  [WARN]  WARNING - Field 'roles' doesn't have a default value at D:\wwwroot\aowow\setup\tools\sqlgen\classes.ss.php line 58 @ D:\wwwroot\aowow\includes\database.class.php:92
07:34:46  [WARN]  WARNING - Field 'cuFlags' doesn't have a default value at D:\wwwroot\aowow\setup\tools\sqlgen\classes.ss.php line 58 @ D:\wwwroot\aowow\includes\database.class.php:92
07:34:46  [WARN]  WARNING - Field 'roles' doesn't have a default value at D:\wwwroot\aowow\setup\tools\sqlgen\classes.ss.php line `

`D:\wwwroot\aowow\setup\tools\sqlgen\spawns.ss.php line 144 @ D:\wwwroot\aowow\includes\database.class.php:92
08:04:41  [WARN]  WARNING - Field 'pathId' doesn't have a default value at D:\wwwroot\aowow\setup\tools\sqlgen\spawns.ss.php line 144 @ D:\wwwroot\aowow\includes\database.class.php:92
08:04:41  [WARN]  WARNING - Field 'pathId' doesn't have a default value at D:\wwwroot\aowow\setup\tools\sqlgen\spawns.ss.php line 144 @ D:\wwwroot\aowow\includes\database.class.php:92`

run php aowow --build

log

`08:41:23  [WARN]  WARNING - preg_match(): Compilation failed: unrecognized character follows \ at offset 6 @ D:\wwwroot\aowow\setup\tools\CLISetup.class.php:535
08:41:23  [WARN]  WARNING - preg_match(): Compilation failed: unrecognized character follows \ at offset 6 @ D:\wwwroot\aowow\setup\tools\CLISetup.class.php:535
08:41:23  [WARN]  WARNING - preg_match(): Compilation failed: unrecognized character follows \ at offset 6 @ D:\wwwroot\aowow\setup\tools\CLISetup.class.php:535
08:41:23  [WARN]  WARNING - preg_match(): Compilation failed: unrecognized character follows \ at offset 6 @ D:\wwwroot\aowow\setup\tools\CLISetup.class.php:535
08:41:23  [WARN]  WARNING - preg_match(): Compilation failed: unrecognized character follows \ at offset 6 @ D:\wwwroot\aowow\setup\tools\CLISetup.class.php:535
08:41:23  [WARN]  WARNING - preg_match(): Compilation failed: unrecognized character follows \ at offset 6 @ D:\wwwroot\aowow\setup\tools\CLISetup.class.php:535
08:41:23  [WARN]  WARNING - preg_match(): Compilation failed: unrecognized character follows \ at offset 6 @ D:\wwwroot\aowow\setup\tools\CLISetup.class.php:535
08:41:23  [WARN]  WARNING - preg_match(): Compilation failed: unrecognized character follows \ at offset 6 @ D:\wwwroot\aowow\setup\tools\CLISetup.class.php:535
08:41:23  [WARN]  WARNING - preg_match(): Compilation failed: unrecognized character follows \ at offset 6 @ D:\wwwroot\aowow\setup\tools\CLISetup.class.php:535
08:41:23  [WARN]  WARNING - preg_match(): Compilation failed: unrecognized character follows \ at offset 6 @ D:\wwwroot\aowow\setup\tools\CLISetup.class.php:535
08:41:23  [WARN]  WARNING - preg_match(): Compilation failed: unrecognized character follows \ at offset 6 @ D:\wwwroot\aowow\setup\tools\CLISetup.class.php:535
08:41:23  [WARN]  WARNING - preg_match(): Compilation failed: unrecognized character follows \ at offset 6 @ D:\wwwroot\aowow\setup\tools\CLISetup.class.php:535
08:41:23  [WARN]  WARNING - preg_match(): Compilation failed: unrecognized character follows \ at offset 6 @ D:\wwwroot\aowow\setup\tools\CLISetup.class.php:535
08:41:23  [WARN]  WARNING - preg_match(): Compilation failed: unrecognized character follows \ at offset 6 @ D:\wwwroot\aowow\setup\tools\CLISetup.class.php:535`

`08:47:32          PARTIAL - WorldMap/ @ setup/mpqdata/[enus/ zhCN/]Interface/WorldMap/
08:47:34  [WARN]  WARNING - mysqli_query(): (42S22/1054): Unknown column 'worldMapAreaId' in 'field list' @ D:\wwwroot\aowow\includes\libs\DbSimple\Mysqli.php:166
08:47:34  [WARN]  WARNING -  at D:\wwwroot\aowow\setup\tools\filegen\img-maps.ss.php line 404 @ D:\wwwroot\aowow\includes\database.class.php:92
08:47:34  [ERR]   [img-maps] - could not read required dbc files: WorldMapArea.dbc [108 entries]; WorldMapOverlay.dbc [61] entries; DungeonMap.dbc [0 entries]
08:47:34  [ERR]   [build] subscript 'img-maps' returned with errors`


`09:07:44  [OK]    [build] subscript 'soundfiles' returned successfully

09:07:44          [build] gathering data for statistics
09:07:44  [OK]    [build] subscript 'statistics' returned successfully

09:07:44          [build] gathering data for talentcalc
09:07:46  [OK]    [build] subscript 'talentcalc' returned successfully

09:07:46          [build] gathering data for talenticons
09:07:48  [OK]    [build] subscript 'talenticons' returned successfully

09:07:48          [build] gathering data for tooltips
09:07:48  [OK]    [build] subscript 'tooltips' returned successfully

09:07:48          [build] gathering data for weightpresets
09:07:48  [WARN]  [weightpresets] Scale 'arms' has no data set.
09:07:48  [OK]    [build] subscript 'weightpresets' returned successfully

09:07:48  [ERR]   finished file generation with errors`

And then he quit

mpfans avatar Apr 28 '25 00:04 mpfans

what do you see in the website? you should be able to see something already

When I run this script https://github.com/Helias/www-aowow/blob/ci-docker-pipeline/setup/scripts/docker-pipeline.sh I am able to see the website. You can check if you are missing some step reading it

Helias avatar Apr 28 '25 17:04 Helias

echo "Downloading and importing DB" wget https://github.com/TrinityCore/TrinityCore/releases/download/TDB335.21101/TDB_full_world_335.21101_2021_10_15.7z > /dev/null 2>&1 7z x TDB_full_world_335.21101_2021_10_15.7z > /dev/null 2>&1 rm TDB_full_world_335.21101_2021_10_15.7z

Your SH script uses TC's database, so there won't be any errors

mpfans avatar Apr 29 '25 01:04 mpfans

Yes, but I used it also for azerothcore. I will make the script compatible with AC but I was waiting that the PR was merged to sarjuuk/aowow, to align our ac/aowow repository properly

Helias avatar Apr 29 '25 10:04 Helias

So I just need to wait for the PR merge.

mpfans avatar Apr 29 '25 11:04 mpfans

@Helias Are there any merger plans in the near future?

mpfans avatar Oct 27 '25 09:10 mpfans

I am sorry but unfortunately I did not find the time to do it and I am not planning to do it soon :(

You can use this https://github.com/wowgaming/aowow/blob/master/.github/workflows/generate-aowow-database.yml as rerference for understanding how to make the setup work

Helias avatar Oct 27 '25 09:10 Helias