Jump to content
Why are these forums read only? ×
TrinityCore
Why are these forums read only?

6opoDUJIo

Plebs
 View Profile  See their activity

  • Posts

    4

  • Joined

  • Last visited

 Content Type 

Posts posted by 6opoDUJIo

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

    in Help and Support

    Posted

    I have tried to launch triniry server , but taking these errors in log:

    


C:\Trinity\build\bin\Debug>worldserver.exe

Using configuration file worldserver.conf.

TrinityCore rev. 0000-00-00 00:00:00 +0000 (Archived) (Win32, Debug) (worldserve

r-daemon)

<Ctrl-C> to stop.


 ______                       __

/\__  _\       __          __/\ \__

\/_/\ \/ _ __ /\_\    ___ /\_\ \, _\  __  __

   \ \ \/\`'__\/\ \ /' _ `\/\ \ \ \/ /\ \/\ \

    \ \ \ \ \/ \ \ \/\ \/\ \ \ \ \ \_\ \ \_\ \

     \ \_\ \_\  \ \_\ \_\ \_\ \_\ \__\\/`____ \

      \/_/\/_/   \/_/\/_/\/_/\/_/\/__/ `/___/> \

                                 C O R E  /\___/

http://TrinityCore.org                    \/__/




SFMT has been enabled as the random number generator, if worldserver

freezes or crashes randomly, first, try disabling SFMT in CMAKE configuration



Opening databasepool 'world'. Async threads: 1, synch threads: 1

MySQL client library: 5.5.9

MySQL server ver: 5.5.22

[WARNING] MySQL client/server version mismatch; may conflict with behaviour of p

repared statements.

MySQL client library: 5.5.9

MySQL server ver: 5.5.22

[WARNING] MySQL client/server version mismatch; may conflict with behaviour of p

repared statements.

[ERROR]: In mysql_stmt_prepare() id: 29, sql: "SELECT point, position_x, positio

n_y, position_z, orientation, move_flag, delay, action, action_chance FROM waypo

int_data WHERE id = ? ORDER BY point"

[ERROR]: Unknown column 'orientation' in 'field list'

[ERROR]: In mysql_stmt_prepare() id: 32, sql: "SELECT position_x, position_y, po

sition_z, orientation FROM waypoint_data WHERE id = ? ORDER BY point DESC LIMIT

1"

[ERROR]: Unknown column 'orientation' in 'field list'

[ERROR]: In mysql_stmt_prepare() id: 56, sql: "SELECT difficulty_entry_1, diffic

ulty_entry_2, difficulty_entry_3, KillCredit1, KillCredit2, modelid1, modelid2,

modelid3, modelid4, name, subname, IconName, gossip_menu_id, minlevel, maxlevel,

 exp, faction_A, faction_H, npcflag, speed_walk, speed_run, scale, rank, mindmg,

 maxdmg, dmgschool, attackpower, dmg_multiplier, baseattacktime, rangeattacktime

, unit_class, unit_flags, dynamicflags, family, trainer_type, trainer_spell, tra

iner_class, trainer_race, minrangedmg, maxrangedmg, rangedattackpower, type, typ

e_flags, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3

, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, spell5,

 spell6, spell7, spell8, PetSpellDataId, VehicleId, mingold, maxgold, AIName, Mo

vementType, InhabitType, HoverHeight, Health_mod, Mana_mod, Armor_mod, RacialLea

der, questItem1, questItem2, questItem3, questItem4, questItem5, questItem6, mov

ementId, RegenHealth, equipment_id, mechanic_immune_mask, flags_extra, ScriptNam

e FROM creature_template WHERE entry = ?"

[ERROR]: Unknown column 'HoverHeight' in 'field list'

[ERROR]: In mysql_stmt_prepare() id: 58, sql: "SELECT c.country FROM ip2nationCo

untries c, ip2nation i WHERE i.ip < ? AND c.code = i.country ORDER BY i.ip DESC

LIMIT 0,1"

[ERROR]: Table 'world.ip2nationcountries' doesn't exist

Databasepool opened successfully. 2 total connections running.

Cannot connect to world database 127.0.0.1;3306;root;7640;world

    i have downloaded latest database(https://github.com/TrinityCore/TrinityCore/downloads) , but still getting these errors

    where i can get sql scripts for lost collumns?

×
×
  • Create New...