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

gijsde2de

Plebs
 View Profile  See their activity

  • Posts

    2

  • Joined

  • Last visited

 Content Type 

Posts posted by gijsde2de

  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 gijsde2de

    I'm new to trinity and have problems with starting the worldserver.exe (the auth one works fine),

    I used this guide How-to:Win - TrinityCore Wiki

    the error i get in server.log is this:

    
2012-07-19 17:15:59 Using configuration file worldserver.conf.

2012-07-19 17:15:59 Using SSL version: OpenSSL 1.0.1c 10 May 2012 (library: OpenSSL 1.0.1c 10 May 2012)

2012-07-19 17:15:59 Using ACE version: 5.8.3

2012-07-19 17:15:59 TrinityCore rev. 0000-00-00 00:00:00 +0000 (Archived) (Win32, Release) (worldserver-daemon)

2012-07-19 17:15:59 <Ctrl-C> to stop.

2012-07-19 17:15:59 ______					 __

2012-07-19 17:15:59 /\__ _\	 __		 __/\ \__

2012-07-19 17:15:59 \/_/\ \/ _ __ /\_\ ___ /\_\ \, _\ __ __

2012-07-19 17:15:59 \ \ \/\`'__\/\ \ /' _ `\/\ \ \ \/ /\ \/\ \

2012-07-19 17:15:59	 \ \ \ \ \/ \ \ \/\ \/\ \ \ \ \ \_\ \ \_\ \

2012-07-19 17:15:59	 \ \_\ \_\ \ \_\ \_\ \_\ \_\ \__\\/`____ \

2012-07-19 17:15:59	 \/_/\/_/ \/_/\/_/\/_/\/_/\/__/ `/___/> \

2012-07-19 17:15:59								 C O R E /\___/

2012-07-19 17:15:59 http://TrinityCore.org				 \/__/

2012-07-19 17:16:05 ERROR: DatabasePool characters NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors.

2012-07-19 17:16:05 ERROR: Cannot connect to Character database 127.0.0.1;3306;root;ascent;characters
    I know (i googled xD) this means character database structure has changed and it needs to be updated... But problem is that i downloaded latest core/world database and there's no updates for character database (at least none that i can find..) sql error is this (from sqldriver.log): 
    
2012-07-18 22:19:40 Opening DatabasePool 'world'. Asynchronous connections: 1, synchronous connections: 1.

2012-07-18 22:19:41 MySQL client library: 5.5.9

2012-07-18 22:19:41 MySQL server ver: 5.5.9

2012-07-18 22:19:41 MySQL client library: 5.5.9

2012-07-18 22:19:41 MySQL server ver: 5.5.9

2012-07-18 22:19:41 DatabasePool 'world' opened successfully. 2 total connections running.

2012-07-18 22:19:41 Opening DatabasePool 'characters'. Asynchronous connections: 1, synchronous connections: 2.

2012-07-18 22:19:41 MySQL client library: 5.5.9

2012-07-18 22:19:41 MySQL server ver: 5.5.9

2012-07-18 22:19:41 [ERROR]: In mysql_stmt_prepare() id: 65, sql: "SELECT setguid, setindex, name, iconname, ignore_mask, item0, item1, item2, item3, item4, item5, item6, item7, item8, item9, item10, item11, item12, item13, item14, item15, item16, item17, item18 FROM character_equipmentsets WHERE guid = ? ORDER BY setindex"

2012-07-18 22:19:41 [ERROR]: Unknown column 'ignore_mask' in 'field list'

2012-07-18 22:19:41 [ERROR]: In mysql_stmt_prepare() id: 182, sql: "UPDATE character_equipmentsets SET name=?, iconname=?, ignore_mask=?, item0=?, item1=?, item2=?, item3=?, item4=?, item5=?, item6=?, item7=?, item8=?, item9=?, item10=?, item11=?, item12=?, item13=?, item14=?, item15=?, item16=?, item17=?, item18=? WHERE guid=? AND setguid=? AND setindex=?"

2012-07-18 22:19:41 [ERROR]: Unknown column 'ignore_mask' in 'field list'

2012-07-18 22:19:41 [ERROR]: In mysql_stmt_prepare() id: 183, sql: "INSERT INTO character_equipmentsets (guid, setguid, setindex, name, iconname, ignore_mask, item0, item1, item2, item3, item4, item5, item6, item7, item8, item9, item10, item11, item12, item13, item14, item15, item16, item17, item18) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"

2012-07-18 22:19:41 [ERROR]: Unknown column 'ignore_mask' in 'field list'

2012-07-18 22:19:41 MySQL client library: 5.5.9

2012-07-18 22:19:41 MySQL server ver: 5.5.9

2012-07-18 22:19:41 MySQL client library: 5.5.9

2012-07-18 22:19:41 MySQL server ver: 5.5.9

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

2012-07-19 17:15:59 MySQL client library: 5.5.9

2012-07-19 17:15:59 MySQL server ver: 5.5.9

2012-07-19 17:16:01 MySQL client library: 5.5.9

2012-07-19 17:16:01 MySQL server ver: 5.5.9

2012-07-19 17:16:01 DatabasePool 'world' opened successfully. 2 total connections running.

2012-07-19 17:16:01 Opening DatabasePool 'characters'. Asynchronous connections: 1, synchronous connections: 2.

2012-07-19 17:16:01 MySQL client library: 5.5.9

2012-07-19 17:16:01 MySQL server ver: 5.5.9

2012-07-19 17:16:03 [ERROR]: In mysql_stmt_prepare() id: 65, sql: "SELECT setguid, setindex, name, iconname, ignore_mask, item0, item1, item2, item3, item4, item5, item6, item7, item8, item9, item10, item11, item12, item13, item14, item15, item16, item17, item18 FROM character_equipmentsets WHERE guid = ? ORDER BY setindex"

2012-07-19 17:16:03 [ERROR]: Unknown column 'ignore_mask' in 'field list'

2012-07-19 17:16:04 [ERROR]: In mysql_stmt_prepare() id: 182, sql: "UPDATE character_equipmentsets SET name=?, iconname=?, ignore_mask=?, item0=?, item1=?, item2=?, item3=?, item4=?, item5=?, item6=?, item7=?, item8=?, item9=?, item10=?, item11=?, item12=?, item13=?, item14=?, item15=?, item16=?, item17=?, item18=? WHERE guid=? AND setguid=? AND setindex=?"

2012-07-19 17:16:04 [ERROR]: Unknown column 'ignore_mask' in 'field list'

2012-07-19 17:16:04 [ERROR]: In mysql_stmt_prepare() id: 183, sql: "INSERT INTO character_equipmentsets (guid, setguid, setindex, name, iconname, ignore_mask, item0, item1, item2, item3, item4, item5, item6, item7, item8, item9, item10, item11, item12, item13, item14, item15, item16, item17, item18) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"

2012-07-19 17:16:04 [ERROR]: Unknown column 'ignore_mask' in 'field list'

2012-07-19 17:16:05 MySQL client library: 5.5.9

2012-07-19 17:16:05 MySQL server ver: 5.5.9

2012-07-19 17:16:05 MySQL client library: 5.5.9

2012-07-19 17:16:05 MySQL server ver: 5.5.9

    If someone would be so kind to tell me where i can find the update for my character database i'd greatly appreciate it (or any other newb mistake i made xD)

×
×
  • Create New...