lukaserdar

June 28, 2012

ok, will try again, will read every line

thank you guys for replying

I'm trying to save money and teach her linux..

I gave up from showing Ubuntu to females, don't know why, but they don't see how awesome it is..

June 26, 2012

nope, recompiled, updated world with every sql,auth and chars too, still nothing...

June 26, 2012

did download, and updated database with "TDB_full_335.11.47_2012_05_19.rar" from github..

and manually inserted all from 19 may to today..

will try all again, and post if i got lucky

June 26, 2012

did all.. just for "world_2012_02_13_2012_05_19", had an error(1050) saying "Table temp_convert_spells already exists".. so just clicked ok..

but I didnt see problem if something already exists

ty for reply

June 26, 2012

I'm running Windows 7, followed up whole tutorial on how to make server, and everything went smooth, no errors..

Just when I start worldserver.exe, it just exits..

I searched google for few days now, but no luck.. authserver.exe works fine..

Here is SQLDriver.txt :

2012-06-18 22:05:01 Opening DatabasePool 'world'. Asynchronous connections: 1, synchronous connections: 1.

2012-06-18 22:05:01 MySQL client library: 5.5.9

2012-06-18 22:05:01 MySQL server ver: 5.5.25

2012-06-18 22:05:01 [WARNING] MySQL client/server version mismatch; may conflict with behaviour of prepared statements.

2012-06-18 22:05:01 MySQL client library: 5.5.9

2012-06-18 22:05:01 MySQL server ver: 5.5.25

2012-06-18 22:05:01 [WARNING] MySQL client/server version mismatch; may conflict with behaviour of prepared statements.

2012-06-18 22:05:01 [ERROR]: In mysql_stmt_prepare() id: 29, sql: "SELECT point, position_x, position_y, position_z, orientation, move_flag, delay, action, action_chance FROM waypoint_data WHERE id = ? ORDER BY point"

2012-06-18 22:05:01 [ERROR]: Unknown column 'orientation' in 'field list'

2012-06-18 22:05:01 [ERROR]: In mysql_stmt_prepare() id: 32, sql: "SELECT position_x, position_y, position_z, orientation FROM waypoint_data WHERE id = ? ORDER BY point DESC LIMIT 1"

2012-06-18 22:05:01 [ERROR]: Unknown column 'orientation' in 'field list'

2012-06-18 22:05:01 [ERROR]: In mysql_stmt_prepare() id: 56, sql: "SELECT difficulty_entry_1, difficulty_entry_2, difficulty_entry_3, KillCredit1, KillCredit2, modelid1, modelid2, modelid3, modelid4, name, subname, IconName, gossip_menu_id, minlevel, maxlevel, exp, faction_A, faction_H, npcflag, speed_walk, speed_run, scale, rank, mindmg, maxdmg, dmgschool, attackpower, dmg_multiplier, baseattacktime, rangeattacktime, unit_class, unit_flags, dynamicflags, family, trainer_type, trainer_spell, trainer_class, trainer_race, minrangedmg, maxrangedmg, rangedattackpower, type, type_flags, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, spell5, spell6, spell7, spell8, PetSpellDataId, VehicleId, mingold, maxgold, AIName, MovementType, InhabitType, HoverHeight, Health_mod, Mana_mod, Armor_mod, RacialLeader, questItem1, questItem2, questItem3, questItem4, questItem5, questItem6, movementId, RegenHealth, equipment_id, mechanic_immune_mask, flags_extra, ScriptName FROM creature_template WHERE entry = ?"

2012-06-18 22:05:01 [ERROR]: Unknown column 'HoverHeight' in 'field list'

2012-06-18 22:05:01 [ERROR]: In mysql_stmt_prepare() id: 58, sql: "SELECT c.country FROM ip2nationCountries c, ip2nation i WHERE i.ip < ? AND c.code = i.country ORDER BY i.ip DESC LIMIT 0,1"

2012-06-18 22:05:01 [ERROR]: Table 'world.ip2nationcountries' doesn't exist

2012-06-18 22:41:44 Opening DatabasePool 'world'. Asynchronous connections: 1, synchronous connections: 1.

2012-06-18 22:41:44 MySQL client library: 5.5.9

2012-06-18 22:41:44 MySQL server ver: 5.5.25

2012-06-18 22:41:44 [WARNING] MySQL client/server version mismatch; may conflict with behaviour of prepared statements.

2012-06-18 22:41:44 MySQL client library: 5.5.9

2012-06-18 22:41:44 MySQL server ver: 5.5.25

2012-06-18 22:41:44 [WARNING] MySQL client/server version mismatch; may conflict with behaviour of prepared statements.

2012-06-18 22:41:44 [ERROR]: In mysql_stmt_prepare() id: 29, sql: "SELECT point, position_x, position_y, position_z, orientation, move_flag, delay, action, action_chance FROM waypoint_data WHERE id = ? ORDER BY point"

