What's new

Error in WorldServer

Astraroth

Veteran Member
41
2014
0
Location
Spain
Hello friends of Emucoachw, I am having a problem opening theWorldserver.exe

I open and then arriving at this part closes.

I am using the DB which brings by Default the compiled Server.

TrinityCore rev. unknown 1970-01-01 00:00:00 +0000 (Archived branch) (Win32, Release) (worldserver-daemon)
<Ctrl-C> to stop.


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


Using configuration file worldserver.conf.
Using SSL version: OpenSSL 1.0.0c 2 Dec 2010 (library: OpenSSL 1.0.0c 2 Dec 2010)
Using Boost version: 1.57.0
DatabasePool characters NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors. Read wiki at http://collab.kpsn.org/display/tc/TrinityCore+Home
Cannot connect to Character database 127.0.0.1;3306;root;ascent;characters


DB Errors :

In mysql_stmt_prepare() id: 237, sql: "DELETE FROM corpse_phases WHERE Guid = ?"Table 'characters.corpse_phases' doesn't exist
In mysql_stmt_prepare() id: 238, sql: "DELETE FROM corpse_phases WHERE OwnerGuid = ? AND CorpseType <> 0"
Table 'characters.corpse_phases' doesn't exist
In mysql_stmt_prepare() id: 239, sql: "DELETE FROM corpse_phases WHERE CorpseType = 0 OR Time < (UNIX_TIMESTAMP(NOW()) - ?)"
Table 'characters.corpse_phases' doesn't exist
In mysql_stmt_prepare() id: 240, sql: "INSERT INTO corpse_phases (Guid, PhaseId, OwnerGuid, Time, CorpseType) VALUES (?, ?, ?, ?, ?)"
Table 'characters.corpse_phases' doesn't exist
In mysql_stmt_prepare() id: 16, sql: "UPDATE creature_template SET faction = ? WHERE entry = ?"
Unknown column 'faction' in 'field list'
In mysql_stmt_prepare() id: 61, sql: "INSERT INTO creature (guid, id , map, spawnMask, phaseMask, PhaseId, PhaseGroup, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, curhealth, curmana, MovementType, npcflag, unit_flags, dynamicflags) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
Unknown column 'PhaseId' in 'field list'
In mysql_stmt_prepare() id: 68, sql: "UPDATE creature SET zoneId = ?, areaId = ? WHERE guid = ?"
Unknown column 'zoneId' in 'field list'
In mysql_stmt_prepare() id: 69, sql: "UPDATE gameobject SET zoneId = ?, areaId = ? WHERE guid = ?"
Unknown column 'zoneId' in 'field list'
In mysql_stmt_prepare() id: 16, sql: "UPDATE creature_template SET faction = ? WHERE entry = ?"
Unknown column 'faction' in 'field list'
In mysql_stmt_prepare() id: 61, sql: "INSERT INTO creature (guid, id , map, spawnMask, phaseMask, PhaseId, PhaseGroup, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, curhealth, curmana, MovementType, npcflag, unit_flags, dynamicflags) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
Unknown column 'PhaseId' in 'field list'
In mysql_stmt_prepare() id: 68, sql: "UPDATE creature SET zoneId = ?, areaId = ? WHERE guid = ?"
Unknown column 'zoneId' in 'field list'
In mysql_stmt_prepare() id: 69, sql: "UPDATE gameobject SET zoneId = ?, areaId = ? WHERE guid = ?"

Unknown column 'zoneId' in 'field list'


The truth is that not is that me is throwing the error.

You Use Trinity Core Branch 4.3.4 :
https://github.com/TrinityCore/TrinityCore/tree/4.3.4
 
Last edited:

ExO

Admin
5,119
2014
1,639
You are missing some SQL updates, or using an older version of a core/db - not the same version and therefor you get an error.

Make sure to run ALL of the SQL updates related to it, so that the core and database match each other.
 
Top