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

Athena

Members
 View Profile  See their activity

  • Posts

    2173

  • Joined

  • Last visited

  • Days Won

    40

 Content Type 

Posts posted by Athena

  4. Is it stable? ...

    in Help and Support

    Posted

    Well... don't know why, but all revisions i compiled (and i compile 1 per week) i can mark all with stable (online uptime 7 days, arround 100-120 online people, no lags or high diffs)

    The last problem i had, was on february, if i remember correclty.

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

    in Help and Support

    Posted

    TrinityCore Hash: Archive (Win32, Release (little-endian)) (worldserver-daemon)

    First, check your dependicies, git is not correctly installed

    [WARNING] MySQL client/server version mismatch; may conflict with behaviour of prepared statements.

    Again, check your dependencies.

    [ERROR]: In mysql_stmt_prepare() id: 26, 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: 30, 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: 34, 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: 137, sql: "INSERT INTO channels(name, team, lastUsed) VALUES (?, ?, UNIX_TIMESTAMP())"

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

    [ERROR]: In mysql_stmt_prepare() id: 138, 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: 139, sql: "UPDATE channels SET lastUsed = UNIX_TIMESTAMP() WHERE name = ? AND team = ?"

    [ERROR]: Unknown column 'name' in 'where clause'

    [ERROR]: In mysql_stmt_prepare() id: 140, sql: "UPDATE channels SET ownership =? WHERE name LIKE ?"

    [ERROR]: Unknown column 'name' in 'where clause'

    [ERROR]: In mysql_stmt_prepare() id: 141, sql: "DELETE FROM channels WHERE ownership = 1 AND lastUsed + ? < UNIX_TIMESTAMP()"

    [ERROR]: Unknown column 'ownership' in 'where clause'

    [ERROR]: In mysql_stmt_prepare() id: 148, sql: "REPLACE INTO account_data(accountId, type, time, data) VALUES (?, ?, ?, ?)"

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

    [ERROR]: In mysql_stmt_prepare() id: 149, sql: "DELETE FROM account_data WHERE accountId = ?"

    [ERROR]: Unknown column 'accountId' in 'where clause'

    [ERROR]: In mysql_stmt_prepare() id: 155, 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: 156, 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: 157, sql: "DELETE FROM account_tutorial WHERE accountId = ?"

    [ERROR]: Table 'characters.account_tutorial' doesn't exist

    [ERROR]: In mysql_stmt_prepare() id: 158, sql: "INSERT INTO instance (id, map, resettime, difficulty, completedEncounters, data) VALUES (?, ?, ?, ?, ?, ?)"

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

    [ERROR]: In mysql_stmt_prepare() id: 159, sql: "UPDATE instance SET completedEncounters=?, data=? WHERE id=?"

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

    [ERROR]: In mysql_stmt_prepare() id: 160, sql: "DELETE FROM game_event_save WHERE eventEntry = ?"

    [ERROR]: Unknown column 'eventEntry' in 'where clause'

    [ERROR]: In mysql_stmt_prepare() id: 161, sql: "INSERT INTO game_event_save (eventEntry, state, next_start) VALUES (?, ? , ?)"

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

    [ERROR]: In mysql_stmt_prepare() id: 162, sql: "DELETE FROM game_event_condition_save WHERE eventEntry = ?"

    [ERROR]: Unknown column 'eventEntry' in 'where clause'

    [ERROR]: In mysql_stmt_prepare() id: 163, 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: 164, 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: 165, 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: 171, 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: 172, 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: 173, sql: "REPLACE INTO character_arena_stats (guid, slot, matchMakerRating) VALUES (?, ?, ?)"

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

    [ERROR]: In mysql_stmt_prepare() id: 177, 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: 180, 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: 181, 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: 184, 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: 185, sql: "DELETE FROM corpse WHERE corpseGuid = ?"

    [ERROR]: Unknown column 'corpseGuid' in 'where clause'

    [ERROR]: In mysql_stmt_prepare() id: 186, sql: "DELETE FROM corpse WHERE guid =? AND corpseType <> 0"

    [ERROR]: Unknown column 'corpseType' in 'where clause'

    [ERROR]: In mysql_stmt_prepare() id: 187, 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: 190, sql: "REPLACE INTO creature_respawn (guid, respawnTime, instanceId) VALUES (?, ?, ?)"

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

    [ERROR]: In mysql_stmt_prepare() id: 191, sql: "DELETE FROM creature_respawn WHERE guid = ? AND instanceId = ?"

    [ERROR]: Unknown column 'instanceId' in 'where clause'

    [ERROR]: In mysql_stmt_prepare() id: 193, sql: "DELETE FROM creature_respawn WHERE instanceId = ?"

    [ERROR]: Unknown column 'instanceId' in 'where clause'

    [ERROR]: In mysql_stmt_prepare() id: 197, sql: "REPLACE INTO gameobject_respawn(guid, respawnTime, instanceId) VALUES (?, ?, ?)"

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

    [ERROR]: In mysql_stmt_prepare() id: 198, sql: "DELETE FROM gameobject_respawn WHERE guid = ? AND instanceId = ?"

    [ERROR]: Unknown column 'instanceId' in 'where clause'

    [ERROR]: In mysql_stmt_prepare() id: 199, sql: "DELETE FROM gameobject_respawn WHERE instanceId = ?"

    [ERROR]: Unknown column 'instanceId' in 'where clause'

    [ERROR]: In mysql_stmt_prepare() id: 203, 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: 204, sql: "DELETE FROM gm_tickets WHERE ticketId = ?"

    [ERROR]: Unknown column 'ticketId' in 'where clause'

    [ERROR]: In mysql_stmt_prepare() id: 206, 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: 208, sql: "INSERT INTO lag_reports (guid, lagType, mapId, posX, posY, posZ) VALUES (?, ?, ?, ?, ?, ?)"

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

    MySQL client library: 5.5.9

    MySQL server ver: 5.5.8

    [WARNING] MySQL client/server version mismatch; may conflict with behaviour of prepared statements.

    [ERROR]: In mysql_stmt_prepare() id: 73, sql: "SELECT matchMakerRating FROM character_arena_stats WHERE guid = ? AND slot = ?"

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

    [ERROR]: In mysql_stmt_prepare() id: 136, 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: 147, sql: "SELECT type, time, data FROM account_data WHERE accountId = ?"

    [ERROR]: Unknown column 'accountId' in 'where clause'

    [ERROR]: In mysql_stmt_prepare() id: 153, 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: 154, sql: "SELECT 1 FROM account_tutorial WHERE accountId = ?"

    [ERROR]: Table 'characters.account_tutorial' doesn't exist

    [ERROR]: In mysql_stmt_prepare() id: 179, sql: "UPDATE character_battleground_data SET instanceId = 0"

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

    [ERROR]: In mysql_stmt_prepare() id: 183, 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: 188, 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: 189, sql: "SELECT guid, respawnTime, instanceId FROM creature_respawn"

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

    [ERROR]: In mysql_stmt_prepare() id: 194, 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: 195, 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: 196, sql: "SELECT guid, respawnTime, instanceId FROM gameobject_respawn"

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

    [ERROR]: In mysql_stmt_prepare() id: 201, 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: 202, 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.5.9

    MySQL server ver: 5.5.8

    [WARNING] MySQL client/server version mismatch; may conflict with behaviour of prepared statements.

    [ERROR]: In mysql_stmt_prepare() id: 73, sql: "SELECT matchMakerRating FROM character_arena_stats WHERE guid = ? AND slot = ?"

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

    [ERROR]: In mysql_stmt_prepare() id: 136, 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: 147, sql: "SELECT type, time, data FROM account_data WHERE accountId = ?"

    [ERROR]: Unknown column 'accountId' in 'where clause'

    [ERROR]: In mysql_stmt_prepare() id: 153, 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: 154, sql: "SELECT 1 FROM account_tutorial WHERE accountId = ?"

    [ERROR]: Table 'characters.account_tutorial' doesn't exist

    [ERROR]: In mysql_stmt_prepare() id: 179, sql: "UPDATE character_battleground_data SET instanceId = 0"

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

    [ERROR]: In mysql_stmt_prepare() id: 183, 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: 188, 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: 189, sql: "SELECT guid, respawnTime, instanceId FROM creature_respawn"

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

    [ERROR]: In mysql_stmt_prepare() id: 194, 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: 195, 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: 196, sql: "SELECT guid, respawnTime, instanceId FROM gameobject_respawn"

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

    [ERROR]: In mysql_stmt_prepare() id: 201, 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: 202, 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'.\\\

    Update your Databases.

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

    in Help and Support

    Posted 

    