2012-06-18 22:41:44 [ERROR]: Unknown column 'orientation' in 'field list'

2012-06-18 22:41:44 [ERROR]: In mysql_stmt_prepare() id: 32, sql: "SELECT position_x, position_y, position_z, orientation FROM waypoint_data WHERE id = ? ORDER BY point DESC LIMIT 1"

2012-06-18 22:41:44 [ERROR]: Unknown column 'orientation' in 'field list'

2012-06-18 22:41:44 [ERROR]: In mysql_stmt_prepare() id: 56, sql: "SELECT difficulty_entry_1, difficulty_entry_2, difficulty_entry_3, KillCredit1, KillCredit2, modelid1, modelid2, modelid3, modelid4, name, subname, IconName, gossip_menu_id, minlevel, maxlevel, exp, faction_A, faction_H, npcflag, speed_walk, speed_run, scale, rank, mindmg, maxdmg, dmgschool, attackpower, dmg_multiplier, baseattacktime, rangeattacktime, unit_class, unit_flags, dynamicflags, family, trainer_type, trainer_spell, trainer_class, trainer_race, minrangedmg, maxrangedmg, rangedattackpower, type, type_flags, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, spell5, spell6, spell7, spell8, PetSpellDataId, VehicleId, mingold, maxgold, AIName, MovementType, InhabitType, HoverHeight, Health_mod, Mana_mod, Armor_mod, RacialLeader, questItem1, questItem2, questItem3, questItem4, questItem5, questItem6, movementId, RegenHealth, equipment_id, mechanic_immune_mask, flags_extra, ScriptName FROM creature_template WHERE entry = ?"

2012-06-18 22:41:44 [ERROR]: Unknown column 'HoverHeight' in 'field list'

2012-06-18 22:41:44 [ERROR]: In mysql_stmt_prepare() id: 58, sql: "SELECT c.country FROM ip2nationCountries c, ip2nation i WHERE i.ip < ? AND c.code = i.country ORDER BY i.ip DESC LIMIT 0,1"

2012-06-18 22:41:44 [ERROR]: Table 'world.ip2nationcountries' doesn't exist

2012-06-19 00:37:19 Opening DatabasePool 'world'. Asynchronous connections: 1, synchronous connections: 1.

2012-06-19 00:37:19 MySQL client library: 5.5.9

2012-06-19 00:37:19 MySQL server ver: 5.5.25

2012-06-19 00:37:19 [WARNING] MySQL client/server version mismatch; may conflict with behaviour of prepared statements.

2012-06-19 00:37:19 MySQL client library: 5.5.9

2012-06-19 00:37:19 MySQL server ver: 5.5.25

2012-06-19 00:37:19 [WARNING] MySQL client/server version mismatch; may conflict with behaviour of prepared statements.

2012-06-19 00:37:19 [ERROR]: In mysql_stmt_prepare() id: 29, sql: "SELECT point, position_x, position_y, position_z, orientation, move_flag, delay, action, action_chance FROM waypoint_data WHERE id = ? ORDER BY point"

2012-06-19 00:37:19 [ERROR]: Unknown column 'orientation' in 'field list'

2012-06-19 00:37:19 [ERROR]: In mysql_stmt_prepare() id: 32, sql: "SELECT position_x, position_y, position_z, orientation FROM waypoint_data WHERE id = ? ORDER BY point DESC LIMIT 1"

2012-06-19 00:37:19 [ERROR]: Unknown column 'orientation' in 'field list'

2012-06-19 00:37:19 [ERROR]: In mysql_stmt_prepare() id: 56, sql: "SELECT difficulty_entry_1, difficulty_entry_2, difficulty_entry_3, KillCredit1, KillCredit2, modelid1, modelid2, modelid3, modelid4, name, subname, IconName, gossip_menu_id, minlevel, maxlevel, exp, faction_A, faction_H, npcflag, speed_walk, speed_run, scale, rank, mindmg, maxdmg, dmgschool, attackpower, dmg_multiplier, baseattacktime, rangeattacktime, unit_class, unit_flags, dynamicflags, family, trainer_type, trainer_spell, trainer_class, trainer_race, minrangedmg, maxrangedmg, rangedattackpower, type, type_flags, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, spell5, spell6, spell7, spell8, PetSpellDataId, VehicleId, mingold, maxgold, AIName, MovementType, InhabitType, HoverHeight, Health_mod, Mana_mod, Armor_mod, RacialLeader, questItem1, questItem2, questItem3, questItem4, questItem5, questItem6, movementId, RegenHealth, equipment_id, mechanic_immune_mask, flags_extra, ScriptName FROM creature_template WHERE entry = ?"

2012-06-19 00:37:19 [ERROR]: Unknown column 'HoverHeight' in 'field list'

