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

Help and Support Help and Support
761

Hello guys,

I followed the instruction provided but my worldserver does not want to start up.

I tried to make a screenshot, but the window closes so fast that its hard to get a good one.

http://www.imagebanana.com/view/hlkl7i92/worldserver_error.png

Can someone have a look and give me a hint where the problem might be?

I would be glad if someone could help me.

chakuze

I copied the protocoll, that might be easier:

Using configuration file worldserver.conf.
Using SSL version: OpenSSL 1.0.1e 11 Feb 2013 (library: OpenSSL 1.0.1e 11 Feb 2013)
Using ACE version: 6.1.4
TrinityCore rev. d1853f693b2c 2013-03-01 16:25:58 +0200 (master branch) (Win32, Release) (worldserver-daemon)
to stop.

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

In mysql_stmt_prepare() id: 56, sql: “SELECT 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_A, faction_H, npcflag, speed_walk, speed_run, scale, rank, mindmg, maxdmg, dmgschool, attackpower, dmg_multiplier, baseattacktime, rangeattacktime, unit_class, unit_flags, unit_flags2, dynamicflags, family, trainer_type, trainer_spell, trainer_class, trainer_race, minrangedmg, maxrangedmg, rangedattackpower, 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, Health_mod, Mana_mod, Armor_mod, RacialLeader, questItem1, questItem2, questItem3, questItem4, questItem5, questItem6, movementId, RegenHealth, mechanic_immune_mask, flags_extra, ScriptName FROM creature_template WHERE entry = ?”
Unknown column ‘unit_flags2’ in ‘field list’
In mysql_stmt_prepare() id: 58, sql: “SELECT c.country FROM ip2nationCountries c, ip2nation i WHERE i.ip < ? AND c.code = i.country ORDER BY i.ip DESC LIMIT 0,1”
Table ‘world.ip2nationcountries’ doesn’t exist
DatabasePool world NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors.
Cannot connect to world database 127.0.0.1;3306;root;;world

762

Drop world db and import TDB51+updates.

763

Ok thanks, I downloaded the wrong version yesterday -.- It is working now, but I still didnt update with the .sql files from “sql/updates”.

I read all the manuals: How can I update my folder “trinity/sql/updates/” to the newest version? can someone post me a tutorial or just explain me?

thanks in advance…

EDIT: Ok I read it a bit more carefully: Its done, server is running with the newest updates. this can be closed here, thanks for your help!

764

When launch Worldserver.exe I am present with this error:

[1054] Unknown column ‘racemask’ in ‘field list’
Your database structure is not up to date. Please make sure you’ve executed all queries in the sql/updates folders.

Yes I have fresh TDB and run all updates up to 04

765

4.3.4 is unsupported, especially for people who can’t read a simple error message and figure out what the problem is, and, really unsupported for anyone who reports “issues” in the forum, instead of the issue tracker.

766

I know what the issue is, it is out of date structure and Race mask needs to be updated to something, I am just too lazy to find out where the DB structure is located in C++ core.

767

o_O

768

and people wonder why Paradox is so blunt lol

769

So, once again, it seems people cannot get it through their skulls that when you update the core, you have to update the DB, when you update the DB, you have to update the core. and, if you have your own fork that you are doing changes on, and don’t feel like pulling in new commits, don’t apply new DBs, and DO NOT ASK FOR HELP HERE.

770

I forked a completely new git, sir.

771

I am having issues with start up of the world server. I am getting sql errors when loading the character database, I have applied all updates from the git source.

I need to know where to get the sql statements to fix this. I am using the core build from git as of 3/12/13 all sql statements from build and the git db have been applied. this is a working build with users and characters. Please, help with the update sql (statements) in need to run or a working DB that I can import player info into

Thank you

Using configuration file /trinity/server//etc/worldserver.conf.
Using SSL version: OpenSSL 1.0.1 14 Mar 2012 (library: OpenSSL 1.0.1 14 Mar 2012)
Using ACE version: 6.0.3
TrinityCore rev. 9ae9277817ac 2013-03-11 14:46:38 +0000 (master branch) (Unix, Release) (worldserver-daemon)
to stop.

/__ \ __ _/\ _
//\ / _ __ /_\ ___ /_\ , \ __ __
\ \ /`‘__/\ \ /’ _ \/\ \ \ \/ /\ \/\ \ \ \ \ \ \/ \ \ \/\ \/\ \ \ \ \ \_\ \ \_\ \ \ \_\ \_\ \ \_\ \_\ \_\ \_\ \__\\/___
//// ////////// `//>
C O R E /_/
http://TrinityCore.org /_/

