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

goyan

Plebs
 View Profile  See their activity

  • Posts

    4

  • Joined

  • Last visited

 Content Type 

Posts posted by goyan

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

    in Help and Support

    Posted · Edited by goyan

    Dear

    We Updated Sqls and Again Create Database world " import New Full TDB "

    Fix DLL File MYSQL Version

    Wow Core Cant run

    Where is the problem ?

    
2012-07-15 19:27:40 Opening DatabasePool 'world'. Asynchronous connections: 1, synchronous connections: 1.

2012-07-15 19:27:40 MySQL client library: 5.1.54

2012-07-15 19:27:40 MySQL server ver: 5.1.54-community

2012-07-15 19:27:40 [ERROR]: In mysql_stmt_prepare() id: 15, sql: "UPDATE creature SET MovementType = ? WHERE guid = ?"

2012-07-15 19:27:40 [ERROR]: Table 'world.creature' doesn't exist

2012-07-15 19:27:40 [ERROR]: In mysql_stmt_prepare() id: 18, sql: "UPDATE creature SET position_x = ?, position_y = ?, position_z = ?, orientation = ? WHERE guid = ?"

2012-07-15 19:27:40 [ERROR]: Table 'world.creature' doesn't exist

2012-07-15 19:27:40 [ERROR]: In mysql_stmt_prepare() id: 19, sql: "UPDATE creature SET spawndist = ?, MovementType = ? WHERE guid = ?"

2012-07-15 19:27:40 [ERROR]: Table 'world.creature' doesn't exist

2012-07-15 19:27:40 [ERROR]: In mysql_stmt_prepare() id: 20, sql: "UPDATE creature SET spawntimesecs = ? WHERE guid = ?"

2012-07-15 19:27:40 [ERROR]: Table 'world.creature' doesn't exist

2012-07-15 19:27:40 [ERROR]: In mysql_stmt_prepare() id: 52, sql: "DELETE FROM creature WHERE guid = ?"

2012-07-15 19:27:40 [ERROR]: Table 'world.creature' doesn't exist

2012-07-15 19:27:40 [ERROR]: In mysql_stmt_prepare() id: 63, sql: "INSERT INTO creature (guid, id , map, spawnMask, phaseMask, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, curhealth, curmana, MovementType, npcflag, unit_flags, dynamicflags) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"

2012-07-15 19:27:40 [ERROR]: Table 'world.creature' doesn't exist

2012-07-15 19:27:40 MySQL client library: 5.1.54

2012-07-15 19:27:40 MySQL server ver: 5.1.54-community

2012-07-15 19:27:40 [ERROR]: In mysql_stmt_prepare() id: 60, sql: "SELECT guid FROM creature WHERE id = ?"

2012-07-15 19:27:40 [ERROR]: Table 'world.creature' doesn't exist

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

    in Help and Support

    Posted

    Hello

    Copy All Informaion ( Data )

    
2012-07-11 17:39:00 Opening DatabasePool 'world'. Asynchronous connections: 1, synchronous connections: 1.

2012-07-11 17:39:00 MySQL client library: 5.1.54

2012-07-11 17:39:00 MySQL server ver: 5.0.51b-community-nt

2012-07-11 17:39:00 [WARNING] MySQL client/server version mismatch; may conflict with behaviour of prepared statements.

2012-07-11 17:39:00 [ERROR]: In mysql_stmt_prepare() id: 15, sql: "UPDATE creature SET MovementType = ? WHERE guid = ?"

2012-07-11 17:39:00 [ERROR]: Table 'world.creature' doesn't exist

2012-07-11 17:39:00 [ERROR]: In mysql_stmt_prepare() id: 18, sql: "UPDATE creature SET position_x = ?, position_y = ?, position_z = ?, orientation = ? WHERE guid = ?"

2012-07-11 17:39:00 [ERROR]: Table 'world.creature' doesn't exist

2012-07-11 17:39:00 [ERROR]: In mysql_stmt_prepare() id: 19, sql: "UPDATE creature SET spawndist = ?, MovementType = ? WHERE guid = ?"

2012-07-11 17:39:00 [ERROR]: Table 'world.creature' doesn't exist

2012-07-11 17:39:00 [ERROR]: In mysql_stmt_prepare() id: 20, sql: "UPDATE creature SET spawntimesecs = ? WHERE guid = ?"

2012-07-11 17:39:00 [ERROR]: Table 'world.creature' doesn't exist

2012-07-11 17:39:00 [ERROR]: In mysql_stmt_prepare() id: 52, sql: "DELETE FROM creature WHERE guid = ?"