2012-06-19 00:37:19 [ERROR]: In mysql_stmt_prepare() id: 58, sql: "SELECT c.country FROM ip2nationCountries c, ip2nation i WHERE i.ip < ? AND c.code = i.country ORDER BY i.ip DESC LIMIT 0,1"

2012-06-19 00:37:19 [ERROR]: Table 'world.ip2nationcountries' doesn't exist

2012-06-19 04:30:02 Opening DatabasePool 'world'. Asynchronous connections: 1, synchronous connections: 1.

2012-06-19 04:30:04 MySQL client library: 5.5.9

2012-06-19 04:30:04 MySQL server ver: 5.5.25

2012-06-19 04:30:04 [WARNING] MySQL client/server version mismatch; may conflict with behaviour of prepared statements.

2012-06-19 04:30:09 MySQL client library: 5.5.9

2012-06-19 04:30:09 MySQL server ver: 5.5.25

2012-06-19 04:30:09 [WARNING] MySQL client/server version mismatch; may conflict with behaviour of prepared statements.

2012-06-19 04:30:11 [ERROR]: In mysql_stmt_prepare() id: 56, sql: "SELECT difficulty_entry_1, difficulty_entry_2, difficulty_entry_3, KillCredit1, KillCredit2, modelid1, modelid2, modelid3, modelid4, name, subname, IconName, gossip_menu_id, minlevel, maxlevel, exp, faction_A, faction_H, npcflag, speed_walk, speed_run, scale, rank, mindmg, maxdmg, dmgschool, attackpower, dmg_multiplier, baseattacktime, rangeattacktime, unit_class, unit_flags, dynamicflags, family, trainer_type, trainer_spell, trainer_class, trainer_race, minrangedmg, maxrangedmg, rangedattackpower, type, type_flags, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, spell5, spell6, spell7, spell8, PetSpellDataId, VehicleId, mingold, maxgold, AIName, MovementType, InhabitType, HoverHeight, Health_mod, Mana_mod, Armor_mod, RacialLeader, questItem1, questItem2, questItem3, questItem4, questItem5, questItem6, movementId, RegenHealth, equipment_id, mechanic_immune_mask, flags_extra, ScriptName FROM creature_template WHERE entry = ?"

2012-06-19 04:30:11 [ERROR]: Unknown column 'HoverHeight' in 'field list'

2012-06-19 04:30:11 [ERROR]: In mysql_stmt_prepare() id: 58, sql: "SELECT c.country FROM ip2nationCountries c, ip2nation i WHERE i.ip < ? AND c.code = i.country ORDER BY i.ip DESC LIMIT 0,1"

2012-06-19 04:30:11 [ERROR]: Table 'world.ip2nationcountries' doesn't exist

2012-06-26 20:10:02 Opening DatabasePool 'world'. Asynchronous connections: 1, synchronous connections: 1.

2012-06-26 20:10:02 MySQL client library: 5.5.9

2012-06-26 20:10:02 MySQL server ver: 5.5.25

2012-06-26 20:10:02 [WARNING] MySQL client/server version mismatch; may conflict with behaviour of prepared statements.

2012-06-26 20:10:02 MySQL client library: 5.5.9

2012-06-26 20:10:02 MySQL server ver: 5.5.25

2012-06-26 20:10:02 [WARNING] MySQL client/server version mismatch; may conflict with behaviour of prepared statements.

2012-06-26 20:10:02 DatabasePool 'world' opened successfully. 2 total connections running.

2012-06-26 20:10:02 Opening DatabasePool 'characters'. Asynchronous connections: 1, synchronous connections: 2.

2012-06-26 20:10:02 MySQL client library: 5.5.9

2012-06-26 20:10:02 MySQL server ver: 5.5.25

2012-06-26 20:10:02 [WARNING] MySQL client/server version mismatch; may conflict with behaviour of prepared statements.

2012-06-26 20:10:03 MySQL client library: 5.5.9

2012-06-26 20:10:03 MySQL server ver: 5.5.25

2012-06-26 20:10:03 [WARNING] MySQL client/server version mismatch; may conflict with behaviour of prepared statements.

2012-06-26 20:10:04 MySQL client library: 5.5.9

2012-06-26 20:10:04 MySQL server ver: 5.5.25

2012-06-26 20:10:04 [WARNING] MySQL client/server version mismatch; may conflict with behaviour of prepared statements.

2012-06-26 20:10:04 DatabasePool 'characters' opened successfully. 3 total connections running.

2012-06-26 20:10:04 Opening DatabasePool 'auth'. Asynchronous connections: 1, synchronous connections: 1.

2012-06-26 20:10:04 MySQL client library: 5.5.9

2012-06-26 20:10:04 MySQL server ver: 5.5.25

2012-06-26 20:10:04 [WARNING] MySQL client/server version mismatch; may conflict with behaviour of prepared statements.

2012-06-26 20:10:04 MySQL client library: 5.5.9

2012-06-26 20:10:04 MySQL server ver: 5.5.25

