Jump to content
TrinityCore
Apple

"unknown column" "missing table" "duplicate column" error / sql problems / SQLDriverLogFile < answer on 1st post of 1st page

Recommended Posts

I had a similar one recently. I had previously added something like Monsterheight = 50000 into the worldserver.conf file due to info message in the start log. Removing it fixed it.

 

So try updating your worldserver.conf file to the latest

Share this post


Link to post
Share on other sites

 

6 hours ago, skipperheartbeat said:

I had a similar one recently. I had previously added something like Monsterheight = 50000 into the worldserver.conf file due to info message in the start log. Removing it fixed it.

 

So try updating your worldserver.conf file to the latest

worldserver.conf file flags or settings wouldn't have anything to do with a broken database.

  • Upvote 1

Share this post


Link to post
Share on other sites

I HATE HATE HATE asking for help. But I'm at a loss. I've wiped the world database numerous times. Tried over and over again to run the auto updates by the book according to TrinityCore standards. But I'm at a loss here. Googling/DuckDuckGo'ing yields nothing.

 

**EDIT: Forgot system info**

 

Core-i7 4790

ESXi Hypervisor 6.5

VM: Ubuntu 16.04.3

Kernel: 4.4.0-112-generic #135-Ubuntu (I know LTS, I'll address that later)

gcc:  version 6.3.0 20170519 (Ubuntu/Linaro 6.3.0-18ubuntu2~16.04)

 

 

[email protected]:~/server$ ./worldserver
TrinityCore rev. 4130647bf6bb+ 2018-01-27 16:20:41 +0100 (3.3.5 branch) (Unix, RelWithDebInfo, Static) (worldserver-daemon)
<Ctrl-C> to stop.

 ______                       __
/\__  _\       __          __/\ \__
\/_/\ \/ _ __ /\_\    ___ /\_\ \, _\  __  __
   \ \ \/\`'__\/\ \ /' _ `\/\ \ \ \/ /\ \/\ \
    \ \ \ \ \/ \ \ \/\ \/\ \ \ \ \ \_\ \ \_\ \
     \ \_\ \_\  \ \_\ \_\ \_\ \_\ \__\\/`____ \
      \/_/\/_/   \/_/\/_/\/_/\/_/\/__/ `/___/> \
                                 C O R E  /\___/
http://TrinityCore.org \/__/

Using configuration file /usr/local/etc/worldserver.conf.
Using SSL version: OpenSSL 1.0.2g  1 Mar 2016 (library: OpenSSL 1.0.2g  1 Mar 2016)
Using Boost version: 1.63.0
Updating Auth database...
>> The file '2016_10_17_00_auth.sql' was applied to the database, but is missing in your update directory now!
>> The file '2016_11_04_00_auth.sql' was applied to the database, but is missing in your update directory now!
>> The file '2016_11_09_00_auth.sql' was applied to the database, but is missing in your update directory now!
>> The file '2016_10_25_00_auth.sql' was applied to the database, but is missing in your update directory now!
>> The file '2016_11_17_00_auth.sql' was applied to the database, but is missing in your update directory now!
>> The file '2016_10_28_00_auth.sql' was applied to the database, but is missing in your update directory now!
>> The file '2016_12_04_00_auth.sql' was applied to the database, but is missing in your update directory now!
Cleanup is disabled! There were  7 dirty files applied to your database, but they are now missing in your source directory!
>> Auth database is up-to-date! Containing 14 new and 26 archived updates.
Updating Character database...
>> The file '2016_10_17_00_auth.sql' was applied to the database, but is missing in your update directory now!
>> The file '2016_11_04_00_auth.sql' was applied to the database, but is missing in your update directory now!
>> The file '2016_11_09_00_auth.sql' was applied to the database, but is missing in your update directory now!
>> The file '2016_10_25_00_auth.sql' was applied to the database, but is missing in your update directory now!
>> The file '2016_11_17_00_auth.sql' was applied to the database, but is missing in your update directory now!
>> The file '2016_10_28_00_auth.sql' was applied to the database, but is missing in your update directory now!
>> The file '2016_12_04_00_auth.sql' was applied to the database, but is missing in your update directory now!
Cleanup is disabled! There were  7 dirty files applied to your database, but they are now missing in your source directory!
>> Character database is up-to-date! Containing 14 new and 26 archived updates.
Updating World database...
>> World database is up-to-date! Containing 801 new and 2303 archived updates.
In mysql_stmt_prepare() id: 31, sql: "SELECT casterGuid, spell, effectMask, recalculateMask, stackCount, amount0, amount1, amount2, base_amount0, base_amount1, base_amount2, maxDuration, remainTime, remainCharges, critChance, applyResilience FROM character_aura WHERE guid = ?"
Unknown column 'critChance' in 'field list'
In mysql_stmt_prepare() id: 166, sql: "INSERT INTO character_aura (guid, casterGuid, spell, effectMask, recalculateMask, stackCount, amount0, amount1, amount2, base_amount0, base_amount1, base_amount2, maxDuration, remainTime, remainCharges, critChance, applyResilience) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
Unknown column 'critChance' in 'field list'
In mysql_stmt_prepare() id: 425, sql: "INSERT INTO pet_aura (guid, casterGuid, spell, effectMask, recalculateMask, stackCount, amount0, amount1, amount2, base_amount0, base_amount1, base_amount2, maxDuration, remainTime, remainCharges, critChance, applyResilience) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
Unknown column 'critChance' in 'field list'
Could not prepare statements of the Character database, see log for details.
[email protected]:~/server$

 