In mysql_stmt_prepare() id: 36, sql: "SELECT guid, account, name, race, class, gender, level, xp, money, playerBytes, playerBytes2, playerFlags, po$
Unknown column ‘arenaPoints’ in ‘field list’
In mysql_stmt_prepare() id: 73, sql: “SELECT quest FROM character_queststatus_rewarded WHERE guid = ? AND active = 1”
Unknown column ‘active’ in ‘where clause’
In mysql_stmt_prepare() id: 212, sql: "INSERT INTO corpse (corpseGuid, guid, posX, posY, posZ, orientation, mapId, displayId, itemCache, bytes1, by$
Unknown column ‘guildId’ in ‘field list’
In mysql_stmt_prepare() id: 234, sql: "INSERT INTO characters (guid, account, name, race, class, gender, level, xp, money, playerBytes, playerBytes$
Unknown column ‘arenaPoints’ in ‘field list’
In mysql_stmt_prepare() id: 235, sql: "UPDATE characters SET name=?,race=?,class=?,gender=?,level=?,xp=?,money=?,playerBytes=?,playerBytes2=?,playe$
Unknown column ‘arenaPoints’ in ‘field list’
In mysql_stmt_prepare() id: 320, sql: “UPDATE characters SET arenaPoints = (arenaPoints + ?) WHERE guid = ?”
Unknown column ‘arenaPoints’ in ‘field list’
In mysql_stmt_prepare() id: 375, sql: “UPDATE characters SET totalHonorPoints = ? WHERE guid = ?”
Unknown column ‘totalHonorPoints’ in ‘field list’
In mysql_stmt_prepare() id: 376, sql: “UPDATE characters SET arenaPoints = ? WHERE guid = ?”
Unknown column ‘arenaPoints’ in ‘field list’
In mysql_stmt_prepare() id: 386, sql: “INSERT IGNORE INTO character_queststatus_rewarded (guid, quest, active) VALUES (?, ?, 1)”
Unknown column ‘active’ in ‘field list’
In mysql_stmt_prepare() id: 389, sql: “UPDATE character_queststatus_rewarded SET active = 1 WHERE guid = ?”
Unknown column ‘active’ in ‘field list’
In mysql_stmt_prepare() id: 390, sql: “UPDATE character_queststatus_rewarded SET active = 0 WHERE quest = ? AND guid = ?”
Unknown column ‘active’ in ‘field list’
In mysql_stmt_prepare() id: 396, sql: "INSERT INTO character_stats (guid, maxhealth, maxpower1, maxpower2, maxpower3, maxpower4, maxpower5, maxpowe$
Unknown column ‘maxpower6’ in ‘field list’
In mysql_stmt_prepare() id: 401, sql: “INSERT INTO character_glyphs VALUES(?, ?, ?, ?, ?, ?, ?, ?)”
Column count doesn’t match value count at row 1
In mysql_stmt_prepare() id: 211, sql: "SELECT posX, posY, posZ, orientation, mapId, displayId, itemCache, bytes1, bytes2, guildId, flags, dynFlags,$
Unknown column ‘guildId’ in ‘field list’
In mysql_stmt_prepare() id: 430, sql: "SELECT id, entry, owner, modelid, level, exp, Reactstate, slot, name, renamed, curhealth, curmana, curhappin$
Unknown column ‘curhappiness’ in ‘field list’
In mysql_stmt_prepare() id: 431, sql: "SELECT id, entry, owner, modelid, level, exp, Reactstate, slot, name, renamed, curhealth, curmana, curhappin$
Unknown column ‘curhappiness’ in ‘field list’
In mysql_stmt_prepare() id: 432, sql: "SELECT id, entry, owner, modelid, level, exp, Reactstate, slot, name, renamed, curhealth, curmana, curhappin$
Unknown column ‘curhappiness’ in ‘field list’
In mysql_stmt_prepare() id: 422, sql: "SELECT id, entry, owner, modelid, level, exp, Reactstate, slot, name, renamed, curhealth, curmana, curhappin$
Unknown column ‘curhappiness’ in ‘field list’
In mysql_stmt_prepare() id: 211, sql: "SELECT posX, posY, posZ, orientation, mapId, displayId, itemCache, bytes1, bytes2, guildId, flags, dynFlags,$
Unknown column ‘guildId’ in ‘field list’
In mysql_stmt_prepare() id: 430, sql: "SELECT id, entry, owner, modelid, level, exp, Reactstate, slot, name, renamed, curhealth, curmana, curhappin$
Unknown column ‘curhappiness’ in ‘field list’
In mysql_stmt_prepare() id: 431, sql: "SELECT id, entry, owner, modelid, level, exp, Reactstate, slot, name, renamed, curhealth, curmana, curhappin$
Unknown column ‘curhappiness’ in ‘field list’
In mysql_stmt_prepare() id: 432, sql: "SELECT id, entry, owner, modelid, level, exp, Reactstate, slot, name, renamed, curhealth, curmana, curhappin$
Unknown column ‘curhappiness’ in ‘field list’
In mysql_stmt_prepare() id: 422, sql: "SELECT id, entry, owner, modelid, level, exp, Reactstate, slot, name, renamed, curhealth, curmana, curhappin$
Unknown column ‘curhappiness’ in ‘field list’
In mysql_stmt_prepare() id: 211, sql: "SELECT posX, posY, posZ, orientation, mapId, displayId, itemCache, bytes1, bytes2, guildId, flags, dynFlags,$
Unknown column ‘guildId’ in ‘field list’
In mysql_stmt_prepare() id: 430, sql: "SELECT id, entry, owner, modelid, level, exp, Reactstate, slot, name, renamed, curhealth, curmana, curhappin$
Unknown column ‘curhappiness’ in ‘field list’
In mysql_stmt_prepare() id: 431, sql: "SELECT id, entry, owner, modelid, level, exp, Reactstate, slot, name, renamed, curhealth, curmana, curhappin$
Unknown column ‘curhappiness’ in ‘field list’
In mysql_stmt_prepare() id: 432, sql: "SELECT id, entry, owner, modelid, level, exp, Reactstate, slot, name, renamed, curhealth, curmana, curhappin$
Unknown column ‘curhappiness’ in ‘field list’
In mysql_stmt_prepare() id: 422, sql: "SELECT id, entry, owner, modelid, level, exp, Reactstate, slot, name, renamed, curhealth, curmana, curhappin$
Unknown column ‘curhappiness’ in ‘field list’
DatabasePool characters-trinity NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors.
Cannot connect to Character database 127.0.0.1;3306;root;1924;characters-trinity