2012-06-26 20:10:04 [WARNING] MySQL client/server version mismatch; may conflict with behaviour of prepared statements.

2012-06-26 20:10:04 DatabasePool 'auth' opened successfully. 2 total connections running.

2012-06-26 20:10:04 [1 ms] SQL: UPDATE account SET online = 0 WHERE online > 0 AND id IN (SELECT acctid FROM realmcharacters WHERE realmid = 1)

2012-06-26 20:10:04 [1 ms] SQL: UPDATE characters SET online = 0 WHERE online <> 0

2012-06-26 20:10:04 [2 ms] SQL: UPDATE character_battleground_data SET instanceId = 0

2012-06-26 20:10:04 [5 ms] SQL: UPDATE version SET core_version = 'TrinityCore rev. 0000-00-00 00:00:00 +0000 (Archived) (Win32, Release)', core_revision = 'Archived'

2012-06-26 20:10:04 [1 ms] SQL: SELECT db_version, cache_id FROM version LIMIT 1

2012-06-26 20:10:04 [45 ms] SQL: UPDATE realmlist SET flag = (flag & ~2) | 1 WHERE id = '1'

2012-06-26 20:10:04 [2 ms] SQL(p): SELECT allowedSecurityLevel from realmlist WHERE id = '1'

2012-06-26 20:10:04 [6 ms] SQL: SELECT MAX(guid) FROM characters

2012-06-26 20:10:04 [1 ms] SQL: SELECT MAX(guid) FROM creature

2012-06-26 20:10:04 [1 ms] SQL: SELECT MAX(guid) FROM item_instance

2012-06-26 20:10:04 [1 ms] SQL: SELECT MAX(guid) FROM gameobject

2012-06-26 20:10:04 [3 ms] SQL: DELETE FROM character_inventory WHERE item >= '1'

2012-06-26 20:10:04 [1 ms] SQL: DELETE FROM mail_items WHERE item_guid >= '1'

2012-06-26 20:10:04 [0 ms] SQL: DELETE FROM auctionhouse WHERE itemguid >= '1'

2012-06-26 20:10:04 [2 ms] SQL: DELETE FROM guild_bank_item WHERE item_guid >= '1'

2012-06-26 20:10:04 [10 ms] SQL: SELECT MAX(guid) FROM transports

2012-06-26 20:10:04 [1 ms] SQL: SELECT MAX(id) FROM auctionhouse

2012-06-26 20:10:04 [1 ms] SQL: SELECT MAX(id) FROM mail

2012-06-26 20:10:04 [0 ms] SQL: SELECT MAX(corpseGuid) FROM corpse

2012-06-26 20:10:04 [0 ms] SQL: SELECT MAX(arenateamid) FROM arena_team

2012-06-26 20:10:04 [1 ms] SQL: SELECT MAX(setguid) FROM character_equipmentsets

2012-06-26 20:10:04 [1 ms] SQL: SELECT MAX(guildId) FROM guild

2012-06-26 20:10:04 [0 ms] SQL: SELECT MAX(guid) FROM groups

2012-06-26 20:10:47 Opening DatabasePool 'world'. Asynchronous connections: 1, synchronous connections: 1.

2012-06-26 20:10:47 MySQL client library: 5.5.9

2012-06-26 20:10:47 MySQL server ver: 5.5.25

2012-06-26 20:10:47 [WARNING] MySQL client/server version mismatch; may conflict with behaviour of prepared statements.

2012-06-26 20:10:47 MySQL client library: 5.5.9

2012-06-26 20:10:47 MySQL server ver: 5.5.25

2012-06-26 20:10:47 [WARNING] MySQL client/server version mismatch; may conflict with behaviour of prepared statements.

2012-06-26 20:10:47 DatabasePool 'world' opened successfully. 2 total connections running.

2012-06-26 20:10:47 Opening DatabasePool 'characters'. Asynchronous connections: 1, synchronous connections: 2.

2012-06-26 20:10:47 MySQL client library: 5.5.9

2012-06-26 20:10:47 MySQL server ver: 5.5.25

2012-06-26 20:10:47 [WARNING] MySQL client/server version mismatch; may conflict with behaviour of prepared statements.

2012-06-26 20:10:47 MySQL client library: 5.5.9

2012-06-26 20:10:47 MySQL server ver: 5.5.25

2012-06-26 20:10:47 [WARNING] MySQL client/server version mismatch; may conflict with behaviour of prepared statements.

2012-06-26 20:10:48 MySQL client library: 5.5.9

2012-06-26 20:10:48 MySQL server ver: 5.5.25

2012-06-26 20:10:48 [WARNING] MySQL client/server version mismatch; may conflict with behaviour of prepared statements.

2012-06-26 20:10:48 DatabasePool 'characters' opened successfully. 3 total connections running.

2012-06-26 20:10:48 Opening DatabasePool 'auth'. Asynchronous connections: 1, synchronous connections: 1.

