Trinity Worldserver crash

07/20/2011 18:33 TheBashor99#1
Hallo,

Beim Trinity Worldserver Start bekomme ich immer eine lange Fehlermeldung.



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'.
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 ?

Danke für eure Antworten
07/20/2011 18:49 Olanden#2
Er sagt dir das er nicht auf die Datenbank connecten kann. Hast du in den Configs auch die richtigen Daten eingetragen?

lg Olanden
07/20/2011 19:02 TheBashor99#3
also soweit ist da alles richtig es sei denn ich bin bilnd XD

kann es an der MySQL version liegen ? ich hab 5.1.41
07/20/2011 19:31 Olanden#4
Ich denke mal das es nicht an der MySQL Version liegt. Er sagt halt das er nicht auf die Char Datenbank zugreifen kann. Hast du sie vllt. unter MySQL Char genannt und in der Config Characters getauft?
07/20/2011 19:36 °"Crazy"°#5
Hast du alle 3 Datenbanken richtig eingebatcht und in der Config richtig zugewiesen? MySQL - Serversion ist eher unrelevant. :)
07/20/2011 19:53 TheBashor99#6
also die configs sind soweit alle richtig nur ist in characters keine infos bzw sachen drinne egal was ich dort einbatche es tut sich nix oder ich bin zu blöd die sachen dafür zu finden XD
07/20/2011 20:03 °"Crazy"°#7
Mit was batchst du es ein und welche SQL nimmst du dafür?
07/20/2011 20:20 Kent_Brockman#8
Wenn du die CleanSQL nimmst, dann solltest du bei NAviCat auch fehler ignorieren einschalten.
Ab denn sollte sich auch was Batchen lassen.

Kannst natürlich auch die SQL Datei bearbeiten und den Teil löschen, der gelöscht werden soll (steht in der Datei).
07/20/2011 20:25 TheBashor99#9
ich batche sql dateien mit navicat ein und habe auch fehler ignorieren an!!!!! ich batche die characters.sql ein. Doch wenn Navicat damit fertig ist sehe ich zwar die Tabellen aber wenn ich mir eine anschaue ist diese leer
07/20/2011 20:32 Kent_Brockman#10
Also in der DB Characters sind Tables da, aber leer?
Das ist gut so, denn gefüllt werden die erst wenn du auch einen Char erstellst.

Cannot connect to Character database 127.0.0.1;3306;root;******;characters
Ist aber dennoch ein Indiz dafür das du irgendwas bei den Daten für die Verbindung falsch gemacht oder eingegeben hast.
Bitte schau mal nach ob es geht, wenn du 127.0.0.1 durch localhost ersetzt.
Auch solltest du Groß- und Kleinschreibung beachten.

Eigentlich die ganz normale Checklist.
07/20/2011 21:10 TheBashor99#11
so habs mal durch localhost ersetz zumindest sollte es dan so ausehen oder irre ich mich da?

07/20/2011 21:32 Kent_Brockman#12
Jops so sollte es aussehen.
Und was sagt er bein Startup?
07/20/2011 21:43 TheBashor99#13
Was meinst du mit Startup ?


Wenn ich ./worldserver mache kommt trotzdem der gleiche Fehler wie am Anfang ...
07/21/2011 20:17 Olanden#14
Kent wollte wissen wie der Inhalt des Logs aussieht wenn du den Worldserver startest :).
07/25/2011 23:20 TheBashor99#15
Danke hat sich erledigt :)

Server läuft... wenn auch mit ein paar Schwierigkeiten.

Wollte zuerst Trinity > da ging die db nicht
Mangos hatte servercrash am 2. Tag
und nun habe ich Arcemu auch wenn das nicht besonders toll ist da alles auf Englisch ist und ich keine Deutsche DB finden kann

Danke nochmal an euch !