Hallo,
Beim Trinity Worldserver Start bekomme ich immer eine lange Fehlermeldung.
Danke für eure Antworten
Beim Trinity Worldserver Start bekomme ich immer eine lange Fehlermeldung.
Was hat das zu bedeuten ? und gibt es eine DB die keine bugs oder zumindest nur wenige hat und sich ohne probleme Starten lässt ?Quote:
______ __
/\__ _\ __ __/\ \__
\/_/\ \/ _ __ /\_\ ___ /\_\ \ ,_\ __ __
\ \ \/\`'__\/\ \ /' _ `\/\ \ \ \/ /\ \/\ \
\ \ \ \ \/ \ \ \/\ \/\ \ \ \ \ \_\ \ \_\ \
\ \_\ \_\ \ \_\ \_\ \_\ \_\ \__\\/`____ \
\/_/\/_/ \/_/\/_/\/_/\/_/\/__/ `/___/> \
C O R E /\___/
[Only registered and activated users can see links. Click Here To Register...] \/__/
Opening databasepool 'world'. Async threads: 1, synch threads: 1
MySQL client library: 5.1.41
MySQL server ver: 5.1.41-3ubuntu12.10
MySQL client library: 5.1.41
MySQL server ver: 5.1.41-3ubuntu12.10
Databasepool opened succesfuly. 2 total connections running.
Opening databasepool 'characters'. Async threads: 1, synch threads: 2
MySQL client library: 5.1.41
MySQL server ver: 5.1.41-3ubuntu12.10
[ERROR]: In mysql_stmt_prepare() id: 29, sql: "SELECT mapId, zoneId, posX, posY, posZ FROM character_homebind WHERE guid = ?"
[ERROR]: Unknown column 'mapId' in 'field list'
[ERROR]: In mysql_stmt_prepare() id: 33, sql: "SELECT arenaTeamId, weekGames, seasonGames, seasonWins, personalRating FROM
arena_team_member WHERE guid = ?"
[ERROR]: Unknown column 'weekGames' in 'field list'
[ERROR]: In mysql_stmt_prepare() id: 37, sql: "SELECT instanceId, team, joinX, joinY, joinZ, joinO, joinMapId, taxiStart,
taxiEnd, mountSpell FROM character_battleground_data WHERE guid = ?"
[ERROR]: Unknown column 'instanceId' in 'field list'
[ERROR]: In mysql_stmt_prepare() id: 44, sql: "SELECT instanceId, releaseTime FROM account_instance_times WHERE accountId = ?"
[ERROR]: Table 'characters.account_instance_times' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 73, sql: "DELETE FROM account_instance_times WHERE accountId = ?"
[ERROR]: Table 'characters.account_instance_times' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 74, sql: "INSERT INTO account_instance_times (accountId, instanceId, releaseTime) VALUES
(?, ?, ?)"
[ERROR]: Table 'characters.account_instance_times' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 140, sql: "INSERT INTO channels(name, team, lastUsed) VALUES (?, ?, UNIX_TIMESTAMP())"
[ERROR]: Unknown column 'name' in 'field list'
[ERROR]: In mysql_stmt_prepare() id: 141, sql: "UPDATE channels SET announce = ?, ownership = ?, password = ?, bannedList = ?,
lastUsed = UNIX_TIMESTAMP() WHERE name = ? AND team = ?"
[ERROR]: Unknown column 'name' in 'where clause'
[ERROR]: In mysql_stmt_prepare() id: 142, sql: "UPDATE channels SET lastUsed = UNIX_TIMESTAMP() WHERE name = ? AND team = ?"
[ERROR]: Unknown column 'name' in 'where clause'
[ERROR]: In mysql_stmt_prepare() id: 143, sql: "UPDATE channels SET ownership = ? WHERE name LIKE ?"
[ERROR]: Unknown column 'name' in 'where clause'
[ERROR]: In mysql_stmt_prepare() id: 144, sql: "DELETE FROM channels WHERE ownership = 1 AND lastUsed + ? < UNIX_TIMESTAMP()"
[ERROR]: Unknown column 'ownership' in 'where clause'
[ERROR]: In mysql_stmt_prepare() id: 151, sql: "REPLACE INTO account_data(accountId, type, time, data) VALUES (?, ?, ?, ?)"
[ERROR]: Unknown column 'accountId' in 'field list'
[ERROR]: In mysql_stmt_prepare() id: 152, sql: "DELETE FROM account_data WHERE accountId = ?"
[ERROR]: Unknown column 'accountId' in 'where clause'
[ERROR]: In mysql_stmt_prepare() id: 158, sql: "INSERT INTO account_tutorial(tut0, tut1, tut2, tut3, tut4, tut5, tut6, tut7,
accountId) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)"
[ERROR]: Table 'characters.account_tutorial' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 159, sql: "UPDATE account_tutorial SET tut0 = ?, tut1 = ?, tut2 = ?, tut3 = ?, tut4 = ?,
tut5 = ?, tut6 = ?, tut7 = ? WHERE accountId = ?"
[ERROR]: Table 'characters.account_tutorial' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 160, sql: "DELETE FROM account_tutorial WHERE accountId = ?"
[ERROR]: Table 'characters.account_tutorial' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 161, sql: "INSERT INTO instance (id, map, resettime, difficulty, completedEncounters,
data) VALUES (?, ?, ?, ?, ?, ?)"
[ERROR]: Unknown column 'completedEncounters' in 'field list'
[ERROR]: In mysql_stmt_prepare() id: 162, sql: "UPDATE instance SET completedEncounters=?, data=? WHERE id=?"
[ERROR]: Unknown column 'completedEncounters' in 'field list'
[ERROR]: In mysql_stmt_prepare() id: 163, sql: "DELETE FROM game_event_save WHERE eventEntry = ?"
[ERROR]: Unknown column 'eventEntry' in 'where clause'
[ERROR]: In mysql_stmt_prepare() id: 164, sql: "INSERT INTO game_event_save (eventEntry, state, next_start) VALUES (?, ? , ?)"
[ERROR]: Unknown column 'eventEntry' in 'field list'
[ERROR]: In mysql_stmt_prepare() id: 165, sql: "DELETE FROM game_event_condition_save WHERE eventEntry = ?"
[ERROR]: Unknown column 'eventEntry' in 'where clause'
[ERROR]: In mysql_stmt_prepare() id: 166, sql: "DELETE FROM game_event_condition_save WHERE eventEntry = ? AND condition_id =
?"
[ERROR]: Unknown column 'eventEntry' in 'where clause'
[ERROR]: In mysql_stmt_prepare() id: 167, sql: "INSERT INTO game_event_condition_save (eventEntry, condition_id, done) VALUES
(?, ?, ?)"
[ERROR]: Unknown column 'eventEntry' in 'field list'
[ERROR]: In mysql_stmt_prepare() id: 168, sql: "INSERT INTO arena_team (arenaTeamId, name, captainGuid, type, rating,
backgroundColor, emblemStyle, emblemColor, borderStyle, borderColor) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
[ERROR]: Unknown column 'rating' in 'field list'
[ERROR]: In mysql_stmt_prepare() id: 174, sql: "UPDATE arena_team SET rating = ?, weekGames = ?, weekWins = ?, seasonGames =
?, seasonWins = ?, rank = ? WHERE arenaTeamId = ?"
[ERROR]: Unknown column 'rating' in 'field list'
[ERROR]: In mysql_stmt_prepare() id: 175, sql: "UPDATE arena_team_member SET personalRating = ?, weekGames = ?, weekWins = ?,
seasonGames = ?, seasonWins = ? WHERE arenaTeamId = ? AND guid = ?"
[ERROR]: Unknown column 'personalRating' in 'field list'
[ERROR]: In mysql_stmt_prepare() id: 176, sql: "REPLACE INTO character_arena_stats (guid, slot, matchMakerRating) VALUES (?,
?, ?)"
[ERROR]: Unknown column 'matchMakerRating' in 'field list'
[ERROR]: In mysql_stmt_prepare() id: 180, sql: "INSERT INTO character_battleground_data (guid, instanceId, team, joinX, joinY,
joinZ, joinO, joinMapId, taxiStart, taxiEnd, mountSpell) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
[ERROR]: Unknown column 'instanceId' in 'field list'
[ERROR]: In mysql_stmt_prepare() id: 183, sql: "INSERT INTO character_homebind (guid, mapId, zoneId, posX, posY, posZ) VALUES
(?, ?, ?, ?, ?, ?)"
[ERROR]: Unknown column 'mapId' in 'field list'
[ERROR]: In mysql_stmt_prepare() id: 184, sql: "UPDATE character_homebind SET mapId = ?, zoneId = ?, posX = ?, posY = ?, posZ
= ? WHERE guid = ?"
[ERROR]: Unknown column 'mapId' in 'field list'
[ERROR]: In mysql_stmt_prepare() id: 187, sql: "INSERT INTO corpse (corpseGuid, guid, posX, posY, posZ, orientation, mapId,
displayId, itemCache, bytes1, bytes2, guildId, flags, dynFlags, time, corpseType, instanceId, phaseMask) VALUES (?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
[ERROR]: Unknown column 'corpseGuid' in 'field list'
[ERROR]: In mysql_stmt_prepare() id: 188, sql: "DELETE FROM corpse WHERE corpseGuid = ?"
[ERROR]: Unknown column 'corpseGuid' in 'where clause'
[ERROR]: In mysql_stmt_prepare() id: 189, sql: "DELETE FROM corpse WHERE guid = ? AND corpseType <> 0"
[ERROR]: Unknown column 'corpseType' in 'where clause'
[ERROR]: In mysql_stmt_prepare() id: 190, sql: "DELETE FROM corpse WHERE corpseType = 0 OR time < (UNIX_TIMESTAMP(NOW()) - ?)"
[ERROR]: Unknown column 'corpseType' in 'where clause'
[ERROR]: In mysql_stmt_prepare() id: 193, sql: "REPLACE INTO creature_respawn (guid, respawnTime, instanceId) VALUES (?, ?,
?)"
[ERROR]: Unknown column 'instanceId' in 'field list'
[ERROR]: In mysql_stmt_prepare() id: 194, sql: "DELETE FROM creature_respawn WHERE guid = ? AND instanceId = ?"
[ERROR]: Unknown column 'instanceId' in 'where clause'
[ERROR]: In mysql_stmt_prepare() id: 196, sql: "DELETE FROM creature_respawn WHERE instanceId = ?"
[ERROR]: Unknown column 'instanceId' in 'where clause'
[ERROR]: In mysql_stmt_prepare() id: 200, sql: "REPLACE INTO gameobject_respawn (guid, respawnTime, instanceId) VALUES (?, ?,
?)"
[ERROR]: Unknown column 'instanceId' in 'field list'
[ERROR]: In mysql_stmt_prepare() id: 201, sql: "DELETE FROM gameobject_respawn WHERE guid = ? AND instanceId = ?"
[ERROR]: Unknown column 'instanceId' in 'where clause'
[ERROR]: In mysql_stmt_prepare() id: 202, sql: "DELETE FROM gameobject_respawn WHERE instanceId = ?"
[ERROR]: Unknown column 'instanceId' in 'where clause'
[ERROR]: In mysql_stmt_prepare() id: 206, sql: "REPLACE INTO gm_tickets (ticketId, guid, name, message, createTime, mapId,
posX, posY, posZ, lastModifiedTime, closedBy, assignedTo, comment, completed, escalated, viewed) VALUES (?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?)"
[ERROR]: Unknown column 'ticketId' in 'field list'
[ERROR]: In mysql_stmt_prepare() id: 207, sql: "DELETE FROM gm_tickets WHERE ticketId = ?"
[ERROR]: Unknown column 'ticketId' in 'where clause'
[ERROR]: In mysql_stmt_prepare() id: 209, sql: "INSERT INTO gm_surveys (guid, surveyId, mainSurvey, overallComment,
createTime) VALUES (?, ?, ?, ?, UNIX_TIMESTAMP(NOW()))"
[ERROR]: Unknown column 'guid' in 'field list'
[ERROR]: In mysql_stmt_prepare() id: 211, sql: "INSERT INTO lag_reports (guid, lagType, mapId, posX, posY, posZ) VALUES (?, ?,
?, ?, ?, ?)"
[ERROR]: Unknown column 'guid' in 'field list'
MySQL client library: 5.1.41
MySQL server ver: 5.1.41-3ubuntu12.10
[ERROR]: In mysql_stmt_prepare() id: 76, sql: "SELECT matchMakerRating FROM character_arena_stats WHERE guid = ? AND slot = ?"
[ERROR]: Unknown column 'matchMakerRating' in 'field list'
[ERROR]: In mysql_stmt_prepare() id: 139, sql: "SELECT announce, ownership, password, bannedList FROM channels WHERE name = ?
AND team = ?"
[ERROR]: Unknown column 'announce' in 'field list'
[ERROR]: In mysql_stmt_prepare() id: 150, sql: "SELECT type, time, data FROM account_data WHERE accountId = ?"
[ERROR]: Unknown column 'accountId' in 'where clause'
[ERROR]: In mysql_stmt_prepare() id: 156, sql: "SELECT tut0, tut1, tut2, tut3, tut4, tut5, tut6, tut7 FROM account_tutorial
WHERE accountId = ?"
[ERROR]: Table 'characters.account_tutorial' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 157, sql: "SELECT 1 FROM account_tutorial WHERE accountId = ?"
[ERROR]: Table 'characters.account_tutorial' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 182, sql: "UPDATE character_battleground_data SET instanceId = 0"
[ERROR]: Unknown column 'instanceId' in 'field list'
[ERROR]: In mysql_stmt_prepare() id: 186, sql: "SELECT posX, posY, posZ, orientation, mapId, displayId, itemCache, bytes1,
bytes2, guildId, flags, dynFlags, time, corpseType, instanceId, phaseMask, corpseGuid, guid FROM corpse WHERE corpseType <> 0"
[ERROR]: Unknown column 'posX' in 'field list'
[ERROR]: In mysql_stmt_prepare() id: 191, sql: "UPDATE corpse SET instanceId = 0 WHERE instanceId > 0 AND instanceId NOT IN
(SELECT id FROM instance)"
[ERROR]: Unknown column 'instanceId' in 'where clause'
[ERROR]: In mysql_stmt_prepare() id: 192, sql: "SELECT guid, respawnTime, instanceId FROM creature_respawn"
[ERROR]: Unknown column 'instanceId' in 'field list'
[ERROR]: In mysql_stmt_prepare() id: 197, sql: "SELECT MAX(respawnTime), instanceId FROM creature_respawn WHERE instanceId > 0
GROUP BY instanceId"
[ERROR]: Unknown column 'instanceId' in 'field list'
[ERROR]: In mysql_stmt_prepare() id: 198, sql: "DELETE FROM creature_respawn WHERE instanceId > 0 AND instanceId NOT IN
(SELECT instanceId FROM instance)"
[ERROR]: Unknown column 'instanceId' in 'where clause'
[ERROR]: In mysql_stmt_prepare() id: 199, sql: "SELECT guid, respawnTime, instanceId FROM gameobject_respawn"
[ERROR]: Unknown column 'instanceId' in 'field list'
[ERROR]: In mysql_stmt_prepare() id: 204, sql: "DELETE FROM gameobject_respawn WHERE instanceId > 0 AND instanceId NOT IN
(SELECT instanceId FROM instance)"
[ERROR]: Unknown column 'instanceId' in 'where clause'
[ERROR]: In mysql_stmt_prepare() id: 205, sql: "SELECT ticketId, guid, name, message, createTime, mapId, posX, posY, posZ,
lastModifiedTime, closedBy, assignedTo, comment, completed, escalated, viewed FROM gm_tickets"
[ERROR]: Unknown column 'ticketId' in 'field list'
MySQL client library: 5.1.41
MySQL server ver: 5.1.41-3ubuntu12.10
[ERROR]: In mysql_stmt_prepare() id: 76, sql: "SELECT matchMakerRating FROM character_arena_stats WHERE guid = ? AND slot = ?"
[ERROR]: Unknown column 'matchMakerRating' in 'field list'
[ERROR]: In mysql_stmt_prepare() id: 139, sql: "SELECT announce, ownership, password, bannedList FROM channels WHERE name = ?
AND team = ?"
[ERROR]: Unknown column 'announce' in 'field list'
[ERROR]: In mysql_stmt_prepare() id: 150, sql: "SELECT type, time, data FROM account_data WHERE accountId = ?"
[ERROR]: Unknown column 'accountId' in 'where clause'
[ERROR]: In mysql_stmt_prepare() id: 156, sql: "SELECT tut0, tut1, tut2, tut3, tut4, tut5, tut6, tut7 FROM account_tutorial
WHERE accountId = ?"
[ERROR]: Table 'characters.account_tutorial' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 157, sql: "SELECT 1 FROM account_tutorial WHERE accountId = ?"
[ERROR]: Table 'characters.account_tutorial' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 182, sql: "UPDATE character_battleground_data SET instanceId = 0"
[ERROR]: Unknown column 'instanceId' in 'field list'
[ERROR]: In mysql_stmt_prepare() id: 186, sql: "SELECT posX, posY, posZ, orientation, mapId, displayId, itemCache, bytes1,
bytes2, guildId, flags, dynFlags, time, corpseType, instanceId, phaseMask, corpseGuid, guid FROM corpse WHERE corpseType <> 0"
[ERROR]: Unknown column 'posX' in 'field list'
[ERROR]: In mysql_stmt_prepare() id: 191, sql: "UPDATE corpse SET instanceId = 0 WHERE instanceId > 0 AND instanceId NOT IN
(SELECT id FROM instance)"
[ERROR]: Unknown column 'instanceId' in 'where clause'
[ERROR]: In mysql_stmt_prepare() id: 192, sql: "SELECT guid, respawnTime, instanceId FROM creature_respawn"
[ERROR]: Unknown column 'instanceId' in 'field list'
[ERROR]: In mysql_stmt_prepare() id: 197, sql: "SELECT MAX(respawnTime), instanceId FROM creature_respawn WHERE instanceId > 0
GROUP BY instanceId"
[ERROR]: Unknown column 'instanceId' in 'field list'
[ERROR]: In mysql_stmt_prepare() id: 198, sql: "DELETE FROM creature_respawn WHERE instanceId > 0 AND instanceId NOT IN
(SELECT instanceId FROM instance)"
[ERROR]: Unknown column 'instanceId' in 'where clause'
[ERROR]: In mysql_stmt_prepare() id: 199, sql: "SELECT guid, respawnTime, instanceId FROM gameobject_respawn"
[ERROR]: Unknown column 'instanceId' in 'field list'
[ERROR]: In mysql_stmt_prepare() id: 204, sql: "DELETE FROM gameobject_respawn WHERE instanceId > 0 AND instanceId NOT IN
(SELECT instanceId FROM instance)"
[ERROR]: Unknown column 'instanceId' in 'where clause'
[ERROR]: In mysql_stmt_prepare() id: 205, sql: "SELECT ticketId, guid, name, message, createTime, mapId, posX, posY, posZ,
lastModifiedTime, closedBy, assignedTo, comment, completed, escalated, viewed FROM gm_tickets"
[ERROR]: Unknown column 'ticketId' in 'field list'
Databasepool opened succesfuly. 3 total connections running.
Cannot connect to Character database 127.0.0.1;3306;root;******;characters
~DatabaseWorkerPool for ''.
~DatabaseWorkerPool for 'characters'.
~DatabaseWorkerPool for 'world'.
Danke für eure Antworten