2012-06-26 20:10:48 MySQL client library: 5.5.9

2012-06-26 20:10:48 MySQL server ver: 5.5.25

2012-06-26 20:10:48 [WARNING] MySQL client/server version mismatch; may conflict with behaviour of prepared statements.

2012-06-26 20:10:48 MySQL client library: 5.5.9

2012-06-26 20:10:48 MySQL server ver: 5.5.25

2012-06-26 20:10:48 [WARNING] MySQL client/server version mismatch; may conflict with behaviour of prepared statements.

2012-06-26 20:10:48 DatabasePool 'auth' opened successfully. 2 total connections running.

2012-06-26 20:10:48 [1 ms] SQL: UPDATE account SET online = 0 WHERE online > 0 AND id IN (SELECT acctid FROM realmcharacters WHERE realmid = 1)

2012-06-26 20:10:48 [1 ms] SQL: UPDATE characters SET online = 0 WHERE online <> 0

2012-06-26 20:10:48 [1 ms] SQL: UPDATE character_battleground_data SET instanceId = 0

2012-06-26 20:10:48 [0 ms] SQL: SELECT db_version, cache_id FROM version LIMIT 1

2012-06-26 20:10:48 [1 ms] SQL: UPDATE version SET core_version = 'TrinityCore rev. 0000-00-00 00:00:00 +0000 (Archived) (Win32, Release)', core_revision = 'Archived'

2012-06-26 20:10:48 [1 ms] SQL: UPDATE realmlist SET flag = (flag & ~2) | 1 WHERE id = '1'

2012-06-26 20:10:48 [2 ms] SQL(p): SELECT allowedSecurityLevel from realmlist WHERE id = '1'

2012-06-26 20:10:48 [1 ms] SQL: SELECT MAX(guid) FROM characters

2012-06-26 20:10:48 [1 ms] SQL: SELECT MAX(guid) FROM creature

2012-06-26 20:10:48 [1 ms] SQL: SELECT MAX(guid) FROM item_instance

2012-06-26 20:10:48 [1 ms] SQL: SELECT MAX(guid) FROM gameobject

2012-06-26 20:10:48 [0 ms] SQL: SELECT MAX(guid) FROM transports

2012-06-26 20:10:48 [1 ms] SQL: SELECT MAX(id) FROM auctionhouse

2012-06-26 20:10:48 [3 ms] SQL: DELETE FROM character_inventory WHERE item >= '1'

2012-06-26 20:10:48 [1 ms] SQL: SELECT MAX(id) FROM mail

2012-06-26 20:10:48 [1 ms] SQL: DELETE FROM mail_items WHERE item_guid >= '1'

2012-06-26 20:10:48 [2 ms] SQL: SELECT MAX(corpseGuid) FROM corpse

2012-06-26 20:10:48 [0 ms] SQL: DELETE FROM auctionhouse WHERE itemguid >= '1'

2012-06-26 20:10:48 [1 ms] SQL: SELECT MAX(arenateamid) FROM arena_team

2012-06-26 20:10:48 [1 ms] SQL: SELECT MAX(setguid) FROM character_equipmentsets

2012-06-26 20:10:48 [1 ms] SQL: SELECT MAX(guildId) FROM guild

2012-06-26 20:10:48 [2 ms] SQL: DELETE FROM guild_bank_item WHERE item_guid >= '1'

2012-06-26 20:10:48 [0 ms] SQL: SELECT MAX(guid) FROM groups

2012-06-26 20:24:47 Opening DatabasePool 'world'. Asynchronous connections: 1, synchronous connections: 1.

2012-06-26 20:24:47 MySQL client library: 5.5.9

2012-06-26 20:24:47 MySQL server ver: 5.5.25

2012-06-26 20:24:47 [WARNING] MySQL client/server version mismatch; may conflict with behaviour of prepared statements.

2012-06-26 20:24:47 MySQL client library: 5.5.9

2012-06-26 20:24:47 MySQL server ver: 5.5.25

2012-06-26 20:24:47 [WARNING] MySQL client/server version mismatch; may conflict with behaviour of prepared statements.

2012-06-26 20:24:47 DatabasePool 'world' opened successfully. 2 total connections running.

2012-06-26 20:24:47 Opening DatabasePool 'characters'. Asynchronous connections: 1, synchronous connections: 2.

2012-06-26 20:24:47 MySQL client library: 5.5.9

2012-06-26 20:24:47 MySQL server ver: 5.5.25

2012-06-26 20:24:47 [WARNING] MySQL client/server version mismatch; may conflict with behaviour of prepared statements.

2012-06-26 20:24:47 MySQL client library: 5.5.9

2012-06-26 20:24:47 MySQL server ver: 5.5.25

2012-06-26 20:24:47 [WARNING] MySQL client/server version mismatch; may conflict with behaviour of prepared statements.

2012-06-26 20:24:47 MySQL client library: 5.5.9