Edited by Darknation242
Missed some information

Share this post


Link to post
Share on other sites
3 hours ago, Darknation242 said:

I HATE HATE HATE asking for help. But I'm at a loss. I've wiped the world database numerous times. Tried over and over again to run the auto updates by the book according to TrinityCore standards. But I'm at a loss here. Googling/DuckDuckGo'ing yields nothing.

 

**EDIT: Forgot system info**

 

Core-i7 4790

ESXi Hypervisor 6.5

VM: Ubuntu 16.04.3

Kernel: 4.4.0-112-generic #135-Ubuntu (I know LTS, I'll address that later)

gcc:  version 6.3.0 20170519 (Ubuntu/Linaro 6.3.0-18ubuntu2~16.04)

 

 

[email protected]:~/server$ ./worldserver
TrinityCore rev. 4130647bf6bb+ 2018-01-27 16:20:41 +0100 (3.3.5 branch) (Unix, RelWithDebInfo, Static) (worldserver-daemon)
<Ctrl-C> to stop.

 ______                       __
/\__  _\       __          __/\ \__
\/_/\ \/ _ __ /\_\    ___ /\_\ \, _\  __  __
   \ \ \/\`'__\/\ \ /' _ `\/\ \ \ \/ /\ \/\ \
    \ \ \ \ \/ \ \ \/\ \/\ \ \ \ \ \_\ \ \_\ \
     \ \_\ \_\  \ \_\ \_\ \_\ \_\ \__\\/`____ \
      \/_/\/_/   \/_/\/_/\/_/\/_/\/__/ `/___/> \
                                 C O R E  /\___/
http://TrinityCore.org \/__/

Using configuration file /usr/local/etc/worldserver.conf.
Using SSL version: OpenSSL 1.0.2g  1 Mar 2016 (library: OpenSSL 1.0.2g  1 Mar 2016)
Using Boost version: 1.63.0
Updating Auth database...
>> The file '2016_10_17_00_auth.sql' was applied to the database, but is missing in your update directory now!
>> The file '2016_11_04_00_auth.sql' was applied to the database, but is missing in your update directory now!
>> The file '2016_11_09_00_auth.sql' was applied to the database, but is missing in your update directory now!
>> The file '2016_10_25_00_auth.sql' was applied to the database, but is missing in your update directory now!
>> The file '2016_11_17_00_auth.sql' was applied to the database, but is missing in your update directory now!
>> The file '2016_10_28_00_auth.sql' was applied to the database, but is missing in your update directory now!
>> The file '2016_12_04_00_auth.sql' was applied to the database, but is missing in your update directory now!
Cleanup is disabled! There were  7 dirty files applied to your database, but they are now missing in your source directory!
>> Auth database is up-to-date! Containing 14 new and 26 archived updates.
Updating Character database...
>> The file '2016_10_17_00_auth.sql' was applied to the database, but is missing in your update directory now!
>> The file '2016_11_04_00_auth.sql' was applied to the database, but is missing in your update directory now!
>> The file '2016_11_09_00_auth.sql' was applied to the database, but is missing in your update directory now!
>> The file '2016_10_25_00_auth.sql' was applied to the database, but is missing in your update directory now!
>> The file '2016_11_17_00_auth.sql' was applied to the database, but is missing in your update directory now!
>> The file '2016_10_28_00_auth.sql' was applied to the database, but is missing in your update directory now!
>> The file '2016_12_04_00_auth.sql' was applied to the database, but is missing in your update directory now!
Cleanup is disabled! There were  7 dirty files applied to your database, but they are now missing in your source directory!
>> Character database is up-to-date! Containing 14 new and 26 archived updates.
Updating World database...
>> World database is up-to-date! Containing 801 new and 2303 archived updates.
In mysql_stmt_prepare() id: 31, sql: "SELECT casterGuid, spell, effectMask, recalculateMask, stackCount, amount0, amount1, amount2, base_amount0, base_amount1, base_amount2, maxDuration, remainTime, remainCharges, critChance, applyResilience FROM character_aura WHERE guid = ?"
Unknown column 'critChance' in 'field list'
In mysql_stmt_prepare() id: 166, sql: "INSERT INTO character_aura (guid, casterGuid, spell, effectMask, recalculateMask, stackCount, amount0, amount1, amount2, base_amount0, base_amount1, base_amount2, maxDuration, remainTime, remainCharges, critChance, applyResilience) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
Unknown column 'critChance' in 'field list'
In mysql_stmt_prepare() id: 425, sql: "INSERT INTO pet_aura (guid, casterGuid, spell, effectMask, recalculateMask, stackCount, amount0, amount1, amount2, base_amount0, base_amount1, base_amount2, maxDuration, remainTime, remainCharges, critChance, applyResilience) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
Unknown column 'critChance' in 'field list'
Could not prepare statements of the Character database, see log for details.
[email protected]:~/server$

 

Delete the whole repository and clone it again AND don't delete any files on it.

Share this post


Link to post
Share on other sites
2 hours ago, Darknation242 said:

Just gave it a try, no luck boss. Wiped the repository clean and did a re checkout of just the 3.3.5 repository. It's not playing nice with others. :)

paste again your startup log.

Share this post


Link to post
Share on other sites

idk what are you doing, but you don't have proper files on repository.


DBUpdater: Given update include directory "/home/sysadmin/git/3.3.5/sql/updates/auth" does not exist, skipped!
DBUpdater: Given update include directory "/home/sysadmin/git/3.3.5/sql/custom/auth" does not exist, skipped!
DBUpdater: Given update include directory "/home/sysadmin/git/3.3.5/sql/old/3.3.5a/auth" does not exist, skipped!


