• This is a read only backup of the old Emudevs forum. If you want to have anything removed, please message me on Discord: KittyKaev

[SOLVED] more compile erros, annoying

Status
Not open for further replies.

vxea

Respected Member
I get this shitty error, and I've tried to fix this the last couple of hours

Auth
TrinityCore rev. unknown 1970-01-01 00:00:00 +0000 (Archived branch) (Win32, Release) (authserver)
<Ctrl-C> to stop.

Using configuration file authserver.conf.
OpenSSL 1.0.1e 11 Feb 2013 (Library: OpenSSL 0.9.8e 23 Feb 2007)
Opening DatabasePool 'auth'. Asynchronous connections: 1, synchronous connections: 1.
MySQL client library: 5.5.9
MySQL server ver: 5.5.9-log
Connected to MySQL database at 127.0.0.1
In mysql_stmt_prepare() id: 35, sql: "INSERT INTO realmcharacters (realmid, acctid, numchars) SELECT realmlist.id, account.id, 0 FROM realmlist, account LEFT JOIN realmcharacters ON acctid=account.id WHERE acctid IS NULL"
Table 'auth.realmlist' doesn't exist
In mysql_stmt_prepare() id: 46, sql: "UPDATE uptime SET uptime = ?, maxplayers = ? WHERE realmid = ? AND starttime = ?"
Table 'auth.uptime' doesn't exist
In mysql_stmt_prepare() id: 75, sql: "INSERT INTO rbac_account_roles (accountId, roleId, granted, realmId) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE granted = VALUES(granted)"
Table 'auth.rbac_account_roles' doesn't exist
In mysql_stmt_prepare() id: 76, sql: "DELETE FROM rbac_account_roles WHERE accountId = ? AND roleId = ? AND (realmId = ? OR realmId = -1)"
Table 'auth.rbac_account_roles' doesn't exist
In mysql_stmt_prepare() id: 78, sql: "INSERT INTO rbac_account_permissions (accountId, permissionId, granted, realmId) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE granted = VALUES(granted)"
Table 'auth.rbac_account_permissions' doesn't exist
In mysql_stmt_prepare() id: 79, sql: "DELETE FROM rbac_account_permissions WHERE accountId = ? AND permissionId = ? AND (realmId = ? OR realmId = -1)"
Table 'auth.rbac_account_permissions' doesn't exist
MySQL client library: 5.5.9
MySQL server ver: 5.5.9-log
Connected to MySQL database at 127.0.0.1
In mysql_stmt_prepare() id: 0, sql: "SELECT id, name, address, localAddress, localSubnetMask, port, icon, flag, timezone, allowedSecurityLevel, population, gamebuild FROM realmlist WHERE flag <> 3 ORDER BY name"
Table 'auth.realmlist' doesn't exist
In mysql_stmt_prepare() id: 66, sql: "SELECT allowedSecurityLevel from realmlist WHERE id = ?"
Table 'auth.realmlist' doesn't exist
In mysql_stmt_prepare() id: 74, sql: "SELECT roleId, granted FROM rbac_account_roles WHERE accountId = ? AND (realmId = ? OR realmId = -1) ORDER BY roleId, realmId"
Table 'auth.rbac_account_roles' doesn't exist
In mysql_stmt_prepare() id: 77, sql: "SELECT permissionId, granted FROM rbac_account_permissions WHERE accountId = ? AND (realmId = ? OR realmId = -1) ORDER BY permissionId, realmId"
Table 'auth.rbac_account_permissions' doesn't exist
DatabasePool auth NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors.
Cannot connect to database

World

DatabasePool characters NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors.
Cannot connect to Character database 127.0.0.1;3306;root;ascent;characters




and I've updated and so on and I still don't get it
 

Hyperion

Founder
"Cannot connect to Character database 127.0.0.1;3306;root;ascent;characters"

=P

Use the right mysql info and make sure you imported the DB correctly
 

vxea

Respected Member
I'm Following this guide http://www.youtube.com/watch?v=I3e5b7tFO6A and since heidie was outdated it gave me erros so I belive Redoing all the MySQL DB and it will probably work, Well thanks for informing me. :)


__________________________________

Solved, The problem was that my heidisql was outdated so it gave me erros while trying to add the DB and Thanks to fade he Solved one of my noob problems, because he's an expert, So thanks and yesh Peace
 
Last edited:

vxea

Respected Member
Actully the problem was that I got erros when updating the Db with heidisql he error was that it didn't load the files, it loaded emty Querys and but that was because the Program was outdated. and my DB wasn't outdated, the sql didn't import all the files, now it works and Thanks for help help
 
Status
Not open for further replies.
Top