2012-06-26 20:24:47 MySQL server ver: 5.5.25

2012-06-26 20:24:47 [WARNING] MySQL client/server version mismatch; may conflict with behaviour of prepared statements.

2012-06-26 20:24:47 DatabasePool 'characters' opened successfully. 3 total connections running.

2012-06-26 20:24:47 Opening DatabasePool 'auth'. Asynchronous connections: 1, synchronous connections: 1.

2012-06-26 20:24:47 MySQL client library: 5.5.9

2012-06-26 20:24:47 MySQL server ver: 5.5.25

2012-06-26 20:24:47 [WARNING] MySQL client/server version mismatch; may conflict with behaviour of prepared statements.

2012-06-26 20:24:47 MySQL client library: 5.5.9

2012-06-26 20:24:47 MySQL server ver: 5.5.25

2012-06-26 20:24:47 [WARNING] MySQL client/server version mismatch; may conflict with behaviour of prepared statements.

2012-06-26 20:24:47 DatabasePool 'auth' opened successfully. 2 total connections running.

2012-06-26 20:24:47 [1 ms] SQL: UPDATE account SET online = 0 WHERE online > 0 AND id IN (SELECT acctid FROM realmcharacters WHERE realmid = 1)

2012-06-26 20:24:47 [1 ms] SQL: UPDATE characters SET online = 0 WHERE online <> 0

2012-06-26 20:24:47 [1 ms] SQL: UPDATE character_battleground_data SET instanceId = 0

2012-06-26 20:24:47 [1 ms] SQL: UPDATE version SET core_version = 'TrinityCore rev. 0000-00-00 00:00:00 +0000 (Archived) (Win32, Release)', core_revision = 'Archived'

2012-06-26 20:24:47 [2 ms] SQL: SELECT db_version, cache_id FROM version LIMIT 1

2012-06-26 20:24:47 [1 ms] SQL: UPDATE realmlist SET flag = (flag & ~2) | 1 WHERE id = '1'

2012-06-26 20:24:47 [1 ms] SQL(p): SELECT allowedSecurityLevel from realmlist WHERE id = '1'

2012-06-26 20:24:47 [1 ms] SQL: SELECT MAX(guid) FROM characters

2012-06-26 20:24:47 [1 ms] SQL: SELECT MAX(guid) FROM creature

2012-06-26 20:24:47 [1 ms] SQL: SELECT MAX(guid) FROM item_instance

2012-06-26 20:24:47 [1 ms] SQL: SELECT MAX(guid) FROM gameobject

2012-06-26 20:24:47 [1 ms] SQL: SELECT MAX(guid) FROM transports

2012-06-26 20:24:47 [2 ms] SQL: DELETE FROM character_inventory WHERE item >= '1'

2012-06-26 20:24:47 [1 ms] SQL: SELECT MAX(id) FROM auctionhouse

2012-06-26 20:24:47 [1 ms] SQL: SELECT MAX(id) FROM mail

2012-06-26 20:24:47 [1 ms] SQL: DELETE FROM mail_items WHERE item_guid >= '1'

2012-06-26 20:24:47 [1 ms] SQL: SELECT MAX(corpseGuid) FROM corpse

2012-06-26 20:24:47 [1 ms] SQL: SELECT MAX(arenateamid) FROM arena_team

2012-06-26 20:24:47 [2 ms] SQL: DELETE FROM auctionhouse WHERE itemguid >= '1'

2012-06-26 20:24:47 [1 ms] SQL: SELECT MAX(setguid) FROM character_equipmentsets

2012-06-26 20:24:47 [1 ms] SQL: SELECT MAX(guildId) FROM guild

2012-06-26 20:24:47 [0 ms] SQL: DELETE FROM guild_bank_item WHERE item_guid >= '1'

2012-06-26 20:24:47 [0 ms] SQL: SELECT MAX(guid) FROM groups

2012-06-26 20:25:12 Opening DatabasePool 'world'. Asynchronous connections: 1, synchronous connections: 1.

2012-06-26 20:25:12 MySQL client library: 5.5.9

2012-06-26 20:25:12 MySQL server ver: 5.5.25

2012-06-26 20:25:12 [WARNING] MySQL client/server version mismatch; may conflict with behaviour of prepared statements.

2012-06-26 20:25:12 MySQL client library: 5.5.9

2012-06-26 20:25:12 MySQL server ver: 5.5.25

2012-06-26 20:25:12 [WARNING] MySQL client/server version mismatch; may conflict with behaviour of prepared statements.

2012-06-26 20:25:12 DatabasePool 'world' opened successfully. 2 total connections running.

2012-06-26 20:25:12 Opening DatabasePool 'characters'. Asynchronous connections: 1, synchronous connections: 2.

2012-06-26 20:25:12 MySQL client library: 5.5.9

2012-06-26 20:25:12 MySQL server ver: 5.5.25