DBUpdater: Given update include directory "/home/sysadmin/git/3.3.5/sql/updates/world" does not exist, skipped!
DBUpdater: Given update include directory "/home/sysadmin/git/3.3.5/sql/custom/world" does not exist, skipped!
DBUpdater: Given update include directory "/home/sysadmin/git/3.3.5/sql/old/3.3.5a/world" does not exist, skipped!

If it's 1st time install drop all your auth, world and characters database, clone repository again, and re-run compile work following wiki.

Share this post


Link to post
Share on other sites

Must be from when I deleted the repo. How embarrassing. This is the output now that I unfucked my mess.

Oh and it's not my first time install. I've been running TrinityCore for about 3 years now, this is just the first time I've gotten stuck and needed assistance.


 ______                       __
/\__  _\       __          __/\ \__
\/_/\ \/ _ __ /\_\    ___ /\_\ \, _\  __  __
   \ \ \/\`'__\/\ \ /' _ `\/\ \ \ \/ /\ \/\ \
    \ \ \ \ \/ \ \ \/\ \/\ \ \ \ \ \_\ \ \_\ \
     \ \_\ \_\  \ \_\ \_\ \_\ \_\ \__\\/`____ \
      \/_/\/_/   \/_/\/_/\/_/\/_/\/__/ `/___/> \
                                 C O R E  /\___/
http://TrinityCore.org \/__/

Using configuration file /usr/local/etc/worldserver.conf.
Using SSL version: OpenSSL 1.0.2g  1 Mar 2016 (library: OpenSSL 1.0.2g  1 Mar 2016)
Using Boost version: 1.63.0
Updating Auth database...
>> The file '2016_10_17_00_auth.sql' was applied to the database, but is missing in your update directory now!
>> The file '2016_11_04_00_auth.sql' was applied to the database, but is missing in your update directory now!
>> The file '2016_11_09_00_auth.sql' was applied to the database, but is missing in your update directory now!
>> The file '2016_10_25_00_auth.sql' was applied to the database, but is missing in your update directory now!
>> The file '2016_11_17_00_auth.sql' was applied to the database, but is missing in your update directory now!
>> The file '2016_10_28_00_auth.sql' was applied to the database, but is missing in your update directory now!
>> The file '2016_12_04_00_auth.sql' was applied to the database, but is missing in your update directory now!
Cleanup is disabled! There were  7 dirty files applied to your database, but they are now missing in your source directory!
>> Auth database is up-to-date! Containing 14 new and 26 archived updates.
Updating Character database...
>> The file '2016_10_17_00_auth.sql' was applied to the database, but is missing in your update directory now!
>> The file '2016_11_04_00_auth.sql' was applied to the database, but is missing in your update directory now!
>> The file '2016_11_09_00_auth.sql' was applied to the database, but is missing in your update directory now!
>> The file '2016_10_25_00_auth.sql' was applied to the database, but is missing in your update directory now!
>> The file '2016_11_17_00_auth.sql' was applied to the database, but is missing in your update directory now!
>> The file '2016_10_28_00_auth.sql' was applied to the database, but is missing in your update directory now!
>> The file '2016_12_04_00_auth.sql' was applied to the database, but is missing in your update directory now!
Cleanup is disabled! There were  7 dirty files applied to your database, but they are now missing in your source directory!
>> Character database is up-to-date! Containing 14 new and 26 archived updates.
Updating World database...
>> Applying update "2018_01_29_00_world.sql" 'E9E0AE0'...
mysql: [Warning] Using a password on the command line interface can be insecure.

>> Applying update "2018_01_29_01_world_335.sql" 'E0C6362'...
mysql: [Warning] Using a password on the command line interface can be insecure.

>> Applied 2 queries. Containing 801 new and 2303 archived updates.
In mysql_stmt_prepare() id: 31, sql: "SELECT casterGuid, spell, effectMask, recalculateMask, stackCount, amount0, amount1, amount2, base_amount0, base_amount1, base_amount2, maxDuration, remainTime, remainCharges, critChance, applyResilience FROM character_aura WHERE guid = ?"
Unknown column 'critChance' in 'field list'
In mysql_stmt_prepare() id: 166, sql: "INSERT INTO character_aura (guid, casterGuid, spell, effectMask, recalculateMask, stackCount, amount0, amount1, amount2, base_amount0, base_amount1, base_amount2, maxDuration, remainTime, remainCharges, critChance, applyResilience) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
Unknown column 'critChance' in 'field list'
In mysql_stmt_prepare() id: 425, sql: "INSERT INTO pet_aura (guid, casterGuid, spell, effectMask, recalculateMask, stackCount, amount0, amount1, amount2, base_amount0, base_amount1, base_amount2, maxDuration, remainTime, remainCharges, critChance, applyResilience) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
Unknown column 'critChance' in 'field list'
Could not prepare statements of the Character database, see log for details.
[email protected]:~/server$

 

Edited by Darknation242

Share this post


Link to post
Share on other sites
7 hours ago, Darknation242 said:

Tried re compiling, same output as before.  This is an exsisting installation of TC3. It only started doing this recently.

Where are you running the binaries? Did you create a bin directory and place your mmaps, vmaps, etc... in said directory?

I'm just trying to see if you ran everything correctly but just running the binaries in the wrong directory. It can't find your updates directory.  "/home/sysadmin/git/3.3.5/sql/updates/world".

 