2012-07-11 17:39:00 [ERROR]: Table 'world.creature' doesn't exist

2012-07-11 17:39:00 [ERROR]: In mysql_stmt_prepare() id: 63, sql: "INSERT INTO creature (guid, id , map, spawnMask, phaseMask, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, curhealth, curmana, MovementType, npcflag, unit_flags, dynamicflags) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"

2012-07-11 17:39:00 [ERROR]: Table 'world.creature' doesn't exist

2012-07-11 17:39:00 MySQL client library: 5.1.54

2012-07-11 17:39:00 MySQL server ver: 5.0.51b-community-nt

2012-07-11 17:39:00 [WARNING] MySQL client/server version mismatch; may conflict with behaviour of prepared statements.

2012-07-11 17:39:00 [ERROR]: In mysql_stmt_prepare() id: 60, sql: "SELECT guid FROM creature WHERE id = ?"

2012-07-11 17:39:00 [ERROR]: Table 'world.creature' doesn't exist

2012-07-11 17:39:03 Opening DatabasePool 'world'. Asynchronous connections: 1, synchronous connections: 1.

2012-07-11 17:39:03 MySQL client library: 5.1.54

2012-07-11 17:39:03 MySQL server ver: 5.0.51b-community-nt

2012-07-11 17:39:03 [WARNING] MySQL client/server version mismatch; may conflict with behaviour of prepared statements.

2012-07-11 17:39:03 [ERROR]: In mysql_stmt_prepare() id: 15, sql: "UPDATE creature SET MovementType = ? WHERE guid = ?"

2012-07-11 17:39:03 [ERROR]: Table 'world.creature' doesn't exist

2012-07-11 17:39:03 [ERROR]: In mysql_stmt_prepare() id: 18, sql: "UPDATE creature SET position_x = ?, position_y = ?, position_z = ?, orientation = ? WHERE guid = ?"

2012-07-11 17:39:03 [ERROR]: Table 'world.creature' doesn't exist

2012-07-11 17:39:03 [ERROR]: In mysql_stmt_prepare() id: 19, sql: "UPDATE creature SET spawndist = ?, MovementType = ? WHERE guid = ?"

2012-07-11 17:39:03 [ERROR]: Table 'world.creature' doesn't exist

2012-07-11 17:39:03 [ERROR]: In mysql_stmt_prepare() id: 20, sql: "UPDATE creature SET spawntimesecs = ? WHERE guid = ?"

2012-07-11 17:39:03 [ERROR]: Table 'world.creature' doesn't exist

2012-07-11 17:39:03 [ERROR]: In mysql_stmt_prepare() id: 52, sql: "DELETE FROM creature WHERE guid = ?"

2012-07-11 17:39:03 [ERROR]: Table 'world.creature' doesn't exist

2012-07-11 17:39:03 [ERROR]: In mysql_stmt_prepare() id: 63, sql: "INSERT INTO creature (guid, id , map, spawnMask, phaseMask, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, curhealth, curmana, MovementType, npcflag, unit_flags, dynamicflags) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"

2012-07-11 17:39:03 [ERROR]: Table 'world.creature' doesn't exist

2012-07-11 17:39:03 MySQL client library: 5.1.54

2012-07-11 17:39:03 MySQL server ver: 5.0.51b-community-nt

2012-07-11 17:39:03 [WARNING] MySQL client/server version mismatch; may conflict with behaviour of prepared statements.

2012-07-11 17:39:03 [ERROR]: In mysql_stmt_prepare() id: 60, sql: "SELECT guid FROM creature WHERE id = ?"

2012-07-11 17:39:03 [ERROR]: Table 'world.creature' doesn't exist

2012-07-11 17:43:52 Opening DatabasePool 'world'. Asynchronous connections: 1, synchronous connections: 1.

2012-07-11 17:43:52 MySQL client library: 5.0.51b

2012-07-11 17:43:52 MySQL server ver: 5.0.51b-community-nt

2012-07-11 17:43:52 [ERROR]: In mysql_stmt_prepare() id: 15, sql: "UPDATE creature SET MovementType = ? WHERE guid = ?"

2012-07-11 17:43:52 [ERROR]: Table 'world.creature' doesn't exist

2012-07-11 17:43:52 [ERROR]: In mysql_stmt_prepare() id: 18, sql: "UPDATE creature SET position_x = ?, position_y = ?, position_z = ?, orientation = ? WHERE guid = ?"

2012-07-11 17:43:52 [ERROR]: Table 'world.creature' doesn't exist

