bareikhodom
-
Posts
4 -
Joined
-
Last visited
Posts posted by bareikhodom
-
-
-
-
Hey it seems that after i have configured my auth.conf to the right mysql settings it won't connect for some reason,
TrinityCore rev. unknown 1970-01-01 00:00:00 +0000 (Archived branch) (Win32, Debug) (authserver) <Ctrl-C> to stop. Using configuration file authserver.conf. OpenSSL 1.0.1e 11 Feb 2013 (Library: OpenSSL 1.0.1e 11 Feb 2013) Opening DatabasePool '3-auth'. Asynchronous connections: 1, synchronous connections: 1. MySQL client library: 5.5.9 MySQL server ver: 5.5.9 Connected to MySQL database at 127.0.0.1 MySQL client library: 5.5.9 MySQL server ver: 5.5.9 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 '3-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 '3-auth.ip2nationcountries' doesn't exist DatabasePool 3-auth NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors. Cannot connect to database
Bit new to the trinity, so would be great with some help on this issue.
"unknown column" "missing table" "duplicate column" error / sql problems / SQLDriverLogFile < answer on 1st post of 1st page
in Help and Support
Posted
Every time that I start worldserver.exe i get the error [1054] Unknown column 'id' in 'field list'