ProjectSkyfire/SkyFireEMU_rebase — comment on commit 0a158e79a89cd38ed37d36961898b6c580fbf92e
File:  line 0
By newrage:

[ERROR]: In mysql_stmt_prepare() id: 165, sql: "DELETE FROM game_event_save WHER
E eventEntry = ?"
[ERROR]: Table 'characters.game_event_save' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 166, sql: "INSERT INTO game_event_save (eve
ntEntry, state, next_start) VALUES (?, ? , ?)"
[ERROR]: Table 'characters.game_event_save' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 167, sql: "DELETE FROM game_event_condition
_save WHERE eventEntry = ?"
[ERROR]: Table 'characters.game_event_condition_save' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 168, sql: "DELETE FROM game_event_condition
_save WHERE eventEntry = ? AND condition_id = ?"
[ERROR]: Table 'characters.game_event_condition_save' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 169, sql: "INSERT INTO game_event_condition
_save (eventEntry, condition_id, done) VALUES (?, ?, ?)"
[ERROR]: Table 'characters.game_event_condition_save' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 186, sql: "INSERT INTO character_homebind (
guid, mapId, zoneId, posX, posY, posZ) VALUES (?, ?, ?, ?, ?, ?)"
[ERROR]: Table 'characters.character_homebind' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 187, sql: "UPDATE character_homebind SET ma
pId = ?, zoneId = ?, posX = ?, posY = ?, posZ = ? WHERE guid = ?"
[ERROR]: Table 'characters.character_homebind' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 188, sql: "DELETE FROM character_homebind W
HERE guid = ?"
[ERROR]: Table 'characters.character_homebind' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 190, sql: "INSERT INTO corpse (corpseGuid,
guid, posX, posY, posZ, orientation, mapId, displayId, itemCache, bytes1, bytes2
, guildId, flags, dynFlags, time, corpseType, instanceId, phaseMask) VALUES (?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
[ERROR]: Table 'characters.corpse' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 191, sql: "DELETE FROM corpse WHERE corpseG
uid = ?"
[ERROR]: Table 'characters.corpse' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 192, sql: "DELETE FROM corpse WHERE guid =
? AND corpseType <> 0"
[ERROR]: Table 'characters.corpse' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 193, sql: "DELETE FROM corpse WHERE corpseT
ype = 0 OR time < (UNIX_TIMESTAMP(NOW()) - ?)"
[ERROR]: Table 'characters.corpse' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 196, sql: "REPLACE INTO creature_respawn (g
uid, respawnTime, instanceId) VALUES (?, ?, ?)"
[ERROR]: Table 'characters.creature_respawn' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 197, sql: "DELETE FROM creature_respawn WHE
RE guid = ? AND instanceId = ?"
[ERROR]: Table 'characters.creature_respawn' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 198, sql: "DELETE FROM creature_respawn WHE
RE guid = ?"
[ERROR]: Table 'characters.creature_respawn' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 199, sql: "DELETE FROM creature_respawn WHE
RE instanceId = ?"
[ERROR]: Table 'characters.creature_respawn' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 203, sql: "REPLACE INTO gameobject_respawn
(guid, respawnTime, instanceId) VALUES (?, ?, ?)"
[ERROR]: Table 'characters.gameobject_respawn' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 204, sql: "DELETE FROM gameobject_respawn W
HERE guid = ? AND instanceId = ?"
[ERROR]: Table 'characters.gameobject_respawn' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 205, sql: "DELETE FROM gameobject_respawn W
HERE instanceId = ?"
[ERROR]: Table 'characters.gameobject_respawn' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 209, sql: "REPLACE INTO gm_tickets (ticketI
d, guid, name, message, createTime, mapId, posX, posY, posZ, lastModifiedTime, c
losedBy, assignedTo, comment, completed, escalated, viewed) VALUES (?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
[ERROR]: Table 'characters.gm_tickets' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 210, sql: "DELETE FROM gm_tickets WHERE tic
ketId = ?"
[ERROR]: Table 'characters.gm_tickets' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 211, sql: "DELETE FROM gm_tickets WHERE gui
d = ?"
[ERROR]: Table 'characters.gm_tickets' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 212, sql: "INSERT INTO gm_surveys (guid, su
rveyId, mainSurvey, overallComment, createTime) VALUES (?, ?, ?, ?, UNIX_TIMESTA
MP(NOW()))"
[ERROR]: Table 'characters.gm_surveys' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 213, sql: "INSERT INTO gm_subsurveys (surve
yId, subsurveyId, rank, comment) VALUES (?, ?, ?, ?)"
[ERROR]: Table 'characters.gm_subsurveys' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 214, sql: "INSERT INTO lag_reports (guid, l
agType, mapId, posX, posY, posZ) VALUES (?, ?, ?, ?, ?, ?)"
[ERROR]: Table 'characters.lag_reports' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 215, sql: "INSERT INTO characters (guid, ac
count, name, race, class, gender, level, xp, money, playerBytes, playerBytes2, p
layerFlags, map, instance_id, instance_mode_mask, position_x, position_y, positi
on_z, orientation, taximask, cinematic, totaltime, leveltime, rest_bonus, logout
_time, is_logout_resting, resettalents_cost, resettalents_time, extra_flags, at_
login, zone, death_expire_time, taxi_path, arenaPoints, totalHonorPoints, todayH
onorPoints, yesterdayHonorPoints, totalKills, todayKills, yesterdayKills, chosen
Title, knownCurrencies, watchedFaction, drunk, health, power1, power2, power3, p
ower4, power5, power6, power7, power8, power9, power10, latency, speccount, acti
vespec, exploredZones, equipmentCache, ammoId, knownTitles, actionBars, currentP
etSlot, petSlotUsed, grantableLevels) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,
?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,
?,?,?,?,?,?,?,?,?)"
[ERROR]: Table 'characters.characters' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 216, sql: "UPDATE characters SET name=?,rac
e=?,class=?,gender=?,level=?,xp=?,money=?,playerBytes=?,playerBytes2=?,playerFla
gs=?,map=?,instance_id=?,instance_mode_mask=?,position_x=?,position_y=?,position
_z=?,orientation=?,taximask=?,cinematic=?,totaltime=?,leveltime=?,rest_bonus=?,l
ogout_time=?,is_logout_resting=?,resettalents_cost=?,resettalents_time=?,extra_f
lags=?,at_login=?,zone=?,death_expire_time=?,taxi_path=?,arenaPoints=?,totalHono
rPoints=?,todayHonorPoints=?,yesterdayHonorPoints=?,totalKills=?,todayKills=?,ye
sterdayKills=?,chosenTitle=?,knownCurrencies=?,watchedFaction=?,drunk=?,health=?
,power1=?,power2=?,power3=?,power4=?,power5=?,power6=?,power7=?,power8=?,power9=
?,power10=?,latency=?,speccount=?,activespec=?,exploredZones=?,equipmentCache=?,
ammoId=?,knownTitles=?,actionBars=?,currentPetSlot=?,petSlotUsed=?,grantableLeve
ls=?,online=? WHERE guid=?"
[ERROR]: Table 'characters.characters' doesn't exist
MySQL client library: 5.5.15
MySQL server ver: 5.0.45-community-nt
[WARNING] MySQL client/server version mismatch; may conflict with behaviour of p
repared statements.
[ERROR]: In mysql_stmt_prepare() id: 6, sql: "SELECT account FROM characters WHE
RE name = ?"
[ERROR]: Table 'characters.characters' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 12, sql: "SELECT guid FROM characters WHERE
name = ?"
[ERROR]: Table 'characters.characters' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 13, sql: "SELECT guid, name FROM characters
WHERE name LIKE CONCAT('%', ?, '%')"
[ERROR]: Table 'characters.characters' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 22, sql: "SELECT characters.name FROM chara
cters, character_banned WHERE character_banned.guid = ? AND character_banned.gui
d = characters.guid"
[ERROR]: Table 'characters.characters' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 55, sql: "SELECT creatorGuid, giftCreatorGu
id, count, duration, charges, flags, enchantments, randomPropertyId, durability,
playedTime, text, item_guid, itemEntry, owner_guid FROM mail_items mi JOIN item
_instance ii ON mi.item_guid = ii.guid WHERE mail_id = ?"
[ERROR]: Table 'characters.mail_items' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 56, sql: "SELECT name, class FROM character
s WHERE guid = ?"
[ERROR]: Table 'characters.characters' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 57, sql: "SELECT creatorGuid, giftCreatorGu
id, count, duration, charges, flags, enchantments, randomPropertyId, durability,
playedTime, text, itemguid, itemEntry FROM auctionhouse ah JOIN item_instance i
i ON ah.itemguid = ii.guid"
[ERROR]: Table 'characters.item_instance' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 60, sql: "SELECT id, auctioneerguid, itemgu
id, itemEntry, itemowner, buyoutprice, time, buyguid, lastbid, startbid, deposit
FROM auctionhouse ah INNER JOIN item_instance ii ON ii.guid = ah.itemguid"
[ERROR]: Table 'characters.item_instance' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 61, sql: "SELECT id, auctioneerguid, itemgu
id, itemEntry, itemowner, buyoutprice, time, buyguid, lastbid, startbid, deposit
FROM auctionhouse ah INNER JOIN item_instance ii ON ii.guid = ah.itemguid WHERE
ah.time <= ?"
[ERROR]: Table 'characters.item_instance' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 66, sql: "SELECT id, messageType, sender, r
eceiver, has_items, expire_time, cod, checked, mailTemplateId FROM mail WHERE ex
pire_time < ?"
[ERROR]: Table 'characters.mail' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 67, sql: "SELECT item_guid, itemEntry, mail
_id FROM mail_items mi INNER JOIN item_instance ii ON ii.guid = mi.item_guid LEF
T JOIN mail mm ON mi.mail_id = mm.id WHERE mm.id IS NOT NULL AND mm.expire_time
< ?"
[ERROR]: Table 'characters.mail_items' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 73, sql: "SELECT player_guid, paidMoney, pa
idExtendedCost FROM item_refund_instance WHERE item_guid = ? AND player_guid = ?
LIMIT 1"
[ERROR]: Table 'characters.item_refund_instance' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 74, sql: "SELECT allowedPlayers FROM item_s
oulbound_trade_data WHERE itemGuid = ? LIMIT 1"
[ERROR]: Table 'characters.item_soulbound_trade_data' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 145, sql: "SELECT name, level, class, zone,
account FROM characters WHERE guid = ?"
[ERROR]: Table 'characters.characters' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 170, sql: "SELECT ownerguid, name, type FRO
M petition WHERE petitionguid = ?"
[ERROR]: Table 'characters.petition' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 171, sql: "SELECT playerguid FROM petition_
sign WHERE petitionguid = ?"
[ERROR]: Table 'characters.petition_sign' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 189, sql: "SELECT posX, posY, posZ, orienta
tion, mapId, displayId, itemCache, bytes1, bytes2, guildId, flags, dynFlags, tim
e, corpseType, instanceId, phaseMask, corpseGuid, guid FROM corpse WHERE corpseT
ype <> 0"
[ERROR]: Table 'characters.corpse' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 194, sql: "UPDATE corpse SET instanceId = 0
WHERE instanceId > 0 AND instanceId NOT IN (SELECT id FROM instance)"
[ERROR]: Table 'characters.corpse' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 195, sql: "SELECT guid, respawnTime, instan
ceId FROM creature_respawn"
[ERROR]: Table 'characters.creature_respawn' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 200, sql: "SELECT MAX(respawnTime), instanc
eId FROM creature_respawn WHERE instanceId > 0 GROUP BY instanceId"
[ERROR]: Table 'characters.creature_respawn' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 201, sql: "DELETE FROM creature_respawn WHE
RE instanceId > 0 AND instanceId NOT IN (SELECT instanceId FROM instance)"
[ERROR]: Table 'characters.creature_respawn' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 202, sql: "SELECT guid, respawnTime, instan
ceId FROM gameobject_respawn"
[ERROR]: Table 'characters.gameobject_respawn' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 206, sql: "DELETE FROM gameobject_respawn W
HERE respawnTime <= UNIX_TIMESTAMP(NOW())"
[ERROR]: Table 'characters.gameobject_respawn' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 207, sql: "DELETE FROM gameobject_respawn W
HERE instanceId > 0 AND instanceId NOT IN (SELECT instanceId FROM instance)"
[ERROR]: Table 'characters.gameobject_respawn' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 208, sql: "SELECT ticketId, guid, name, mes
sage, createTime, mapId, posX, posY, posZ, lastModifiedTime, closedBy, assignedT
o, comment, completed, escalated, viewed FROM gm_tickets"
[ERROR]: Table 'characters.gm_tickets' doesn't exist
MySQL client library: 5.5.15
MySQL server ver: 5.0.45-community-nt
[WARNING] MySQL client/server version mismatch; may conflict with behaviour of p
repared statements.
[ERROR]: In mysql_stmt_prepare() id: 6, sql: "SELECT account FROM characters WHE
RE name = ?"
[ERROR]: Table 'characters.characters' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 12, sql: "SELECT guid FROM characters WHERE
name = ?"
[ERROR]: Table 'characters.characters' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 13, sql: "SELECT guid, name FROM characters
WHERE name LIKE CONCAT('%', ?, '%')"
[ERROR]: Table 'characters.characters' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 22, sql: "SELECT characters.name FROM chara
cters, character_banned WHERE character_banned.guid = ? AND character_banned.gui
d = characters.guid"
[ERROR]: Table 'characters.characters' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 55, sql: "SELECT creatorGuid, giftCreatorGu
id, count, duration, charges, flags, enchantments, randomPropertyId, durability,
playedTime, text, item_guid, itemEntry, owner_guid FROM mail_items mi JOIN item
_instance ii ON mi.item_guid = ii.guid WHERE mail_id = ?"
[ERROR]: Table 'characters.mail_items' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 56, sql: "SELECT name, class FROM character
s WHERE guid = ?"
[ERROR]: Table 'characters.characters' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 57, sql: "SELECT creatorGuid, giftCreatorGu
id, count, duration, charges, flags, enchantments, randomPropertyId, durability,
playedTime, text, itemguid, itemEntry FROM auctionhouse ah JOIN item_instance i
i ON ah.itemguid = ii.guid"
[ERROR]: Table 'characters.item_instance' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 60, sql: "SELECT id, auctioneerguid, itemgu
id, itemEntry, itemowner, buyoutprice, time, buyguid, lastbid, startbid, deposit
FROM auctionhouse ah INNER JOIN item_instance ii ON ii.guid = ah.itemguid"
[ERROR]: Table 'characters.item_instance' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 61, sql: "SELECT id, auctioneerguid, itemgu
id, itemEntry, itemowner, buyoutprice, time, buyguid, lastbid, startbid, deposit
FROM auctionhouse ah INNER JOIN item_instance ii ON ii.guid = ah.itemguid WHERE
ah.time <= ?"
[ERROR]: Table 'characters.item_instance' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 66, sql: "SELECT id, messageType, sender, r
eceiver, has_items, expire_time, cod, checked, mailTemplateId FROM mail WHERE ex
pire_time < ?"
[ERROR]: Table 'characters.mail' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 67, sql: "SELECT item_guid, itemEntry, mail
_id FROM mail_items mi INNER JOIN item_instance ii ON ii.guid = mi.item_guid LEF
T JOIN mail mm ON mi.mail_id = mm.id WHERE mm.id IS NOT NULL AND mm.expire_time
< ?"
[ERROR]: Table 'characters.mail_items' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 73, sql: "SELECT player_guid, paidMoney, pa
idExtendedCost FROM item_refund_instance WHERE item_guid = ? AND player_guid = ?
LIMIT 1"
[ERROR]: Table 'characters.item_refund_instance' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 74, sql: "SELECT allowedPlayers FROM item_s
oulbound_trade_data WHERE itemGuid = ? LIMIT 1"
[ERROR]: Table 'characters.item_soulbound_trade_data' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 145, sql: "SELECT name, level, class, zone,
account FROM characters WHERE guid = ?"
[ERROR]: Table 'characters.characters' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 170, sql: "SELECT ownerguid, name, type FRO
M petition WHERE petitionguid = ?"
[ERROR]: Table 'characters.petition' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 171, sql: "SELECT playerguid FROM petition_
sign WHERE petitionguid = ?"
[ERROR]: Table 'characters.petition_sign' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 189, sql: "SELECT posX, posY, posZ, orienta
tion, mapId, displayId, itemCache, bytes1, bytes2, guildId, flags, dynFlags, tim
e, corpseType, instanceId, phaseMask, corpseGuid, guid FROM corpse WHERE corpseT
ype <> 0"
[ERROR]: Table 'characters.corpse' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 194, sql: "UPDATE corpse SET instanceId = 0
WHERE instanceId > 0 AND instanceId NOT IN (SELECT id FROM instance)"
[ERROR]: Table 'characters.corpse' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 195, sql: "SELECT guid, respawnTime, instan
ceId FROM creature_respawn"
[ERROR]: Table 'characters.creature_respawn' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 200, sql: "SELECT MAX(respawnTime), instanc
eId FROM creature_respawn WHERE instanceId > 0 GROUP BY instanceId"
[ERROR]: Table 'characters.creature_respawn' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 201, sql: "DELETE FROM creature_respawn WHE
RE instanceId > 0 AND instanceId NOT IN (SELECT instanceId FROM instance)"
[ERROR]: Table 'characters.creature_respawn' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 202, sql: "SELECT guid, respawnTime, instan
ceId FROM gameobject_respawn"
[ERROR]: Table 'characters.gameobject_respawn' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 206, sql: "DELETE FROM gameobject_respawn W
HERE respawnTime <= UNIX_TIMESTAMP(NOW())"
[ERROR]: Table 'characters.gameobject_respawn' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 207, sql: "DELETE FROM gameobject_respawn W
HERE instanceId > 0 AND instanceId NOT IN (SELECT instanceId FROM instance)"
[ERROR]: Table 'characters.gameobject_respawn' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 208, sql: "SELECT ticketId, guid, name, mes
sage, createTime, mapId, posX, posY, posZ, lastModifiedTime, closedBy, assignedT
o, comment, completed, escalated, viewed FROM gm_tickets"
[ERROR]: Table 'characters.gm_tickets' doesn't exist
Databasepool opened succesfuly. 3 total connections running.
Cannot connect to Character database 127.0.0.1;3306;root;ascent;characters
how do i fix that ?