["unknown column" "missing table" "duplicate column" error / sql problems / SQLDriverLogFile < answer on 1st post of 1st page]

THX

The authserver works...

 

But is the table "creature_transport" in the world-database outdated?

In the SQL-Updates is a query like this: DROP TABLE IF EXISTS `creature_transport`;

And i cant find a sektion to create a new table named "creature_transport"...?!

 

Thx 4 your help

["unknown column" "missing table" "duplicate column" error / sql problems / SQLDriverLogFile < answer on 1st post of 1st page]

Hello,

 

i used the last rev from the TrinityCore 3.3.5a.

I have compiled the TrinityCore on my Linux Debian server.

All okay.

Then i insert the "auth"-database in my mysql. ("TrinityCore/sql/base/auth_database.sql")

When i am insert the updates from "TrinityCore/sql/updates/auth" show me this error:

mysql> . 2013_08_25_00_auth.sql
ERROR 1060 (42S21): Duplicate column name 'token_key'
mysql> . 2013_08_30_00_auth_misc.sql
Query OK, 7 rows affected (0.00 sec)

Query OK, 17 rows affected (0.01 sec)
Records: 17  Duplicates: 0  Warnings: 0

ERROR 1146 (42S02): Table 'auth.rbac_role_permissions' doesn't exist
ERROR 1146 (42S02): Table 'auth.rbac_role_permissions' doesn't exist

Who can i download the new correct auth-database whith RBAC?

 

Sry my english is not so good

Greetings from Germany!