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)