Bottom of doc: https://trinitycore.atlassian.net/wiki/spaces/tc/pages/10977309/Linux+Core+Installation

-DCMAKE_INSTALL_PREFIX=/path/to/where/you/want/core/to/be/installed

It will create the following structure:

<path>/bin/ - binaries will be placed here 
<path>/etc/ - config files will be placed here

  • Upvote 1

Share this post


Link to post
Share on other sites

Awesome, thanks for all the help Aokromes and CDawg.

The binaries are located under /home/server the same place I've been running them from for the past two years. As for the configs they are located in the default location /usr/local/etc which as far as I know has been the default config directory for quite some time. Nothing has been moved or relocated. It's the same folder for the binaries and configs I've been using with success for years.

There is one thing I neglected to mention, and I'm sure this will cause follow-up questions but because I'm running all this under an ESXi Hypervisor environment the database is actually located on a seperate install of Ubuntu 16.04.3. All systems are up to date within reason to accomadate TrinityCore.

Share this post


Link to post
Share on other sites

Hi ... my two cents ... have you tried fishing through the named sql files that have issues and butchering them to work with your (possibly modified) core? I seem to remember some problems along these lines during my last build. GL.

 

Share this post


Link to post
Share on other sites

I just flushed all the databases and let TrinityCore import everything. Same results.

 

>> Applying update "2018_01_29_01_world_335.sql" 'E0C6362'...
mysql: [Warning] Using a password on the command line interface can be insecure.

>> Applying update "2018_01_30_00_world.sql" '18F1231'...
mysql: [Warning] Using a password on the command line interface can be insecure.

>> Applying update "2018_01_30_01_world_335.sql" 'FE57CBD'...
mysql: [Warning] Using a password on the command line interface can be insecure.

>> Applied 804 queries. Containing 1 new and 2303 archived updates.
In mysql_stmt_prepare() id: 31, sql: "SELECT casterGuid, spell, effectMask, recalculateMask, stackCount, amount0, amount1, amount2, base_amount0, base_amount1, base_amount2, maxDuration, remainTime, remainCharges, critChance, applyResilience FROM character_aura WHERE guid = ?"
Unknown column 'critChance' in 'field list'
In mysql_stmt_prepare() id: 166, sql: "INSERT INTO character_aura (guid, casterGuid, spell, effectMask, recalculateMask, stackCount, amount0, amount1, amount2, base_amount0, base_amount1, base_amount2, maxDuration, remainTime, remainCharges, critChance, applyResilience) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
Unknown column 'critChance' in 'field list'
In mysql_stmt_prepare() id: 425, sql: "INSERT INTO pet_aura (guid, casterGuid, spell, effectMask, recalculateMask, stackCount, amount0, amount1, amount2, base_amount0, base_amount1, base_amount2, maxDuration, remainTime, remainCharges, critChance, applyResilience) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
Unknown column 'critChance' in 'field list'
Could not prepare statements of the Character database, see log for details.
[email protected]:~/server$

 

Share this post


Link to post
Share on other sites

Got it. It caused a 6 month roll back on the characters database but it's fixed. I had to manually run the updates.Before anyone asks of course I was backing up the databases, but the most recent ones were corrupted by this issue and I just happened to have an older local copy I could work with.

  • Like 2

Share this post


Link to post
Share on other sites
On 2/3/2018 at 8:49 AM, Darknation242 said:

Got it. It caused a 6 month roll back on the characters database but it's fixed. I had to manually run the updates.Before anyone asks of course I was backing up the databases, but the most recent ones were corrupted by this issue and I just happened to have an older local copy I could work with.

Ah... It was corrupted.. Iv'e had that before. Fortunately for me, it was only about 5 weeks in a character table, but it took me a whole month to find the issue. I also know how you feel.. sometimes having backups of a DB that is already corrupt just makes things worse :(

Curious.. do you know where it was corrupted? Like a bad row in a table, or just garbage all over the place?

Share this post


Link to post
Share on other sites

So, the table I'm having trouble with is the characters table. When I run the create script it claims the table already exists. Do I need to backup the data, drop the table, let the create script run then import the data back? I feel like I'm likely missing an update that ran between now and the last time I updated.

 

For the record this is my log.

"Updating Auth database...
>> Auth database is up-to-date! Containing 8 new and 19 archived updates.
Updating Character database...
>> Character database is up-to-date! Containing 1 new and 22 archived updates.
Updating World database...
>> World database is up-to-date! Containing 155 new and 2303 archived updates.
Unknown column 'critChance' in 'field list'
In mysql_stmt_prepare() id: 31, sql: "SELECT casterGuid, spell, effectMask, recalculateMask, stackCount, amount0, amount1, amount2, base_amount0, base_amount1, base_amount2, maxDuration, remainTime, remainCharges, critChance, applyResilience FROM character_aura WHERE guid = ?"
In mysql_stmt_prepare() id: 82, sql: "INSERT IGNORE INTO auctionbidders (id, bidderguid) VALUES (?, ?)"
Table 'characters.auctionbidders' doesn't exist
In mysql_stmt_prepare() id: 83, sql: "DELETE FROM auctionbidders WHERE id = ?"
Table 'characters.auctionbidders' doesn't exist
In mysql_stmt_prepare() id: 166, sql: "INSERT INTO character_aura (guid, casterGuid, spell, effectMask, recalculateMask, stackCount, amount0, amount1, amount2, base_amount0, base_amount1, base_amount2, maxDuration, remainTime, remainCharges, critChance, applyResilience) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
Unknown column 'critChance' in 'field list'
In mysql_stmt_prepare() id: 425, sql: "INSERT INTO pet_aura (guid, casterGuid, spell, effectMask, recalculateMask, stackCount, amount0, amount1, amount2, base_amount0, base_amount1, base_amount2, maxDuration, remainTime, remainCharges, critChance, applyResilience) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
Unknown column 'critChance' in 'field list'
Could not prepare statements of the Character database, see log for details."