2012-06-26 20:25:12 [WARNING] MySQL client/server version mismatch; may conflict with behaviour of prepared statements.

2012-06-26 20:25:12 MySQL client library: 5.5.9

2012-06-26 20:25:12 MySQL server ver: 5.5.25

2012-06-26 20:25:12 [WARNING] MySQL client/server version mismatch; may conflict with behaviour of prepared statements.

2012-06-26 20:25:12 MySQL client library: 5.5.9

2012-06-26 20:25:12 MySQL server ver: 5.5.25

2012-06-26 20:25:12 [WARNING] MySQL client/server version mismatch; may conflict with behaviour of prepared statements.

2012-06-26 20:25:12 DatabasePool 'characters' opened successfully. 3 total connections running.

2012-06-26 20:25:12 Opening DatabasePool 'auth'. Asynchronous connections: 1, synchronous connections: 1.

2012-06-26 20:25:12 MySQL client library: 5.5.9

2012-06-26 20:25:12 MySQL server ver: 5.5.25

2012-06-26 20:25:12 [WARNING] MySQL client/server version mismatch; may conflict with behaviour of prepared statements.

2012-06-26 20:25:13 MySQL client library: 5.5.9

2012-06-26 20:25:13 MySQL server ver: 5.5.25

2012-06-26 20:25:13 [WARNING] MySQL client/server version mismatch; may conflict with behaviour of prepared statements.

2012-06-26 20:25:13 DatabasePool 'auth' opened successfully. 2 total connections running.

2012-06-26 20:25:13 [1 ms] SQL: UPDATE account SET online = 0 WHERE online > 0 AND id IN (SELECT acctid FROM realmcharacters WHERE realmid = 1)

2012-06-26 20:25:13 [1 ms] SQL: UPDATE characters SET online = 0 WHERE online <> 0

2012-06-26 20:25:13 [1 ms] SQL: UPDATE character_battleground_data SET instanceId = 0

2012-06-26 20:25:13 [1 ms] SQL: SELECT db_version, cache_id FROM version LIMIT 1

2012-06-26 20:25:13 [1 ms] SQL: UPDATE realmlist SET flag = (flag & ~2) | 1 WHERE id = '1'

2012-06-26 20:25:13 [6 ms] SQL: UPDATE version SET core_version = 'TrinityCore rev. 0000-00-00 00:00:00 +0000 (Archived) (Win32, Release)', core_revision = 'Archived'

2012-06-26 20:25:13 [1 ms] SQL(p): SELECT allowedSecurityLevel from realmlist WHERE id = '1'

2012-06-26 20:25:13 [0 ms] SQL: SELECT MAX(guid) FROM characters

2012-06-26 20:25:13 [1 ms] SQL: SELECT MAX(guid) FROM creature

2012-06-26 20:25:13 [1 ms] SQL: SELECT MAX(guid) FROM item_instance

2012-06-26 20:25:13 [1 ms] SQL: SELECT MAX(guid) FROM gameobject

2012-06-26 20:25:13 [2 ms] SQL: DELETE FROM character_inventory WHERE item >= '1'

2012-06-26 20:25:13 [1 ms] SQL: SELECT MAX(guid) FROM transports

2012-06-26 20:25:13 [2 ms] SQL: DELETE FROM mail_items WHERE item_guid >= '1'

2012-06-26 20:25:13 [1 ms] SQL: SELECT MAX(id) FROM auctionhouse

2012-06-26 20:25:13 [1 ms] SQL: DELETE FROM auctionhouse WHERE itemguid >= '1'

2012-06-26 20:25:13 [1 ms] SQL: DELETE FROM guild_bank_item WHERE item_guid >= '1'

2012-06-26 20:25:13 [1 ms] SQL: SELECT MAX(id) FROM mail

2012-06-26 20:25:13 [1 ms] SQL: SELECT MAX(corpseGuid) FROM corpse

2012-06-26 20:25:13 [1 ms] SQL: SELECT MAX(arenateamid) FROM arena_team

2012-06-26 20:25:13 [1 ms] SQL: SELECT MAX(setguid) FROM character_equipmentsets

2012-06-26 20:25:13 [1 ms] SQL: SELECT MAX(guildId) FROM guild

2012-06-26 20:25:13 [1 ms] SQL: SELECT MAX(guid) FROM groups

2012-06-26 20:35:25 Opening DatabasePool 'world'. Asynchronous connections: 1, synchronous connections: 1.

2012-06-26 20:35:25 MySQL client library: 5.5.9

2012-06-26 20:35:25 MySQL server ver: 5.5.25

2012-06-26 20:35:25 [WARNING] MySQL client/server version mismatch; may conflict with behaviour of prepared statements.

2012-06-26 20:35:25 MySQL client library: 5.5.9

2012-06-26 20:35:25 MySQL server ver: 5.5.25

2012-06-26 20:35:25 [WARNING] MySQL client/server version mismatch; may conflict with behaviour of prepared statements.