2012-07-11 17:43:52 [ERROR]: In mysql_stmt_prepare() id: 19, sql: "UPDATE creature SET spawndist = ?, MovementType = ? WHERE guid = ?"

2012-07-11 17:43:52 [ERROR]: Table 'world.creature' doesn't exist

2012-07-11 17:43:52 [ERROR]: In mysql_stmt_prepare() id: 20, sql: "UPDATE creature SET spawntimesecs = ? WHERE guid = ?"

2012-07-11 17:43:52 [ERROR]: Table 'world.creature' doesn't exist

2012-07-11 17:43:52 [ERROR]: In mysql_stmt_prepare() id: 52, sql: "DELETE FROM creature WHERE guid = ?"

2012-07-11 17:43:52 [ERROR]: Table 'world.creature' doesn't exist

2012-07-11 17:43:52 [ERROR]: In mysql_stmt_prepare() id: 63, sql: "INSERT INTO creature (guid, id , map, spawnMask, phaseMask, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, curhealth, curmana, MovementType, npcflag, unit_flags, dynamicflags) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"

2012-07-11 17:43:52 [ERROR]: Table 'world.creature' doesn't exist

2012-07-11 17:43:52 MySQL client library: 5.0.51b

2012-07-11 17:43:52 MySQL server ver: 5.0.51b-community-nt

2012-07-11 17:43:52 [ERROR]: In mysql_stmt_prepare() id: 60, sql: "SELECT guid FROM creature WHERE id = ?"

2012-07-11 17:43:52 [ERROR]: Table 'world.creature' doesn't exist

2012-07-15 18:15:21 Opening DatabasePool 'world'. Asynchronous connections: 1, synchronous connections: 1.

2012-07-15 18:15:21 MySQL client library: 5.0.51b

2012-07-15 18:15:21 MySQL server ver: 5.0.51b-community-nt

2012-07-15 18:15:22 [ERROR]: In mysql_stmt_prepare() id: 15, sql: "UPDATE creature SET MovementType = ? WHERE guid = ?"

2012-07-15 18:15:22 [ERROR]: Table 'world.creature' doesn't exist

2012-07-15 18:15:22 [ERROR]: In mysql_stmt_prepare() id: 18, sql: "UPDATE creature SET position_x = ?, position_y = ?, position_z = ?, orientation = ? WHERE guid = ?"

2012-07-15 18:15:22 [ERROR]: Table 'world.creature' doesn't exist

2012-07-15 18:15:22 [ERROR]: In mysql_stmt_prepare() id: 19, sql: "UPDATE creature SET spawndist = ?, MovementType = ? WHERE guid = ?"

2012-07-15 18:15:22 [ERROR]: Table 'world.creature' doesn't exist

2012-07-15 18:15:22 [ERROR]: In mysql_stmt_prepare() id: 20, sql: "UPDATE creature SET spawntimesecs = ? WHERE guid = ?"

2012-07-15 18:15:22 [ERROR]: Table 'world.creature' doesn't exist

2012-07-15 18:15:22 [ERROR]: In mysql_stmt_prepare() id: 52, sql: "DELETE FROM creature WHERE guid = ?"

2012-07-15 18:15:22 [ERROR]: Table 'world.creature' doesn't exist

2012-07-15 18:15:22 [ERROR]: In mysql_stmt_prepare() id: 63, sql: "INSERT INTO creature (guid, id , map, spawnMask, phaseMask, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, curhealth, curmana, MovementType, npcflag, unit_flags, dynamicflags) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"

2012-07-15 18:15:22 [ERROR]: Table 'world.creature' doesn't exist

2012-07-15 18:15:22 MySQL client library: 5.0.51b

2012-07-15 18:15:22 MySQL server ver: 5.0.51b-community-nt

2012-07-15 18:15:22 [ERROR]: In mysql_stmt_prepare() id: 60, sql: "SELECT guid FROM creature WHERE id = ?"

2012-07-15 18:15:22 [ERROR]: Table 'world.creature' doesn't exist

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

    in Help and Support

    Posted

    Dear Sir / Madam ,

    We Following Help " How-to:Windows" of website Error Step by Step to end doc

    But now we've received the following error. Core does not launch.

    2012-07-11 16:47:10 ERROR: DatabasePool world NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors.

    2012-07-11 16:47:10 ERROR: Cannot connect to world database 127.0.0.1;3306;trinity;trinity;world

    Where is the problem ?

    Please help us ! we need to know all the step which we need to complete it .

×
×
  • Create New...