Edited by Wronglebowski

Share this post


Link to post
Share on other sites

Hello I have done a clear install core and db yesterday. I added the base auth/characters db, TDB_full_735.00_2018_02_19 (world and hotfixes). Auth and characters got autoupdated when i ran the worldserver.exe but I'm getting this error with hotfixes db (log):

In mysql_stmt_prepare() id: 46, sql: "SELECT ID, Flags, ClientPrefix, ClientFileString, Name, NameFemale, NameMale, FacialHairCustomization1, FacialHairCustomization2, HairCustomization, CreateScreenFileDataID, SelectScreenFileDataID, MaleCustomizeOffset1, MaleCustomizeOffset2, MaleCustomizeOffset3, FemaleCustomizeOffset1, FemaleCustomizeOffset2, FemaleCustomizeOffset3, LowResScreenFileDataID, FactionID, MaleDisplayID, FemaleDisplayID, ResSicknessSpellID, SplashSoundID, CinematicSequenceID, BaseLanguage, CreatureType, TeamID, RaceRelated, UnalteredVisualRaceID, CharComponentTextureLayoutID, DefaultClassID, NeutralRaceID, ItemAppearanceFrameRaceID, CharComponentTexLayoutHiResID, HighResMaleDisplayID, HighResFemaleDisplayID, Unk1, Unk2, Unk3 FROM chr_races ORDER BY ID DESC"
Unknown column 'NameMale' in 'field list'
In mysql_stmt_prepare() id: 47, sql: "SELECT ID, Name_lang, NameFemale_lang, NameMale_lang FROM chr_races_locale WHERE locale = ?"
Unknown column 'NameMale_lang' in 'field list'
In mysql_stmt_prepare() id: 158, sql: "SELECT ID, Key1, Key2, Key3, Key4, Key5, Key6, Key7, Key8, Key9, Key10, Key11, Key12, Key13, Key14, Key15, Key16, Key17, Key18, Key19, Key20, Key21, Key22, Key23, Key24, Key25, Key26, Key27, Key28, Key29, Key30, Key31, Key32 FROM key_chain ORDER BY ID DESC"
Table 'hotfixes.key_chain' doesn't exist
In mysql_stmt_prepare() id: 210, sql: "SELECT ID, Name, Script, PrevScriptId, NextScriptId FROM scene_script ORDER BY ID DESC"
Unknown column 'Name' in 'field list'
In mysql_stmt_prepare() id: 214, sql: "SELECT ID, SpellID, RaceMask, SupercedesSpell, SkillLine, MinSkillLineRank, TrivialSkillLineRankHigh, TrivialSkillLineRankLow, UniqueBit, TradeSkillCategoryID, AcquireMethod, NumSkillUps, Unknown703, ClassMask FROM skill_line_ability ORDER BY ID DESC"
Unknown column 'Unknown703' in 'field list'
In mysql_stmt_prepare() id: 216, sql: "SELECT Name, VolumeFloat, MinDistance, DistanceCutoff, VolumeVariationPlus, VolumeVariationMinus, PitchVariationPlus, PitchVariationMinus, PitchAdjust, Flags, SoundEntriesAdvancedID, BusOverwriteID, SoundType, EAXDef, DialogType, Unk700, ID FROM sound_kit ORDER BY ID DESC"
Unknown column 'Name' in 'field list'
In mysql_stmt_prepare() id: 217, sql: "SELECT ID, Name_lang FROM sound_kit_locale WHERE locale = ?"
Table 'hotfixes.sound_kit_locale' doesn't exist
In mysql_stmt_prepare() id: 220, sql: "SELECT Name, NameSubtext, Description, AuraDescription, MiscID, ID, DescriptionVariablesID FROM spell ORDER BY ID DESC"
Unknown column 'MiscID' in 'field list'
In mysql_stmt_prepare() id: 233, sql: "SELECT ID, Coefficient, Variance, ResourceCoefficient, SpellEffectID FROM spell_effect_scaling ORDER BY ID DESC"
Table 'hotfixes.spell_effect_scaling' doesn't exist
In mysql_stmt_prepare() id: 281, sql: "SELECT ID, Flags, TurnSpeed, PitchSpeed, PitchMin, PitchMax, MouseLookOffsetPitch, CameraFadeDistScalarMin, CameraFadeDistScalarMax, CameraPitchOffset, FacingLimitRight, FacingLimitLeft, MsslTrgtTurnLingering, MsslTrgtPitchLingering, MsslTrgtMouseLingering, MsslTrgtEndOpacity, MsslTrgtArcSpeed, MsslTrgtArcRepeat, MsslTrgtArcWidth, MsslTrgtImpactRadius1, MsslTrgtImpactRadius2, MsslTrgtArcTexture, MsslTrgtImpactTexture, MsslTrgtImpactModel1, MsslTrgtImpactModel2, CameraYawOffset, MsslTrgtImpactTexRadius, SeatID1, SeatID2, SeatID3, SeatID4, SeatID5, SeatID6, SeatID7, SeatID8, VehicleUIIndicatorID, PowerDisplayID1, PowerDisplayID2, PowerDisplayID3, FlagsB, UILocomotionType FROM vehicle ORDER BY ID DESC"
Unknown column 'MsslTrgtTurnLingering' in 'field list'

 