772

You prepared all the git statements. Did you add the TDB, though ? Somehow, it doesn’t seem so.

773

It looks like you imported either an outdated characters table, or you trying to add some kind of table that I don’t think TC uses. Some of those columns don’t even exist in TDB

774

If you updated from a very old TC, (before TDB 51 was released) you will need to apply all of the proper updates, even those in sql/updates/old/3.3.5a/ that were added after the last revision you used… character updates SHOULD NOT be moved when a new full TDB is released, as the world DB has nothing to do with the characters or auth DBs, but, they still move them when they release a new full TDB… I don’t know what the best course of action is, since the user could be updating from any revision along the line, so, you can’t put them all together in one big update, but, something needs to be figured out that will make that part easier.

775

Perhaps… https://github.com/TrinityCore/TrinityCore/commit/41c3c4273115c079c34dfd03e1ae06e5f9fe6838

776

That’s probably not something you want to admit when you’re asking for help…

Anyway, the problem isn’t with the core. You missed an SQL file somewhere along the way so the core is looking for a field that you don’t have in your DB.

777

server.log

In mysql_stmt_prepare() id: 56, sql: “SELECT 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_A, faction_H, npcflag, speed_walk, speed_run, scale, rank, mindmg, maxdmg, dmgschool, attackpower, dmg_multiplier, baseattacktime, rangeattacktime, unit_class, unit_flags, unit_flags2, dynamicflags, family, trainer_type, trainer_spell, trainer_class, trainer_race, minrangedmg, maxrangedmg, rangedattackpower, 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, Health_mod, Mana_mod, Armor_mod, RacialLeader, questItem1, questItem2, questItem3, questItem4, questItem5, questItem6, movementId, RegenHealth, mechanic_immune_mask, flags_extra, ScriptName FROM creature_template WHERE entry = ?”
Unknown column ‘trainer_spell’ in ‘field list’
DatabasePool world 4.3.4 NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors.

used : TDB_full_434.04_2013_02_14.7z + updates => https://github.com/TrinityCore/TrinityCore_4.3.4_DB_Alpha updates 04

sorry im speak in french

778

I have compiled the latest trinitycore from here https://github.com/TrinityCore/TrinityCore , and I have imported these world mysql database : http://trinitycore.org/f/files/download/5-tdb-full-updates/ when I will start the server I get the error …

“Unkown column ‘trainer_spell’ in ‘field list’”

But when I import “TDB_full_335.51_2013_02_14.sql” I get this error :

3). Extracted file might be from wrong client version or a database-update has been forgotten.
/home/trinity/server/datadir/dbc/OverrideSpellData.dbc exists, and has 13 field(s) (expected 12). Extracted file might be from wrong client version or a database-update has been forgotten.
/home/trinity/server/datadir/dbc/QuestSort.dbc exists, and has 2 field(s) (expected 18). Extracted file might be from wrong client version or a database-update has been forgotten.
/home/trinity/server/datadir/dbc/ScalingStatDistribution.dbc exists, and has 23 field(s) (expected 22). Extracted file might be from wrong client version or a database-update has been forgotten.
/home/trinity/server/datadir/dbc/ScalingStatValues.dbc exists, and has 47 field(s) (expected 24). Extracted file might be from wrong client version or a database-update has been forgotten.
/home/trinity/server/datadir/dbc/SkillLine.dbc exists, and has 7 field(s) (expected 56). Extracted file might be from wrong client version or a database-update has been forgotten.

… etc

779

Once again… you didn’t follow the wiki and run ALL the updates to our DB.

780 
DatabasePool world 4.3.4 NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors.

What do you need?

The error is in plain sight.

Did you even configure your DB?