gijsde2de

am sorry didn't work, executed query and said 0 rows affected... so i guess my database was up to date??? but still same errors.

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)