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

hello guys i have compiled with the latest version of eluna evreything worked well

auth server will run but the world server crash do somone know a solution how to fix it 

 

i use my world database backup from the orginal trinitycore

 

+ rep if you can help me out

 

 

i have run the updates for the world/auth/characters but it wont get online

 

In mysql_stmt_prepare() id: 29, sql: "SELECT point, position_x, position_y, position_z, orientation, move_type, delay, action, action_chance FROM waypoint_data WHERE id = ? ORDER BY point"
Unknown column 'move_type' in 'field list'
In mysql_stmt_prepare() id: 34, sql: "SELECT id, point, delay, move_type, action, action_chance FROM waypoint_data WHERE wpguid = ?"
Unknown column 'move_type' in 'field list'
In mysql_stmt_prepare() id: 54, sql: "SELECT entry, difficulty_entry_1, difficulty_entry_2, difficulty_entry_3, KillCredit1, KillCredit2, modelid1, modelid2, modelid3, modelid4, name, subname, IconName, gossip_menu_id, minlevel, maxlevel, exp, faction, npcflag, speed_walk, speed_run, scale, rank, dmgschool, BaseAttackTime, RangeAttackTime, BaseVariance, RangeVariance, unit_class, unit_flags, unit_flags2, dynamicflags, family, trainer_type, trainer_spell, trainer_class, trainer_race, type, type_flags, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, spell5, spell6, spell7, spell8, PetSpellDataId, VehicleId, mingold, maxgold, AIName, MovementType, InhabitType, HoverHeight, HealthModifier, ManaModifier, ArmorModifier, DamageModifier, ExperienceModifier, RacialLeader, questItem1, questItem2, questItem3, questItem4, questItem5, questItem6, movementId, RegenHealth, mechanic_immune_mask, flags_extra, ScriptName FROM creature_template WHERE entry = ?"
Unknown column 'BaseVariance' in 'field list'
In mysql_stmt_prepare() id: 29, sql: "SELECT point, position_x, position_y, position_z, orientation, move_type, delay, action, action_chance FROM waypoint_data WHERE id = ? ORDER BY point"
Unknown column 'move_type' in 'field list'
In mysql_stmt_prepare() id: 34, sql: "SELECT id, point, delay, move_type, action, action_chance FROM waypoint_data WHERE wpguid = ?"
Unknown column 'move_type' in 'field list'
In mysql_stmt_prepare() id: 54, sql: "SELECT entry, difficulty_entry_1, difficulty_entry_2, difficulty_entry_3, KillCredit1, KillCredit2, modelid1, modelid2, modelid3, modelid4, name, subname, IconName, gossip_menu_id, minlevel, maxlevel, exp, faction, npcflag, speed_walk, speed_run, scale, rank, dmgschool, BaseAttackTime, RangeAttackTime, BaseVariance, RangeVariance, unit_class, unit_flags, unit_flags2, dynamicflags, family, trainer_type, trainer_spell, trainer_class, trainer_race, type, type_flags, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, spell5, spell6, spell7, spell8, PetSpellDataId, VehicleId, mingold, maxgold, AIName, MovementType, InhabitType, HoverHeight, HealthModifier, ManaModifier, ArmorModifier, DamageModifier, ExperienceModifier, RacialLeader, questItem1, questItem2, questItem3, questItem4, questItem5, questItem6, movementId, RegenHealth, mechanic_immune_mask, flags_extra, ScriptName FROM creature_template WHERE entry = ?"
Unknown column 'BaseVariance' in 'field list'

 

[Compile or cmake problems]

hello guys i am trying to run cmake but i recieve this error hopefully somone can help me 

 

i compiled with the latest rev version from trinitycore 

Determining if files pthread.h exist failed with the following output:
Change Dir: C:/TrinityCore/Build/CMakeFiles/CMakeTmp

Run Build Command:"C:/Program Files (x86)/MSBuild/12.0/bin/MSBuild.exe" "cmTryCompileExec2558042386.vcxproj" "/p:Configuration=Debug" "/p:VisualStudioVersion=12.0"
Microsoft (R) Build Engine version 12.0.21005.1

[Microsoft .NET Framework, version 4.0.30319.18444]

Copyright (C) Microsoft Corporation. All rights reserved.



Build started 9/9/2014 12:38:42 PM.

Project "C:TrinityCoreBuildCMakeFilesCMakeTmpcmTryCompileExec2558042386.vcxproj" on node 1 (default targets).

PrepareForBuild:

  Creating directory "cmTryCompileExec2558042386.dirDebug".

  Creating directory "C:TrinityCoreBuildCMakeFilesCMakeTmpDebug".

  Creating directory "cmTryCompileExec2558042386.dirDebugcmTryCom.82BE167A.tlog".

InitializeBuildStatus:

  Creating "cmTryCompileExec2558042386.dirDebugcmTryCom.82BE167A.tlogunsuccessfulbuild" because "AlwaysCreate" was specified.

ClCompile:

  C:Program Files (x86)Microsoft Visual Studio 12.0VCbinCL.exe /c /Zi /W3 /WX- /Od /Ob0 /Oy- /D WIN32 /D _WINDOWS /D _DEBUG /D "CMAKE_INTDIR="Debug"" /D _MBCS /Gm- /RTC1 /MDd /GS /fp:precise /Zc:wchar_t /Zc:forScope /Fo"cmTryCompileExec2558042386.dirDebug" /Fd"cmTryCompileExec2558042386.dirDebugvc120.pdb" /Gd /TC /wd4996 /wd4355 /wd4244 /wd4985 /wd4267 /wd4619 /wd4512 /analyze- /errorReport:queue CheckIncludeFiles.c

  Microsoft (R) C/C++ Optimizing Compiler Version 18.00.21005.1 for x86

  Copyright (C) Microsoft Corporation.  All rights reserved.

  

  cl /c /Zi /W3 /WX- /Od /Ob0 /Oy- /D WIN32 /D _WINDOWS /D _DEBUG /D "CMAKE_INTDIR="Debug"" /D _MBCS /Gm- /RTC1 /MDd /GS /fp:precise /Zc:wchar_t /Zc:forScope /Fo"cmTryCompileExec2558042386.dirDebug" /Fd"cmTryCompileExec2558042386.dirDebugvc120.pdb" /Gd /TC /wd4996 /wd4355 /wd4244 /wd4985 /wd4267 /wd4619 /wd4512 /analyze- /errorReport:queue CheckIncludeFiles.c

  

  CheckIncludeFiles.c

CheckIncludeFiles.c(2): fatal error C1083: Cannot open include file: 'pthread.h': No such file or directory [C:TrinityCoreBuildCMakeFilesCMakeTmpcmTryCompileExec2558042386.vcxproj]

Done Building Project "C:TrinityCoreBuildCMakeFilesCMakeTmpcmTryCompileExec2558042386.vcxproj" (default targets) -- FAILED.



Build FAILED.



"C:TrinityCoreBuildCMakeFilesCMakeTmpcmTryCompileExec2558042386.vcxproj" (default target) (1) ->

(ClCompile target) -> 

  CheckIncludeFiles.c(2): fatal error C1083: Cannot open include file: 'pthread.h': No such file or directory [C:TrinityCoreBuildCMakeFilesCMakeTmpcmTryCompileExec2558042386.vcxproj]



    0 Warning(s)

    1 Error(s)



Time Elapsed 00:00:00.88


Source:
/* */
#include <pthread.h>


int main(){return 0;}