Dunno if I have missed any update or I did something wrong but I guess that its a issue with the last patch in folder old\7\hotfixes\01_2018_02_19 ,where patch  2018_02_18_00_hotfixes.sql drop "namemale" field and others need and maybe it happens with db world too with the same patch in world.

Any idea? Thanks you.

PS: If the issue is that patch, the TDB_full_735.00_2018_02_19 include that patch too so It would need to revert it too there.

Share this post


Link to post
Share on other sites
1 hour ago, Daniel25 said:

Hello I have done a clear install core and db yesterday. I added the base auth/characters db, TDB_full_735.00_2018_02_19 (world and hotfixes). Auth and characters got autoupdated when i ran the worldserver.exe but I'm getting this error with hotfixes db (log):

Dunno if I have missed any update or I did something wrong but I guess that its a issue with the last patch in folder old\7\hotfixes\01_2018_02_19 ,where patch  2018_02_18_00_hotfixes.sql drop "namemale" field and others need and maybe it happens with db world too with the same patch in world.

Any idea? Thanks you.

PS: If the issue is that patch, the TDB_full_735.00_2018_02_19 include that patch too so It would need to revert it too there.

Don't manually import sql files, leave core to do the job.

Share this post


Link to post
Share on other sites
3 hours ago, Wronglebowski said:

So, the table I'm having trouble with is the characters table. When I run the create script it claims the table already exists. Do I need to backup the data, drop the table, let the create script run then import the data back? I feel like I'm likely missing an update that ran between now and the last time I updated.


Unknown column 'critChance' in 'field list'
Could not prepare statements of the Character database, see log for details."

Don't manually import sql files, leave core to do the job.

Share this post


Link to post
Share on other sites
4 hours ago, Aokromes said:

Don't manually import sql files, leave core to do the job.

That's exactly what I did :(

When I "Update" my Trinity core I download the precompiled branch, extract it, deposit in the Trinity Core folder I have. I overwrite all existing files so the new files take precidence. Then I launch core. 

Share this post


Link to post
Share on other sites
On 25/2/2018 at 12:02 PM, Aokromes said:

Don't manually import sql files, leave core to do the job.

First time i only added manually base auth/characters and tdb_full hotfixes and world (I have done this several times before, I follow your job since long time ago and I have installed the most of your server versions and everything was ok always this way). Nevermind...

