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

Skettis

Members
 View Profile  See their activity

  • Posts

    22

  • Joined

  • Last visited

 Content Type 

Posts posted by Skettis

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

    in Help and Support

    Posted · Edited by Senaris

    Greetings TrinityCore.

    Got an issue with Worldserver.exe

    It's the latest revision from trinity github. ( downloaded, and compiled today (like everyday))

    So as the World DB (downloaded, and apply every SQL update today(like everyday))

    Using configuration file worldserver.conf.

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

    <Ctrl-C> to stop.

    ______ __

    /\__ _\ __ __/\ \__

    \/_/\ \/ _ __ /\_\ ___ /\_\ \ ,_\ __ __

    \ \ \/\`'__\/\ \ /' _ `\/\ \ \ \/ /\ \/\ \

    \ \ \ \ \/ \ \ \/\ \/\ \ \ \ \ \_\ \ \_\ \

    \ \_\ \_\ \ \_\ \_\ \_\ \_\ \__\\/`____ \

    \/_/\/_/ \/_/\/_/\/_/\/_/\/__/ `/___/> \

    C O R E /\___/

    http://TrinityCore.org \/__/

    Opening databasepool 'world2'. Async threads: 1, synch threads: 1

    MySQL client library: 5.5.9

    MySQL server ver: 5.5.11

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

    MySQL client library: 5.5.9

    MySQL server ver: 5.5.11

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

    Databasepool opened succesfuly. 2 total connections running.

    Opening databasepool 'chartest'. Async threads: 1, synch threads: 2

    MySQL client library: 5.5.9

    MySQL server ver: 5.5.12

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

    [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: 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.12

    [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: 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.12

    [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: 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.

    ~DatabaseWorkerPool for ''.

    ~DatabaseWorkerPool for 'chartest'.

    ~DatabaseWorkerPool for 'world2'.

    Cannot connect to Character database 94.177.***.***;3306;********;chartest

    This issue i got since yesterday.

    I use Visual Studio 10 (x32) to compile it.

    The MYSQL server on Hostserver works, my main test realm it's currently online *1 day and a half uptime*

    I double check if "chartest" it's allright, it is.

    I didn't modified any database..

    I rechecked the config, this is what writes in it :

    
LoginDatabaseInfo     = "94.177.***.***;3306;root;passwd;auth"

WorldDatabaseInfo     = "94.177.***.***;3306;root;passwd;world2"

CharacterDatabaseInfo = "94.177.***.***;3306;root;passwd;chartest"

    The hostserver has a Windows Server 2003 running on it.

    I tried everything i could.. but i don't know what to do.

    Thanks in advance!

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

    in Help and Support

    Posted · Edited by Senaris

    I applied any of them from updates (didn't checked "old" directory)...

    http://vault.senaris.net/public/d5fb1280528e158ef359cd2e9ab6d2c9.php

    
/* 

* sql\updates\world\2011_04_02_01_world_version.sql 

*/ 


to


/* 

* sql\updates\world\2011_04_30_02_world_scriptname.sql 

*/

    And if you'll ask me if i recompiled the source. Yes i did also.

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

    in Help and Support

    Posted

    I didn't tried to see them with GM on.

    Yes i applied them, and in the process i got also few errors like... 

    
SQL: SELECT entry, itemEntry1, itemEntry2, itemEntry3 FROM creature_equip_template

ERROR: [1054] Unknown column 'itemEntry1' in 'field list'

    I didn't erased any thing, it's untouched.

    When you ask about SQL you mean the whole World database? Okay.

    http://vault.senaris.net/public/ed5286e439fe13a126f61219db4c3fd1.php

    If you're feeling uncomfortable to download from the link i posted, i'll make another. (It is my web-server)

    Thanks in advance.

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

    in Help and Support

    Posted · Edited by Senaris

    Hope i made this thread in correct section.

    I got latest TrinityCore revision from the day i made this thread.

    The TDB it's (as in mysql writes) TDB 335.11.39

    I tried to make a "custom" zone, where only the gameobjects/npc's in world it's spawned there..

    I took all the Profession Trainers, Class Trainers, side-proffesions, and i took also a Forge/Runeforge and put them there.

    I added also an object for design, some tiny fountains.

    The problem it's that, i restarted the server just once, and when i did that. the Runeforge/Forge and an anvil plus a Gate dissapeared completly, like i never spawned them there.

    I put them back, and again i tried to restart the server. Same thing, only the runeforge/forge and an anvil plus a gate dissapeared completly. The mini-fountains did not. The NPC's also did not.

    What i've done wrong? or.. What's wrong?

    Got also this errors from creature_equip

    2011-05-02 03:46:17 Table `creature_template` lists creature (Entry: 198) with `equipment_id` 19 not found in table `creature_equip_template`, set to no equipment.

2011-05-02 03:46:17 Table `creature_template` lists creature (Entry: 4614) with `equipment_id` 389 not found in table `creature_equip_template`, set to no equipment.

2011-05-02 03:46:17 Table `creature_template` lists creature (Entry: 518) with `equipment_id` 30 not found in table `creature_equip_template`, set to no equipment.

2011-05-02 03:46:17 Table `creature_template` lists creature (Entry: 6) with `equipment_id` 135 not found in table `creature_equip_template`, set to no equipment.

2011-05-02 03:46:17 Table `creature_template` lists creature (Entry: 100) with `equipment_id` 23 not found in table `creature_equip_template`, set to no equipment.
    And it's a full log of these errors! And also i get this error ( i post it just because i think it's something to do with my gameobjects... ) 
    [WARNING] MySQL client/server version mismatch; may conflict with behaviour of prepared statements.

MySQL client library: 5.5.9

MySQL server ver: 5.5.11

    i took the .dll from Mysql folder in program files.. so i don't know why it's a mismatch.

    Thanks in advance!

×
×
  • Create New...