TrinityCore Hash: Archive (Unix, Release (little-endian)) (worldserver-daemon)

Connected to MySQL database at 178.63.215.214

Cannot connect to Character database 178.63.215.214;3306;trinity;*****;characters

    From this 3 lines i can say that:

    - You don't have git correctly installed.

    - Are you trying to connect to a MySQL Server over internet?

    - If so, the DB errors probably are due to Timeouts. Try connecting to a local MySQL (on the same box or @ least on same lan).

  12. Compile or cmake problems

    in Help and Support

    Posted

    You have a linking problem.

    When you installed ACE, did you installed it with root priviledges to be used by all system? Or did you installed it with a simple user only to be used by him?

    Try reading the wiki about ACE instalation and correct the problem.

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

    in Help and Support

    Posted

    More info would be usefull.

    - Wich Core version are you using?

    - Did you grab it from the official repo?

    - Wich DB Version are you using?

    - Is it the official one?

    - Did you applyed all updates to the world db, characters db and auth db?

    - Wich system have you?

    Note: Before you post, read the sticky's. It is said to give the maximum info you can (OS, MySQL version, etc...)

    • Upvote 1

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

    in Help and Support

    Posted

    I'm not sure what you mean, I believe I don't know any other git's than the one at the wikipedia.

    My debian skills are lame, so only way for me to compile a core is to go step by step with wiki.

    Just delete the folder where you have the sources, and follow the wiki to get again the sources from the repo and compile it.

    Or if you don't want to follow and learn that "boring" stuff, check my signature.

  19. Compile or cmake problems

    in Help and Support

    Posted

    You have tons of warnings on the extractors due to a outdated SDK.

    Try uninstalling the outdated SDK and installing the updated one...

    Note: I also think that someone here told to not use the professional version, but instead use the distributable version.

    Note 2: Next time use pastbin.com to present your errors/logs.

    Follow the wiki and download only the packages mentioned there.

×
×
  • Create New...