Hello,
Today i compiled a fresh TC Master core and everything went smooth until the updating of the databases.
Here are the steps i followed:
1. Created the 3 databases: auth, characters, world.
2. Imported the auth db structure from the sql/base folder.
3. Imported the characters db structure from the same folder.
4. Imported the world db structure by importing the TDB_full_335.51_2013_02_14.sql
5. Created a .bat file that would combine all the sql's from the sql/updates folder.
6. Imported all required updates in each db. -> And here is where the errors appeared (see the screenshots attached).
Auth log:
TrinityCore rev. 4537d4082eb3 2013-04-22 17:37:13 +0200 (master branch) (Win32, Release) (authserver)
<Ctrl-C> to stop.
Using configuration file authserver.conf.
OpenSSL 1.0.1e 11 Feb 2013 (Library: OpenSSL 1.0.1c 10 May 2012)
Opening DatabasePool 'auth'. Asynchronous connections: 1, synchronous connections: 1.
MySQL client library: 5.5.9
MySQL server ver: 5.5.24-log
Connected to MySQL database at 127.0.0.1
MySQL client library: 5.5.9
MySQL server ver: 5.5.24-log
Connected to MySQL database at 127.0.0.1
In mysql_stmt_prepare() id: 14, sql: "SELECT country FROM ip2nation WHERE ip < ? ORDER BY ip DESC LIMIT 0,1"
Table 'auth.ip2nation' doesn't exist
In mysql_stmt_prepare() id: 68, 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"
Table 'auth.ip2nationcountries' doesn't exist
DatabasePool auth NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors.
Cannot connect to database
So what's the deal with these errors?
Am i doing something wrong like: "Another very common error is to try to apply auth/character updates into a fresh downloaded core, the base files for auth/characters are usualy updated every time they need to be updated and you don't need to run them on new server install." ?
Thanks
