Getting a missing field error on spell_area table when first run of worldserver to build world database. Below is my Server.log I've looked at the database after the worldserver.exe closes and there is no flags field in the spell_area table. Have downloaded most recent database and cloned most recent git. DBErrors.log is empty.
Using configuration file C:/projects/trinitycore/worldserver.conf.
Using SSL version: OpenSSL 1.0.2s 28 May 2019 (library: OpenSSL 1.0.2s 28 May 2019)
Using Boost version: 1.67.0
Database Auth is empty, auto populating it...
>> Applying 'C:/projects/trinitycore/sql/base/auth_database.sql'...
>> Done!
Database Character is empty, auto populating it...
>> Applying 'C:/projects/trinitycore/sql/base/characters_database.sql'...
>> Done!
Database World is empty, auto populating it...
>> Applying 'TDB_full_world_335.19091_2019_09_15.sql'...
>> Done!
Updating Auth database...
>> Auth database is up-to-date! Containing 21 new and 115 archived updates.
Updating Character database...
>> Character database is up-to-date! Containing 12 new and 77 archived updates.
Updating World database...
DBUpdater: Given update include directory "C:/projects/trinitycore/sql/old/3.3.5a/world" does not exist, skipped!
>> Applying update "2019_06_20_02_world_2017_01_06_01_world.sql" 'D469B1D'...
>> Applying update "2019_06_20_03_world_2017_01_07_01_world.sql" '676F8B9'...
ERROR 1054 (42S22) at line 3: Unknown column 'flags' in 'field list'
Applying of file 'C:/projects/trinitycore/sql/updates/world/master/2019_06_20_03_world_2017_01_07_01_world.sql' to database 'world' failed! If you are a user, please pull the latest revision from the repository. Also make sure you have not applied any of the databases with your sql client. You cannot use auto-update system and import sql files from TrinityCore repository with your sql client. If you are a developer, please fix your sql query.
Could not update the World database, see log for details.
"unknown column" "missing table" "duplicate column" error / sql problems / SQLDriverLogFile < answer on 1st post of 1st page
in Help and Support
Posted · Edited by steihl
Getting a missing field error on spell_area table when first run of worldserver to build world database. Below is my Server.log I've looked at the database after the worldserver.exe closes and there is no flags field in the spell_area table. Have downloaded most recent database and cloned most recent git. DBErrors.log is empty.
TrinityCore rev. ada4e431ae77 2019-10-05 20:40:17 +0200 (HEAD branch) (Win64, RelWithDebInfo, Dynamic) (worldserver-daemon)
<Ctrl-C> to stop.
______ __
/\__ _\ __ __/\ \__
\/_/\ \/ _ __ /\_\ ___ /\_\ \, _\ __ __
\ \ \/\`'__\/\ \ /' _ `\/\ \ \ \/ /\ \/\ \
\ \ \ \ \/ \ \ \/\ \/\ \ \ \ \ \_\ \ \_\ \
\ \_\ \_\ \ \_\ \_\ \_\ \_\ \__\\/`____ \
\/_/\/_/ \/_/\/_/\/_/\/_/\/__/ `/___/> \
C O R E /\___/
http://TrinityCore.org \/__/
Using configuration file C:/projects/trinitycore/worldserver.conf.
Using SSL version: OpenSSL 1.0.2s 28 May 2019 (library: OpenSSL 1.0.2s 28 May 2019)
Using Boost version: 1.67.0
Database Auth is empty, auto populating it...
>> Applying 'C:/projects/trinitycore/sql/base/auth_database.sql'...
>> Done!
Database Character is empty, auto populating it...
>> Applying 'C:/projects/trinitycore/sql/base/characters_database.sql'...
>> Done!
Database World is empty, auto populating it...
>> Applying 'TDB_full_world_335.19091_2019_09_15.sql'...
>> Done!
Updating Auth database...
>> Auth database is up-to-date! Containing 21 new and 115 archived updates.
Updating Character database...
>> Character database is up-to-date! Containing 12 new and 77 archived updates.
Updating World database...
DBUpdater: Given update include directory "C:/projects/trinitycore/sql/old/3.3.5a/world" does not exist, skipped!
>> Applying update "2019_06_20_02_world_2017_01_06_01_world.sql" 'D469B1D'...
>> Applying update "2019_06_20_03_world_2017_01_07_01_world.sql" '676F8B9'...
ERROR 1054 (42S22) at line 3: Unknown column 'flags' in 'field list'
Applying of file 'C:/projects/trinitycore/sql/updates/world/master/2019_06_20_03_world_2017_01_07_01_world.sql' to database 'world' failed! If you are a user, please pull the latest revision from the repository. Also make sure you have not applied any of the databases with your sql client. You cannot use auto-update system and import sql files from TrinityCore repository with your sql client. If you are a developer, please fix your sql query.
Could not update the World database, see log for details.