I followed your instructions (dropped every db) and I allowed worldserver.exe to create dbs and update it...same log error... and I didnt import manually any sql file this time....

 

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Recently Browsing   1 member

  • Similar Content

    • By Hydra_Btforce
      Just finished download & compile fresh trinitycore 4.3.4  From : https://gitlab.com/trinitycore/TrinityCore_434/tree/4.3.4
       
      Creating World database from : https://github.com/TrinityCoreLegacy/TrinityCore/releases
      Downloading the lasted one & create new database named World
      Navigate to my repo applying sql/updates/world/4.3.4
      Trying to apply all updates but an error occurred while applying updates
      And if i don't apply all updates the world is totally bugged and items/creature are missing.
       
      Please help
    • By 939h
      Hi,

      The chat channel Lookup for group is not available when a player isn't in a city. I tried to modify the worldserver.conf file with:
      #
      #    Channel.RestrictedLfg
      #        Description: Restrict LookupForGroup channel to characters registered in the LFG tool.
      #        Default:     1 - (Enabled, Allow join to channel only if registered in LFG)
      #                     0 - (Disabled, Allow join to channel in any time)
      Channel.RestrictedLfg = 0

      I restarted the server but it didn't help.

      Thanks
    • By Probie_Wan_Kenobi
      I believe everything I have done up to this point has been correct. When I go to launch worldserver.exe a console window opens up for a second and closes right away and nothing else seems to have happened. I skipped a head a little in the instructions to see what is left and step 5 seems skippable since I am running this only for this computer and step 6 has me launch to a log in screen which I can not get to. I tried going to the faq but the page was not loading properly so I am forced to post here.
    • By Cantte
      Well ... today I was about to compile the trinity core version for WoW 4.3.4 of this repository "https://gitlab.com/trinitycore/TrinityCore_434". Download them and when you use the cmake, I generate the solution correctly. When I began to compile this went well until I got to the last step, when I was 90% practically.
      This was the error:
      Main.obj: error LNK2019: external symbol SSLeay_version unresolved referred to in the function "public: void __cdecl <lambda_4a2d53ce610f18dba0b4b4d6532c13a7> :: operator () (void) const" (?? R <lambda_4a2d53ce610f18dba0b4b4d6532c13a7> @@ QEBAXXZ)
      25> scripts.lib (cs_server.obj): error LNK2001: external symbol SSLeay_version unresolved
      25> gsoap.lib (stdsoap2.obj): error LNK2019: unresolved sk_num external symbol referenced in the tcp_connect function
      25> gsoap.lib (stdsoap2.obj): error LNK2019: unresolved sk_value external symbol referenced in the tcp_connect function
      25> gsoap.lib (stdsoap2.obj): error LNK2019: unresolved sk_pop_free external symbol referenced in the tcp_connect function
      25> gsoap.lib (stdsoap2.obj): error LNK2019: outer symbol OPENSSL_add_all_algorithms_noconf unresolved referenced in the soap_ssl_init function
      25> gsoap.lib (stdsoap2.obj): error LNK2019: external symbol SSL_load_error_strings unresolved referenced in the soap_ssl_init function
      25> gsoap.lib (stdsoap2.obj): error LNK2019: unresolved external SSLv23_method symbol referenced in the ssl_auth_init function
      25> gsoap.lib (stdsoap2.obj): error LNK2019: external symbol SSL_library_init unresolved referenced in the soap_ssl_init function
      25> gsoap.lib (stdsoap2.obj): error LNK2019: external symbol SSL_state unresolved referenced in the tcp_connect function
      25> common.lib (OpenSSLCrypto.obj): error LNK2019: external symbol CRYPTO_num_locks unresolved referred to in the function "void __cdecl OpenSSLCrypto :: threadsCleanup (void)" (? ThreadsCleanup @ OpenSSLCrypto @@ YAXXZ)
      25> common.lib (OpenSSLCrypto.obj): error LNK2019: external symbol CRYPTO_set_locking_callback unresolved referred to in the function "void __cdecl OpenSSLCrypto :: threadsCleanup (void)" (? ThreadsCleanup @ OpenSSLCrypto @@ YAXXZ)
      25> common.lib (OpenSSLCrypto.obj): error LNK2019: external symbol CRYPTO_THREADID_set_numeric unresolved referred to in the function "void __cdecl threadIdCallback (struct crypto_threadid_st *)" (? ThreadIdCallback @@ YAXPEAUcrypto_threadid_st @@@ Z)
      25> common.lib (OpenSSLCrypto.obj): error LNK2019: external symbol CRYPTO_THREADID_set_callback unresolved referenced in the function "void __cdecl OpenSSLCrypto :: threadsCleanup (void)" (? ThreadsCleanup @ OpenSSLCrypto @@ YAXXZ)
      25> common.lib (ARC4.obj): error LNK2019: external symbol EVP_CIPHER_CTX_init unresolved referred to in the function "public: __cdecl ARC4 :: ARC4 (unsigned int)" (?? 0ARC4 @@ QEAA @ I @ Z)
      25> common.lib (HmacHash.obj): error LNK2019: unresolved HMAC_CTX_init external symbol referenced in the "struct hmac_ctx_st * __cdecl HMAC_CTX_new (void)" function (? HMAC_CTX_new @@ YAPEAUhmac_ctx_st @@ XZ)
      25> common.lib (HmacHash.obj): error LNK2019: unresolved HMAC_CTX_cleanup external symbol referenced in the "void __cdecl HMAC_CTX_free (struct hmac_ctx_st *)" function (? HMAC_CTX_free @@ YAXPEAUhmac_ctx_st @@@ Z)
      25> E: \ Server-Wow \ TrinityCore_434-4.3.4 \ Build \ bin \ RelWithDebInfo \ worldserver.exe: fatal error LNK1120: 16 external unresolved
      25> Compilation of the "worldserver.vcxproj" project completed - ERROR.
      26> ------ Compile operation started: project: ALL_BUILD, configuration: RelWithDebInfo x64 ------
      26> Building Custom Rule E: /Server-Wow/TrinityCore_434-4.3.4/CMakeLists.txt
      26> CMake does not need to re-run because E: /Server-Wow/TrinityCore_434-4.3.4/Build/CMakeFiles/generate.stamp is up-to-date.
      ========== Compile: 23 correct, 3 incorrect, 0 updated, 0 omitted ==========
       
      And this is the original error in Spanish (since I use the compiler in Spanish)
       
      Main.obj : error LNK2019: símbolo externo SSLeay_version sin resolver al que se hace referencia en la función "public: void __cdecl <lambda_4a2d53ce610f18dba0b4b4d6532c13a7>::operator()(void)const " (??R<lambda_4a2d53ce610f18dba0b4b4d6532c13a7>@@QEBAXXZ)
      25>scripts.lib(cs_server.obj) : error LNK2001: símbolo externo SSLeay_version sin resolver
      25>gsoap.lib(stdsoap2.obj) : error LNK2019: símbolo externo sk_num sin resolver al que se hace referencia en la función tcp_connect
      25>gsoap.lib(stdsoap2.obj) : error LNK2019: símbolo externo sk_value sin resolver al que se hace referencia en la función tcp_connect
      25>gsoap.lib(stdsoap2.obj) : error LNK2019: símbolo externo sk_pop_free sin resolver al que se hace referencia en la función tcp_connect
      25>gsoap.lib(stdsoap2.obj) : error LNK2019: símbolo externo OPENSSL_add_all_algorithms_noconf sin resolver al que se hace referencia en la función soap_ssl_init
      25>gsoap.lib(stdsoap2.obj) : error LNK2019: símbolo externo SSL_load_error_strings sin resolver al que se hace referencia en la función soap_ssl_init
      25>gsoap.lib(stdsoap2.obj) : error LNK2019: símbolo externo SSLv23_method sin resolver al que se hace referencia en la función ssl_auth_init
      25>gsoap.lib(stdsoap2.obj) : error LNK2019: símbolo externo SSL_library_init sin resolver al que se hace referencia en la función soap_ssl_init
      25>gsoap.lib(stdsoap2.obj) : error LNK2019: símbolo externo SSL_state sin resolver al que se hace referencia en la función tcp_connect
      25>common.lib(OpenSSLCrypto.obj) : error LNK2019: símbolo externo CRYPTO_num_locks sin resolver al que se hace referencia en la función "void __cdecl OpenSSLCrypto::threadsCleanup(void)" ([email protected]@@YAXXZ)
      25>common.lib(OpenSSLCrypto.obj) : error LNK2019: símbolo externo CRYPTO_set_locking_callback sin resolver al que se hace referencia en la función "void __cdecl OpenSSLCrypto::threadsCleanup(void)" ([email protected]@@YAXXZ)
      25>common.lib(OpenSSLCrypto.obj) : error LNK2019: símbolo externo CRYPTO_THREADID_set_numeric sin resolver al que se hace referencia en la función "void __cdecl threadIdCallback(struct crypto_threadid_st *)" ([email protected]@[email protected]@@Z)
      25>common.lib(OpenSSLCrypto.obj) : error LNK2019: símbolo externo CRYPTO_THREADID_set_callback sin resolver al que se hace referencia en la función "void __cdecl OpenSSLCrypto::threadsCleanup(void)" ([email protected]@@YAXXZ)
      25>common.lib(ARC4.obj) : error LNK2019: símbolo externo EVP_CIPHER_CTX_init sin resolver al que se hace referencia en la función "public: __cdecl ARC4::ARC4(unsigned int)" ([email protected]@[email protected]@Z)
      25>common.lib(HmacHash.obj) : error LNK2019: símbolo externo HMAC_CTX_init sin resolver al que se hace referencia en la función "struct hmac_ctx_st * __cdecl HMAC_CTX_new(void)" ([email protected]@[email protected]@XZ)
      25>common.lib(HmacHash.obj) : error LNK2019: símbolo externo HMAC_CTX_cleanup sin resolver al que se hace referencia en la función "void __cdecl HMAC_CTX_free(struct hmac_ctx_st *)" ([email protected]@[email protected]@@Z)
      25>E:\Server-Wow\TrinityCore_434-4.3.4\Build\bin\RelWithDebInfo\worldserver.exe : fatal error LNK1120: 16 externos sin resolver
      25>Compilación del proyecto "worldserver.vcxproj" terminada -- ERROR.
      26>------ Operación Compilar iniciada: proyecto: ALL_BUILD, configuración: RelWithDebInfo x64 ------
      26>Building Custom Rule E:/Server-Wow/TrinityCore_434-4.3.4/CMakeLists.txt
      26>CMake does not need to re-run because E:/Server-Wow/TrinityCore_434-4.3.4/Build/CMakeFiles/generate.stamp is up-to-date.
      ========== Compilar: 23 correctos, 3 incorrectos, 0 actualizados, 0 omitidos ==========
       
       
      Thanks.
    • By Fyury
      When I run "worldserver.exe" it just crashes and I get this:
      TrinityCore rev. 084da48ba15a 2018-05-26 18:48:09 +0200 (master branch) (Win64, RelWithDebInfo, Static) (worldserver-daemon)
      <Ctrl-C> to stop.
       ______                       __
      /\__  _\       __          __/\ \__
      \/_/\ \/ _ __ /\_\    ___ /\_\ \, _\  __  __
         \ \ \/\`'__\/\ \ /' _ `\/\ \ \ \/ /\ \/\ \
          \ \ \ \ \/ \ \ \/\ \/\ \ \ \ \ \_\ \ \_\ \
           \ \_\ \_\  \ \_\ \_\ \_\ \_\ \__\\/`____ \
            \/_/\/_/   \/_/\/_/\/_/\/_/\/__/ `/___/> \
                                       C O R E  /\___/
      http://TrinityCore.org                    \/__/
      Using configuration file C:/WoW-Server/bin/RelWithDebInfo/worldserver.conf.
      Using SSL version: OpenSSL 1.0.1e 11 Feb 2013 (library: OpenSSL 1.0.1e 11 Feb 2013)
      Using Boost version: 1.65.1
      Updating Auth database...
      >> Auth database is up-to-date! Containing 6 new and 115 archived updates.
      Updating Character database...
      >> Character database is up-to-date! Containing 3 new and 77 archived updates.
      Updating World database...
      >> World database is up-to-date! Containing 193 new and 2262 archived updates.
      Updating Hotfixes database...
      >> Hotfixes database is up-to-date! Containing 18 new and 130 archived updates.
      Realm running as realm ID 1
      Using World DB: TDB 735.00
      Using enUS DBC Locale
      Will clear `logs` table of entries older than 1209600 seconds every 10 minutes.
      Using DataDir ./
      WORLD: MMap data directory is: ./mmaps
      VMap support included. LineOfSight: 1, getHeight: 1, indoorCheck: 1
      VMap data directory is: ./vmaps
      Missing name Guild.SaveInterval in config file C:/WoW-Server/bin/RelWithDebInfo/worldserver.conf, add "Guild.SaveInterval = 15" to this file
      Initialize PlayerDump...
      >> Initialized 370 PlayerDump ColumnDefinitions in 551 ms.
      Loading Trinity strings...
      >> Loaded 965 trinity strings in 32 ms
      Initialize data stores...
      Some required *.db2 files (2 from 230) not found or not compatible:
      ItemSearchName.db2
      WorldSafeLocs.db2
       
       
      ItemSearName.db2 & WorldSafeLocs.db2 dont exist but how can I get them
      When I start "mapextractor.exe" this happens:
       
      Unable to open file DBFilesClient\ItemSearchName.db2 in the archive for locale enUS: FILE_NOT_FOUND
      Unable to open file DBFilesClient\Unittest.db2 in the archive for locale enUS: FILE_NOT_FOUND
      Unable to open file DBFilesClient\WorldSafeLocs.db2 in the archive for locale enUS: FILE_NOT_FOUND
       
×
×
  • Create New...