2012-06-26 20:35:25 DatabasePool 'world' opened successfully. 2 total connections running.

2012-06-26 20:35:25 Opening DatabasePool 'characters'. Asynchronous connections: 1, synchronous connections: 2.

2012-06-26 20:35:25 MySQL client library: 5.5.9

2012-06-26 20:35:25 MySQL server ver: 5.5.25

2012-06-26 20:35:25 [WARNING] MySQL client/server version mismatch; may conflict with behaviour of prepared statements.

2012-06-26 20:35:25 MySQL client library: 5.5.9

2012-06-26 20:35:25 MySQL server ver: 5.5.25

2012-06-26 20:35:25 [WARNING] MySQL client/server version mismatch; may conflict with behaviour of prepared statements.

2012-06-26 20:35:25 MySQL client library: 5.5.9

2012-06-26 20:35:25 MySQL server ver: 5.5.25

2012-06-26 20:35:25 [WARNING] MySQL client/server version mismatch; may conflict with behaviour of prepared statements.

2012-06-26 20:35:25 DatabasePool 'characters' opened successfully. 3 total connections running.

2012-06-26 20:35:25 Opening DatabasePool 'auth'. Asynchronous connections: 1, synchronous connections: 1.

2012-06-26 20:35:25 MySQL client library: 5.5.9

2012-06-26 20:35:25 MySQL server ver: 5.5.25

2012-06-26 20:35:25 [WARNING] MySQL client/server version mismatch; may conflict with behaviour of prepared statements.

2012-06-26 20:35:25 MySQL client library: 5.5.9

2012-06-26 20:35:25 MySQL server ver: 5.5.25

2012-06-26 20:35:25 [WARNING] MySQL client/server version mismatch; may conflict with behaviour of prepared statements.

2012-06-26 20:35:25 DatabasePool 'auth' opened successfully. 2 total connections running.

2012-06-26 20:35:25 [1 ms] SQL: UPDATE account SET online = 0 WHERE online > 0 AND id IN (SELECT acctid FROM realmcharacters WHERE realmid = 1)

2012-06-26 20:35:25 [1 ms] SQL: UPDATE characters SET online = 0 WHERE online <> 0

2012-06-26 20:35:25 [1 ms] SQL: UPDATE character_battleground_data SET instanceId = 0

2012-06-26 20:35:25 [1 ms] SQL: UPDATE version SET core_version = 'TrinityCore rev. 0000-00-00 00:00:00 +0000 (Archived) (Win32, Release)', core_revision = 'Archived'

2012-06-26 20:35:25 [2 ms] SQL: SELECT db_version, cache_id FROM version LIMIT 1

2012-06-26 20:35:25 [2 ms] SQL: UPDATE realmlist SET flag = (flag & ~2) | 1 WHERE id = '1'

2012-06-26 20:35:25 [1 ms] SQL(p): SELECT allowedSecurityLevel from realmlist WHERE id = '1'

2012-06-26 20:35:25 [1 ms] SQL: SELECT MAX(guid) FROM characters

2012-06-26 20:35:25 [1 ms] SQL: SELECT MAX(guid) FROM creature

2012-06-26 20:35:25 [0 ms] SQL: SELECT MAX(guid) FROM item_instance

2012-06-26 20:35:25 [1 ms] SQL: SELECT MAX(guid) FROM gameobject

2012-06-26 20:35:25 [2 ms] SQL: DELETE FROM character_inventory WHERE item >= '1'

2012-06-26 20:35:25 [1 ms] SQL: SELECT MAX(guid) FROM transports

2012-06-26 20:35:25 [1 ms] SQL: SELECT MAX(id) FROM auctionhouse

2012-06-26 20:35:25 [2 ms] SQL: DELETE FROM mail_items WHERE item_guid >= '1'

2012-06-26 20:35:25 [1 ms] SQL: SELECT MAX(id) FROM mail

2012-06-26 20:35:25 [1 ms] SQL: DELETE FROM auctionhouse WHERE itemguid >= '1'

2012-06-26 20:35:25 [2 ms] SQL: SELECT MAX(corpseGuid) FROM corpse

2012-06-26 20:35:25 [1 ms] SQL: SELECT MAX(arenateamid) FROM arena_team

2012-06-26 20:35:25 [1 ms] SQL: DELETE FROM guild_bank_item WHERE item_guid >= '1'

2012-06-26 20:35:25 [0 ms] SQL: SELECT MAX(setguid) FROM character_equipmentsets

2012-06-26 20:35:25 [1 ms] SQL: SELECT MAX(guildId) FROM guild

2012-06-26 20:35:25 [0 ms] SQL: SELECT MAX(guid) FROM groups

and exits...

Thank you in advance

Sign In

lukaserdar

Posts

Joined

Last visited

Content Type

Forums

Posts posted by lukaserdar

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

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

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

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

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

Repos

Browse

Activity