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

[mpfans]

Current Behaviour

php aowow --setup cannot find the world version

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

[Helias]

It's a known issue, you can ignore it

[mpfans]

Cannot ignore, continuing will automatically exit

[Helias]

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

[mpfans]

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

[Helias]

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

[mpfans]

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

[Helias]

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

[mpfans]

So I just need to wait for the PR merge.

[mpfans]

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

[Helias]

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